User guide

Using Excel with Datastream Advance for Office
Page 25 of 38
Tools available in the Expression Builder
Function
The Select a Function dialog is displayed. Select a specific Datastream function, the function and its
parameters (e.g., start and end dates) are inserted into the workspace area.
Existing expression
The Expression Picker dialog is displayed. Select an existing Datastream global expression or local expression
to add to your expression. For example, if you want to nest one expression into another. Only expressions with
no symbolic substitution are allowed.
Find Series
Datastream Navigator is displayed. Select a „static‟ or „symbolic‟ series to add to your expression. You can use
the Change Filter facility to select a simple or an extended series filter.
Number
The Enter Number dialog is displayed. Add a number to your expression. A number occupies its own line in the
workspace area, typically after a math operator. Double click the displayed number to enter another value.
Datatype
The Datatype Selection dialog is displayed. Add a datatype after a „static‟ or „symbolic‟ series. You can use the
Datatype dropdown list and mnemonic search to select and add a specific datatype.
Currency
The Currency dropdown list is displayed. Select a different display currency for a „static‟ or „symbolic‟ series.
The currency you select is used for the new expression until you modify it.
Dates
Edit the start and end dates for a selected function. The work space cursor must be positioned over a date
variable line. You have the same start and end date options as you have for normal requests.
Math Operator
Add parenthesis or math operators to your expression. Position the workspace cursor at the insertion point and
click an operator button.
Delete
Delete parts of your expression. For example, details contained within parenthesis. Position the workspace
cursor at the point of deletion and click this button to logically delete expression details.
Undo
Undo your last action in the expression builder workspace. For example, undo the last series added to the
workspace.