User guide

Using Excel with Datastream Advance for Office
Page 8 of 38
Selecting datatypes
The Datatype Mnemonic Picker, displayed by clicking the Datatypes button, enables you to select
individual datatypes per request. When you select a datatype, the Datastream mnemonic for the Datatype, for
example, MV for Market Value, is copied to the Datatypes field on the Request dialog. Multiple selections are
automatically separated by commas.
The following example shows you how to search and select the Datastream equity datatype EPS (earnings per
share) by typing its mnemonic in the Datatype Mnemonic Picker.
If you don‟t know the Datastream mnemonic for the required datatype but you know the general description, for
example Price, choose to find by Name and type Price in the Search Field. This lists all datatypes for the
chosen Data Category and Datatype with descriptions beginning with Price (e.g. Price (adjusted), Price
(unadjusted), and so on).