Workspace Excel Add In: How to get the number of holdings in an ETF?

Question

I am trying to get the exact number of holdings of an ETF. I have tried "TR.FundHoldingName.holdingname" but this gives me a list of all the ETF Holdings. We only need the number not the list.

Jirapongse · Answer

@alphonsa

You can try this one. I use the LSEG Data Library for Python.

ld.get_data(
    universe = ['SPY'],
    fields = ['COUNT(TR.FundHoldingName)'],
    parameters = {'EndNum':10000})

For excel, it could be:

=@RDP.Data("SPY","COUNT(TR.FundHoldingName)","EndNum=10000 CH=Fd RH=IN",B2)

However, for other fields, please contact the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

raksina.samasiri · Answer

Hi @alphonsa ,

Thank you for posting the question in this forum. However, this forum is dedicated to an API usage questions. Hence, the moderators on this forum do not have deep expertise in every type of content available through LSEG products. Such expertise is available through the Helpdesk, which can be reached via LSEG Support.

You can raise the ticket there and the support team is going to contact you directly to assist with this.

Hope this helps and please let me know in case you have any further questions.

EXPLORE OUR SITES