User guide

Using Excel with Datastream Advance for Office
Page 15 of 38
When you click the Expression Picker button in the Edit Series/Lists (Time Series dialog) the
Expression Picker is displayed showing All the expressions on the ID. When you return the expression to
the Editor it returns the name of the Expression with symbolic placeholders “X”, “Y”, “Z”, “A” replaced by Series1,
Series2, Series3 or Series4, as appropriate.
But, when you click the Expression Picker button in the Datatypes/Expressions (both Static and Time
Series dialog) the Expression Picker is displayed showing only those expressions with 1 symbolic variable.
When you click the Currency Picker button available in the Times Series request, Datatype Currency
dialog is displayed. Select a Currency and click Apply Last/Selected button to apply currency like:
SERIES~Currency (Eg: BAY~AL).
Other functionalities in the Expression Editor (both Static and Time Series dialog)
- Click this button to delete the text in the Editor area.
- Click this button to view classifications and metadata displayed from the Navigator. For functions, this
button is not enabled.
- Click this button to replace the selected item in the Selector grid below the text in the Editor area.
- Click this button to add Editor text as new item in Selector.
- Click this button to delete item from Selector.
- Click these buttons to move items in the Selector up and down.