Eikon api - fund manager equity holdings

jhanly
jhanly
in Eikon Data APIs


I am trying to use the Eikon api to download this page from various fund managers. I have the code which works for mutual funds and other funds that have Lipper codes, but it doesnt work when you just use the Company ID (starting with 429... here) . Is there a way to view these equity holdings for funds through the API?


Page i am trying to call:

thumbnail-image.png



Code that works with Lipper/RICs but not company id:



fund_manager_id = 'LP40186956'

# Fields

fields = ['TR.FundHoldingRIC', 'TR.FundHoldingName']

# Retrieve the data

holdings_data = ek.get_data(fund_manager_id, fields, {'Endnum':'10'})

print(holdings_data)

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @jhanly

    Thank you for reachng out to us.

    I found the answer on this discussion. The code looks like this:

    df, err = ek.get_data(
        instruments = ['4297175221'],
        fields = ['TR.SecurityOwnedRIC'
                  ,'TR.SecurityOwnedName'
                  ,'TR.InvestorValueHeld'
                  ,'TR.InvestorValueHeld.calcdate'
                  ,'TR.InvestorSharesHeld'
                  ,'TR.InvestorPctPortfolio'
                  ,'TR.PctSecuritySharesOut'
                  ,'TR.InvestorFilingDate'],
        parameters = {'Scale':'6', 'Curn':'USD'}
    ) 
    display(df)

    The output is:

    1701406006275.png



Answers

  • Anufriyev
    Anufriyev

    Thank you @Jirapongse From the post you attached I see that we could also specify a specific date:

    parameters = {'Scale':'6', 'Curn':'USD', 'SDate':'2021-09-30'}

    ...but what if we do not know the previous date of reporting (it could ad-hoc as well)? I don't want to loop every day and check if there is data. Do you have ideas?
    Thank you

Categories