Gold Customer
Joined: 1/26/2005 Posts: 113
|
I'd like to write a PCF (to use as a column heading for sorting purposes) for the Price % Chg of the quarter that just ended. I see there's a Price % Chg 28 weeks condition available and if I could see that formula it should be a simple thing to change it to 12 weeks.
But where is that condition so I can see it's formula? Or, how can I write a condition that could be used as a column heading? Is that even possible...
John
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A price percent change for the most recent 12 bars could be written as follows. You could use this with a weekly time frame in TC2000 v17.
100 * (C / C12 - 1)
But if you want the 12 bars ending during the previous bar, you would need to add 1 to all of the bars ago parameters.
100 * (C1 / C13 - 1)
You may be better off the 1 period price percent change for the previous bar in a quarterly time frame if you are interested in a quarterly percent change however in TC2000 v17.
100 * (C1 / C2 - 1)
Rate of Change Percent (ROC%)
But if you are using TC2000 v7, you will only be able to use a daily time frame and will probably want to use dates.
100 * C'03/31/2017' / C'12/30/2016' - 1)
For a 12 week price percent change, you would multiply the periods by 5 to get the daily formula. So for the current value.
100 * (C / C60 - 1)
And for the previous value.
100 * (C5 / C65 - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|