Registered User Joined: 12/3/2006 Posts: 278
|
Morning Bruce - could you please make me a pcf for Chaikin Money Flow 21 day to be below it's zero line for 5 days or more?? Thanks - Mike
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The syntax in TC2000 v18 is fairly straightforward.
TrueInRow(AVG((2 * C - L - H) / (H - L - (H = L)) * V, 21) / (AVGV21 - (AVGV21 = 0)) < 0, 5) = 5
But the syntax is TC2000 v7 needs to expand the moving average used for the numerator and compare each bar individually.
((2 * C - L - H) / (H - L + .00001) * V + (2 * C1 - L1 - H1) / (H1 - L1 + .00001) * V1 + (2 * C2 - L2 - H2) / (H2 - L2 + .00001) * V2 + (2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15 + (2 * C16 - L16 - H16) / (H16 - L16 + .00001) * V16 + (2 * C17 - L17 - H17) / (H17 - L17 + .00001) * V17 + (2 * C18 - L18 - H18) / (H18 - L18 + .00001) * V18 + (2 * C19 - L19 - H19) / (H19 - L19 + .00001) * V19 + (2 * C20 - L20 - H20) / (H20 - L20 + .00001) * V20) / (AVGV21 * 21 + .00001) < 0 AND ((2 * C1 - L1 - H1) / (H1 - L1 + .00001) * V1 + (2 * C2 - L2 - H2) / (H2 - L2 + .00001) * V2 + (2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15 + (2 * C16 - L16 - H16) / (H16 - L16 + .00001) * V16 + (2 * C17 - L17 - H17) / (H17 - L17 + .00001) * V17 + (2 * C18 - L18 - H18) / (H18 - L18 + .00001) * V18 + (2 * C19 - L19 - H19) / (H19 - L19 + .00001) * V19 + (2 * C20 - L20 - H20) / (H20 - L20 + .00001) * V20 + (2 * C21 - L21 - H21) / (H21 - L21 + .00001) * V21) / (AVGV21.1 * 21 + .00001) < 0 AND ((2 * C2 - L2 - H2) / (H2 - L2 + .00001) * V2 + (2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15 + (2 * C16 - L16 - H16) / (H16 - L16 + .00001) * V16 + (2 * C17 - L17 - H17) / (H17 - L17 + .00001) * V17 + (2 * C18 - L18 - H18) / (H18 - L18 + .00001) * V18 + (2 * C19 - L19 - H19) / (H19 - L19 + .00001) * V19 + (2 * C20 - L20 - H20) / (H20 - L20 + .00001) * V20 + (2 * C21 - L21 - H21) / (H21 - L21 + .00001) * V21 + (2 * C22 - L22 - H22) / (H22 - L22 + .00001) * V22) / (AVGV21.2 * 21 + .00001) < 0 AND ((2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15 + (2 * C16 - L16 - H16) / (H16 - L16 + .00001) * V16 + (2 * C17 - L17 - H17) / (H17 - L17 + .00001) * V17 + (2 * C18 - L18 - H18) / (H18 - L18 + .00001) * V18 + (2 * C19 - L19 - H19) / (H19 - L19 + .00001) * V19 + (2 * C20 - L20 - H20) / (H20 - L20 + .00001) * V20 + (2 * C21 - L21 - H21) / (H21 - L21 + .00001) * V21 + (2 * C22 - L22 - H22) / (H22 - L22 + .00001) * V22 + (2 * C23 - L23 - H23) / (H23 - L23 + .00001) * V23) / (AVGV21.3 * 21 + .00001) < 0 AND ((2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15 + (2 * C16 - L16 - H16) / (H16 - L16 + .00001) * V16 + (2 * C17 - L17 - H17) / (H17 - L17 + .00001) * V17 + (2 * C18 - L18 - H18) / (H18 - L18 + .00001) * V18 + (2 * C19 - L19 - H19) / (H19 - L19 + .00001) * V19 + (2 * C20 - L20 - H20) / (H20 - L20 + .00001) * V20 + (2 * C21 - L21 - H21) / (H21 - L21 + .00001) * V21 + (2 * C22 - L22 - H22) / (H22 - L22 + .00001) * V22 + (2 * C23 - L23 - H23) / (H23 - L23 + .00001) * V23 + (2 * C24 - L24 - H24) / (H24 - L24 + .00001) * V24) / (AVGV21.4 * 21 + .00001) < 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 12/3/2006 Posts: 278
|
Thanks Bruce - I knew there was a reason I couldn't make this work. What a formula...
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|