For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
ajalden avatar image
3 ●0 ●0 ●1

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?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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 @ajalden

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


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


ahs1.png (70.2 KiB)
ahs2.png (30.5 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