For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

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.

dataexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvote
Accepted
52.5k 134 44 63

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


1657098179491.png (20.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.