question

Upvotes
Accepted
5 2 4 5

Mutual Fund Holdings - (S12)

Hi,

I want to know how to download the S12 mutual fund holdings data. I have a workspace account. Can I download it using RDP?

Thanks.

funds
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
384 4 4 9

Hi @econ-eikon5 ,


This code is from another thread in the Q&A forum which I believe might be useful for your case:

df, err = ek.get_data('LP40065886', ['TR.FundHoldingRIC','TR.FundHoldingName',
                           'TR.FundPercentageOfFundAssets',
                           'TR.FundNumberOfShares',
                           'TR.FundNumberOfSharesChanged'],
            {'Endnum':'5000'})

df

Please let me know if you were looking for something different here.


Best regards,

Haykaz

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks, Haykaz.

I want to further download the FUNDNO-MGRNO link, which can be used to map the fund numbers (FUNDNO) in the mutual fund holding database to the manager numbers (MGRNO) in the institutional holdings database.

Refinitiv began to report these links from 1994. Do you know how to download it?


I am afraid you can't find that information via the API requests. Could you please elaborate how you access that now? through Workspace or.. ? That way I could dig deeper and see if that's possible to retrieve using APIs

Hi @econ-eikon5, I have consulted with my colleagues as well and there is one RDP endpoint (https://api.refinitiv.com/data/ownership/v1/views/investor/holdings?) where you might find the information you need. However, to make sure the endpoint covers the information you need, you need to talk to the content expert via my.refinitiv.com.

I can see from you profile that you are using a student account, and unfortunately neither me nor you can create a content query and the only is to approach the support team in your University and ask to open a content query with your request on your behalf. Basically, you should first ask where can be found that information (or whether that content is available) using refinitiv and then look for API endpoints/requests allowing the access.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.