User guide

Using Excel with Datastream Advance for Office
Page 35 of 38
USER CREATED TIME SERIES
This workbook also includes a Request table to enable series to be downloaded manipulated - and then
uploaded these series back to Datastream to be charted.
A user time series is a series of values (data) for different points in time created by you and uploaded for storage
on Datastream. The values can be daily, weekly, monthly, quarterly, or yearly and you can save the series in
management groups to help you organise them. You can use these series in Datastream and AFO charts and
reports. You can combine them with Datastream maintained series and use functions and expressions to
manipulate them. An Excel template is used to create and edit your time series. You can download an existing
series to form the basis of a new one.
THE USER CREATED TIME SERIES TEMPLATE:
Name
The series name (up to 64 characters).
Code
The series code. Use this to retrieve your series in Datastream and AFO.
This must start with TS followed by 6 characters, eg TSUKRPI1.
Mgmt. Group
Management group. 1 - 10 characters. You can have up to 200 series in a group, eg UK.
Decimals
The number of decimal places for your values.
As %
No indicates the series are actual values. Yes indicates the series are expressed as
percentages.
Freq. Conv.
Determines the adjustment to make when you use a series at a lower frequency than it is
stored. For example, using series stored with daily values in a request for weekly values.
Sum
Sum all values for a calendar period. Avg - Average all values for a calendar period. End -
The value at the end of a calendar period. Act - The actual value at the calendar intervals.
Date align.
For data adjusted for frequency, select where in the calendar period to align the data for
plotting.