Registered User Joined: 12/30/2004 Posts: 10
|
I have been trying to figure out how to rank a watchlist using the ROC of the 200 day Expotential Moving Average.
In other words I start with a 200 day expotential MA of the price. I then want to get the ROC of this MA and then somehow rank the stocks in the Watchlist from the Best ROC to the worst ROC
Any help would be appreciated.
Greg Vieth
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could sort in descending order using one of the following formulas:
1-Period ROC (Net) of EMA200:
AVGC200 - AVGC200.1
1-Period ROC ( %) of EMA200:
100 * AVGC200 / AVGC200.1 - 100
You can adjust the ROC period by adjusting the days ago parameter (the .1). You may wish to review the following:
Create your own stock rankings using WatchLists and Sort conditions How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|