Organization level ESG data

wang.lei

We have been prompted by our Customer Success Manager to post this question here, so here goes:

Ultimately, we’d like to be able to map all Securities under the same logical Organization to the same ESG indicator values. We noticed that using the Eikon Excel plugin, we’re able to use a Security’s TR.OrganizationId to query for ESG values, while the public Eikon Data API for Python does not have this capability.

1. We suspect that the Organization-level fetched by the Excel plugin is actually fetching from the Security level by some primary/parent Security’s RIC, and the implementation is hidden from the Excel user. Is that accurate? If so, how does that primary/parent Security RIC get determined?
2. If (a) Is not accurate, is there a way for us to pull Organization-level ESG data using the public Data API such that it matches what gets pulled using the Excel plugin? If so, can you please point to relevant documentation?
3. Is there anything we should know in general about how Organization-level ESG data gets reconciled in Eikon?

Alex Putkov.1

@wang.lei

ESG data is all at the organization level. It can be retrieved using some instrument identifiers, e.g. using company's stock RIC. But the data is still at the organizational level. I'm not sure I understand your statement that you were able to retrieve data using Eikon Excel, but not using Eikon Data APIs. This does not sound right to me. If data can be retrieved using =TR function in Eikon Excel, it can also be retrieved using get_data method of Eikon Data APIs and vice versa.