Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog


Bankruptcy in databases

People sometimes ask about data on bankruptcies and which databases provide data about it.
Not alle datbases deleiver data, and not all in the same form.
In this post I am going to list an overview to the benefit of our users.

REACH (Dutch database on Dutch companies) Unfortunately there is no language switch
** Specific sections are available with some basic financial information, information on ownership and the board & directors. (compensationsare there, but scarce)**

Selection method > e.e. region > industry > call result list (resultatenlijst) of companies.
Press  link > Meer > unfold in the tree: Status & rechtsvorm > juridische gegevens > status > huidige status and datum huidige status (current status and date current status)

The output give current status of the company and the date of that status. In your out put export (Excel) it is easy to filter on status.

If you are interested in company status is a better idea to wait with that selection until your have made your first selections. (image)

Result list (resultatenlijst) Orange button
In order to add data to your set (not further limiting the number of selected companies) press the link 'meer' (more)

Selecting identification numbers is always a good idea. Even though the language is Dutch, identification numbers are independent of this. Stock traded companies will ofthen have SEDOL, ISIN or Tickers.


 Listed: (bankruptcy)
 Listed (moratorium, suspension of payment)

Delisted (moratorium, suspension of payment)
Delisted (Liquidation)

 Example of list:
(Stock traded)
Status could be: ingeschreven (currently running),  failliet (bankrupt)

In Amadeus status is presented like this:

Compustat has the data item DLRSN (Reason for deletion)
Downloading provides codes, if deleted, and these can be found in the Compustat expressfeed manual.
The codes are:
01 Acquisition or merger
02 Bankruptcy
03 Liquidation
04 Reverse acquisition (1983 forward)
05 No longer fits original format (1978 forward)
06 Leveraged buyout (1982 forward)
07 Other (no longer files with SEC among other possible reasons), but pricing continues
09 Now a private company
10 Other (no longer files with SEC among other reasons)
11 Agency governing settlement of securities' trading inactivated the issue's Local Settlement Code because the issue matured,
expired or was called. No successor settlement code was established.
12 Agency governing settlement of securities' trading inactivated the issue's Local Settlement Code. A successor settlement
code was established; issue was changed for another, as in a par value change.
13 Price source for the SEDOL was no longer available. Issue now identified under different SEDOL.
14 Fully paid issue was replaced or partly paid issue was replaced by a subsequent installment. Successor settlement code was established.

Bankruptcy is code 02
For help in searching Compustat I refer to my other Compustat Pages

Bankscope does provide current status, but no status date.
Zephyr does not provide any status data

Datastream does not provide any status data. Datatype: In case of dead stock datatype TIME tells the last trading date, but it is uncertain if this does actually is the date a company ceases to exist.
SDC: liquidation data are mostly about funds and such, not companies.
The M&A database offers a bankruptcy flag (Y/N), but no date.

Otherwise, newspaper sites might give bankruptcy dates or if present maybe annual reports.

Sources:  (Dutch situation)
Lexis/Nexis (Company Information/ newspapers)

No comments:

Post a Comment