Home > company information, Library guides > Checking database coverage (companies)

Checking database coverage (companies)

As research students begin to scope their dissertation projects, they often ask about the availability of company data for a specific market (country). Two basic questions are how many companies are covered by a database, and how much historical data is available.

This post will take South Africa and Datastream as a concrete example, but it can be adapted to other databases.

Using Thomson Reuters Datastream Navigator Critera Search we can search for :-

  • Market equals South Africa
  • Major Security is Yes and Primary Quote is Yes (to ensure that there is only one equity series for a company)
  • Status is All (to include both active and dead/inactive companies)

This search returned 1295 results, and on the Base Date header we can select the results to be oldest to newest

Datastream Navigator South Africa equities search (click to expand)

Datastream Navigator South Africa equities search (click to expand)

A total of 1295 is a reasonable number of companies, and the results show that data is available from January 1 1973.

This list can be downloaded for further analysis using the Excel icon at the top right.

One of the columns in the Datastream Navigator output, WS, indicates whether the company is in Worldscope, and therefore whether company accounts information is available.

The summary statistics for WS and Equity Status are

in Worldscope Not in Worldscope
Active 322 88
Dead 533 347
Suspended 4 1

The Datastream Base Date (BDATE) variable gives the first date for which price data is available for a company (equity series). There is a Worldscope variable WC11516, Date added to product, but when a company is added this can include historical accounts data. For example, the company AECI (dscode 930060) has a value for  WC11516 of 19920609 indicating it was added to Worldscope in June 1992. However a time series request for net sales (WC01001) shows that data is available at least from 1980.

Creating a Datastream list and then doing a few test requests is the quickest way to check the availability of specific data items. See our guide Datastream Part 2 (List Creation) for more details.

Quick Summary

Datastream covers approximately 1300 South African companies, about 400 of which are active (on May 28 2014), and price data goes back to 1973. Company accounts data is available for approx 850 of these 1300 companies, and data pre-1990 looks limited.

A quick equity screen on Thomson ONE.com has 324 active South African companies (386 if active/inactive is selected). (This is what we would expect – dead companies are removed from Thomson ONE.com as they are no longer of interest to professional investors.)

Advertisements
  1. markgreenwood
    2 June 2014 at 11:53 am

    A quick check with the Bloomberg EQS function gives 409 companies for search [Trading Status = Active AND Country of Domicile = South Africa AND Primary security of company only] This does include companies listed on other exchanges, e.g. US, London. etc.

    Extending the Trading Status to “Acquired OR Active OR Delisted OR Expired OR Halted OR Inactive OR Liquidated” gives a total of 1253 companies.
    However, I haven’t found a quick way to check what data is available for inactive/dead companies.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s