how to get more than the top 10 holdings from TR.FundPercentageOfFundAssets

I have the following formula in Excel that allows me to get all the holdings weights for a fund:


=TR("ARKK.K","TR.ISIN;TR.FdSecurityOwnedRIC;TR.FdSecurityOwnedName;TR.FdInvestorFilingDate;TR.FdInvestorSharesHeld;TR.FdInvestorShrsHeldChg; TR.FundPercentageOfFundAssets","EndNum=5000 CH=Fd")


How do I replicate this in python?


I have the following code

hldgs, err = ek.get_data(
instruments = 'ARKK.K',
fields = ['TR.FdSecurityOwnedRIC;TR.FdInvestorFilingDate;TR.FundPercentageOfFundAssets'])


But it only gives me the top 10 holdings. How do I get this to give me the full set of holdings weights? I see in the Excel formula that "EndNum=5000" is achieving this goal. How can I amend my python code to do the same thing?

Best Answer

  • Hi @ajalden

    You can use Data Item Browser to check the supported parameters for each field.

    image


    You can then add EndNum parameter to the API call. You can change from 5 to 1000.

    image