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

Ha.T.Nguyen
Ha.T.Nguyen
in Eikon Data APIs

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

image

image

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @Ha.T.Nguyen

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

    image


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


    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.

Answers

  • Ha.T.Nguyen
    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.

    image

  • Ha.T.Nguyen
    Ha.T.Nguyen

    image

    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.

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Please try the parameter

    from sdate = 20xx-xx-xx

    to state 0, edate -5

Categories