Python returns N/A for ESGC Score of an instrument into a list while DIB on the same instrument r...

patrick.sentis

...eports a value

When I run this code in Python:

...

index = '.STOXX'

DateR='2018-12-31'

df,err = ek.get_data('{}{}({})'.format('0#', index, DateR), fields=['TR.TRESGCScore'],

parameters={'SDate': '{}'.format(DateR), 'Period': 'FY0'})

...

Python returns N/A for some instruments like BOUY.PA. However the DIB of the same date and instrument reports 64.44.

How can I obtain the right historical ESGC Score in my Python request for all instruments into an index at a specific date?

Alex Putkov.1

@patrick.sentis

For ESG scores I strongly recommend to not use the SDate parameter, and instead specify the absolute financial period in the request. E.g. to retrieve the scores for 2017 use

ek.get_data('0#.STOXX(2018-12-31)', ['TR.TRESGCScore'], 
            {'Period': 'FY2017'})

Note that in the above expression the significance of the 2018-12-31 date is only that the index constituents are returned as of that date.

For a bit more color on the issue you experienced, see my answers in the discussion on the previous thread on similar topic following the link below

https://community.developers.refinitiv.com/questions/74916/esg-get-historical-data-issue.html