Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 1/15/2006 Posts: 19
|
I believe it was Bruce who kindly wrote me this outstanding PCF on the 3PER RSI of the 1PER Rate of Change. I wanted to see if it could be written also to scan for this for ONE DAY AGO also. Just like if I wanted to scan for stocks that made a 20-day high yesterday (H1 = MAXH20.1), I want to be able to run scans based on this ROC3/RSI1 reading YESTERDAY.
Thanks.
100 - (100 / (1 + (((C0 + C2 > 2 * C1) * (2 * C1 - C0 - C2) + 2 / 3 * ((C1 + C3 > 2 * C2) * (2 * C2 - C1 - C3) + 2 / 3 * ((C2 + C4 > 2 * C3) * (2 * C3 - C2 - C4) + 2 / 3 * ((C3 + C5 > 2 * C4) * (2 * C4 - C3 - C5) + 2 / 3 * ((C4 + C6 > 2 * C5) * (2 * C5 - C4 - C6) + 2 / 3 * ((C5 + C7 > 2 * C6) * (2 * C6 - C5 - C7) + 2 / 3 * ((C6 + C8 > 2 * C7) * (2 * C7 - C6 - C8) + 2 / 3 * ((C7 + C9 > 2 * C8) * (2 * C8 - C7 - C9) + 2 / 3 * ((C8 + C10 > 2 * C9) * (2 * C9 - C8 - C10) + 2 / 3 * ((C9 + C11 > 2 * C10) * (2 * C10 - C9 - C11) + 2 / 3 * ((C10 + C12 > 2 * C11) * (2 * C11 - C10 - C12) + 2 / 3 * ((C11 + C13 > 2 * C12) * (2 * C12 - C11 - C13) + 2 / 3 * ((C12 + C14 > 2 * C13) * (2 * C13 - C12 - C14) + 2 / 3 * ((C13 + C15 > 2 * C14) * (2 * C14 - C13 - C15) + 2 / 3 * ((C14 + C16 > 2 * C15) * (2 * C15 - C14 - C16) + 2 / 3 * ((C15 + C17 > 2 * C16) * (2 * C16 - C15 - C17) + 2 / 3 * ((C16 + C18 > 2 * C17) * (2 * C17 - C16 - C18) + 2 / 3 * ((C17 + C19 > 2 * C18) * (2 * C18 - C17 - C19))))))))))))))))))) / ((C0 + C2 < 2 * C1) * (C0 + C2 - 2 * C1) + 2 / 3 * ((C1 + C3 < 2 * C2) * (C1 + C3 - 2 * C2) + 2 / 3 * ((C2 + C4 < 2 * C3) * (C2 + C4 - 2 * C3) + 2 / 3 * ((C3 + C5 < 2 * C4) * (C3 + C5 - 2 * C4) + 2 / 3 * ((C4 + C6 < 2 * C5) * (C4 + C6 - 2 * C5) + 2 / 3 * ((C5 + C7 < 2 * C6) * (C5 + C7 - 2 * C6) + 2 / 3 * ((C6 + C8 < 2 * C7) * (C6 + C8 - 2 * C7) + 2 / 3 * ((C7 + C9 < 2 * C8) * (C7 + C9 - 2 * C8) + 2 / 3 * ((C8 + C10 < 2 * C9) * (C8 + C10 - 2 * C9) + 2 / 3 * ((C9 + C11 < 2 * C10) * (C9 + C11 - 2 * C10) + 2 / 3 * ((C10 + C12 < 2 * C11) * (C10 + C12 - 2 * C11) + 2 / 3 * ((C11 + C13 < 2 * C12) * (C11 + C13 - 2 * C12) + 2 / 3 * ((C12 + C14 < 2 * C13) * (C12 + C14 - 2 * C13) + 2 / 3 * ((C13 + C15 < 2 * C14) * (C13 + C15 - 2 * C14) + 2 / 3 * ((C14 + C16 < 2 * C15) * (C14 + C16 - 2 * C15) + 2 / 3 * ((C15 + C17 < 2 * C16) * (C15 + C17 - 2 * C16) + 2 / 3 * ((C16 + C18 < 2 * C17) * (C16 + C18 - 2 * C17) + 2 / 3 * ((C17 + C19 < 2 * C18) * (C17 + C19 - 2 * C18))))))))))))))))))))))
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
100 - (100 / (1 + (((C1 + C3 > 2 * C2) * (2 * C2 - C1 - C3) + 2 / 3 * ((C2 + C4 > 2 * C3) * (2 * C3 - C2 - C4) + 2 / 3 * ((C3 + C5 > 2 * C4) * (2 * C4 - C3 - C5) + 2 / 3 * ((C4 + C6 > 2 * C5) * (2 * C5 - C4 - C6) + 2 / 3 * ((C5 + C7 > 2 * C6) * (2 * C6 - C5 - C7) + 2 / 3 * ((C6 + C8 > 2 * C7) * (2 * C7 - C6 - C8) + 2 / 3 * ((C7 + C9 > 2 * C8) * (2 * C8 - C7 - C9) + 2 / 3 * ((C8 + C10 > 2 * C9) * (2 * C9 - C8 - C10) + 2 / 3 * ((C9 + C11 > 2 * C10) * (2 * C10 - C9 - C11) + 2 / 3 * ((C10 + C12 > 2 * C11) * (2 * C11 - C10 - C12) + 2 / 3 * ((C11 + C13 > 2 * C12) * (2 * C12 - C11 - C13) + 2 / 3 * ((C12 + C14 > 2 * C13) * (2 * C13 - C12 - C14) + 2 / 3 * ((C13 + C15 > 2 * C14) * (2 * C14 - C13 - C15) + 2 / 3 * ((C14 + C16 > 2 * C15) * (2 * C15 - C14 - C16) + 2 / 3 * ((C15 + C17 > 2 * C16) * (2 * C16 - C15 - C17) + 2 / 3 * ((C16 + C18 > 2 * C17) * (2 * C17 - C16 - C18) + 2 / 3 * ((C17 + C19 > 2 * C18) * (2 * C18 - C17 - C19)) + 2 / 3 * ((C18 + C20 > 2 * C19) * (2 * C19 - C18 - C20))))))))))))))))))) / ((C1 + C3 < 2 * C2) * (C1 + C3 - 2 * C2) + 2 / 3 * ((C2 + C4 < 2 * C3) * (C2 + C4 - 2 * C3) + 2 / 3 * ((C3 + C5 < 2 * C4) * (C3 + C5 - 2 * C4) + 2 / 3 * ((C4 + C6 < 2 * C5) * (C4 + C6 - 2 * C5) + 2 / 3 * ((C5 + C7 < 2 * C6) * (C5 + C7 - 2 * C6) + 2 / 3 * ((C6 + C8 < 2 * C7) * (C6 + C8 - 2 * C7) + 2 / 3 * ((C7 + C9 < 2 * C8) * (C7 + C9 - 2 * C8) + 2 / 3 * ((C8 + C10 < 2 * C9) * (C8 + C10 - 2 * C9) + 2 / 3 * ((C9 + C11 < 2 * C10) * (C9 + C11 - 2 * C10) + 2 / 3 * ((C10 + C12 < 2 * C11) * (C10 + C12 - 2 * C11) + 2 / 3 * ((C11 + C13 < 2 * C12) * (C11 + C13 - 2 * C12) + 2 / 3 * ((C12 + C14 < 2 * C13) * (C12 + C14 - 2 * C13) + 2 / 3 * ((C13 + C15 < 2 * C14) * (C13 + C15 - 2 * C14) + 2 / 3 * ((C14 + C16 < 2 * C15) * (C14 + C16 - 2 * C15) + 2 / 3 * ((C15 + C17 < 2 * C16) * (C15 + C17 - 2 * C16) + 2 / 3 * ((C16 + C18 < 2 * C17) * (C16 + C18 - 2 * C17) + 2 / 3 * ((C17 + C19 < 2 * C18) * (C17 + C19 - 2 * C18)) + 2 / 3 * ((C18 + C20 < 2 * C19) * (C18 + C20 - 2 * C19))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2006 Posts: 19
|
Thanks again!!!! Works great.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,006
|
Hi Bruce,
Can you provide a 1 period and 5 Period Rate of Change PCF for RSI8.7 and RSI8.7.1 (Average Type-Exponential). After I see these, I will try a 20 Period Rate of Change myself.
Thanks Winnie
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Winnie, Please try the following (assuming use Wilders Smoothing is unchecked):
1-Period Rate of Change of Exponential RSI8.7:
XAVG(RSI8.1,7) - XAVG(RSI8.1.1,7)
5-Period Rate of Change of Exponential RSI8.7:
XAVG(RSI8.1,7) - XAVG(RSI8.1.5,7)
1-Period Rate of Change of Exponential RSI8.7.1:
XAVG(RSI8.1.1,7) - XAVG(RSI8.1.2,7)
5-Period Rate of Change of Exponential RSI8.7.1:
XAVG(RSI8.1.1,7) - XAVG(RSI8.1.6,7)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,006
|
Thanks Bruce
Winnie
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |