Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research - Loading a list of companies in Datastream
Financial Databases and Research

Loading a list of companies in Datastream

Posted in Datastream
Very often when you are doing research you can only get part of the information you need from a single database. Some of the information you need may be available in the database Datastream. This database has much financial information, including: commodities, financial information from annual reports, and data from stock exchanges. When you have a specific list of companies which is not available as a list in Datastream, like for instance as a constituent list, you may want to upload your own list.

You can create and upload a list of identifiers for companies in datastream. Only three types of lists can be uploaded based on one of the following identifiers: DS codes, Sedol codes, or ISIN codes. For more information on these identifiers check out an earlier entry of this blog called: "Company identifiers & databases".

Loading a list in Datastream using Microsoft Excel can only be done if a Datastream connection is available and installed. This is visible in Excel when an extra menu option is available called: "Datastream-AFO". Loading a list of Sedol company codes and using it to download data goes as follows:

Part 1: creating a list for Datastream
  • Open an Excel file with a list of Sedol codes
  • Select the option: Datastream-AFO > Tools > Create List (from range)

  • In a new popup called "List Creation for Excel" click the button "Change Selection"

  • A new popup will now appear called "List's Code Range Selection". Now select all the codes from the Excel file that you want to include in the list and click the button OK.               

  • The previous popup "List Creation for Excel" will appear again with the selected range shown in the field "Code range". Type in your own list name at "List Description Name" and type in a file name at  "List File name". The file name should end with the extension .LLT.

  • Choose to save the list Locally. You can also Upload the list on the server of Datastream. If you upload the list on the server this makes your list also available on another computer. Uploading a list may not always work as well as it should, however.
  • Click the button OK to finish saving the list. If everything is in order you will get a popup stating the location of your list file and the text: ... has been successfully created!
Part 2: downloading data using a saved list
  • If necessary, start up the Excel program and create a new excel file
  • Select the menu option: Datastream-AFO > Time Series Request
  • Use the following button, called the "List Picker", to select your list from the available lists:
  • Select the Datatypes you need, the relevant time period, and the frequency of the data
  • Mark the option "TS for each item in list"

  • Click the button "Submit" to begin downloading the data.
Author information: LinkedIn

10:14 PM - 17 June 2008

Last Page
Next Page
This weblog will deal with all kinds of tips and tricks on the use of several financial databases.

User Profile
--- Amadeus
--- Company.Info
--- Datastream
--- GMID
--- General
--- International Statistics
--- LexisNexis
--- SDC Platinum
--- S&P Indexes
--- Wharton
--- Zephyr
Recent Entries
- Announcement: New Blog
- International Human Development Indicators
- Global Reporting Initiative
- WorldScope company coverage update
- World Bank Commodity Prices - update November 2011

External Links:
--- NYSE Euronext
--- Finabase Blog
--- VU Law Blogspot