How can I get the Parent RIC (RIC of the Issuer) for a given ETF RIC?

siddharth.marya

For example the ETF 'Xtrackers II ESG Global Agg Bond UCITS ETF' has the RIC XBAE.DE. The issuer for this ETF is Deutsche Asset Management. Therefore using the XBAE.DE RIC how can I get the RIC for Deutsche Asset Management

I basically want to get the following information from the Overview page of an ETF:

m.bunkowski

Hi @siddharth.marya

Instead of Eikon Python library I recommend to use refinitiv-data library.

That would not be a one step approach but you can do it in a few steps:

import refinitiv.data as rd
rd.open_session()
result = rd.discovery.search(
    view = rd.discovery.Views.FUND_QUOTES,
    filter = "RIC eq 'XBAE.DE'",
    select = "IssuerAdvisorOrgId"
)
result
# IssuerAdvisorOrgId
# 0105339502|105645097|108431745

Now we need to iterate over to see the names and we can choose the right one:

ids = result['IssuerAdvisorOrgId'][0].split('|')
for i in ids:
    print(rd.get_data(f'{i}@orgid';,'TR.CommonName'))

# 105339502  Deutsche Asset Management London Ltd
# 105645097  State Street Global Advisors Ltd
# 108431745  DWS Investments UK Ltd

rd.discovery.search(
    view = rd.discovery.Views.SEARCH_ALL,
    filter = "Orgid eq '108431745'",
    select = "RIC,Orgid,ParentCompanyOAPermID,CommonName,DTSimpleType"
)

The results is a private company so we can check it's parent

rd.discovery.search(
    view = rd.discovery.Views.SEARCH_ALL,
    filter = "OAPermID eq '5062367285'",
    select = "PrimaryRIC,Orgid,ParentCompanyOAPermID,CommonName,DTSimpleType"
)

siddharth.marya

Any leads here @jason.ramchandani01 @Gurpreet @jeane.samson.refinitiv ?

jonathan.legrand

Hi @siddharth.marya , Have you had a look at DIB? Does this tool provide the fields you're after?

m.bunkowski

Hi @siddharth.marya
If you have access to funds endpoint https://api.refinitiv.com/data/funds/v1/assets you can try::

import refinitiv.data as rd
rd.open_session() 
request_definition = rd.delivery.endpoint_request.Definition(
                method=rd.delivery.endpoint_request.RequestMethod.POST,
                url='https://api.refinitiv.com/data/funds/v1/assets',
                body_parameters={
                    "properties": [
                        {"name": "ServiceProviders"}
                    ],
                    "universe": {
                        "symbols": ["XBAE.DE"
                                   ]}})
response = request_definition.get_data()

items = ['ADMINISTRATOR','INVESTMENT_ADVISOR','CUSTODIAN','FUND_MANAGEMENT_COMP','PROMOTER']

for i in items:
    for sub in result:
        if sub['code'] == i:
            print(f"{i}\t {sub['values'][0]['longName']}")

you can also use search endpoint:

import refinitiv.data as rd
rd.open_session() 
url = 'https://api.refinitiv.com/discovery/search/v1/';
request_body={"View": "FundQuotes",
"Filter":"RIC eq 'XBAE.DE'",
"Select":"IssuerAdministratorCommonName,IssuerAdvisorCommonName,IssuerCustodianCommonName,IssuerPortfolioManagerLegalName"
}

request = rd.delivery.endpoint_request.Definition(
    method = rd.delivery.endpoint_request.RequestMethod.POST,
    url = url,
    body_parameters = request_body
)
response = request.get_data()
response.data.raw['Hits'][0]

siddharth.marya

Hi @jonathan.legrand ,

These fields are not working for my case, I already tried numerous TR. fields from DIB. They are not filled for ETFs. basically the information I need is present on the overview page and the question is how to extract it from there. I additionally also need to extract the following info(highlighted in red) from the overview page:


Do you have any leads?

Thanks

siddharth.marya

@marcin.bunkowski01 is it also possible to get the issuer RIC. Additionally, is there a possibility to do this via the Eikon Python library?