User guide

Using Excel with Datastream Advance for Office
Page 22 of 38
Expression editing
Select the Show out of date warning to warn you when expressions have not been refreshed.
Intellisense – This option enables you to see the functions and parameters available for the functions with
links to the help files.
Function picker – This option enables you to search and pick the functions and parameters available.for
the functions with links to the help files.
Time series for Lists
Show confirmation dialog – When this option is ticked - a message box is displayed when a series identified as
a list is used and the time series for list tick box is not ticked.
Autocorrect options Delete "..." from the list is removed from Excel‟s default Autocorrect settings whereby "..."
is replaced by the symbol "...".
Datastream Navigator options
The Server field enables you to define the location of the server from which you would like to run Datastream
Navigator.
Symbol Input
Section Symbol Input helps to specify whether the series input codes being used are Datastream supported
ones - DS, ISIN, SEDOL, etc or Thomson ONE codes. Click on the option buttons to specify the input.
Sample Sheet
Samples URL: This specifies the URL from where AFO Samples can be downloaded.
Download Path: The download path for the AFO Samples file can be specified here.