Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Keltner PCF request Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
TGS618
Posted : Thursday, March 22, 2012 2:56:00 PM
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.

Bruce_L
Posted : Thursday, March 22, 2012 3:24:10 PM


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
TGS618
Posted : Thursday, March 22, 2012 3:39:33 PM
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.

Bruce_L
Posted : Thursday, March 22, 2012 3:42:56 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.