Unable to pull stocks from S&P 500 ESG

=TR("0#.SPX","TR.CompanyMarketCap","CH=Fd RH=IN;date SORTD=TR.CompanyMarketCap")

When using this formula in Excel, I can pull the stocks for S&P 500 stocks.

But if similar approach is used for S&P 500 ESG (EFIV.K), I'm unable to pull the stocks.

=TR("0#.EFIV.K","TR.CompanyMarketCap","CH=Fd RH=IN;date SORTD=TR.CompanyMarketCap")

Kindly help me with this problem.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @Akhilesh.Kumar

    0#.EFIV.K is not a valid RIC.

    I checked and found that you can use TR.FundHoldingRIC with EFIV.K to retrieve holding RICs.

    =@TR("EFIV.N","TR.FundHoldingRIC","StartNum=1 EndNum=1000 CH=Fd RH=IN",B5)

    1657098179491.png

    However, you need to contact the Eikon Excel support team directly via MyRefinitiv to get the =TR formula which can be used to retrieve the required data.