User guide
Using Excel with Datastream Advance for Office
Page 36 of 38
1st - Plot data from the beginning of the calendar period.
Mid - Plot data from the middle of the calendar period.
End - Plot data from the end of the calendar period.
Carry ind.
For null values. You can leave the values blank or carry forward the previous value.
Yes - carries the previous value. No - leaves the value at null.
Upload type
When editing a series, you can upload only the values that have changed.
Full - uploads all the values in the series.
Partial - uploads the values that have changed.
Set date range
This is used to set the start and end dates, and the frequency for new series. Use this to
change the end date when extending the series.
Optional:
Units
A qualifying unit for your data. For example: tons, U$ millions, index.
Currency
Select a currency for series with monetary values.
Other fields:
Start date
The start date for the series data.
End date
The end date for the series data. Note, you can change this for Partial uploads - only data
after the end date is uploaded.
Frequency
The frequency of values: daily, weekly, monthly, quarterly, or yearly.
CREATING A USER CREATED TIME SERIES
To create a time series:
1. Select New UCTS table from the Datastream menu>User created time series menu and save the
workbook.
2. Type a name for the series.
3. Type the series code. This must start with TS followed by 6 characters, example TSUKRPI1.
4. Type the management group you want the series to belong to (up to 10 characters) example UK.
5. Select the number of decimal places for display. Type the number, or select from the drop down box and
click the Add button.
6. Type the units, (optional). This is a qualifying unit for your data. For example: tons, U$ millions, index.
7. Select As %. No indicates the values are actual values. Yes indicates the values are expressed as
percentage. Used in the Latest Values and % change over 3 periods report.
8. Select the type of Frequency conversion. This determines how the series is handled if you use it a lower
frequency than it is stored.
9. Select the Date alignment for data adjusted for frequency.
10. Select a Currency for monetary values (optional).
11. Select the Upload type. Select Full to upload all the values.
Use Partial to upload only the values that have changed when editing a series.