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!
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
The other way is contacting the Eikon support team via my.refinitiv.com website to help you on the specific Eikon excel formula.