How to pull organization id using debt ticker code

MJarosz

We are trying to pull organisation id's and company/issuer names from Eikon using the debt ticker code. Is there any function on excel or in the API that would allow us to do so.

For eg: HHYON - Hydro One
GEELYV - Volvo Car AB

chavalit-jintamalit

Hi @MJarosz

I think this code should work:

Search for result

#pip install refinitiv.dataplatform

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxxxxxx')

df = rdp.search(query="HHYON", top=2000, view = rdp.SearchViews.SearchAll )
df1 = df[df['RIC'].notnull()]
df1.head(5)

Filter for ticker = HHYON

rics = df1['RIC'].tolist()
fields = ['TR.TickerSymbol', 'TR.FiTicker','TICKER', 'GV1_TEXT', 'TR.CDSTicker', 'TR.CDSRefEntTicker', 'TR.TickerSymbolOld', 'TR.IssuerTickerCode', 'TR.TickerSymbolCode']
df2,e = ek.get_data(rics, fields)
df3 = df2[df2['TICKER']=='HHYON']
df3.head()

m.bunkowski

Hi @MJarosz, you can also try:

rdp.search(view = rdp.SearchViews.FixedIncomeQuotes,
filter = "IssuerTicker eq 'HHYON'",
select = "IssuerCommonName,IssuerOAPermID",
top=1)

MJarosz

https://community.developers.refinitiv.com/discussion/comment/75934#Comment_75934

Hi @chavalit-jintamalit,

Thank you for the answer above. I just have a follow up question of what would go inside open_desktop_session. I have Eikon API Proxy open and I've tried adding in the app key for the eikon data api but rdp.seach result returns None. Am I missing something here?

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/76071#Comment_76071

@MJarosz

In rdp.open_desktop_session you should be able to use the same app key you use in ek.set_app_key method. I also suggest you take a look at the response by @marcin.bunkowski below, as it better answers your use case than the example provided by @chavalit-jintamalit