Pull Fund Management Company RIC for a given fund LipperID

daan.vanacker

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.

chavalit-jintamalit

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/

chavalit-jintamalit

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)

daan.vanacker

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.

nick.zincone

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.

daan.vanacker

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.

marcin.bunkowski

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

daan.vanacker

chavalit.jintamalit . I was afraid that this mightbe the case. I'll try to reach out to the helpdesk.

daan.vanacker

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.