Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 45
|
I`m looking for a scan to pick out stocks where the RSI 2 with average of 2 days goes below 30.
Thanks for your assistance.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If Use Wilders Smoothing is unchecked and the Average Type is Simple:
RSI2.2 < 30 AND RSI2.2.1 >= 30
If Use Wilders Smoothing is unchecked and the Average Type is Exponential:
XAVG(RSI2,2) < 30 AND XAVG(RSI2.1.1,2) >= 30
If Use Wilders Smoothing is checked and the Average Type is Simple:
50 * ((C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + (C1 - XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15))))))))))))))))) / 2 + 50 < 30 AND 50 * ((C1 - XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + (C2 - XAVGC3.3) / 2 / (.500030519440884 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15) + .5 * (ABS(C15 - C16))))))))))))))))) / 2 + 50 >= 30
If Use Wilders Smoothing is checked and the Average Type is Exponential, the resulting formula is probably too long to be practical.
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Cascades of Moving Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/4/2005 Posts: 4
|
I have read through the RSI2 postings pertaining to RSI2 cumulative and I am more confused than before. I am trying to create a RSi2.1 + RSI2.1.1 . I can't get my values to match the charts. I have picked up that it is in teh way PCF calculates the wilders smoothing. V11 doesn't give you a choice and I want the Wilders smoothing. So what should my formula be if I want Wilders smoothing? Any ideas?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The TC2000.com version 11 beta has two different indicators instead of providing a Use Wilders Smoothing option as part of a single indicator. The RSI does not use Wilders Smoothing and the RSI - Wilders does use Wilders Smoothing.
It should probably be noted that you ended up choosing a topic that has nothing at all to do with a Cumulative RSI (although since it does have to do with Average RSI, you could multiple the formula by two to get the Sum instead). If you want to add together Wilders Smoothed versions of the current and previous 2-Period Wilders Smoothed RSIs, the formula could be written as:
50 * (C - XAVGC3.1) / 2 / (.500030519440884 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50 + 50 * (C1 - XAVGC3.2) / 2 / (.500030519440884 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |