How can I get ESG scores for target companies? I am using excel.
Hi @TSE ,
You can click Formula Builder button in Workspace Excel or CodeCreator in LSEG Workspace application to find instruments and fields to be used. You may find the ESG scores related fields with the Category tab on the left panel
I have tried that but didn't manage to get any results. Is there other ways to get ESG data? And also I tried to get ESG data with use of PermID and ticker. Should I use some other code?
@TSE
Can you share the Excel Formula that you are using?
If you are using the LSEG Workspace Excel, you can contact the helpdesk support team directly via LSEG Support to verify the Excel formula or content.
Target PermID in column B and dates are in column A. Following formula is done with use of Build Formula. I think the problem should be that I am researching target companies and naturally, they might not have esg rating anymore but it should be fixed with the date I am using.
=@RDP .Data($B$2:$B$125;"TR.TRESGScore";"Period=#1 CH=Fd RH=IN";F3;$A$2)
