This calculates the value of a series or expression at a given date.
VAL#(Expression,Date)
This displays a single value for a series at a specified date. This value can be used within an expression or displayed on a graph where it appears as a horizontal line. You can use actual dates (standard DD/MM/YY format) or displacement dates or date parameters.
VAL#(Expression)
If you do not specify a date, the default is the end date of the display period.
VAL#(Expression, BDATEXXF)
The BDATE parameter displays the value on the base date plus a period specified in terms of a number XX and a frequency F, for example 30D to specify 30 days.
VAL#(Expression, LYEX)
This displays the value for the fiscal year-end X periods prior to the last year end.
VAL#(Expression , LYE-XXF )
This displays the value for the fiscal year-end minus XXF periods.
VAL#(Expression , LYE+XXF )
his displays the value for the fiscal year-end plus XXF periods.
VAL#(Expression, TIME-XXF)
The TIME parameter displays the value on the date of the latest available value. Optionally, a period prior to the TIME date can be specified in terms of a number -XX and a frequency F, for example -2Q to specify 2 quarters before the date of the last available value. Note – you can also specify F as the frequency – this will take the frequency of the series – so -2F would be 2 quarters for a quarterly for a quarterly series and 2 months for a monthly series
VAL#(UKCONEXPB-UKCNFOODB,31/12/98)
This displays the value of UK consumer expenditure on all items except food as at 31/12/98.
VAL#(FTSE-100,-1M)
This displays the value of the FTSE 100 one month in the past.
VAL#(@FB,BDATE3M)
This displays the Facebook share price 3 months after its base date.
VAL#(MKS(WC01001),LYE3)
This displays Mark and Spencer revenues from 3 fiscal years prior to the most recent fiscal year end.
VAL#(X(MV), LYE-100D)
This will display the MV value on the latest fiscal year-end minus 100 days.
VAL#(SDGDP...D,TIME-3Q)
This displays Swedish GDP from 3 quarters prior to the latest reported values.
VAL#(SDGDP...D,TIME-1F) and VAL#(SDCONPRCF,TIME-1F)
This displays Swedish GDP from 1 quarter prior to the latest reported values, and CPI 1 month prior to the latest value