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