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 /

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by daan.vanacker · Jul 29, 2020 at 08:57 AM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonricsfundslipper

Pull Fund Management Company RIC for a given fund LipperID

Is it possible to retrieve the RIC of the fund management company of a given fund using the Eikon Data API get_data (or any other) function?

I've managed to retrieve the fund management company name as follows: get_data('40061133','TR.FundCompany'). However, I'd now like to get further information on the fund management company (e.g. ultimate parent), for which I'd need its RIC.

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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit-jintamalit · Jul 29, 2020 at 05:00 PM

Hi @daan.vanacker

df, err = ek.get_data(['SPY','LP40061133','40061133'],['TR.CommonName','TR.FundCompany'])
display(df)

TR.FundCompany will give you the company name, SSgA Funds Management Inc

But I cannot locate field that carry its PermID.


The moderators here do not have deep expertise in every type of content available through Eikon.

You may want to verify this with Refinitiv Helpdesk by asking if there's a field carrying the Fund Company PermID.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/



ahs.png (17.4 KiB)
Comment
daan.vanacker

People who like this

1 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
daan.vanacker · Jul 30, 2020 at 08:44 AM 0
Share

Thanks for your help, @chavalit.jintamalit . I was afraid that this mightbe the case. I'll try to reach out to the helpdesk.

avatar image
REFINITIV
Answer by chavalit-jintamalit · Jul 29, 2020 at 12:04 PM

You can try this code:

df, err = ek.get_data('40061133',
                      ["TR.FUNDHOLDINGRIC","TR.FundHoldingname","TR.FundPercentageOfFundAssets","TR.FundNumberOfShares","TR.FundAllocationDate"],
                      {'endnum' :3000 })
display(df)


Then to get RIC list:

rics = df['Holding RIC'].tolist()
len(rics)


ahs.png (52.7 KiB)
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
daan.vanacker · Jul 29, 2020 at 12:15 PM 0
Share

I'm afraid this isn't what I'm asking about. This gives me a list of RICs for the companies held by the fund (i.e. the fund portfolio).

What I'm looking to get instead is the (single) RIC of the fund management company, i.e. the financial company which manages the fund. For the examlpe Lipper ID I gave, this is SSgA Funds Management Inc with RIC 4297137409.

avatar image
REFINITIV
Answer by nick.zincone · Jul 29, 2020 at 03:48 PM

Hi @daan.vanacker,

Accessing the DIB within Eikon, I want to confirm if the RIC you are looking for is SPY, as you can see here:

If so, using the following will get you:

If not, you can further investigate within the DIB and filter on the term RIC which will provide a number of matches. Otherwise, I would suggest you reach out to the Refinitiv Helpdesk to ask if the data is available.


ahs.png (22.6 KiB)
ahs.png (6.3 KiB)
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
daan.vanacker · Jul 29, 2020 at 04:06 PM 0
Share

Hi nick.zincone.1,

Thanks for this. You've made me realise I may be confusing my identifiers.

I'm looking for an identifier for the fund management company associated with the fund, not an identifier for the fund itself, as you have pointed me to. This may not be a RIC as I originally asked for, but instead a PermID.

For example, for the SPDR S&P500 ETF Trust, the listed fund management company on the overview page under 'Company Information' is SSgA Funds Management Inc (see screenshot).

I'd like to get an identifier, perhaps the PermID associated with this fund management company, as a data item. In this case, the PermID would be as in the below screenshot (found on SSgA Funds Management Inc's company overview page).

Is there a data item associated with this? I can't seem to find one in the DIB.

spdr-sp-500-etf-trust-fund-overview-29-07-2020-17.png (120.4 KiB)
ssga-funds-management-inc-overview-29-07-2020-17-0.png (64.5 KiB)
avatar image
REFINITIV
Answer by marcin.bunkowski · Jul 30, 2020 at 08:08 AM

Hi @daan.vanacker

You can try this:

df1,err = ek.get_data('40061133','TR.FundCompany')
name=df1['Fund Company'].iloc[0]
df2, err = ek.get_data(instruments = 'SCREEN(U(IN(Private(OrgType(COM,UNK,MKP)))),Contains(TR.CommonName,"'+name+'"))',fields="TR.CommonName")
df2


ahs.jpg (10.7 KiB)
Comment
daan.vanacker

People who like this

1 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
daan.vanacker · Jul 30, 2020 at 08:47 AM 0
Share

Hi @marcin.bunkowski . This is helpful, thank you. Although I'd rather avoid using a screen, as this might return zero or multiple results for certain common names without notifying me and thus compromise further calculations.

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

Related Questions

Can I get decent hedge fund data via Eikon?

How to use get_symbology method using Lipper ID

What is the RIC for EMINI S&P?

How to get the market cap name (e.g. mid-cap, small-cap) of a RIC?

How to get a list of fund from certain criteria?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • 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
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges