Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by Rupert.Geyang · Aug 19, 2020 at 09:04 AM · esg

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

People who like this

0 Show 4
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
b.lee · Aug 19, 2020 at 10:39 AM 1
Share

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

avatar image
REFINITIV
chavalit.jintamalit ♦♦ b.lee · Aug 19, 2020 at 05:15 PM 0
Share

Hi @b.lee

I also tested RDP API endpoints.

It does not provide ESG data for SPY


For company, it provides ESG data

ahs1.png (62.8 KiB)
ahs2.png (179.5 KiB)
avatar image
b.lee · Aug 19, 2020 at 09:42 AM 0
Share

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

avatar image
Rupert.Geyang b.lee · Aug 19, 2020 at 10:02 AM 0
Share

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

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani · Aug 19, 2020 at 10:04 AM

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.


1597831051112.png (139.6 KiB)
Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Rupert.Geyang · Aug 19, 2020 at 10:07 AM 0
Share

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.

avatar image
REFINITIV
jason.ramchandani ♦♦ Rupert.Geyang · Aug 19, 2020 at 11:10 AM 1
Share

As far as I know we don't provide ESG ratings for ETFs or Funds in Eikon API. It seems like there may be some new services on Refinitiv Data Platform (RDP)that seem able to provide and ESG Rating for funds. However you will not be able to access this endpoint with your Eikon Login and would need to speak to your account team about what is available there and access to it. You will likely want to investigate how these scores are being weighted - by mkt cap etc as I mentioned above. Also if tracker funds are using derivatives you may not be getting the whole picture. So there will likely be a number of points of enquiry which your account team / content team can help with.

As an aside you can already see some new RDP endpoints you do have access to as an Eikon user - a much improved Historical Pricing API (a replacement for get_timeseries API), a new Search API, a new Symbology Service plus some new bond and derivative pricing analytics. This is easiest accessed using the new CODEBOOK app - a new hosted python scripting environment - (type 'CODEBOOK' into Eikon Search bar) and then looking at the Refinitiv Data Platform Examples.

I hope this can help.

avatar image
REFINITIV
Answer by chavalit.jintamalit · Aug 19, 2020 at 10:15 AM

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.



ahs1.png (22.9 KiB)
ahs2.png (93.3 KiB)
Comment

People who like this

0 Show 4 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Rupert.Geyang · Aug 19, 2020 at 10:20 AM 0
Share

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'])

avatar image
REFINITIV
chavalit.jintamalit ♦♦ Rupert.Geyang · Aug 19, 2020 at 10:33 AM 0
Share

Hi @Rupert.Geyang


If you mean to get all the holding RICs and get ESG score for each RIC, please see this example:

ahs.png (30.2 KiB)
ahs2.png (132.2 KiB)
avatar image
Rupert.Geyang chavalit.jintamalit ♦♦ · Aug 19, 2020 at 10:56 AM 0
Share

Thanks for this, I think this will work for me. I was just curious that I do see that Eikon offers these ESG data points for SPY, but they cannot be extracted to python?

1597834539288.png (439.3 KiB)
avatar image
Answer by b.lee · Aug 19, 2020 at 11:20 PM

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



rdp-funds-api-esg.png (59.4 KiB)
Comment
chavalit.jintamalit

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

how to obtain esg ratings of the stoxx europe 600 index

How can I get historical ESG data?

How can I get the fiscal year end date for the Environmental Pillar Score?

Duplicated and missing observations in ESG data

ek.get_data("AAPL.O", "TR.TRESGScore", {'Period': "CY2016"}) : At which point in time do data get pulled ?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges