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
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
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()
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?
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
Hi @MJarosz, you can also try:
rdp.search(view = rdp.SearchViews.FixedIncomeQuotes, filter = "IssuerTicker eq 'HHYON'", select = "IssuerCommonName,IssuerOAPermID", top=1)