I´m in searach for all stocks which got an ESG Rating from Refinitiv (or formerly Thomson Reuters/Asset4). Basically, I need the ISIN numbers of all of these stocks such that I can download both the respective ESG ratings and further data (like stock prices). Is there a way to get these ISIN numbers, for example via Datastream in the Eikon Excel add in?
I am currently searching for the same thing. Where do I insert the link to get the data in excel?
=TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.TRESGScore(Period=FY0)>=0, CURN=USD)","TR.CommonName;TR.TRESGScore(Period=FY0);TR.ISIN","RH=In CH=Fd")
Do you have access to an Eikon installation?
If so, load 'Thomson Reuters Eikon - Microsoft Excel', make sure you are logged in/connected by selecting the Thomson Reuters tab
Once online, paste the above into a cell in your sheet. You should see a 'Retrieving...' message momentarily and then the data should appear across the 4 columns.