Registered User Joined: 9/15/2011 Posts: 9
|
Hi - i want to run a pcf % true indicator which states that the %B 20, 2 has not been under 0 in the last 10 periods or over 100.
I know i can run a pcf for the 10 periods to say it has been between 99.9 and 0.1 and then put the % true in as 100 but i do not know what the pcf formula for %B 20, 2 is. Can you help?
thanks
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
An Indicator Formula Formula for a %B 20, 2.00 can be written as follows.
(C - AVGC20) / 4 / 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) + .5
So you should be able to just add the < 0 or > 100 portion to the end to create the Boolean Formula to use in your Custom PCF % True Indicator.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|