Where can I get the ISIN numbers from all stocks which have an ESG rating?

Hi @jonaslar88,

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.

Hi @jonaslar88

I am not an Eikon expert but had a play with the Eikon SCREENER app and came up with the two following possibilities - the first uses a series in the filter and the 2nd does not:

=TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), ALL(ZAV(TR.TRESGScore(SDate=0,EDate=-7,Period=FY0,Frq=FY))>0), CURN=USD)","TR.CommonName;TR.TRESGScore(Period=FY0);TR.ISIN","curn=USD RH=In CH=Fd")

OR

=TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.TRESGScore(SDate=2010-01-01,Period=FY0)>0, CURN=USD)","TR.CommonName;TR.TRESGScore(Period=FY0);TR.ISIN","curn=USD RH=In CH=Fd")

Do either of the above meet your requirement?

If not, I recommend you have a play with the SCREENER app yourself in Eikon - see this article for brief intro.

Failing that I would recommend you contact the helpdesk and raise an Eikon ticket to get further assistance.

Hi @jonaslar88

Another expression - this time returning scores for all eight years

=TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), ALL(ZAV(TR.TRESGScore(SDate=0,EDate=-7,Period=FY0,Frq=FY))>0), CURN=USD)","TR.CommonName;TR.TRESGScore(SDate=0,EDate=-7,Period=FY0,Frq=FY);TR.ISIN","curn=USD RH=In CH=Fd;CalcDa"&"te;rfperiod")