What is the formula to extract ESG ratings in Excel?

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!

Best Answer