Are there any ways to get a list of the RICs of all the companies covered by Refinitiv ESG?

hiroko.yamaguchi1
hiroko.yamaguchi1 LSEG
in Eikon Data APIs

Are there any ways to get a list of the RICs of all the companies covered by Refinitiv ESG so that users for Eikon Data API can set all the RICs in their API call to retrieve the ESG data for all the companied covered and available?

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @hiroko.yamaguchi1 Thanks for your question - there is indeed a pretty straightforward way of doing this using the screener app. There is a boolean field called 'TR.HasESGCoverage'. This can be used in the following screener query to generate the universe. However, there is a limit of 5000 companies that can be returned per screen - therefore I have added the TR.HeadquartersRegion with Europe, Africa, Oceania in one call, Asia and Americas in 2 separate calls.

    df = rd.get_data(["SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.HasESGCoverage==true, IN(TR.HeadquartersRegion,""Europe"",""Africa"",""Oceania""), CURN=USD)"],["TR.CommonName;TR.HasESGCoverage;TR.HeadquartersRegion"])
    df

    1675938554016.png

    df1 = rd.get_data(["SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.HasESGCoverage==true, IN(TR.HeadquartersRegion,""Asia""), CURN=USD)"],["TR.CommonName;TR.HasESGCoverage;TR.HeadquartersRegion"])
    df1

    1675938578296.png

    df2 = rd.get_data(["SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), TR.HasESGCoverage==true, IN(TR.HeadquartersRegion,""Americas""), CURN=USD)"],["TR.CommonName;TR.HasESGCoverage;TR.HeadquartersRegion"])
    df2


    I hope this can help.

Categories