User guide

Using Excel with Datastream Advance for Office
Page 12 of 38
Selecting dates
Dates can be typed as either a fixed date format, that is dd/mm/yy, or as a number of days (D), weeks (W),
months (M), quarters (Q), or years (Y) ago from today, for example -3D which is three days ago from today.
Note If the Date field is left blank, the last value (which may be prior to the date of the request) will be
retrieved. You can also enter TODAY in the Date field to retrieve the latest intraday values.
Latest Intraday prices are only available for European equities and indices where real time prices
are subscribed to.
CREATING EXPRESSION USING INTELLISENSE FEATURE
Intellisense automatically lists all the available Datastream functions. You can then select one by using the
arrow keys and hitting a completion character when the correct member function is highlighted.
There are two ways you can create or select an expression with Intellisense:
1. Using Function Selector / Help.
2. Writing directly in Text field, and selecting expression.
Using Function Selector for expression creation
1. Choose Time Series Request or Static Request from the Datastream menu.
2. Click Function Selector button, The Function Help dialog is displayed.
3. Select a function from the list, for example ABS# and click OK. Function arguments dialog box is then
displayed.