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

Options
ML92
ML92 Newcomer
in Eikon COM

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?

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    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)


    image

Categories