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

% Change Weekly Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
hhphoto2006
Posted : Wednesday, July 5, 2017 10:44:31 AM
Registered User
Joined: 10/18/2008
Posts: 260

Hi Bruce

Is it possible to write a PFC column formula for price % change not daily but weekly?

Thank you

Bruce_L
Posted : Wednesday, July 5, 2017 10:50:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formula is the same if you are interested in a calendar week running from Monday through Friday. So the percent change since the close on Friday (or earlier day if Friday is a market holiday).

100 * (C / C1 - 1)

You just need to change the Time Frame setting of the WatchList Column to use Weekly instead of Daily (and you should be able to do this with the existing % Change WL Column as well).

If you are interested in a rolling 5 trading day "week", you could use the following with a daily time frame instead (but it isn't going to take into account market holidays).

100 * (C / C5 - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
hhphoto2006
Posted : Sunday, July 9, 2017 2:23:20 PM
Registered User
Joined: 10/18/2008
Posts: 260

Thanks Bruce

traderc
Posted : Sunday, July 9, 2017 4:17:38 PM
Registered User
Joined: 10/7/2004
Posts: 86

Bruce follow-on to above,

How can one display a % in the column instead of an integer.

so the colum dat would be as an example,

23.4% instead of 23.4

thnx

rctrade

 

 

 

Bruce_L
Posted : Monday, July 10, 2017 9:46:54 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I do not know of a way to force the display of the percent symbol in a WatchList Column in TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderc
Posted : Monday, July 10, 2017 4:52:04 PM
Registered User
Joined: 10/7/2004
Posts: 86

thanks Bruce

Bruce_L
Posted : Monday, July 10, 2017 4:55:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-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.