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 07, 2019 at 11:07 AM · holdingsapi accessmutual fundsmutual fund info

Access mutual fund portfolio holdings via Eikon API

Hello,

I would like to extract the portfolio holdings of multiple mutual funds via the Eikon API. Are the full holdings, the top 10 holdings, or historial holdings of a mutual fund accessible via the API? Which field would I have to use to get these holdings?

Background: In the Fund screener in Eikon, the full holdings of a single fund can be viewed, and they can be manually exported as xlsx (Excel) file for ONE fund at a time. But since I want to build a large panel data set, I need to be able to automate the export of portfolio data for multiple funds at a time, hence my interest in the API. So far I have been unable to find a field that describes anything remotely resembling the fund portfolio holdings; this is unfortunate since the data is clearly available in Eikon!

Thank you!

ethan.hayashi

People who like this

1 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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · May 07, 2019 at 11:45 AM

Here's an example

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

I think you would benefit from checking out this tutorial, which talks at length about discovering metadata (field names and parameters) for use with Eikon Data APIs.

Comment
rajanraju
CSI
ethan.hayashi
alex.yermolayev

People who like this

4 Show 2 · 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
CSI · May 08, 2019 at 02:04 PM 0
Share

Thank you Alex, this is exactly what I was looking for. I did stumble upon TR.FundHoldingName in the data item browser but did not realize it was what I was looking for, because it only showed one company (first item) rather than a list.

To find these field names myself next time: Was there a way to identify these field names from the fund holdings screen in Eikon, which shows this data (screenshot of that screen below)? Because going via data item browser kind of requires one to know the right term (part of the field name) in the first place.

fundholdings.png (112.3 KiB)
avatar image
REFINITIV
Alex Putkov. ♦♦ CSI · May 08, 2019 at 03:06 PM 1
Share

I'm afraid there's no way to discover the field names from the Fund Holdings view in Eikon. In Formula Builder wizard in Excel you can browse the fields by category, which in my opinion is the best way to go about metadata discovery for use with Eikon Data APIs. Unfortunately these categories are not available in DIB.

formulabuilder.png (84.1 KiB)
avatar image
Answer by swang · Feb 12, 2020 at 04:25 PM

Hi @Alex Putkov. , do you know how to get the full holding name for bond etfs? Seems like it's not possible to retrieve tickers/isins for bond etfs

Comment

People who like this

0 Show 1 · 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. ♦♦ · Feb 12, 2020 at 07:55 PM 0
Share

You're right, it appears that you can only get the holding name, but not RIC or ISIN, or another identifier. This said, I suggest you verify it with Refinitiv Helpdesk. This forum is aimed at software developers using Refinitiv APIs. The moderators on this forum are experts in the use of Refinitiv APIs, who do not necessarily have deep expertise in every type of content available through Refinitiv products and services. Content questions such as this one are best directed to Refinitiv Helpdesk, which you can reach by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.
Also whenever you'd like to ask a new question, please start a new thread. Old threads that already have an accepted answer are not monitored by forum moderators, hence a question asked on an old thread can be easily overlooked.

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 >
10 People are following this question.

Related Questions

Mutual fund past portfolio holdings via Eikon API

Historical data on bond holdings in eMAXX

Eikon Api Error code 503

Historical Holdings of an ETF

Is it possible to get American Petroleum Institute data via API ?

  • 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
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • 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