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
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) 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
|