This calculates a function for a series for each full calendar quarter within the display period. Calendar quarters run from 1 January to 31 March, from 1 April to 30 June, from 1 July to 30 September, and from 1 October to 31 December.
CFQ#(Expression,Parameter,Display Indicator,Carry indicator)
Where Parameter is usually 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 quarter values (where PCH uses the start and end of quarter 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
CW Values are padded but only within calendar months.
I missing or NA values are ignored.
N output values are NA’s if the input values contain an NA
CFQ#(X,VLO)
VLO retrieves the first reading of each year.
CFQ#(C:GIM,SDN)
This calculates the standard deviation for the Gulf International price for each full month within the display period.
CFQ#(FTSE100,VLO,R)
This calculates the value for the first day of each quarter requested in the time period, including both the first quarter and the last (unfinished) quarter.
CFQ#(ABF(P#S),AVG,R,I)
This calculates the average price for each quarter requested in the time period, including both the first quarter and the last (unfinished) quarter. Missing values are ignored.
CFQ#(USCONPRCE,PCHP,P)
This calculates the percentage change between the previous and present quarter end values of a US consumer price index