User guide

Using Excel with Datastream Advance for Office
Page 10 of 38
CREATING TIME SERIES REQUESTS
You can create time series requests for individual series (e.g. price indices, exchange rates, and expression,
etc.) as well as for your Datastream Local Lists, User created lists, and Datastream constituent lists. Unlike static
data requests, you can specify a time period which can start as far back as data is held for a specific stock right
up to the latest value. A Frequency format option enables you to define periodicity of the data required.
Time series requests are created by using the Time Series Request dialog from the Datastream menu,
supplying the required series (lists or expression), datatypes, time period, and frequency, and clicking Submit.
Example
USING LISTS WITH TIME SERIES REQUESTS
When you use a Local List, a Datastream list, or a constituent list with a static data request, between one and
ten datatypes are returned for each series in the list. When you use a Local List, a Datastream list, or a
constituent list with a time series request, a sequence of data (i.e. the time series datatype and frequency) is
returned for each constituent. See Creating local lists.
To indicate that you want a time series on each datatype that you enter, you must click the TS for each item in
list check box. This can be switched off in the options dialog.