What is the formula to extract ESG ratings in Excel?

fin-thesis-abs

Hi there,

I was wondering what the formula would be in the Excel function of Refinitiv Eikon to extract all the ESG ratings (also separate for each component) for the U.S. listed companies over the maximum period for each year including CIUSP codes.

Is there anyone able to be helping me with the formula?

Thanks in advance!

wasin.w V3

Hello @fin-thesis-abs

I am not the Eikon expert but the Eikon/Workspace Data Item Browser application ("DIB" app) should be able to help you find the list of fields and build a formula.

The following articles also should be able to help you

• How to discover available fields for Data Grid service
• Find Your Right Companies with SCREENER

The other way is contacting the Eikon support team via my.refinitiv.com website to help you on the specific Eikon excel formula.