question

Upvotes
Accepted
3 1 0 2

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

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?

eikoneikon-com-apiindex
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

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

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)



ahs.png (40.1 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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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