Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
Registered User Joined: 10/18/2008 Posts: 260
|
Thanks Bruce
|
|
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
|
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 86
|
thanks Bruce
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |