Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Formula reults and chart indicator don't agree Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
reeder1558
Posted : Wednesday, April 25, 2012 5:01:03 PM
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&rsquo;t they 0.00??

Thanks for your help.

Richard

Bruce_L
Posted : Thursday, April 26, 2012 8:22:31 AM


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
reeder1558
Posted : Thursday, April 26, 2012 5:43:31 PM
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

Bruce_L
Posted : Thursday, April 26, 2012 7:21:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.