Is it possible to access joins/leaves from constituents of index through excel add-in?

ML92

I would like the history of constituents for MSCI Emerging Markets (EEM).

I have tried to use =TR("EEM","TR.indexJLConstituentRIC","Sdate=0D Edate=-20CY IC=B") however it is not working.

Any ideas?

Find more posts tagged with

eikon

index

eikon-com-api

Accepted answers

chavalit-jintamalit

Hi @ML92

I believe that EEM is RIC for "Fund"

You can use TR.FundHoldingRIC but it does not support historical data.

Please note that this forum is moderated by developer and it is best to contact Refinitiv Data Helpdesk at https://my.refinitiv.com/ to get content expert to help you on your content query.

=TR("EEM","TR.FundHoldingRIC","StartNum=1 EndNum=2200 CH=Fd RH=IN",B5)

All comments