This calculates a function for a series for each full calendar month within the display period. A calendar month runs from the first working day of the month to the last working day of the month.
CFM#(Expression,Parameter,Display Indicator,Carry indicator)
Where Parameter is usualy the result from another function. Please see: Using function codes as arguments for detail.
An exception is the special parameter PCHP, which calculates the percentage change between the previous and present end of month values (where PCH uses the start and end of month values).
Display Indicator – the default is to display values only for complete periods, however the following optional parameters exist –
P Values calculated for incomplete calendar periods at the start of the display period
R Values calculated for incomplete calendar periods at the start and end of the display period
Carry Indicator – the default is to carry the previous value, but not between periods, however the following optional parameters exist –
C Values are padded
CWValues are padded but only within calendar months
I missing or NA values are ignored
Noutput values are NA’s if the input values contain an NA
CFM#(X,VLO)
VLO retrieves the first reading of each year.
CFM#(C:GIM,VAL)
This calculates the value for Gulf International for each full month within the display period.
CFM#(FTSE100,VLO,R)
This calculates the value for the first day of each month requested in the time period, including in both the first month and the last (unfinished) month.
CFM#(FTSE100(VO),SDN,R,CW)
This calculates monthly standard deviations using within month padded values for each month requested, including those in both the first month and the last (unfinished) month.
CFM#(C:GIM,PCHP,R)
This calculates the percentage change between the previous and current end of month values