Registered User
Joined: 2/19/2009
Posts: 28
|
Hey Bruce
was wondering if you can show me how to convert this PCF into S.F??
Thanks Craig
If you want the True Range to be, on average, at least 3 points a day for the last 20-Days you would use the 20-Period Simple Moving Average of True Range formula and add >= 3 to end to convert from a Value based formula to a Boolean (True or False) formula to use as an EasyScan Condition.
If you need the Minimum Value of True Range over the last 20-Days to be at 3, you would want to test each of the last 20-Days:
(H -L + ABS(H - C1) + ABS(C1 - L)) / 2 >= 3 AND (H1 -L1 + ABS(H1 - C2) + ABS(C2 - L1)) / 2 >= 3 AND (H2 -L2 + ABS(H2 - C3) + ABS(C3 - L2)) / 2 >= 3 AND (H3 -L3 + ABS(H3 - C4) + ABS(C4 - L3)) / 2 >= 3 AND (H4 -L4 + ABS(H4 - C5) + ABS(C5 - L4)) / 2 >= 3 AND (H5 -L5 + ABS(H5 - C6) + ABS(C6 - L5)) / 2 >= 3 AND (H6 -L6 + ABS(H6 - C7) + ABS(C7 - L6)) / 2 >= 3 AND (H7 -L7 + ABS(H7 - C8) + ABS(C8 - L7)) / 2 >= 3 AND (H8 -L8 + ABS(H8 - C9) + ABS(C9 - L8)) / 2 >= 3 AND (H9 -L9 + ABS(H9 - C10) + ABS(C10 - L9)) / 2 >= 3 AND (H10 -L10 + ABS(H10 - C11) + ABS(C11 - L10)) / 2 >= 3 AND (H11 -L11 + ABS(H11 - C12) + ABS(C12 - L11)) / 2 >= 3 AND (H12 -L12 + ABS(H12 - C13) + ABS(C13 - L12)) / 2 >= 3 AND (H13 -L13 + ABS(H13 - C14) + ABS(C14 - L13)) / 2 >= 3 AND (H14 -L14 + ABS(H14 - C15) + ABS(C15 - L14)) / 2 >= 3 AND (H15 -L15 + ABS(H15 - C16) + ABS(C16 - L15)) / 2 >= 3 AND (H16 -L16 + ABS(H16 - C17) + ABS(C17 - L16)) / 2 >= 3 AND (H17 -L17 + ABS(H17 - C18) + ABS(C18 - L17)) / 2 >= 3 AND (H18 -L18 + ABS(H18 - C19) + ABS(C19 - L18)) / 2 >= 3 AND (H19 -L19 + ABS(H19 - C20) + ABS(C20 - L19)) / 2 >= 3
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
- Select Add Indicator | Select... | Average True Range | OK.
- Left-click on the ATR to bring up the Main tab of its Edit window.
- Change the Period to 1 and select OK.
- Select Add Indicator | Select... | Moving Average | OK | Average True Range | OK.
- Left-click on the Moving Average to bring up the main tab of its Edit window.
- Make the following adjustments to the settings and select OK.
-- Average Type: Simple
-- MovAvg Period: 20
-- Offset: 0
- Right-click on the Moving Average and select Create Rule | Greater Than Value: 3 | Apply | OK.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|