User guide

Using Excel with Datastream Advance for Office
Page 14 of 38
USING EXPRESSION EDITOR IN STATIC AND TIME SERIES DIALOGS
The Expression Editor helps you to edit long strings you have entered in the Series/Lists (Time Series dialog) or
the Datatypes/Expressions (Static dialog) text boxes in Excel. The Expression Editor is available whether
Intellisense is “on‟” or “off”.
Expression Editor launched from the Series/Lists (Time Series dialog)
In a Time Series request, you can enter series, datatypes and currency conversion combinations.
1. Click the Editor button next to the Series/Lists textbox in the Times Series dialog. Edit
Series/Lists dialog is displayed.
2. You can construct an expression in the Editor using the Navigator button and/or the
Function/Expression/Currency pickers .
3. Click the fx button to select a function. Once you select a function and click OK, Function
arguments dialog is displayed.
4. When you click OK in the dialog above, if “X”, “Y”, “Z”, “A” is displayed the Expression field, then in the
text returned to the Editor - Series1, Series2, Series3, Series4 are displayed depending on the number of
substitutable variables in the function. In the example above, MAV#(X,1Y) is returned as
MAV#(Series1,1Y).
5. The Series1 text is then highlighted when the expression is returned to the Editor. This should then be
replaced by a series from the Navigator. Note there is a tip below which tells you what to do next. For
example, you should not enter datatypes in the Datatypes/Expressions field in the static or time series
dialog if a function or expression is used in the Series/List field.