=TR(RIC; "BID) leads to "The record could not be found"

felixrostek

I am trying to get the BID-Price via Excel of the following: Acco Brands in Frankfurt

First i converted the ISIN (US00081T1088) to RIC (=TR("US00081T1088";"TR.RIC";"RH=IN";B2). Via Excel I extracted the base RIC (ACCO).

Then I am trying to get the BID-Price via Excel of the following: Acco Brands in Frankfurt

=TR("ACCO.F";"BID")

This leads to "The record could not be found". But I know that it is traded in Frankfurt. Whats wrong here?

chavalit-jintamalit

Hi @felixrostek

You may consider using CodeBook and RDP Lib.

Please type in "CODEBOOK" on Eikon search bar and press enter to launch CodeBook app.

Look at this article on how to launch CodeBook (could be on Eikon Web access or Eikon Desktop).

https://developers.refinitiv.com/article/use-eikon-data-api-or-rdp-library-python-codebook-web-browser

You can then use this code in the CodeBook:

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

df = rdp.search('US00081T1088',
                view = rdp.SearchViews.Quotes,
                select = 'RIC,BusinessEntity,PermID',
                top = 100)
result_rics = df['RIC'].tolist()
print(result_rics)

Result:

['ACCO.K', 'ACCO.N', 'A3B.F', 'ACCO.TH', 'ACCO.Z', 'ACCO.P', 'ACCO.ZY', 'ACCO.DG', 'ACCO.C', 'ACCO.DY', 'ACCO.B', 'ACCO.A', 'ACCO.PH', 'ACCO.MW', 'A3Bf.TRE', 'A3B.BE', 'ACCO.DF', 'ACCO.ARC', 'ACCO.NB', 'ACCO.ITC', 'ACCO.BAT', 'ACCO.BYX', 'ACCO.EI', 'ACCO.BT1', 'A3Bf.ICEM', 'A3Bf.DAp', 'A3B.DEU', 'ACCO_w.K^E12', 'ACCO_w.N^E12', 'A3B.DE^E11', 'ACCO.W^E14', 'ABD.B^J07', 'ACCO_w.B^E12', 'ACCO_w.C^E12', 'ACCO_w.DF^E12', 'ACCO_w.DG^E12', 'ACCO_w.DY^E12', 'ACCO_w.MW^E12', 'ACCO_w.P^E12', 'ACCO_w.TH^E12', 'ACCO_w.W^E12', 'ACCO_w.Z^E12', 'ACCO_w.PH^E12', 'ACCO_w.ZY^E12', 'ABD.PH^B09', 'ABD.II^G10', 'A3Bf.TRXA', 'A3Bf.TWEA']

From this RIC list, you can find out the exchange or country.

import refinitiv.dataplatform.eikon as ek
ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

df2,e = ek.get_data(result_rics,['TR.ExchangeCountry', 'TR.ExchangeName', 'TR.ISIN'])
df2

result: