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'})
Best Answer
-
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.
2
Answers
-
The Helpdesk confirmed that currently historical fund holdings are not available through Excel or through Eikon Data APIs.
0 -
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.
0 -
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!
0 -
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.0
-
Hi @Alex Putkov. , do you know if it is now possible to get the historical/past portfolio holdings of a mutual fund via the Eikon API? I have checked with Eikon Help desk and it is not available on Excel. Thanks
0 -
Hi @Alex Putkov. , do you know if it is now possible to get the historical/past portfolio holdings of a mutual fund via the Eikon API? I have checked with Eikon Help desk and it is not available on Excel. Thanks
0 -
I'm afraid the answer is no. The rule of the thumb is that, if the data can be retrieved into Excel using =TR function, it can also be retrieved using get_data method of Eikon Data APIs, and vice versa.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛