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.

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

Search This Blog

3/17/2015

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.

Sustainability

Environmental Performance Index (EPI)
World wide environment index of countries.
http://epi.yale.edu/  (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




Filtered.
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)



Webdirectory
https://www.webdirectory.com/Databases/

Examples: Supra National organizations

World Bank
http://www.worldbank.org/en/topic/environment
Choose: data

United Nations
http://geodata.grid.unep.ch/





















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











Submit.












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)
CBS
Monthly Bulletin of Statistics
ODS

OFFstats - Official Statistics on the Web
Source OECD


Goodwill
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.

Datastream










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

Compustat

North America: 9 datatypes
Global: only 1 datatype >



(explanations on using Compustat see these items)

SDC

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


















(for explanations on using SDC)

Suggestions?




No comments:

Post a Comment