How can I get historical ESG data?

Question

Question by Erik77 · Nov 03, 2020 at 09:54 AM · eikon eikon-data-api workspace python workspace-data-api refinitiv-dataplatform-eikon historical esg

How can I get historical ESG data?

I am looking to get historical data for data points such as "TR.BoardMeetingAttendanceAvg" or "QMS Certified Percent" going back two or three years. Ideally on a monthly basis.

How can I access that through the API?

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-11-03T10:32:38Z

REFINITIV

Best Answer

Answer by jason.ramchandani01 · Nov 03, 2020 at 10:32 AM

hi @Erik77 thanks for your question. Please see the code below:

df, err = ek.get_data(['0#.FTSE'],['TR.BoardMeetingAttendanceAvg(SDate=0,EDate=-4,Period=FY0,Frq=FY).date',                       'TR.BoardMeetingAttendanceAvg(SDate=0,EDate=-4,Period=FY0,Frq=FY)'])

df

So this can get you the data for the requested field for -4 FY for all of FTSE. As the data is captured only once per year, i believe you simply want to group by month of return which is easy enough if you df.set_index on the date field added. I hope this can help.

1604398831524.png (125.5 KiB)

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Erik77 · Nov 03, 2020 at 11:11 AM 1

Share

thank you @jason.ramchandani!

How can I get historical ESG data?

1 Reply

Watch this question

Related Questions