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
Ha.T.Nguyen avatar image
21 ●1 ●0 ●3

ESG data in ek.get_data() only available until 2018

Hi,

I am trying to get data for firms but seems like ESG information only updates to 2018. I check on the app and also screener from Excel, data is updated to 2019 already. I need to retrieve this information for about 15000 firms so I want to know is there any way I can use python to get the latest data. Thank you so much.

I attached two pictures. First one is from Eikon API and second one is from Application

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiesg
1615460894704.png (24.4 KiB)
1615460937465.png (75.4 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
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @Ha.T.Nguyen

You can mouse over the "?" to see the field name.


Then you can use "CODECR" app to see the supporting parameters.


Here is the sample code:

rics = ['YAR.OL','IBM.N']
fields = ['TR.TRESGCScore.date','TR.TRESGCScore','TR.TRESGCScoreGrade','TR.TRESGScore','TR.TRESGScoreGrade'] #you can add more fields
parameters = {'Period':'FY0','Frq':'FY','SDate':'0','EDate':'-1'}
df,e = ek.get_data(rics, fields, parameters)
df

Please do not try to retrieve 15000 instruments in a single API call.


ahs1.png (111.3 KiB)
ahs2.png (95.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.

Ha.T.Nguyen avatar image Ha.T.Nguyen

Thank you so much for this.

This does solve my problems. I am still confused because my old code only can get data from 2018 not 2019. I hope you can help me with this.

Thank you once again.

1615466006587.png (43.2 KiB)
chavalit-jintamalit avatar image chavalit-jintamalit Ha.T.Nguyen

Please try the parameter

from sdate = 20xx-xx-xx

to state 0, edate -5

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.