Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by CSI · May 10, 2019 at 02:41 PM · holdingsmutual fundsapi accessmutual fund info

Mutual fund past portfolio holdings via Eikon API

Hello,

as a follow up to my recent question here, which was wonderfully answered, I was wondering if it is possible to get the historical/past portfolio holdings of a mutual fund via the Eikon API?

In Eikon, this data is available when viewing a specific fund, then going holdings => derived holdings. A screenshot of that screen is attached, which shows that one can view the past portfolio for any of the past months.

But how would I access this via Python? In the Excel formula builder, I was not able to see a way to enter a date for the fields that return the portfolio holdings, e.g. 'TR.FundHoldingName', 'TR.FundPercentageOfFundAssets', 'TR.FundNumberOfShares'.

Can the following code, which returns the top 100 holdings of a specific fund for the last available date, be adapted to get historical portfolios?

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

pastholdings.png (123.2 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · May 10, 2019 at 05:01 PM

I'm afraid I don't see a way of retrieving this data using Eikon Data APIs. I have opened a case on your behalf with Refinitiv Helpdesk to check if there's a way to retrieve this data into Excel using =TR worksheet function. If the Helpdesk produce a method of retrieving this data using =TR function, then we should be able to replicate the same call using Eikon Data APIs. Refinitiv Helpdesk will be in touch with you, but just in case and for your reference the case number is 07609916.

Comment
CSI
alex.yermolayev

People who like this

2 Show 4 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Alex Putkov. ♦♦ · May 10, 2019 at 05:37 PM 0
Share

The Helpdesk confirmed that currently historical fund holdings are not available through Excel or through Eikon Data APIs.

avatar image
CSI · May 11, 2019 at 07:01 AM 0
Share

Thanks Alex! Unfortunate, but I suspected as much since the "derived holdings" are marked as "new" in Eikon, so they presumably did not have time to extend this functionality yet.

avatar image
CSI · Oct 26, 2019 at 05:00 PM 0
Share

Hi Alex,

do you know if anything has changed in the meantime? Is it now possible to get also historical fund holdings data via the API? The data is clearly available in Eikon, it is just a matter of making it accessible via the API.

I think it would be great to have this possibility, because right now I have to pull the current holdings data every month for a year to create a year-long panel data set, whereas it should be possible to build such a data set in a day just by getting current and historical data. Thanks!

avatar image
REFINITIV
Alex Putkov. ♦♦ CSI · Oct 29, 2019 at 09:13 PM 0
Share
To the best of my knowledge nothing changed, and I'm not aware of any immediate plans to make historical fund holdings available through a function in Excel or through Eikon Data APIs. I suggest you raise this to Refinitiv Helpdesk and ask for enhancement.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

Access mutual fund portfolio holdings via Eikon API

Hi, using python api I would like to extract all the funds managed by a given manager fund, and for all these funds get the holdings data from emaxxbh. Is it possible to do that?

How to retrieve pricing data for Mutual Funds with one ISIN code, traded at 4 different exchanges with 4 different prices?

I'm trying to get the dividend holdings with the get_data command, and I can't get out the history even using SDate and EDate, only returns current holdings

how long is the trial api valid for and has it full access to all data, including news?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges