Date parameters

Functions ACHV#, PCHV#, REB#, and VAL# accept the following date parameters as arguments:

• WKE last weekend

• WKE+/-XXXF last weekend with positive or negative offset, where F can be D, W, etc

• MTE last month end

• MTE+/-XXXF last month end with positive or negative offset, where F can be D, W, etc

• QTE last quarter end

• QTE+/-XXXF last quarter end with positive or negative offset, where F can be D, W, etc

• HFE last half-year end

• HFE+/-XXXF last half-year end with positive or negative offset, where F can be D, W, etc

• YRE last calendar year end

• YRE+/-XXXF last calendar year end, with positive or negative offset, where F can be D, W, etc

• LYE last financial year end

• LYE+/-XXXF last financial year end with positive or negative offset, where F can be D, W, etc

• LYEXX last financial year end minus XX years

• Not available for REB#

• LYEXXF last financial year end plus or minus an offset such as LYE+1Y or LYE-2M
  Not available for REB#

• BDATE base date for the series

• BDATEXXF base date plus an offset XXF as for example BDATE10Y display a value for 10 years after the base date

• CDATE date of last change of bourse or exchange listing

• TIME date for latest available value
  Only available for the VAL# and REB# functions

• TIME-XXF where XXF is an offset such as for example -10M or -10F where F is literally used to have the offset in terms of the data frequency for the datatype used in the expression Only available for the VAL# and VALD# For the latter only XXF allowed

• VAL last value in display or request range
  Only available for the functions CFW#, CFM#, CFQ#, CFH#, CFY# and VAL#.

• VLO first value of period
  Only available for the functions CFM#, CFQ#, CFH#,CFY# and VAL#.

• WTD Week to date
  Only available for ACHV# and PCHV

• MTD month to date
  Only available for ACHV# and PCHV

• QTD quarter to date
  Only available for ACHV# and PCHV

• YTD year to date
  Only available for ACHV# and PCHV#

• FXYR latest IBES FY estimate – where X is 0 to 4 estimates

• FPXYR latest IBES FY actual where X is 1 to 4 actual

• EPSANCDT Datastream EPS actual announcement date; value depend on request (start) date
  Only available for ACHV#, PCHV# and VAL#.

• FSET for bonds/convertibles having the datatype FSET for First settlement date

• FSET+/-XXF for positive or negative offsets, where F can be D, W, etc

Some of the other functions may accept a subset of the above parameters. That is mentioned specifically for each function.

Examples

VAL#(X,YRE+10D)

Displays the value at the last calendar year end.plus ten observations presuming daily frequency for X.

ACH#(X,QTE-1Q,)

Displays the actual change in value since next to the last quarter end

REB##(X,FSET+10D)

Rebases to 100 on the FSET plus ten days