Skip to Main Content

Erasmus Data Service Centre (EDSC) manuals

Overview of manuals provided by the EDSC

Important update for Eikon/Datastream manuals

The update to Workspaces has changed the way you perform a Time series or Static request in Datastream. This document provides additional screenshots and instructions.

Update.pdf

Once you have read these instructions you can continue to use the existing manuals for Datatream.

Annual report data

Database(s)

  • Datastream
  • WRDS
  • Eikon
  • Orbis

Database comparison

  • Getting data from Datastream (worldscope) is possible in the Bloomberg/Eikon class (Polak building Y1-07) and via remote access. More info about remote access: https://www.eur.nl/en/library/erasmus-data-service-centre/databases/remote-access
  • History: Compustat NA has data started from 1950, Compustat Global from 1987. Worldscope contains data  from  1980 onwards. Orbis from the end of the 90’s.
  • Identifiers: to get data from financial databases like Compustat identifiers are needed, CUSIP (9 digits) or Tickers for NA and ISIN and SEDOL for Compustat Global. In Worldscope one can use ISIN-, SEDOL- or DS-codes, in Orbis you need BvD, ISIN or tickers to retrieve the data.
  • Updates: Compustat is being updated once a year, Worldscope and Orbis has daily updates.

Manuals

Bonds

Database(s)

  • CRSP Treasury
  • Mergent’s FISD
  • Bloomberg

Database comparison

  • Access: Getting data from Bloomberg is only possible in the Bloomberg/Eikon Class in room (Polak building Y01-07). CRSP Treasury and Mergent’s FISD are accessible from home.with a WRDS account.
  • History: CRSP Treasury has data started from 1926, Mergent’s FISD from 1994. Bloomberg starts from the 70’s.
  • Identifiers: to get data from financial databases like CRSP Treasury the CUSIP (9 digits) identifiers is needed, Mergents FISD works with the CUSIP (8 digits). In Bloomberg one can use ISIN-, SEDOL and Bloomberg tickers to retrieve the data.
  • Region: CRSP and Mergent’s FISD have US data only, Bloomberg’s coverage is worldwide.
  • Updates: CRSP Treasury and Mergent’s FISD are being updated once a year, Bloomberg has daily updates.

Manuals

Credit default swaps

Database(s)

  • Datastream
  • Bloomberg

Info

A Credit Default Swap (CDS) is a type of derivative that obliges the seller to compensate the buyer in the event of a loan default or other credit event (e.g. restructuring) of some reference loan, in exchange for a series of regular payments up until the credit event or the end of the contract. Typically, the contracts have a maturity of 5 years. A CDS can be thought of as a kind of insurance; it can be bought by any investor, not only those investors that actually hold the reference loan.

Usually, the premium that is paid at regular intervals (the CDS ‘spread’) is of interest for research. Bloomberg can be used if you are only interested in the CDS spreads of one or only a few companies/loans. Datastream is more convenient if you have a list of companies/loans in which you are interested.

Manual

Deals

Database(s)

  • SDC (joint ventures)
  • Eikon (mergers & aquisitions)
  • Zephyr (mergers & aquisitions)

Manuals

ESG

Database(s)

  • Datastream
  • WRDS

Info

ESG stands for Environmental, Social and Corporate Governance. Examples of items belonging to ESG data are: CO2 Reduction, Child Labor Controversies and Board Gender Diversity.

Since there are no disclosure rules for ESG data, this data is not available for all public companies. The coverage differs per database. There are also no universal standards or regulations.

Manuals

Right now we are offering 2 files with ESG scores (please send an e-mail to edsc@eur.nl to request the password.):

  • The 2024-01-19 (period 2000-2023) file which has a slightly smaller universe, but contains additional static info
  • The 2023-03-01 (period 2010-2022) file which contains scores and grades but no static info.

More info on these data items can be found here: https://libguides.eur.nl/edsc-manuals/blog/new-thomson-reuters-esg-scores-added-to-datastream

 

Forecasts

Database(s)

  • Bloomberg
  • WRDS

Database comparison

  • History: I/B/E/S through WRDS has data from 1970 onwards, I/B/E/S guidance 1992. ThomsonONE only contains forecasts made this year.
  • Identifiers: to get data from financial databases like I/B/E/S and ThomsonONE identifiers are needed, these are codes identifying e.g. a company, stock or bond. In I/B/E/S uses CUSIP (8 digits) or Ticker symbol to retrieve the data. I/B/E/S guidance uses an I/B/E/S ticker. ThomsonONE uses ISIN or Sedol codes.
  • Update: I/B/E/S and I/B/E/S guidance are updated once a year, ThomsonONE has daily updates

Manuals

Funds

Futures

Database(s)

  • Bloomberg
  • Datastream

Database comparison

  • Access: Getting data from Bloomberg and Datastream is possible in the Bloomberg/Eikon class (Polak building Y1-07). Datastream can also be used via remote access. More info about remote access: https://www.eur.nl/en/library/erasmus-data-service-centre/databases/remote-access
  • History: Datastream contains future prices from the 80’s onwards. Bloomberg from the beginning of the 90’s.
  • Identifiers: Datastream and Bloomberg identifiers are needed, these are codes identifying e.g. a company, stock or bond. One can use ISIN-, SEDOL-, Ticker symbol to retrieve the data. In Datastream it’s easier to find future contracts, with the use of constituents lists.
  • Updates: Datastream has the future prices up til yesterday and Bloomberg even has real time future data.

Manuals

Index constituents

Database(s)

  • Bloomberg
  • Datastream
  • WRDS

Info

Sstocks are part of that index are called the constituents of the index. The lists of historical constituents are available in CompuStat North America and CompuStat Global. Which database you have to use depends on the index you’re investigating: American indices, like the S&P 500, can be found in CompuStat North America, indices from other parts of the world can be found in CompuStat Global. Unfortunately there is no list of the indices covered.

Constituent lists can also be found in Datastream, but downloading the historical constituents from CompuStat is much more user-friendly, so we advise you to try Compustat first.

Manuals

Indices

Database(s)

  • Bloomberg
  • Datastream

Database comparison

  • Access: Getting data from Bloomberg and Datastream is possible in the Bloomberg/Eikon class (Polak building Y1-07). Datastream can also be used via remote access. More info about remote access: https://www.eur.nl/en/library/erasmus-data-service-centre/databases/remote-access
  • Historic: Datastream contains stock indices from 1973 onwards. Bloomberg oldest equity index is from 1928.
  • Identifiers: the identifiers are similar for both databases, however for bloomberg identifiers the type of security should be added so S&P 500 Index
  • Update: Datastream with one day history and Bloomberg realtime.

Manuals

IPO's

Databases(s)

  • Eikon
  • Zephyr

Manuals

Options

Database(s)

  • Datastream
  • WRDS

Manuals

Stock prices

Database(s)

  • Bloomberg
  • Datastream
  • WRDS

Manuals