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

Removing duplicate Company Identifiers using Excel 2007

Posted in General

IN two previous posts I have shown how you can use Microsoft Access to remove duplicate company identifiers from a large download and how to do the same in Microsoft Excel 2003 using the If function in combination with the auto filter function.

In Microsoft Excel 2007 this has become even easier using the following steps:
1) Copy the column of codes to a new worksheet
2) Click the tab Data
3) Select the column with duplicate identifiers
4) In the Tab click the option "Remove Duplicates"
5) Click the button OK


If you use excel a lot for gathering and analysing data it could be a good idea to check ou the Youtube channel on Excel. This and many other Excel tips, functions etc. are explained and demonstrated there in over 1000 short movies:

Author information:

12:18 AM - 28 June 2011

WorldScope company coverage update

Posted in General

WorldScope company records now cover annual reports data for (currently) 69380 companies. This includes 44533 active and 24847 inactive companies. This update in 2011 is the biggest update in years: 5239 companies were added. WorldScope company records are 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 2011. several new countries have been added and a lot of new companies are now covered.

New Countries (Number of company records):
Bahamas (7), Barbados (9), Bolivia (8), Bosnia & Herzegovina (76), Ecuador (7), El Salvador (4), Faroe Islands (2), Fiji (11), Georgia (1), Ghana (20), Guatemala (6), Guyana (2), Isle of Man (10), Jamaica (19), Macedonia (28), Malawi (4), Mongolia (1), Montenegro (8), Namibia (5), Palestine (18), Panama (16), Paraguay (38), Sudan (1), Swaziland (3), Tanzania (4), Trinidad & Tobago (1), Uganda (3), Zambia (11).

Major updated Countries (Number of company records):
Canada (1653)
China (202)
Denmark (198)
India (106)
Israel (284)
South Korea (502)
United States (578)

Author information: LinkedIn


05:33 PM - 5 June 2011

Belgian companies & the KBO database

Posted in General


The website "Kruispuntbank van Ondernemingen" (KBO) offers access to a database maintained by the organisation FPS Economy (/FDO Economie = Federal Public Service Economy/Federale Overheidsdienst Economie). The KBO database/Register contains the basic data of the Belgian companies and their locations. The information on the companies is compiled from databases of different Belgian government agencies. Part of the data in the database is freely available to the general public.


Every business/organisation which is registered in the KBO database gets a company number = Ondernemingsnummer. Companies are required by law to use this number. This number is a unique number that from then on applies to a natural person or legal entity. More information on this number is available (In Dutch or French) at the FOD website. Each Belgian company number consists of 10 numbers starting with either a 0 or 1. Each registered business location also gets a separate location number of 10 digits and these start with a number from the range 2 - 8.



Name: Dexia Bank Belgiƫ
Company number: 0403.201.185
Location number Brussel office:


The KBO Database search screen only has two language options: Dutch and French. You will need to be able to read one of these languages to be able to use the KBO database. Three main search screens allow you to search on:
- Company name/details
- Business location
- Address details.



Search result example:



When you click through on the Company number you can find even more data.



At the bottom of this screen there is a section that lists available external links. It is often possible to find links here to official documents like Annual accounts and annual reports. The links to the reports are provided by the National Bank of Belgium.



Author information: LinkedIn


07:12 PM - 27 May 2011

Removing duplicate codes using Microsoft Excel

Posted in General


In a previous post I showed how Microsoft Access could be used to remove duplicates from a large dataset. These duplicate codes can interfere if you need to use this list from the dataset to search for more data on the same companies and do not want to download superfluous data. Personally I prefer Microsoft Access to do things like this, because it is easier to use, combine data, and even deduplicate or combine datasets (in my view).


Excel has the IF function which allows you to do this. In a previous post I showed the IF function. To find the duplicate codes you can use the IF function as follows:



Explanation: IF the content of cell A1 matches that of cell A2, show A1 or else show the number zero. NB: In the Dutch language version of Excel the IF function is called ALS.


Below is a movie which shows how to filter for duplicate company identification codes and also use the IF function to filter out unlisted companies. In combination with the Auto filter function you get a good list that can be used to search for more data.



Author information: LinkedIn


06:25 PM - 14 May 2011

Dutch weather data

Posted in General


A short while ago I was asked the question if there was a source to find out for a number of years which days were sunnier than other days and if there was a correlation with (the amount of) stocks traded at the Dutch stock exchange Amsterdam EuroNext. I could find the data that was needed at the website of the Royal Netherlands Meteorological Institute (part of the Ministry of Infrastructure and the Environment).



The website has a separate section that presents monthly overviews starting with October 1998. Each monthly overview has three section on: Rain, Sun and Temperature. The Sun graph list the average daily number of Sun hours on a daily basis for that month. Below you see an  example of a sun graph. Blue bar: average maximum number of sun hours, Yellow bar: average number of sun hours measured.



It is also possible to get the actual data from the weatherstations for this period. This option is available at the website Climatology section "Daily weather data for the Netherlands -download". After downloading the data for all the weatherstations you can calculate the average daily number of sun hours and compare it with the calculated average maximum amount of sun hours for each day. The download option is available at: Home > climatology > daily data > selection.



Author information: LinkedIn

01:17 AM - 7 April 2011

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