question

Upvotes
Accepted
ML92 avatar image
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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea