User guide

Using Excel with Datastream Advance for Office
Page 16 of 38
CREATING COMPANY ACCOUNTS DATA REQUESTS
In addition to static and time series data, Datastream and Worldscope company accounts data can also be
requested and displayed within Excel. The request creation facilities specific to company accounts data enable
you to retrieve company accounts data for equities, Local Lists, and constituents over a specified time period.
You can adjust the company accounts data over the time period, using the Annualise facility, for companies who
have moved their year-end dates. You can also select from a list of company accounts formats, including
Datastream and Worldscope preset formats. For example, financial ratios.
To create a company accounts data request, select Company Accounts Request from the Datastream menu.
Select an equity series, local list or constituent list, select a format, specify a time period and click Submit.
Annualise and Format Options are optional.
Example - Industrial company accounts for Alcatel
SHORTCUTS WHEN ENTERING REQUEST DETAILS
The data request dialogs have two features that enable you to speed up your typing of request parameters.
These are:
Series, datatype, and date dropdown lists
This feature enables you to select from a dropdown list, under the Series, Datatype and Date field, series,
datatypes and dates that you have previously used in one Excel session. Simply click on the dropdown list
and select a series, datatype or date to copy it into the field.