Registered User
Joined: 10/7/2004
Posts: 7
|
I would like to set up a PCF formula which shows the change in closing price from one day - the closing price of the day before.
I would like to be able to show the formulas (as a PCF) as follows:
(Closing Price for April 24, 2009 - Closing Price for April 23, 2009)
__________________________________________________ * 100.0
(Closing Price for April 23, 2009)
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
100 * (C'04/24/09' - C'04/23/09') / C'04/23/09'
There are two distinct ways to use historical data with Personal Criteria Formulas.
Any criteria can be used to scan X number of days back by adding '.XX' where XX is equal to the number of market days past to calculate for. An example of this is (AVGC21.21), which is a 21 day moving average 21 of close, 21 days ago. This use of historical data always refers to the market day XX number of days ago (in this case, 21). If you wish to use a specific date’s data, use the option detailed below.
The other method of using historical data is by specifying a precise date in history to use. For example, (AVGC21.'11/13/08') will provide a 21 day moving average of close for November 13, 2008 (the period should be used in cases where the first method requires a period and not used when the first method does not use a period). Always confirm that the date you wish to use using this parameter was a market day.
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|