Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Can you check some PCF formulas for me Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
hicraig3
Posted : Sunday, March 23, 2008 1:27:58 PM
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.





Bruce_L
Posted : Monday, March 24, 2008 10:19:38 AM


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
hicraig3
Posted : Tuesday, March 25, 2008 1:34:10 AM
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





Bruce_L
Posted : Tuesday, March 25, 2008 6:21:26 AM


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
hicraig3
Posted : Wednesday, March 26, 2008 7:17:28 AM
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.
hicraig3
Posted : Wednesday, March 26, 2008 7:20:25 AM
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

Bruce_L
Posted : Wednesday, March 26, 2008 8:22:27 AM


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
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.