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 0 0 1

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!

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiesg
esg-example1.png (41.4 KiB)
esg-example2.png (63.6 KiB)
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.

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

Hi @xiang.zheng

I reformat your API call a bit.

For 1:

For 2:


ahs1.png (52.4 KiB)
ahs2.png (61.2 KiB)
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.