Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 1 3 5

ESG data: environmental pillar score and emission score produce zero values

I retrieve time-series ESG data from EIKON API using the get_data function. While overall ESG score (TR.TRESGScore) produces sensible results. Its environmental subpillar (TR.EnvironmentPillarScore) often produces zero value results even though it should be a weighted average of the overall score. The same is true for the emission score (TR.TRESGEmissionsScore). Example RICs are JKHY.O, QRTEA.O, SPLK.O and many more. In addition Total Emission/Sales (TR.AnalyticCO2) often does not change over time (e.g. for same RICs) which does not make sense as at least Sales must change on a yearly basis. Is there a explanation / way to get sensible results
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@mfu.fi

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
18.2k 21 13 21

Case 09633580 was closed with the following comment:


Find the resolution below:

All ESG scores are system generated without any manual intervention. I have shared the category/pillar weights to replicate the ESG scores, also provided one excel sheet on how this will be calculated.

I have worked on BIDU.O-Software & IT Service company and shared the calculation (Formulas) in the attachment.

Calculation of overall ESG score- ESG scores are aggregated based on the 10 category weights, which are calculated based on the Refinitiv magnitude matrix.

For more details on ESG Score and Pillar score calculation, kindly refer to Page number 12-13 in our methodology document (Link shared below):

https://www.refinitiv.com/content/dam/marketing/en_us/documents/methodology/refinitiv-esg-scores-methodology.pdf

Pillar Score calculation:

We will be glad to set up a call and further discuss your below-mentioned concerns. Our Content Specialist Guruprasad Joshi will be available from 12:00 PM IST to 9:00 PM IST (Indian time). Do let us know your available timings so that we can set up this call.

Also please note, as communicated with you before:

The score calculates over 450 company-level ESG measures, of which we have carefully selected a subset of 186 most comparable and relevant fields to power the overall company assessment and scoring process. The underlying measures are based on considerations around comparability, data availability, and industry relevance.

Category Benchmarks

* To calculate the Environmental and Social category scores, as well as the Controversies score, TRBC Industry Group is used as the benchmark as these topics are more relevant and similar to companies within the same industries.
* To calculate the Governance categories, Country of Headquarters is used as the benchmark as best governance practices are more consistent within countries.

The scores will get impacted due to the above benchmark as and when the companies are uploaded on weekly basis, the new data flows and new scores get generated based on the industry and the country. The historical scores will also get recalculated if any changes are done to the values previously updated from the latest reports.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
25.3k 87 12 25

Hi @mfu.fi

As this is a content question, and most of the moderators here are not Content specialists I have raised a Content query for you at My.Refinitiv ref 09633580.

You should receive a response directly from the Eikon Content team.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.