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

Showing posts with label CSR. Show all posts
Showing posts with label CSR. Show all posts

1/25/2016

Asset4 databases - constituent lists in Datastream

Since not all companies have a CSR (Corporate Social Responsibility) or GRI (Global Reporting Initiative) and / or not always provide data to the Asset4 database, chances are companies searches in datastream don't result in data.
The usual check is through Static search and check for the Asset4 Company ID. Yes, means they have data in the Asset4 database.

A better method, maybe is to strive for complete overviews of all companies (globally distributed) providing such data, through a statis search with the Asset4 check...

What I tried to do is seach statis but searched for key word Asset4
Next I filtered on Constituent lists.
Result is 143 constituent lists, either by region or country. E.g. Asset4 netherlands (36 constituents)
I have checked a few and sometimes they provide large output sets.

Striving for completeness.
Data types that might be interesting are Company Name, base date, ISIN, time (latest value), A4ID (asset4 id) and ISO country code (to filter your out put set).

A couple very large: (some too large to provide data)
ASSET4 Global ex US (size 3239, gives data)
ASSET4 Asia Pacific ex Japan (size 1177)
ASSET4 FULL UNIVERSE LIST (size 5059) says too many to list
ASSET4 ACTIVE UNIVERSE LIST (only active) (size 4243) says too many to list
ASSET4 United States (size 1004)
ASSET4 Global (size 4243) says too many to list
ASSET4 Europe (size 976)
ASSET4 NAFTA (size 1342)
ASSET4 Latin America (size 144)

 The output from Gobal Ex USA is easy to filter with auto filter, thus creating the pssibility to create sets by nation...

CSR - Corporate Social Responsibility data

A nice source is: http://www.research-csr.com/?gclid=CMWr3NLJxMoCFarpwgodRZsK8Q#home
This report states that CSR aware companies have positive effect on their employees' motivation.
It's an open door to say that motivated workers are happier and more productive.
Another report is from KPMG: International Survey of Corporate Social Responsibility Reporting


More and more companies embrace CSR policy.
Company performance is measured and widely available in (economic) databases, but where can we find CSR data?

One of the concerns on the reliability of ESG databases. A couple ESG relevant ratings indexes, the Dow Jones Sustainability Index, the FTSE4Good Index and the MSCI ESG Indices.


I made an earlier attempt (march 2015) to provide an overview of sustainability datbases. You can find it here . Specifically, I also made a post on DJSI (jan. 2016)

Library of Calgary University provides a list link

An extra overview

RepRisk
Through Wharton databases (no open access)

Asset4 in Datastream (no open access)

Corporateregister.com link
Their site says: "CorporateRegister.com is the world's largest online directory of corporate responsibility (CR) reports, past and present, making it the primary reference point for CR reports and resources worldwide. The majority of our content is available free of charge after registration as a service to the global CR stakeholder community."

ESG Direct link
"A comprehensive research database, measuring the environmental, social and governance (ESG) performance of corporations. The web-based database contains ESG and controversial business involvement research on more than 4,000 companies in 50+ global markets. The database provides over 200 ESG indicators and over 2,000 ESG points. It provides continuous global coverage for involvement in controversial lines of business, such as nuclear power, tobacco, and weapons." (Cornell University Library)
Avialable through: you have to sign up


Global Reporting Initiative (GRI) link (open access)

 "is an international independent standards organization that helps businesses, governments and other organizations understand and communicate their impacts on issues such as climate change, human rights and corruption."(wikipedia)
 Available through: Datastream, limited, only reporting concordance with GRI guidelines

MSCI ESG Integration 
Their site says: "MSCI ESG Research provides in-depth research, ratings and analysis of the environmental, social and governance-related business practices of thousands of companies worldwide".
Available through: (not open) 
Datastream: find series > search words > msci esg > indices >
Other search terms as presented at link don't give results