Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research
Financial Databases and Research

Presentation of ownership information in Amadeus

Posted in Amadeus

Amadeus is a database that covers companies in the industrials sectors. In addition to annual reports and stock data, it also has historical shareholder ownership data from 2002 to now. You can call up this information using the report format. You can also include the information in the list format. To change the list format you can click the ADD button in the screen (Below the print button and to the left of the Menu box on the left side of your screen).

When you have clicked the Add button you get a screen where you can decide which information to include in the list-presentation. When you have selected the ownership variables you also get the option to view the data historically for the past 5 years using the option Modify next to the variable name  (in the box where the selected variables are shown). Before you select the option Modify be sure to include the variable Shareholder Information Date !

When you have clicked the button Modify you get a new box showing the options available. When you click the tab Archived data you can select and type in 5 specific months in time for which you want to see the ownership data.

When you are finished changing and adding selected variables and information, you click OK. NB: you can also save the list format if you like here to use it again in the future. Below you see an example for the company Ballast Nedam:

If you look carefully you will see that I have selected as the point in time December of 2010. Had I not also included the variable Shareholder Information Date I might have thought that the Shareholder information was presented exactly as it was on December 2010. This is not necessarily the case: each row of Shareholder data will have a specific month listed and the ownership situation may have changed since then and the situation on December 2010 may be different! This example illustrates that you have to be careful how to view shareholder data when you choose to use the Archived Data option to list this type of information in point in time in a list format.
If you want to analyse the ownership information changes you may want to prefer using the specific report on company Ownership available from the menu on the right side when you view a full company report: see example below.

Author information:

11:17 AM - 20 July 2011

BVD ID Numbers and Dutch companies

Posted in Amadeus


Amadeus has several options to look for companies using unique identification numbers. One of these identification numbers is the BVD Id nr. = Bureau van Dijk ID number. For Dutch companies this ID code consists of the nation code NL and the chamber of commerce (Kamer van Koophandel) identification number. The unique code KVK number can be found in annual reports, company websites as well as through the KVK register on the website of the chamber of commerce.


Each KVK number of Dutch companies consists of two parts: the main 8 digit number and the 4 digit sub number. If the sub number is four zeros that means that this concerns the main company. The KVK number for Unilever NV is: 24051830. The Bureau Van Dijk ID Number is therefore: NL240518300000. A list of BVD ID numbers can easily be created in Excel and can be uploaded in BVD databases like Amadeus or REACH. Examples:



Author information: LinkedIn


11:42 PM - 10 August 2010

Zephyr and Amadeus (New and old)

Posted in Amadeus


In an earlier post I told you about the new Amadeus interface. I said that there were some excellent improvements over the old interface. An example is the way you can find additional company information using information from another database. Identifiers you can upload are for instance: BVDEP ID Numbers, ISIN codes and Sedol codes. The first is, of course, a proprietary code for databases from Bureau Van Dijk.


In the old interface you first need to create a text file that can then be uploaded and this file needs to have a specific name. In the new interface you can upload infromation directly from an excel file without the need to first create a text file. The movie below shows how you can use company information from the database Zephyr to find more company data in Amadeus using both the old and the new interface.



NB: Zephyr has information on Mergers & Acquisitions, Initial Public Offerings and Venture Capital deals with links to financial company information.


Author information: LinkedIn


11:09 PM - 31 January 2010

New Amadeus interface

Posted in Amadeus


Last Tuesday I was at a user meeting by Bureau Van Dijk (BvD) where the new interface for Amadeus was presented. The new interface looks very different from the current version. Here is a screen capture of the search screen:



Many changes have been made that make it easier to use. Creating your own customized reports or lists is much easier now and more intuitive. Another change is the expansion of options to upload your own company lists. In the past the BvD website only made it possible to upload BvD identification codes for companies. If you use Amadeus through Wharton it was possible to also upload lists of the following type of codes: Sedol, ISIN or Ticker. In the new interface it is also possible to upload lists of these three types of codes. This makes it a lot easier to gather data from Amadeus using lists from other databases (for instance Datastream).


Uploading a list of codes is now also easier, because in the new website you can upload these lists from an excel file (including Excel 2007) !



Through the BvD website version of Amadeus you can have a look at the Beta version of "Amadeus Neo". This new version will probably replace the current BvD Amadeus interface in June or July of 2010.



For more information on company identifiers please got to the earlier post on this Blog on the subject.


Author information: LinkedIn


10:21 AM - 12 November 2009

The Dutch BIK classification codes in Amadeus

Posted in Amadeus


All companies registered at the Dutch chamber of commerce (= Kamer van Koophandel) get an industry classification code. This code is the "Bedrijfsindeling kamers van Koophandel" (BIK) classification code. The last version of this code can be downloaded here. In addition to a primary BIK code many companies also get a secondary activity BIK code. All codes are a minimum of 2 and a maximum of 6 digits long.


In June 2009 the Dutch Camber of Commerce switched from the 2005 BIK code to the SBI 2008 code (SBI = Standaard BedrijfsIndeling). The SBI code is also used by the Central Bureau for Statistics (CBS) in the Netherlands and is based on the international NACE code.

The first four digits of the SBI are equal to the ISIC (International Standard Industrial Classification of all Economic Activities, international code of the United Nations) and the NACE code (= classification code of the European Union on Economic Activities in the European Community). The fifth digit of the SBI applies specifically to Dutch companies.


On the website of the Dutch Camber of Commerce an overview is published which explains which shows how the BIK codes are translated to SBI codes. An overview of changes in the SBI code version2 (of June 2009) compared to the first version (of April 2009) is also available.


One of the few financial database that has information on Dutch companies is Amadeus of Bureau van Dijk. You can search in this database using the BIK codes. If you want to include the BIK codes in a download you can create a custom report or a custom list. The variable that will list the BIK code for Dutch companies is called the "National Industry Code, primary". The secondary activity code is called "National Industry Code, secondary". The codes can be found in the section "Activities":


If you use Wharton to search in Amadeus the variable that you can use is: NATPRI (Char 6, Primary National Code).


According to Bureau van Dijk the new SBI code will be included in the website version of Amadeus sometime in the next couple of months. The BIK codes will also remain available. The Wharton version of Amadeus will probably be updated next year as this version is updated only once a year.


Note: the variable "National Industry Code" contains different codes for other nations. Click HERE for an overview of the classification codes for other countries.


Author information: LinkedIn


02:11 AM - 1 October 2009

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