Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Price % Chg prev Quarter Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jbclem
Posted : Friday, March 31, 2017 10:37:22 PM
Gold Customer 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

 

Bruce_L
Posted : Monday, April 3, 2017 9:50:14 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.