Registered User
Joined: 3/27/2005
Posts: 4
|
Need help with 2 simple formulae:
#1)a formula for 5 day mov.avg crossing up through the 10 day mov.avg. I am using (AVGC5.2/AVGC10.2)*100 I am getting stocks that crossed up several days ago instead of the last day or two.
#2) A formula for the price moving up through the 15 day exponential mov. avg.
Thanks for any help and a great program.
(email removed by moderator)
SteadyEddy
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
5 day mov.avg crossing up through the 10 day mov.avg.:
Simple:
AVGC5 > AVGC10 AND AVGC5.1 <= AVGC10.1
Exponential:
XAVGC5 > XAVGC10 AND XAVGC5.1 <= XAVGC10.1
price moving up through the 15 day exponential mov. avg.:
C > XAVGC15 AND C1 <= XAVGC15.1
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 3/27/2005
Posts: 4
|
Thanks Bruce for the prompt response. Both formulae work great.
SteadyEddy
|
Registered User
Joined: 8/13/2006
Posts: 1
|
Why is so hard to find how to put a PCF into a tab? That's all I want to do.
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Have you watched these videos yet?
How to create a Personal Criteria Forumula (PCF)
Customize the Information Displayed in the WatchList
- Craig
Here to Help!
|