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.


How to use directors data in REACH

In some cases it is interesting to find out in which Dutch companies directors and board members are currently active. This way you can find out in what kind of network they are active: through which Dutch companies they are linked with other people. The first thing you will probably do is make a selection of companies for which you need to do some research. In REACH you need to make sure to have the following variable in your output: DMC UCI (Uniek Contact Identificator). This variable uniquely identifies an individual director / manager in the database.

To add the field to your output you can click the button Kolommen (= columns) in your screen when you have a list of selected companies:

In the next the variable can be selected at the section Directeuren / Managers. In this screen the variable is called UCI (Uniek Contact Identifier):

When you are finished editing the list you can save/export the selected companies (with directors information) using the Exporteer button in the middle of the screen.

Using the UCI codes goes as follows:

Step 1 is finding the codes

  • When you have the output in Excel you can select the column with the DMC UCI codes and copy them to a new worksheet
  • In the Excel tab Data (= Gegevens) you may use the option to remove duplicate DMC UCI codes. The limit for uploading DMC UCI codes in REACH is 1000, so it pays off to remove duplicate codes!
  • Save the sheet as a text-tab delimited file

Step 2 is using the codes

  • Start up REACH and first select the option Contacten (= Contacts) at the top left corner of the screen (Next to Bedrijven):
  • In the new screen you can search for directors. Here you click on “Zoekstrategieën en IDs” (=Search strategies and ID numbers)
  • Now use the option “Laden van schijf” (= Load from disk) to browse and select the text file (from step 1) with DMC UCI codes:
  • In the next screen click the orange button OK to continue
  • The result screen appears which will show how many DMC UCI codes it could find in the database. It may also show codes it could not find or match. Click the orange OK button to continue
  • The list of people that now appears shows some standard options. The list can be changed and variables can be added through the button Kolommen.

N.B.: In the Contacts part of REACH you can add variables/fields on the directors to the list presentation. It is, however, not possible to add company financial data. You can get the company data by adding the BVD Company ID Nummer (= Unique Company identification number in REACH) to the list presentation and exporting the result to Excel. Company data can be found on the companies by uploading the BVD ID Numbers in the Company (= Bedrijven) screen of the REACH database:


Directors, Board members & Committees in Europe

One of the few databases that cover information on directors and board members as well as some information on senior management staff for European companies is Amadeus. The Amadeus database covers listed and unlisted production companies. No financial type companies are covered here. Part of the information can be called up through separate report-presentations. When you have created a list and click on one of the company names you get the default company snapshot presented. Only when the snapshot is presented, is it possible to make a selection for the specific snapshot/report on board members, directors and management staff data.

There are two versions of the management report:

  • Report (Current Directors / Managers / Contacts)
  • Report (Previous Directors / Managers / Contacts)    .

See example screenshot:

Saving these reports with all the data is possible but the limit for downloading the data is: 50 reports at once. If you need reports for more companies you will need to export repeatedly in batches of 50 (1-50, 51-100, etc.). The data for each company will be presented in a separate tab/sheet in the Excel download file. Much depends on the company, whether board/directors/managers data is available. The origin of the data is usually the annual report, the company website or data from other news sources. The column with the name/header Body, indicates in what company bodies the person is active. Examples are:

  • AdmDep (Administration Department)
  • AudC (Audit Committee)
  • BoD (Board of Directors)
  • CoGoC (Corporate Governance Committee)
  • HR (Human Resources dept.)
  • NomC (Nomination Committee)
  • OthBC (Other Board Committee)
  • R&D (Research & Development)
  • RemC (Remunaration Committee)
  • SenMan (Senior Management)
  • SupB (Supervisory Board).

Important: The Report presentation does not allow you to export all data (including small biographies). You will have to change the list presentation to do this. Click on the option Columns (above the list) to elect and unselect variables/data for the download. Example screenshot:

NB: The database REACH is a database that covers all registered companies at the Dutch Chamber of Commerce (listed and unlisted). Depending on your subscription a module on Board members & Management may be included. If available this allows you to download similar board and Management data (as described above) for Dutch companies.


Shareholder types in BVD databases

Many of the databases of Bureau Van Dijk (BVD) allow you to call up information on the ownership of companies. When you call up a full report for a company in the database it is possible to go to a specific report with historical information on shareholders. Not only does it list the shareholders, but also percentages of ownership, month and year of the information, and type of ownership. Below you see an example screenshot for a company from the REACH database:

The type of shareholder is indicated in this overview with letters: A, B, C, etc. You can adjust the presentation of the type of information presented using the option Filters at the top of the list at the Options. You can also view a subsset of the available types of shareholders:

Unfortunately the list only shows letters and the filter option do not tell you which letters represent what types. If you do some further research in the online support/help information you can find out which letters stand for what types. Below you find an overview in the Dutch and English Languages:

Dutch Translation (used in REACH):
A = Verzekeringsmaatschappij
B = Bank
C = Handel- & Industrie-organisatie
D = Naamloze particuliere aandeelhouders, geaggregeerd
E = Beleggings- & pensioenfonds / Nominee / Trust / Trustee
F = Financiële instelling
I = Eén of meer bij naam genoemde individu(en) of familie(s)
J = Stichting / Onderzoeksinstituut
L = Ander naamloze aandeelhouders, geaggregeerd
M = Werknemers / Managers / Directeuren
P = Private Equity firma’s
S = Overheidsinstantie / Staat / Regering
V = Durfkapitaal
Y = Hedgefondsen
Z = Beursgenoteerde bedrijven

English Translation (used in Amadeus, Bankscope, etc.):
A = Insurance company
B = Bank
C = Trade & Industry organisation
D = Nameless private stockholders, aggregated
E = Mutual & Pension fund / Nominee / Trust / Trustee
F = Financial company
I = One or more named individuals or families
J = Foundation / Research Institute
L = Other named shareholders, aggregated
M = Employees/Managers/Directors
P = Private Equity firms
S = Public authority/State/Government
V = Venture Capital
Y = Hedge funds
Z = Public (Publicly listed companies)

MINT/ORBIS Additional categories:
H = Self ownership
Q = Branch

NB: In the help section it is also possible to get some definitions for some of these catagories (see the Orbis/Mint ownership specific ownership section).