Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Squeezes Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
willie moe
Posted : Saturday, March 31, 2012 7:17:51 PM
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

Bruce_L
Posted : Monday, April 2, 2012 11:43:22 AM


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
willie moe
Posted : Monday, April 2, 2012 12:53:44 PM
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

Bruce_L
Posted : Monday, April 2, 2012 1:07:52 PM


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
willie moe
Posted : Monday, April 2, 2012 5:42:31 PM
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

Bruce_L
Posted : Monday, April 2, 2012 5:55:16 PM


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
willie moe
Posted : Monday, April 2, 2012 9:41:50 PM
Registered User
Joined: 8/25/2010
Posts: 117

Thanks Bruce. Nice work as usual. Appreciate it.

yabado7
Posted : Tuesday, April 3, 2012 7:24:49 AM
Registered User
Joined: 6/16/2008
Posts: 1

commodities

Any way to do easy scans on commodities. Thanks

Bruce_L
Posted : Tuesday, April 3, 2012 8:05:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

No. We do not carry commodities.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jmat2413
Posted : Thursday, April 5, 2012 10:22:22 PM
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.

 

Telework
Posted : Sunday, April 8, 2012 1:40:17 AM
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

douwe
Posted : Thursday, February 19, 2015 6:36:20 AM
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?   

Bruce_L
Posted : Thursday, February 19, 2015 9:48:47 AM


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
PiersP
Posted : Thursday, January 25, 2018 2:14:06 AM
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

Bruce_L
Posted : Thursday, January 25, 2018 9:21:34 AM


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
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.