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


Environment and sustainability - databases

Sustainability awareness has become an important issue for companies. Many publish aside from the financial report, a sustainability report. Enviromental awareness grants goodwill.
This post will focus on both: goodwill and sustainability.


Environmental Performance Index (EPI)
World wide environment index of countries.  (open access)

Asset4 database (through Datastream)
Output in Excel, through the Excel interface. Information is on company level
!!! Not all listed companies  provide data to Asset4 database !!
Important to test which companies do:
How it works:
. Create a static work set  with at least data types, Name, ISIN,ASSET4 Company ID (provides a yes or a no)
. Filter out all companies with Asset4 (auto filter in Excel)
. Upload new list into Datastream
. Download Asset4 data as datatypes
In pictures:

Only 2 comp apply

Time series> asset4 datatypes more than shown
Try to search for alternative terms (items) like emissions etc
result on CSR (Corporate Social responsibility, 2 comp)

More info on Asset4 (board)


Examples: Supra National organizations

World Bank
Choose: data

United Nations

Select an item and press continue

A couple of options is presented next

E.G. show table
As you can see, all options remain available, ordered in tabs.

China in chart

Select TAB download (national) > extensions available from csv, Excel etc
Define dataset


In my humble opinion: a bit disappointing result, (showing only 2010) compared to the graph

Publications of the International Food Policy Research Institute

Statistics sites (not specifically focused on environment, sustainability)
Monthly Bulletin of Statistics

OFFstats - Official Statistics on the Web
Source OECD

Goodwill is measured in many ways. It is presented in annual reports in the balance sheet (iow: companies try to validate goodwill)

Goodwill (finance): An intangible asset that arises as a result of the acquisition of one company by another for a premium value.
The value of a company’s brand name, solid customer base, good customer relations, good employee relations and any patents or proprietary technology represent goodwill. Goodwill is considered an intangible asset because it is not a physical asset like buildings or equipment. (investopedia)
Charity, good customer services, sustainability, working conditions etc are contribute to goodwill.
Wikipedia: according to International Financial Reporting Standards (IFRS), goodwill is never amortized.


In total: 327 data types apply to search term Goodwill
(for explanations on using Datastream see these items)


North America: 9 datatypes
Global: only 1 datatype >

(explanations on using Compustat see these items)


In Mergers & Acquisitions database, the focus is solely on the acquiror. See definition

(for explanations on using SDC)


No comments:

Post a Comment