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 xiang.zheng · Jan 09 at 01:11 AM · esg

Duplicated and missing observations in ESG data

Hi, I have a question regarding the ESG data. When I tried to access the data via API, it turns out that there are duplicated observations for the same period of a firm. You can find two examples as follows.

fields_esg = ["TR.TRESGScore.date","TR.TRESGScore"]

## Example 1:

data,err =ek.get_data('US9663875089', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

******* In Example 1, you can find that the firm US9663875089 has duplicated observations for year 2016 (see attachment 1). Instead, the 2015 and 2017 ESG data for the same firm is missing with this API request.

However, it becomes available in the EIKON desktop. Due to the restriction of the attachment numbers, you can search this company in EIKON desktop by yourself and you should be able to replicate my findings.

## Example 2:

data,err =ek.get_data('US74270Y1038,US7427181091,CA74272N1050,CA74273V1067,US74273Y1001,US74275C2052,US74275G1076,US74280R2058,CA74283A1003,US7429621037', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

******* In Example 2, you can find that the firm US7427181091 has duplicated observations for year 2013 and 2017. Instead, the 2012 and 2016 ESG data for the same firm is missing (see attachment 2).

In the meanwhile, if I only request the ESG data for the firm US7427181091, it turns out that the firm has ESG data available in both 2012 and 2016. Due to the restriction of attachment numbers, I just post the code as follows and you should be able to replicate my findings.

data,err =ek.get_data('US7427181091', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

It would be great if anyone can kindly help me on this issue. Thanks!

esg-example1.png (41.4 KiB)
esg-example2.png (63.6 KiB)

People who like this

0 Show 0
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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · Jan 11 at 06:32 AM

Hi @xiang.zheng

I reformat your API call a bit.

For 1:

For 2:


ahs1.png (52.4 KiB)
ahs2.png (61.2 KiB)
Comment

People who like this

0 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 >
9 People are following this question.

Related Questions

Inconsistent ESG Score using get data API

Request ESG data with C#

How to download entire ESG information with API?

Request full list of companies in the Refinitv ESG data universe

ESG data for indices with Eikon data API

  • 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