Registered User Joined: 4/11/2008 Posts: 12
|
Hoping you can provide a pcf for a keltner channel upper and lower bands for a 40 day with a 4 ATR multiplier around a expontential moving average so I can scan for extreme stock momentum and combine it with other pcfs.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I would not recommend using Indicator Formulas for Keltner Channels are creating Condition Formulas to test for where price is relative to the Keltner Channels. Clicking on the Keltner Channels and selecting Show values in WatchList or Create Scan Condition would be a much better option. It is easier to do and the results will be more efficient than a formula.
That said, a formula for an Exponential Upper Keltner Channel 40, 4.00 could be written as:
(XAVGC40 + XAVGH40 + XAVGL40) / 3 + 4 * (XAVGH40 - XAVGL40 + 0.0489077757274441 * ((H0 < C1) * (H0 - C1) + (C1 < L0) * (C1 - L0) + 39 / 41 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 39 / 41 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 39 / 41 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 39 / 41 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 39 / 41 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 39 / 41 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 39 / 41 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 39 / 41 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 39 / 41 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 39 / 41 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 39 / 41 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 39 / 41 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 39 / 41 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 39 / 41 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 39 / 41 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 39 / 41 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 39 / 41 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 39 / 41 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 39 / 41 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 39 / 41 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 39 / 41 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 39 / 41 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 39 / 41 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 39 / 41 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 39 / 41 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 39 / 41 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 39 / 41 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 39 / 41 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 39 / 41 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 39 / 41 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 39 / 41 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 39 / 41 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 39 / 41 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 39 / 41 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 39 / 41 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 39 / 41 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 39 / 41 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 39 / 41 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 39 / 41 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 39 / 41 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 39 / 41 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 39 / 41 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 39 / 41 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 39 / 41 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 39 / 41 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 39 / 41 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 39 / 41 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 39 / 41 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 39 / 41 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 39 / 41 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 39 / 41 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 39 / 41 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 39 / 41 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 39 / 41 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 39 / 41 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 39 / 41 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 39 / 41 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 39 / 41 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 39 / 41 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 39 / 41 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 39 / 41 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 39 / 41 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 39 / 41 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 39 / 41 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 39 / 41 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 39 / 41 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 39 / 41 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 39 / 41 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 39 / 41 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 39 / 41 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 39 / 41 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 39 / 41 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72) + 39 / 41 * ((H73 < C74) * (H73 - C74) + (C74 < L73) * (C74 - L73) + 39 / 41 * ((H74 < C75) * (H74 - C75) + (C75 < L74) * (C75 - L74) + 39 / 41 * ((H75 < C76) * (H75 - C76) + (C76 < L75) * (C76 - L75) + 39 / 41 * ((H76 < C77) * (H76 - C77) + (C77 < L76) * (C77 - L76) + 39 / 41 * ((H77 < C78) * (H77 - C78) + (C78 < L77) * (C78 - L77) + 39 / 41 * ((H78 < C79) * (H78 - C79) + (C79 < L78) * (C79 - L78) + 39 / 41 * ((H79 < C80) * (H79 - C80) + (C80 < L79) * (C80 - L79) + 39 / 41 * ((H80 < C81) * (H80 - C81) + (C81 < L80) * (C81 - L80) + 39 / 41 * ((H81 < C82) * (H81 - C82) + (C82 < L81) * (C82 - L81) + 39 / 41 * ((H82 < C83) * (H82 - C83) + (C83 < L82) * (C83 - L82) + 39 / 41 * ((H83 < C84) * (H83 - C84) + (C84 < L83) * (C84 - L83) + 39 / 41 * ((H84 < C85) * (H84 - C85) + (C85 < L84) * (C85 - L84) + 39 / 41 * ((H85 < C86) * (H85 - C86) + (C86 < L85) * (C86 - L85) + 39 / 41 * ((H86 < C87) * (H86 - C87) + (C87 < L86) * (C87 - L86) + 39 / 41 * ((H87 < C88) * (H87 - C88) + (C88 < L87) * (C88 - L87) + 39 / 41 * ((H88 < C89) * (H88 - C89) + (C89 < L88) * (C89 - L88) + 39 / 41 * ((H89 < C90) * (H89 - C90) + (C90 < L89) * (C90 - L89) + 39 / 41 * ((H90 < C91) * (H90 - C91) + (C91 < L90) * (C91 - L90) + 39 / 41 * ((H91 < C92) * (H91 - C92) + (C92 < L91) * (C92 - L91) + 39 / 41 * ((H92 < C93) * (H92 - C93) + (C93 < L92) * (C93 - L92) + 39 / 41 * ((H93 < C94) * (H93 - C94) + (C94 < L93) * (C94 - L93) + 39 / 41 * ((H94 < C95) * (H94 - C95) + (C95 < L94) * (C95 - L94) + 39 / 41 * ((H95 < C96) * (H95 - C96) + (C96 < L95) * (C96 - L95) + 39 / 41 * ((H96 < C97) * (H96 - C97) + (C97 < L96) * (C97 - L96) + 39 / 41 * ((H97 < C98) * (H97 - C98) + (C98 < L97) * (C98 - L97) + 39 / 41 * ((H98 < C99) * (H98 - C99) + (C99 < L98) * (C99 - L98) + 39 / 41 * ((H99 < C100) * (H99 - C100) + (C100 < L99) * (C100 - L99) + 39 / 41 * ((H100 < C101) * (H100 - C101) + (C101 < L100) * (C101 - L100) + 39 / 41 * ((H101 < C102) * (H101 - C102) + (C102 < L101) * (C102 - L101) + 39 / 41 * ((H102 < C103) * (H102 - C103) + (C103 < L102) * (C103 - L102) + 39 / 41 * ((H103 < C104) * (H103 - C104) + (C104 < L103) * (C104 - L103) + 39 / 41 * ((H104 < C105) * (H104 - C105) + (C105 < L104) * (C105 - L104) + 39 / 41 * ((H105 < C106) * (H105 - C106) + (C106 < L105) * (C106 - L105) + 39 / 41 * ((H106 < C107) * (H106 - C107) + (C107 < L106) * (C107 - L106) + 39 / 41 * ((H107 < C108) * (H107 - C108) + (C108 < L107) * (C108 - L107) + 39 / 41 * ((H108 < C109) * (H108 - C109) + (C109 < L108) * (C109 - L108) + 39 / 41 * ((H109 < C110) * (H109 - C110) + (C110 < L109) * (C110 - L109) + 39 / 41 * ((H110 < C111) * (H110 - C111) + (C111 < L110) * (C111 - L110) + 39 / 41 * ((H111 < C112) * (H111 - C112) + (C112 < L111) * (C112 - L111) + 39 / 41 * ((H112 < C113) * (H112 - C113) + (C113 < L112) * (C113 - L112) + 39 / 41 * ((H113 < C114) * (H113 - C114) + (C114 < L113) * (C114 - L113) + 39 / 41 * ((H114 < C115) * (H114 - C115) + (C115 < L114) * (C115 - L114) + 39 / 41 * ((H115 < C116) * (H115 - C116) + (C116 < L115) * (C116 - L115) + 39 / 41 * ((H116 < C117) * (H116 - C117) + (C117 < L116) * (C117 - L116) + 39 / 41 * ((H117 < C118) * (H117 - C118) + (C118 < L117) * (C118 - L117) + 39 / 41 * ((H118 < C119) * (H118 - C119) + (C119 < L118) * (C119 - L118)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
While a formula for an Exponential Lower Keltner Channel 40, 4.00 could be written as:
(XAVGC40 + XAVGH40 + XAVGL40) / 3 - 4 * (XAVGH40 - XAVGL40 + 0.0489077757274441 * ((H0 < C1) * (H0 - C1) + (C1 < L0) * (C1 - L0) + 39 / 41 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 39 / 41 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 39 / 41 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 39 / 41 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 39 / 41 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 39 / 41 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 39 / 41 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 39 / 41 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 39 / 41 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 39 / 41 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 39 / 41 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 39 / 41 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 39 / 41 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 39 / 41 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 39 / 41 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 39 / 41 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 39 / 41 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 39 / 41 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 39 / 41 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 39 / 41 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 39 / 41 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 39 / 41 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 39 / 41 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 39 / 41 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 39 / 41 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 39 / 41 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 39 / 41 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 39 / 41 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 39 / 41 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 39 / 41 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 39 / 41 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 39 / 41 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 39 / 41 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 39 / 41 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 39 / 41 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 39 / 41 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 39 / 41 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 39 / 41 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 39 / 41 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 39 / 41 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 39 / 41 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 39 / 41 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 39 / 41 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 39 / 41 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 39 / 41 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 39 / 41 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 39 / 41 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 39 / 41 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 39 / 41 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 39 / 41 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 39 / 41 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 39 / 41 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 39 / 41 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 39 / 41 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 39 / 41 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 39 / 41 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 39 / 41 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 39 / 41 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 39 / 41 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 39 / 41 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 39 / 41 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 39 / 41 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 39 / 41 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 39 / 41 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 39 / 41 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 39 / 41 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 39 / 41 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 39 / 41 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 39 / 41 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 39 / 41 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 39 / 41 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 39 / 41 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72) + 39 / 41 * ((H73 < C74) * (H73 - C74) + (C74 < L73) * (C74 - L73) + 39 / 41 * ((H74 < C75) * (H74 - C75) + (C75 < L74) * (C75 - L74) + 39 / 41 * ((H75 < C76) * (H75 - C76) + (C76 < L75) * (C76 - L75) + 39 / 41 * ((H76 < C77) * (H76 - C77) + (C77 < L76) * (C77 - L76) + 39 / 41 * ((H77 < C78) * (H77 - C78) + (C78 < L77) * (C78 - L77) + 39 / 41 * ((H78 < C79) * (H78 - C79) + (C79 < L78) * (C79 - L78) + 39 / 41 * ((H79 < C80) * (H79 - C80) + (C80 < L79) * (C80 - L79) + 39 / 41 * ((H80 < C81) * (H80 - C81) + (C81 < L80) * (C81 - L80) + 39 / 41 * ((H81 < C82) * (H81 - C82) + (C82 < L81) * (C82 - L81) + 39 / 41 * ((H82 < C83) * (H82 - C83) + (C83 < L82) * (C83 - L82) + 39 / 41 * ((H83 < C84) * (H83 - C84) + (C84 < L83) * (C84 - L83) + 39 / 41 * ((H84 < C85) * (H84 - C85) + (C85 < L84) * (C85 - L84) + 39 / 41 * ((H85 < C86) * (H85 - C86) + (C86 < L85) * (C86 - L85) + 39 / 41 * ((H86 < C87) * (H86 - C87) + (C87 < L86) * (C87 - L86) + 39 / 41 * ((H87 < C88) * (H87 - C88) + (C88 < L87) * (C88 - L87) + 39 / 41 * ((H88 < C89) * (H88 - C89) + (C89 < L88) * (C89 - L88) + 39 / 41 * ((H89 < C90) * (H89 - C90) + (C90 < L89) * (C90 - L89) + 39 / 41 * ((H90 < C91) * (H90 - C91) + (C91 < L90) * (C91 - L90) + 39 / 41 * ((H91 < C92) * (H91 - C92) + (C92 < L91) * (C92 - L91) + 39 / 41 * ((H92 < C93) * (H92 - C93) + (C93 < L92) * (C93 - L92) + 39 / 41 * ((H93 < C94) * (H93 - C94) + (C94 < L93) * (C94 - L93) + 39 / 41 * ((H94 < C95) * (H94 - C95) + (C95 < L94) * (C95 - L94) + 39 / 41 * ((H95 < C96) * (H95 - C96) + (C96 < L95) * (C96 - L95) + 39 / 41 * ((H96 < C97) * (H96 - C97) + (C97 < L96) * (C97 - L96) + 39 / 41 * ((H97 < C98) * (H97 - C98) + (C98 < L97) * (C98 - L97) + 39 / 41 * ((H98 < C99) * (H98 - C99) + (C99 < L98) * (C99 - L98) + 39 / 41 * ((H99 < C100) * (H99 - C100) + (C100 < L99) * (C100 - L99) + 39 / 41 * ((H100 < C101) * (H100 - C101) + (C101 < L100) * (C101 - L100) + 39 / 41 * ((H101 < C102) * (H101 - C102) + (C102 < L101) * (C102 - L101) + 39 / 41 * ((H102 < C103) * (H102 - C103) + (C103 < L102) * (C103 - L102) + 39 / 41 * ((H103 < C104) * (H103 - C104) + (C104 < L103) * (C104 - L103) + 39 / 41 * ((H104 < C105) * (H104 - C105) + (C105 < L104) * (C105 - L104) + 39 / 41 * ((H105 < C106) * (H105 - C106) + (C106 < L105) * (C106 - L105) + 39 / 41 * ((H106 < C107) * (H106 - C107) + (C107 < L106) * (C107 - L106) + 39 / 41 * ((H107 < C108) * (H107 - C108) + (C108 < L107) * (C108 - L107) + 39 / 41 * ((H108 < C109) * (H108 - C109) + (C109 < L108) * (C109 - L108) + 39 / 41 * ((H109 < C110) * (H109 - C110) + (C110 < L109) * (C110 - L109) + 39 / 41 * ((H110 < C111) * (H110 - C111) + (C111 < L110) * (C111 - L110) + 39 / 41 * ((H111 < C112) * (H111 - C112) + (C112 < L111) * (C112 - L111) + 39 / 41 * ((H112 < C113) * (H112 - C113) + (C113 < L112) * (C113 - L112) + 39 / 41 * ((H113 < C114) * (H113 - C114) + (C114 < L113) * (C114 - L113) + 39 / 41 * ((H114 < C115) * (H114 - C115) + (C115 < L114) * (C115 - L114) + 39 / 41 * ((H115 < C116) * (H115 - C116) + (C116 < L115) * (C116 - L115) + 39 / 41 * ((H116 < C117) * (H116 - C117) + (C117 < L116) * (C117 - L116) + 39 / 41 * ((H117 < C118) * (H117 - C118) + (C118 < L117) * (C118 - L117) + 39 / 41 * ((H118 < C119) * (H118 - C119) + (C119 < L118) * (C119 - L118)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/11/2008 Posts: 12
|
Thank you.. if I only had one condition I agree the create scan function would be better.. it will be slow but I will be combining it with other pcfs for end of day scans.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you are using the Conditions in an EasyScan instead of trying to create a single combined Condition, you should still be better off clicking on the Keltner Channel and selecting Create Scan Condition.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|