ESG data for indices with Eikon data API

Hi,

I am trying to get ESG data for indices for example 'SPX', using the following code:

etf_esg, err = ek.get_data('SPX',

['TR.TRESGScore','TR.TRESGScoreGrade','TR.ESGCScore',"TR.TRESGCScoreGrade",'TR.EnvironmentPillarScore','TR.SocialPillarScore','TR.fdfdf','TR.TRESGResourceUseScore'])

However, it returns only NaN values in Python.

How can I retrieve data properly?

Best,

Rupert

Find more posts tagged with

python

eikon

esg

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jason.ramchandani01

Hi @Rupert.Geyang - thanks for your question. ESG Scores are provided at a company level. So if you wanted to check out a particular index - then you would get the constituents of that index and then get the ESG scores for all the constituents and then maybe provide an aggregate score weighted by either marketcap or revenue or profit etc. You can get the constituents of an index by providing a chain RIC - in the case of SPX that is '0#.SPX'

etf_esg, err = ek.get_data('0#.SPX',
['TR.TRESGScore','TR.TRESGScoreGrade','TR.ESGCScore',"TR.TRESGCScoreGrade",'TR.EnvironmentPillarScore','TR.SocialPillarScore','TR.fdfdf','TR.TRESGResourceUseScore'])

I hope this can help.

We also have an article on how to use ESG data overtime as you might find that of interest.

All comments

bob.lee

@RepRupert.Geyang, I do not think ESG is available for indices, but I am not 100% sure. One work-around is to get the ESG scores from a fund tracking that index. e.g. for SPX the ETF: LP40061133. Funds (including ETFs) ESG scores are available in RDP (Refinitiv Data Platform) Funds API.

Rupert.Geyang

Thanks for your reply. Are fund ESG scores not available from Eikon data API?

jason.ramchandani01

etf_esg, err = ek.get_data('0#.SPX',
['TR.TRESGScore','TR.TRESGScoreGrade','TR.ESGCScore',"TR.TRESGCScoreGrade",'TR.EnvironmentPillarScore','TR.SocialPillarScore','TR.fdfdf','TR.TRESGResourceUseScore'])

I hope this can help.

We also have an article on how to use ESG data overtime as you might find that of interest.

Rupert.Geyang

Thanks for your reply. Is there a way to extract the ESG scores of an ETF following an index, such as SPY in Eikon data API? I have tried to plug in SPY but didn't work.

chavalit-jintamalit

Hi @Rupert.Geyang

SPX is not a valid RIC code.

However .SPX -- (dot)SPX is a valid RIC code.

You can use "Data Item Browser" to double confirm that the data field is not available on .SPX

For example, on TR.TRESGScore data field.

Rupert.Geyang

Hi, Thank you for your answer. I am now actually trying with SPY, which is the ETF for sp500. The data field is available. However this returns a NaN value for me:

ek.get_data('SPY',

['TR.TRESGScore'])

bob.lee

Based on my understanding, the ESG scores at funds level is currently not available on Eikon API, but available on RDP Funds API.

chavalit-jintamalit

Hi @bob.lee

I also tested RDP API endpoints.

It does not provide ESG data for SPY

For company, it provides ESG data

bob.lee

@chavlit.jintamalit, you need to use the Funds API in RDP to get the ESG for SPY. The ESG data is from Lipper (by aggregation of the ESG scores held by the underlying assets of fund) and Lipper provides all fund level data in RDP via the Funds API.

EXPLORE OUR SITES