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

Why does't my chart match my PCF Result? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Deion
Posted : Saturday, July 8, 2006 3:07:58 AM
Registered User
Joined: 2/19/2006
Posts: 89
I have a PCF that is titled "Close relative to 10 EMA" and the formula is C / AVGC10. I thought this PCF is supposed to show the close in relation to 10 day expotentioal moving average. When I use the ticker XAX (American Composite) it gives me a value of 1.02 meaning the 10 day EMA should be right near the last closing price. However in my chart he 10 day EMA is well below the closing price.

In another instance, using COMPQX I get a value of .99 but in the chart, the 10 day EMA is well above the closing price.

Any help would be much appreciated.
Craig_S
Posted : Saturday, July 8, 2006 5:28:21 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Your PCF is for a simple moving average. Try this version:

100*C/XAVGC10

I also added 100* to make it close as percent of 10ema. You want values near 100.

Check this out when you get a chance:Handy PCF example formulas to help you learn the syntax of PCFs!

- Craig
Here to Help!
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.