User guide

Using Excel with Datastream Advance for Office
Page 21 of 38
T1 code - displays Thomson ONE code for the requested series. It is available only when Datastream is
embedded in the Thomson ONE workstation and currently applies to the Equities only.
Transpose - displays individual time series data across the Excel spreadsheet in rows. This is particularly
useful if you are requesting data over very short time periods or lower reporting frequencies, that is
quarterly or yearly. The maximum number of columns that you can use in Excel 2003 and earlier is 255.
Hyperlink to metadata - Adds a hyperlink to the series code to link to the classifications and metadata pages from
Navigator for the series (also enable series that are now dead or inactive to be identified in your workbook)
Currency - displays an additional column with the title Currency and with the traded currency of each
selected series.
Annualise Data - adjusts company accounts data over the time period for companies that have moved their
end of year dates.
Embed as Refreshable Data - ensures that the request is embedded in Excel as a dynamic, refreshable
object when saved. If you do not select this option, the results of the request cannot be refreshed and will
remain as plain text/numbers.
Refresh Button - displays the Refresh button within the request result details. If you do not display this
button, you can refresh or edit the request by using the Request Manager from the Datastream menu.
Auto Refresh - enables you to refresh the embedded request automatically upon opening the spreadsheet.
Errors with AFO controls
Do not allow saving of workbooks – where an error has been detected in the workbook
Display Expression - According to the option selected, the Expression description or number is displayed in
the Static and Time Series request results.
Display Datatype - According to the option selected, the Datatype description or mnemonic is displayed in the
Static request results.
Menu options
Two menu options are available:
Fast Load - enables you to launch the Datastream Advance for Office Add-In for Excel, only when a
Datastream menu option has been selected. This option enables Excel to load more quickly upon start-up.
ShortCut - makes the Static Request, Time Series Request, Company Accounts Request and
Request Management options available from the Excel worksheet right mouse click menu.
Data options
The Not Available String field enables you to type the text that you want displayed in Excel when data is not
available from Datastream. For example, #N/A.
Embedded requests
Check this to suppress comments from being added to Data Channel requests.
Suppress Comments - removes row headings e.g. Date, Type, Currency etc.
Suppress error when AFO cannot write to cell - error message is not displayed when AFO cannot write to a
cell.
Cell referencing - is a method by which you refer to a cell or series of cells in a formula. It can be applied
only to embedded request.
Display message when updating to later version – When you open a Request Table saved in a previous
version of Datastream in a later version, an error message pops up.