question

Upvotes
Accepted
20 0 0 2

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

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:

1687353760900.png

refinitiv-dataplatform-eikon#contentpython apidatastream-api
1687353760900.png (12.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
1.5k 5 3 6

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

1687443725165.png

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

1687443787893.png



1687443725165.png (6.8 KiB)
1687443787893.png (8.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
20 0 0 2
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
6.2k 21 3 6

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

1687355414039.png


1687355414039.png (233.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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:

1687432140602.png
Do you have any leads?


Thanks

1687432140602.png (113.2 KiB)
Upvotes
1.5k 5 3 6

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']}")

1687424903588.png

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]


1687424983788.png


1687424903588.png (13.6 KiB)
1687424983788.png (20.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.