Registered User Joined: 4/9/2011 Posts: 12
|
I am trying to write a formula that shows 2 day RSI falling three days in a row. The first days drop should start from below 60 and the last day should be below 10. Here is my formula:
C > AVGC200 and rsi2.1 < 10 and rsi2.2 < rsi2.3 and rsi2.3 < rsi2.4 and rsi2.4 < 60
When I test it against todays QQQ it is obviously false. My problem is my rsi2 indicator for the past few days shows rsi2 (today and going back) at 83.09, 0.00, 0.00, 0.00.
The test results show
66.45 > 58.81 and 83.09 < 10 and 41.55 <
27.70 and 27.70 < 20.77 and 20.77 < 60
Value = False
C, AVGC200 and rsi2.1 agree with my indicator, but where have the other numbers come from?? Why aren’t they 0.00??
Thanks for your help.
Richard
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The syntax for the plain RSI indicator in the Personal Criteria Formula Language is:
RSIx.y.z -> RSI (not Wilder's Smoothed)
Where x is the Period of the Indicator or Function.
Where y is a the Period of an additional Simple Moving Average.
Where z is the number of Periods Ago.
- z can also be a date. May 3, 2007 would be (single quotes required): '05/03/07'
The arguments in indicators are separated by periods.
So your formula is for the Price above the 200-Period Simple Moving Average, the 2-Period RSI below 10, the 2-Period Simple Moving Average of RSI less than the 3-Period Simple Moving Average of RSI, the 3-Period Simple Moving Average of RSI less than the 4-Period Simple Moving Average of RSI and the 4-Period Simple Moving Average of RSI less than 60.
What I'm guessing you want is:
C > AVGC200 AND RSI2 < 10 AND RSI2.1.1 < RSI2.1.2 AND RSI2.1.2 < RSI2.1.3 AND RSI2.1.3 < 60
Which is Price above the 200-Period Simple Moving Average, the 2-Period RSI below 10, the 2-Period RSI of 1-Bar ago below the 2-Period RSI of 2-bars ago, the 2-Period RSI of 2-bars ago below the 2-Period RSI of 3-bars ago and the 2-Period RSI of 3-bars ago below 60.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/9/2011 Posts: 12
|
Bruce, Thanks for your latest help. Sometimes I get the formula right, but usually I need to turn to you for help.
Richard
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|