This calculates the percentage change between values in a series. PCH# has both static and moving formats:
PCH#(Expression,Start Date,End Date)
This static format calculates a single percentage change in value between two dates. Actual dates are typed in using either the standard DD/MM/YY format or the displacement date formats.
As a date parameter one can also use YRE, HFE, QTE, MTE, WKE, LYE, BDATE, BDATEXXF
PCH#(Expression)
If you do not specify start and end dates, the defaults are the start and end dates for the display period.
PCH#(Expression,Period)
This moving format calculates the percentage change for a time period continuously between the start and end dates for the display period. Use the period codes to specify the period.
PCH#(Expression,Period,Parameter)
This moving format calculates the actual change for a time period continuously between the start and end dates for the display period. The trailing parameter determines how observations are selected and can have the following values.
R: Exclude “non-working” days so null values are skipped
PCH#(J:KYTB,1/1/97,31/12/97)
This static format gives the percentage change in value for the Bank of Kyoto share price between 1/1/97 and 31/12/97.
PCH#(J:KYTB)
This default static format calculates the percentage change in value for the Bank of Kyoto between the start and end dates for the display period.
PCH#(FTALLSH,10D)
This moving format calculates a series of percentage changes for values in the FT All Share index over a 10 day period continuously between the display start and end dates.
PCH#(FTSE100,10D,R)
This calculates the rolling ten-day percentage change in the FTSE100 index (using a total of ten working days, and not counting non-working days).
You must use a percentage change period that is consistent with the frequency of the stored data. That is, the Period frequency you request for the function can be greater but not less than the data frequency. For example:
PCH#(UKBCJD..,30D)
A daily time period is invalid for the UK unemployment series because the frequency of the data is monthly.
Note You can use PCH# with a maximum of 4,000 values. If you request a percentage change output which requires more than 4,000 values, an error message is displayed. To reduce the number of values, either reduce the display period or the percentage change period. These time periods should not exceed 15 years.