Multi-year shareholder lists & Amadeus

In an earlier post I told something about the 2 most usual ways to get shareholder data in a list presentation in the database Amadeus. The first option was through the company full shareholder presentation reports. The second option was by changing the report option to get the shareholders at Year’s End. The third option to get multi-year shareholder data is through a specific list option. Shareholders data can be included in the list the usual way by clicking the Columns option in the middle of the screen (or the Add button) and then selecting the items you want. This will get you a list that looks as follows and only shows the “current” shareholders: If you want to get a multi-year overview you need to arrange this when selecting the data-items for the list presentation. After clicking the Columns option you can scroll to the shareholder items. Step 1: In this example I chose to include the shareholder name as the first item. When you mark the item it is included in the variable list on the right side. Step 2: Click the Modify button that is presented next to the variable name Step 3: A new pop-up screen appears. In this screen there are many options you can choose. Click the button at the top, called Archived Data. Step 4: In the screen that now appears it is possible to choose certain Months + Years that you want to see the archived data: up to 5 years are possible (not including the current option: Last available data). In this example I chose the last 5 years and December: Step 5: After clicking the OK button to conform the selection you will go back to the screen where you can select additional shareholder data items like % Direct Ownership and % Total ownership. When you select a multi-year item Amadeus will automatically include the required number of columns that was selected (at step 4): Step 6: After clicking OK to finish the selection you will get the following list presentation that now includes multi-year shareholder data: N.B.: When you need multi-year shareholder data and you select cetain months you need to be careful when inerpreting the result. In the example above I requested shareholder data for December of each year. This means that Amadeus will show the latest available shareholder data since the last selected month. This does not necessarily mean that the presented shareholder data is from the December month! If there were several reported months (for 1 year) with data for a shareholder, the lastest months’ data for that year will be presented: for instance if there is data for March, June and July, then in this case the data for July will be presented. I therefore recommend that you always include the items Information Source and Information Date. That way, you can always judge how recent the data is for each selected month and which entity reported the information.


New BETA platform: Wharton

The WRDS platform (Wharton Research Data Services) is a web-based interface that allows you to search through many licensed databases and makes it easier to download data from them. The learning curve on how to use the Wharton platform is minimal as all databases can be searched in a similar way. The main effort that you need to expend is: learning the details of individual databases and how the data is made available. Databases that can be searched through Wharton include: Compustat Global & North America, Execucomp, CRSP, Amadeus & Audit Analytics.

The past few weeks it has been made possible to view the new changed BETA version of the WRDS platform which looks much different from the current platform. The old interface looks as follows:

The new BETA WRDS interface looks very different:

Overall, the changes are mostly cosmetic. when you click through to a specific database you still get the same search options that are available in the previous / current version: 1) Select time frame, 2) Make a selection, 3) Choose variables, and 4) Select the output format and date format.

N.B.: The new BETA version can be viewed but as yet I do not know when the current version will be replaced. I expect it to be sometime during the summer or autumn of 2015.


New platform change: Passport

Recently the Passport database was changed and now has a new web-based platform. The Passport database (Earlier name: Global Market Information Database / GMID) is a database by Euromonitor International and covers much market-related information as well as broad country and consumer statistics. Over the years, the Passport platform has continued to evolve and now, more than before, offers guided paths to get at the reports and market data that you would like to have. The startup screen now looks as follows: After selecting categories and continueing on you often get guided through maker (more) specific selections and then a geographical region: The end result, however, looks the way you are used to: a table with a selection of items that you need and a time frame / geographical selection: The main change in this last results presentation, is the fact that the save / download / print options are now presented at the top left corner: above the options to change the selection criteria. Email

WorldScope coverage update 2nd Quarter 2015

WorldScope company records now cover annual reports data for 77988 companies. This includes 46485 active and 31503 inactive companies. This update: 509 companies were added. Because of these additions the number of active companies in the database has gone up 218 from 46267 in March. WorldScope company records are also available through Datastream and LexisNexis.

Today I have updated the WorldScope country coverage file and it now includes the latest update as it was posted in the second Thomson Reuters Infostream quarterly publication of 2015.

Major updated Countries (new records):
Australia (17)
China (72)
Hong Kong (35)
India (23)
Japan (34)
South Korea (24)
Taiwan (27)
Thailand (16)
United Kingdom (26)
United States (96)


Abnormal Return & market choice

Today I had a student who wanted the abnormal return for a couple of lists of stocks but wanted to choose different markets depending on the stock. To get the Abnormal Return from datastream you can use the following formula:


I posted about the formula earlier and the post explains that the LI stands for the comparison Local Market Index. In this case that is not the index that was needed for some of the lists that the student wanted to use, because, LI usually is the index of the main exchange where a company is listed. See the previous post on how to find out which index for each equity this is.

To change the formula, you can exchange the market by replacing the X(LI) with a Datastream mnemnonic for an index. Example for the Dutch midkap index AMSMKAP:


If you also need to change to multiple indices/markets for a list the same method can be used to generate formulas like I did for generating a list of BETA formulas. You can download an example here for a list of Abnormal Return formulas. Using such a list an example Request table sheet in Datastream would look like this:

The same thing also applies to other Datastream formulas, like the Alpha formula:


You can download an example Excel sheet here as well.


Historical shareholder lists & Amadeus

A database like Amadeus (from Bureau van Dijk) has shareholder data that can go back to 2002. In a previous post I mentioned how you could find out how the types of shareholders could be identified using the codes. If your license / subscription includes the ownership module the information is available for European companies of the industrial type. Amadeus does not include financial type company data like Banks or Insurance companies. If you need these types of companies or a Global geographical coverage you could go for a database like Orbis or Bankscope.

The only way to view the full historical data for the current and previous shareholders for companies, is using the Ownership Data option that appears in the menu (on the right side of the screen) when you call up the basic Snapshot on a company from your results list by clicking on the name.

There are two presentation options for the Shareholder data:

1) History – all data
The first option presents a long list of all recorded data in the database. At the top the current shareholders are listed and below this the previous shareholders:

2) History – at each closing date
This option presents the recorded shareholders in columns by year. Allthough this makes it easier to view the history of ownership, if many changes occur in each year this makes interpreting the data not always easier:

Information on shareholders includes data like: type, percentage direct ownership, total percentage ownership, country, etc. Also included is information on Source Identity and Date of Info. Bureau van Dijk uses many sources for the Shareholder type data and the main sources include:

  • Annual Reports (RS or RM)
  • Private correspondence (PC)
  • SEC Filings (PX or NQ)
  • Stock exchanges (SE)
  • Company web-sites (WW)
  • Telephone calls (TC)
  • Press News (PN)
  • Additional sources (OS)
  • Information providers (IP)

The choice for the data listed as ownership (for each month) depends on the sources. The Ownership Guide also explains how the sources are used and also has a full list of the Information Providers used. This allows you to find out which Source Ident. codes concern what source for each month.