| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/27/2005
Posts: 83
|
Hi,
Can you check the way I'm using these PCF formulas. Some look correct and some don't. They're all based on RSI period 14, MA 1 (today RSI14.1, yesterday RSI14.1,1)
Two questions for each item.
- Is the formula correct for arithmetic value?
- Is it correct for displaying visually on a chart of RSI?
1. Looking for the Max value of the RSI in the last 63 periods:
MAX(RSI14.1,63)
2. Looking for the Max value of the RSI in the last 63 periods:
MIN(RSI14.1,63)
3. Looking for the intersection of simple moving average of the RSI period 5
and simple moving average of the RSI period 40.
Expressed as a % above or below the 40 period MA.
(AVG(RSI14.1,5) - AVG(RSI14.1,40) ) / (AVG(RSI14.1,40)) * 100
4. Looking for the % below the MAX for the last 63 days for the current RSI value.
(MAX(RSI14.1,63) - RSI14.1) / MAX(RSI14.1,63) * 100
Thanks,
Craig.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formulas appear to be correct for a Charted RSI with the following settings:
RSI Period: 14
Use Wilders Smoothing: Unchecked
Avg Period: 1
Average Type: Doesn't matter (because the Avp Period is 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/27/2005
Posts: 83
|
Bruce,
I'm not seeing on the chart what I think I should see for the max function. I thought what I was displaying was the highest value in the last 63 days for RSI. But what is showing on the chart dips well below the max for the previous 63 days. For some dates its below the RSI line itself.
I set the max value per formula above using custom indicator with RSI drawn on middle chart.
Settings: visible, deselect zero line and price; smoothing average 1 (doesn't matter), simple.
I'm looking at ORCL.
What I thought I would get if the max in the last 63 days was 65, was a line that went across at 65. If the RSI then dips down to 30 and back up again to 65, I might get some curves but pretty much it should be straight lines. I get the straight lines but they don't make any sense.
Any ideas?
Craig
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you are showing it on the chart, you are probably using a Custom Indicator. A Custom Indicator does not have an automated method for fixing it its scale to the same scale as RSI. That means the RSI and the Custom Indicator are on different scales.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/27/2005
Posts: 83
|
Thanks.
You're correct I am using a custom indicator. So since I can't display it effectively on the chart, the best way to display it would then be as a value in one of the 10 tabbed areas?
Thanks,
Craig.
|
|
Registered User
Joined: 12/27/2005
Posts: 83
|
One other question, you said in a previous quote that the formulas appeared correct for a charted RSI. If I'm displaying the values also in the tabs to the left of the chart, are the formulas correct?
If not, what should they be and why is there a difference?
Thanks,
Craig
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Creating them as Personal Criteria Formulas and displaying them in the Watchlists would be a good option:
How to create a Personal Criteria Forumula (PCF)
Customize the Information Displayed in the WatchList
What I was trying to say was that if your settings were different than what I gave, the values returned would not match your charts. For example, if you checked Use Wilders Smoothing and/or had an Avg Period other than 1, the charted values would change, but the results of the formula would not.
You may wish to review the following:
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |