User guide

Using Excel with Datastream Advance for Office
Page 4 of 38
Utilities:
This group consists of six buttons.
Find the series and datatype you require, using the extensive facilities
available in Navigator and return these values to your spreadsheet.
Create, calculate and select User Created Indices on your Datastream ID.
View and create the saved expressions on your Datastream ID.
Create a local, central system (l#), or User Created Index (x#) list from
Datastream, SEDOL or ISIN codes in a range of cells.
Create local lists using series from Navigator or Datastream lists or edit
your lists.
Open a new User Created Time Series Sheet to upload your own series to
commingle with Datastream series.
Open new chart window.
Open new library window.
Open Chart Manager to refresh, edit, apply style, remove links, delete and
upload charts.
Get the latest charts associated to particular Templates in your current
spreadsheet.
Refresh selected / all charts with the latest data.
Open more chart pages (Key Indicators, Overview, Reports) in a new
window. This drop-down list contains following buttons:
Key Indicators: Open the Key Indicators page in a new window.
Overview: Open the Overview page in a new window.
Report: Open the Report page in a new window.
Options
Configure a range of settings and defaults to reflect your preferences.
Extranet
Access the Extranet for information on Datastream content and functionality
including details of the latest changes.
Help
Access Online help contents, Definitions, Contact Us link and Version
details.
Help:
Help Contents: View Datastream Advance for Office - Online help.
Help Definitions: View the syntax for Datastream functions and
expression language.
User Guide: View Datastream for Advance using Excel manual.
Contact Us: Access Thomson Reuters contact details.
About:
Advance for Office: View Advance for Office version details.
Charting for Office: View Datastream Charting version details.