Registered User Joined: 3/13/2005 Posts: 10
|
I want to create a personal criteria for a Moving Average 10 crossing through a Moving Average 30
on the upside. Can you help me?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If the Moving Averages are Simple:
AVGC10 > AVGC30 AND AVGC10.1 <= AVGC30.1
If the Moving Averages are Exponential:
XAVGC10 > XAVGC30 AND XAVGC10.1 <= XAVGC30.1
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"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 12/12/2006 Posts: 77
|
How about these same moving averages - 10 and 30 - crossing each other in either direction? With both the Simple MA and the Exponential MA? Thank you!!!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
For the Simple, the formula would be:
SGN(AVGC10 - AVGC30) <> SGN(AVGC10.1 - AVGC30.1)
For the exponential, you would just need to change AVGC to XAVGC:
SGN(XAVGC10 - XAVGC30) <> SGN(XAVGC10.1 - XAVGC30.1)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|