How to pull organization id using debt ticker code

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

Find more posts tagged with

python

eikon

api

excel

symbology

issue

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

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()

All comments

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

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?

EXPLORE OUR SITES