Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 8/25/2010 Posts: 117
|
Bruce,
I want to create a pcf for the following conditions:
BBands 21 2 Channel Top Price History value below 1.1 ATR Channel Top
BBands 21 2 Channel Bottom Price History value above 1.1 ATR Channel Bottom
I use a 21 EMA and would like to look at 100 days of history
I can create the two conditions separately in TC2000, but can't merge them together into one column.
Thanks, William
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I don't have a built in ATR Channel in my copy of TC2000 version 12.1. Is it a Custom PCF Channel Indicator of some sort?
When you say you use a 21-EMA, is that the centerline of the Bollinger Bands or the ATR Channel?
When you say you would like to look at 100 days of history, are you talking about a 100-Period Simple Moving Average of Average True Range or are you somehow trying to test if this is true at some point or at every point over the most recent 100-bars of history?
I guess if you just tell me all of the details of exactly what you are currently doing to create the individual Conditions, I might be able to create the combined Condition. I suspect this will require supplying the information requested above anyway however.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/25/2010 Posts: 117
|
Bruce,
I use the 21-EMA as the centerline for both the Bollinger Bands and ATR Channel
The 100 days of history may not be relevant. I just want to see if the condition exists now.
I use the Keltner channel indicator in TC2000 - I just call itt ATR. Sorry.
To create the conditions I just click on the BBand indicator and create the conditons referenced above.
What I want is the BBand to be inside the 1.1 ATR channel, but have to do it separately for the top and bottom of the channel. I would like to combine them into one reading so I can have it as a column in my watchlists.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20) < 1.1 * (XAVGH21 - XAVGL21 + .0909956583651082 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 10 / 11 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 10 / 11 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 10 / 11 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 10 / 11 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 10 / 11 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 10 / 11 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 10 / 11 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 10 / 11 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 10 / 11 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 10 / 11 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 10 / 11 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 10 / 11 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 10 / 11 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 10 / 11 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 10 / 11 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 10 / 11 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 10 / 11 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 10 / 11 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 10 / 11 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 10 / 11 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 10 / 11 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 10 / 11 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 10 / 11 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 10 / 11 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 10 / 11 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 10 / 11 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 10 / 11 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 10 / 11 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 10 / 11 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 10 / 11 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 10 / 11 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 10 / 11 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 10 / 11 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 10 / 11 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 10 / 11 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 10 / 11 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 10 / 11 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 10 / 11 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 10 / 11 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 10 / 11 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 10 / 11 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 10 / 11 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 10 / 11 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 10 / 11 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 10 / 11 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 10 / 11 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 10 / 11 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 10 / 11 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 10 / 11 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 10 / 11 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 10 / 11 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 10 / 11 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 10 / 11 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 10 / 11 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 10 / 11 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 10 / 11 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 10 / 11 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 10 / 11 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 10 / 11 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 10 / 11 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 10 / 11 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 10 / 11 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 10 / 11 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 10 / 11 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 10 / 11 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 10 / 11 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 10 / 11 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 10 / 11 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 10 / 11 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 10 / 11 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 10 / 11 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 10 / 11 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/25/2010 Posts: 117
|
Thanks Bruce. It's not perfect, but it generates the squeeze condition I am looking for.
Would you mind doing the same forumula for a BBand 21 2 channel inside a 1.5 ATR Channel.
Appreciate it.
Wm
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You just need to change the 1.1 * to a 1.5 * after the < sign:
2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 20) < 1.5 * (XAVGH21 - XAVGL21 + .0909956583651082 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 10 / 11 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 10 / 11 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 10 / 11 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 10 / 11 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 10 / 11 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 10 / 11 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 10 / 11 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 10 / 11 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 10 / 11 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 10 / 11 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 10 / 11 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 10 / 11 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 10 / 11 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 10 / 11 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 10 / 11 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 10 / 11 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 10 / 11 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 10 / 11 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 10 / 11 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 10 / 11 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 10 / 11 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 10 / 11 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 10 / 11 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 10 / 11 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 10 / 11 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 10 / 11 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 10 / 11 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 10 / 11 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 10 / 11 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 10 / 11 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 10 / 11 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 10 / 11 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 10 / 11 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 10 / 11 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 10 / 11 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 10 / 11 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 10 / 11 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 10 / 11 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 10 / 11 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 10 / 11 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 10 / 11 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 10 / 11 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 10 / 11 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 10 / 11 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 10 / 11 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 10 / 11 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 10 / 11 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 10 / 11 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 10 / 11 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 10 / 11 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 10 / 11 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 10 / 11 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 10 / 11 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 10 / 11 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 10 / 11 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 10 / 11 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 10 / 11 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 10 / 11 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 10 / 11 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 10 / 11 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 10 / 11 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 10 / 11 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 10 / 11 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 10 / 11 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 10 / 11 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 10 / 11 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 10 / 11 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 10 / 11 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 10 / 11 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 10 / 11 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 10 / 11 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 10 / 11 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/25/2010 Posts: 117
|
Thanks Bruce. Nice work as usual. Appreciate it.
|
|
Registered User Joined: 6/16/2008 Posts: 1
|
commodities
Any way to do easy scans on commodities. Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
No. We do not carry commodities.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/30/2004 Posts: 35
|
TC2000 does however have some commodity ETN, ETF, and Index Funds which might, to some degree, track the actual commodities.
|
|
Registered User Joined: 1/12/2011 Posts: 183
|
I have an indicator for The Squeeze that works beautifully. You can easily create Scan Conditions from this as well. When the indicator hits 0 the squeeze is on. When it rises back above 0 it is an action signal.
(SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001))-1
|
|
Registered User Joined: 6/11/2009 Posts: 3
|
The Squeeze indicator of Telework works very well. Thankz for that! I use it also in Easy Scans.
But I also really want to scan on tickers which are in squeeze for the first time today. Simply said, the squeeze situation of today has te be compared by the situation yesterday.
My knowledge of programming a PCF or indicator is too little to do this myself. Does anyone have a solution?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You may want to take a look at the TTM Squeeze -- Conditional Statement modification Bruce topic.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 5/28/2009 Posts: 39
|
Hi Bruce...in the squeeze formula provided above by Telework, could you please amend to base it on a 13 period moving average?
The formula provided was:
(SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001))-1
Many thanks,
Piers
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 - 13 * AVGC13 ^ 2) / 13) * 4 / 3 / ((AVGH13 - AVGL13) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13)) / 26 + .000001) - 1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |