=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.