Registered User
Joined: 2/18/2009
Posts: 9
|
Hi,
Can you help write 2 PCF for Telechart.
- Highest High price in the past 200 days to have occurred in the past 20 days.
- ATR divided by the average closing price, over the past 21 days, to be greater than 1.5% and less than 6%.
Thank you.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (rhollow) Highest High price in the past 200 days to have occurred in the past 20 days.
You might want to try either:
MAXH20 = MAXH200
Or possibly:
MAXH20 > MAXH180.20
QUOTE (rhollow) ATR divided by the average closing price, over the past 21 days, to be greater than 1.5% and less than 6%.
Is the Moving Average used for calculating the ATR and denominator Simple, Exponential or Wilder's Smoothed?
Simple:
ABS(((AVGH21 - AVGL21) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19) + ABS(H20 - C21) + ABS(C21 - L20)) / 42) / AVGC21 - .0375) <= .0225
Exponential:
ABS((XAVGH21 - XAVGL21 + .0909956583651082 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 20 / 22 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 20 / 22 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 20 / 22 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 20 / 22 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 20 / 22 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 20 / 22 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 20 / 22 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 20 / 22 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 20 / 22 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 20 / 22 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 20 / 22 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 20 / 22 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 20 / 22 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 20 / 22 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 20 / 22 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 20 / 22 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 20 / 22 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 20 / 22 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 20 / 22 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 20 / 22 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 20 / 22 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 20 / 22 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 20 / 22 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 20 / 22 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 20 / 22 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 20 / 22 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 20 / 22 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 20 / 22 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 20 / 22 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 20 / 22 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 20 / 22 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 20 / 22 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 20 / 22 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 20 / 22 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 20 / 22 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 20 / 22 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 20 / 22 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 20 / 22 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 20 / 22 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 20 / 22 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 20 / 22 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 20 / 22 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 20 / 22 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 20 / 22 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 20 / 22 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 20 / 22 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 20 / 22 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 20 / 22 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 20 / 22 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 20 / 22 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 20 / 22 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 20 / 22 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 20 / 22 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 20 / 22 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 20 / 22 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 20 / 22 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 20 / 22 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 20 / 22 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 20 / 22 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 20 / 22 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 20 / 22 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 20 / 22 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 20 / 22 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 20 / 22 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 20 / 22 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 20 / 22 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 20 / 22 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 20 / 22 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 20 / 22 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 20 / 22 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 20 / 22 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 20 / 22 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / XAVGC21 - .0375) <= .0225
Wilder's Smoothed:
ABS((XAVGH41 - XAVGL41 + .0476657485943124 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 40 / 42 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 40 / 42 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 40 / 42 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 40 / 42 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 40 / 42 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 40 / 42 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 40 / 42 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 40 / 42 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 40 / 42 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 40 / 42 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 40 / 42 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 40 / 42 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 40 / 42 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 40 / 42 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 40 / 42 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 40 / 42 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 40 / 42 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 40 / 42 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 40 / 42 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 40 / 42 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 40 / 42 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 40 / 42 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 40 / 42 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 40 / 42 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 40 / 42 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 40 / 42 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 40 / 42 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 40 / 42 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 40 / 42 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 40 / 42 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 40 / 42 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 40 / 42 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 40 / 42 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 40 / 42 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 40 / 42 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 40 / 42 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 40 / 42 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 40 / 42 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 40 / 42 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 40 / 42 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 40 / 42 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 40 / 42 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 40 / 42 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 40 / 42 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 40 / 42 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 40 / 42 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 40 / 42 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 40 / 42 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 40 / 42 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 40 / 42 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 40 / 42 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 40 / 42 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 40 / 42 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 40 / 42 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 40 / 42 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 40 / 42 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 40 / 42 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 40 / 42 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 40 / 42 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 40 / 42 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 40 / 42 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 40 / 42 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 40 / 42 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 40 / 42 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 40 / 42 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 40 / 42 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 40 / 42 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 40 / 42 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 40 / 42 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 40 / 42 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 40 / 42 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 40 / 42 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72) + 40 / 42 * ((H73 < C74) * (H73 - C74) + (C74 < L73) * (C74 - L73) + 40 / 42 * ((H74 < C75) * (H74 - C75) + (C75 < L74) * (C75 - L74) + 40 / 42 * ((H75 < C76) * (H75 - C76) + (C76 < L75) * (C76 - L75) + 40 / 42 * ((H76 < C77) * (H76 - C77) + (C77 < L76) * (C77 - L76) + 40 / 42 * ((H77 < C78) * (H77 - C78) + (C78 < L77) * (C78 - L77) + 40 / 42 * ((H78 < C79) * (H78 - C79) + (C79 < L78) * (C79 - L78) + 40 / 42 * ((H79 < C80) * (H79 - C80) + (C80 < L79) * (C80 - L79) + 40 / 42 * ((H80 < C81) * (H80 - C81) + (C81 < L80) * (C81 - L80) + 40 / 42 * ((H81 < C82) * (H81 - C82) + (C82 < L81) * (C82 - L81) + 40 / 42 * ((H82 < C83) * (H82 - C83) + (C83 < L82) * (C83 - L82) + 40 / 42 * ((H83 < C84) * (H83 - C84) + (C84 < L83) * (C84 - L83) + 40 / 42 * ((H84 < C85) * (H84 - C85) + (C85 < L84) * (C85 - L84) + 40 / 42 * ((H85 < C86) * (H85 - C86) + (C86 < L85) * (C86 - L85) + 40 / 42 * ((H86 < C87) * (H86 - C87) + (C87 < L86) * (C87 - L86) + 40 / 42 * ((H87 < C88) * (H87 - C88) + (C88 < L87) * (C88 - L87) + 40 / 42 * ((H88 < C89) * (H88 - C89) + (C89 < L88) * (C89 - L88) + 40 / 42 * ((H89 < C90) * (H89 - C90) + (C90 < L89) * (C90 - L89) + 40 / 42 * ((H90 < C91) * (H90 - C91) + (C91 < L90) * (C91 - L90) + 40 / 42 * ((H91 < C92) * (H91 - C92) + (C92 < L91) * (C92 - L91) + 40 / 42 * ((H92 < C93) * (H92 - C93) + (C93 < L92) * (C93 - L92) + 40 / 42 * ((H93 < C94) * (H93 - C94) + (C94 < L93) * (C94 - L93) + 40 / 42 * ((H94 < C95) * (H94 - C95) + (C95 < L94) * (C95 - L94) + 40 / 42 * ((H95 < C96) * (H95 - C96) + (C96 < L95) * (C96 - L95) + 40 / 42 * ((H96 < C97) * (H96 - C97) + (C97 < L96) * (C97 - L96) + 40 / 42 * ((H97 < C98) * (H97 - C98) + (C98 < L97) * (C98 - L97) + 40 / 42 * ((H98 < C99) * (H98 - C99) + (C99 < L98) * (C99 - L98) + 40 / 42 * ((H99 < C100) * (H99 - C100) + (C100 < L99) * (C100 - L99) + 40 / 42 * ((H100 < C101) * (H100 - C101) + (C101 < L100) * (C101 - L100) + 40 / 42 * ((H101 < C102) * (H101 - C102) + (C102 < L101) * (C102 - L101) + 40 / 42 * ((H102 < C103) * (H102 - C103) + (C103 < L102) * (C103 - L102) + 40 / 42 * ((H103 < C104) * (H103 - C104) + (C104 < L103) * (C104 - L103) + 40 / 42 * ((H104 < C105) * (H104 - C105) + (C105 < L104) * (C105 - L104) + 40 / 42 * ((H105 < C106) * (H105 - C106) + (C106 < L105) * (C106 - L105) + 40 / 42 * ((H106 < C107) * (H106 - C107) + (C107 < L106) * (C107 - L106) + 40 / 42 * ((H107 < C108) * (H107 - C108) + (C108 < L107) * (C108 - L107) + 40 / 42 * ((H108 < C109) * (H108 - C109) + (C109 < L108) * (C109 - L108) + 40 / 42 * ((H109 < C110) * (H109 - C110) + (C110 < L109) * (C110 - L109) + 40 / 42 * ((H110 < C111) * (H110 - C111) + (C111 < L110) * (C111 - L110) + 40 / 42 * ((H111 < C112) * (H111 - C112) + (C112 < L111) * (C112 - L111) + 40 / 42 * ((H112 < C113) * (H112 - C113) + (C113 < L112) * (C113 - L112) + 40 / 42 * ((H113 < C114) * (H113 - C114) + (C114 < L113) * (C114 - L113) + 40 / 42 * ((H114 < C115) * (H114 - C115) + (C115 < L114) * (C115 - L114) + 40 / 42 * ((H115 < C116) * (H115 - C116) + (C116 < L115) * (C116 - L115) + 40 / 42 * ((H116 < C117) * (H116 - C117) + (C117 < L116) * (C117 - L116) + 40 / 42 * ((H117 < C118) * (H117 - C118) + (C118 < L117) * (C118 - L117) + 40 / 42 * ((H118 < C119) * (H118 - C119) + (C119 < L118) * (C119 - L118) + 40 / 42 * ((H119 < C120) * (H119 - C120) + (C120 < L119) * (C120 - L119) + 40 / 42 * ((H120 < C121) * (H120 - C121) + (C121 < L120) * (C121 - L120) + 40 / 42 * ((H121 < C122) * (H121 - C122) + (C122 < L121) * (C122 - L121) + 40 / 42 * ((H122 < C123) * (H122 - C123) + (C123 < L122) * (C123 - L122) + 40 / 42 * ((H123 < C124) * (H123 - C124) + (C124 < L123) * (C124 - L123) + 40 / 42 * ((H124 < C125) * (H124 - C125) + (C125 < L124) * (C125 - L124) + 40 / 42 * ((H125 < C126) * (H125 - C126) + (C126 < L125) * (C126 - L125) + 40 / 42 * ((H126 < C127) * (H126 - C127) + (C127 < L126) * (C127 - L126) + 40 / 42 * ((H127 < C128) * (H127 - C128) + (C128 < L127) * (C128 - L127) + 40 / 42 * ((H128 < C129) * (H128 - C129) + (C129 < L128) * (C129 - L128) + 40 / 42 * ((H129 < C130) * (H129 - C130) + (C130 < L129) * (C130 - L129) + 40 / 42 * ((H130 < C131) * (H130 - C131) + (C131 < L130) * (C131 - L130) + 40 / 42 * ((H131 < C132) * (H131 - C132) + (C132 < L131) * (C132 - L131) + 40 / 42 * ((H132 < C133) * (H132 - C133) + (C133 < L132) * (C133 - L132) + 40 / 42 * ((H133 < C134) * (H133 - C134) + (C134 < L133) * (C134 - L133) + 40 / 42 * ((H134 < C135) * (H134 - C135) + (C135 < L134) * (C135 - L134) + 40 / 42 * ((H135 < C136) * (H135 - C136) + (C136 < L135) * (C136 - L135) + 40 / 42 * ((H136 < C137) * (H136 - C137) + (C137 < L136) * (C137 - L136) + 40 / 42 * ((H137 < C138) * (H137 - C138) + (C138 < L137) * (C138 - L137) + 40 / 42 * ((H138 < C139) * (H138 - C139) + (C139 < L138) * (C139 - L138) + 40 / 42 * ((H139 < C140) * (H139 - C140) + (C140 < L139) * (C140 - L139) + 40 / 42 * ((H140 < C141) * (H140 - C141) + (C141 < L140) * (C141 - L140) + 40 / 42 * ((H141 < C142) * (H141 - C142) + (C142 < L141) * (C142 - L141)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / XAVGC41 - .0375) <= .0225
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|