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:
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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"
)
Hi @siddharth.marya , Have you had a look at DIB? Does this tool provide the fields you're after?
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
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]
@marcin.bunkowski01 is it also possible to get the issuer RIC. Additionally, is there a possibility to do this via the Eikon Python library?
