| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/14/2005
Posts: 12
|
Need formula for the price % change from 21 days ago. Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
The 21-day percent change or the 1-day percent change 21 days ago?
- Craig
Here to Help!
|
|
Registered User
Joined: 11/14/2005
Posts: 12
|
QUOTE (Craig_S) The 21-day percent change or the 1-day percent change 21 days ago?
I am trying to do a "custom sort" to compare the relative performance of select major index' for given periods. For example, QQQQ, DIA, IWF,...
So I want to sort by the percent change each is from "21" days ago, recognizing some will be positive while others will be negative. Hopefully this explains what I am trying to do. I still have not sorted out your question as to which, but hopefully what I have said answers the question. As always, thank you for your assistance.
Ken Bradshaw
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Let me ask another way...
Are you trying to rank the list by their price performance over the last 21 days (from the price 21-days ago till now)?
- Craig
Here to Help!
|
|
Registered User
Joined: 11/14/2005
Posts: 12
|
Yes, and thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Create a WatchList of your major indexes then sort them by Price Percent Change 1-Month.
This will rank them by their 21-day percent performance.
Here are two videos to review:
Create your own stock rankings using WatchLists and Sort conditions
How to create your own Personal WatchList
- Craig
Here to Help!
|
|
Registered User
Joined: 11/14/2005
Posts: 12
|
Let's, say, I wanted to rank the Index' by "15", or some number other than 21 ( or one already customized in the Sort Menu?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Then you can use this PCF as a template:
Price Percent Change 10-day
100*(C-C10)/C10
- Craig
Here to Help!
|
|
|
Guest-1 |