User guide

Using Excel with Datastream Advance for Office
Page 9 of 38
Selecting lists
You can use lists stored on your PC (i.e. Local Lists) or remote lists stored on the Datastream host, rather than
selecting a number of individual series. These lists include:
Local Lists created in Datastream or Advance for Office, Datastream lists that have been downloaded onto
your PC for use in Datastream.
User lists (i.e. L#xxxx lists) that are stored on the Datastream host system.
Constituent lists; for example, LFTSE100. See Creating local lists.
To select a list, click the List Picker button , on the Request dialog. When
you use a list of series for
a data request, data is displayed for the selected datatypes for every series in the list in the order that they
appear in the list. Selecting a list from the List Picker copies the list code into the Series field. This could be a
list file for Local Lists (e.g. LNSABANK.LLT), a list code for mainframe lists (e.g. L#A74953) or a
list mnemonic
for constituent lists (e.g. LNSABANK).
Example - User created list and 3 static datatypes
Selecting expressions
For static data requests, you can browse and select expressions stored on the Datastream host system. The
Static Request Expression Picker, displayed by
clicking the Expression button , on the Static Request
screen, can display
all user created expressions or Datastream global expressions, or both. See Using
Expressions. A Refresh Grid button enables you to update the list of expressions held on your PC from the
Datastream host system.
Expressions can be used for static data requests where only one symbolic variable is used. For example,
PCH#(X,1Y) calculates the percentage change over one year where X is either a single series or a constituent of
a list that you select.