Using function codes as arguments in other functions

The ACHV#, PCHV#, and REB# functions accept certain function codes as arguments in place of the date parameters. You can use the following functions as arguments

ACH Actual change

AVG Average

GRFL Annualised growth rate (first and last values)

GRLS Annualised growth rate (least squares trend line)

MAX Maximum value

MED Median Value

MIN Minimum value

PCH Percentage change

PCHA Percentage change absolute

SDN Standard deviation

SDN1 Standard deviation (N-1)

SUM Sum of values

VAL Last value of period

WAV Weighted average

Examples

ACHV#(MKS,VAL)

This gives the continuous actual change for Marks and Spencers between the current day and the value at the end date on the input screen.

PCHV#(MKS,AVG)

This gives a continuous percentage change for Marks and Spencers between the current day and the average value of the series over the display period, that is, the period between the start date and the end date specified on the input screen.

REB#(MKS,MAX)

This rebases the series so that the maximum share price for Marks and Spencers over the display period equals 100. This allows you to readily estimate the share price deviation below the peak value.

Note 1: You do not use the # sign when using a function as an argument in another function.

Note 2: In static requests, the start date for the calculation defaults to 12 months prior to the specified display date.