Gold Customer
Joined: 3/8/2018 Posts: 30
|
What would be a formula for sorting based on performance
stocks that have done the best in last 3 years , 5 years , etc.
in terms of percentage and in terms of dollar value
Thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could use the following formula for a 252-period % change.
100 * (C / C260 - 1)
And the following formula for a 252-period net change.
C - C260
Set the time frame to 3 day for a 3 year change and to weekly for a 5 year change.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|