get_symbology not working

thomas01

Hi all, 

I'm trying to find companies RIC code using Eikon get_symbology from ticker to RIC. (For example with NVDA and MSFT). The command returns <NaN>, however the documentation clearly supports get_symbology from ticker to ric. As an alternative, I'm now using rdp to get ric. Can someone please help check if get_symbology is still supported ticker->ric mapping.


df = rdp.lookup(view=rdp.SearchViews.EquityQuotes, scope='TickerSymbol',terms="NVDA,MSFT",select='RIC')

raksina.samasiri

hi @thomas01 ,

For reference, here's an answer provided by the support team in case number 10921134

I tried and compared the results. It looks like that for the following tickers I'm not getting anything....
The tickers with no results are either delisted or the underlying ticker is valid for more than one equity. That is why using ISIN or CUSIP as an identifier is more accurate than ticker.

The below script converts TICKERS to CUSIP and then CUSIP to Primary RIC. Please check if it returns more results for you:

RICS= ['KSU','MXIM','INFO','ES','MSCI','CME','CL','BSX','ALXN','AAP']
RICS_list = [RIC+"@ticker" for RIC in RICS]
ticker,err = ek.get_data(RICS_list,"TR.CUSIP")
cusips_list = [cus+'@cusip'; for cus in ticker['CUSIP']]
cusips_list
df,err = ek.get_data(cusips_list,['TR.PrimaryQuote'])
df['TICKER'] = ticker['Instrument']
df
If you identify any tickers with no underlying Primary RIC, please create a ticket via MyRefinitiv to reach out to the content team to check the mapping.

Do you mind telling me what's the difference between .O ,K or even no "dot trailings" for example AAP ticker has RIC AAP:
The full list of RIC exchange codes can be found on EXCHID01 Eikon Page.

wasin.w

Hello @thomas01

I am noticed that you are using the Refinitiv Data Platform Libraries - Python (RDP - Library), so you can use the RDP-Library convert_symbols function to convert from one symbol type to other types.

rdp.convert_symbols(
    symbols = ['NVDA','MSFT'],
    from_symbol_type = rdp.SymbolTypes.Ticker,
    to_symbol_types = [rdp.SymbolTypes.RIC]
)

Jirapongse

@thomas01

You need to set the best_match argument to False.

data = ek.get_symbology(["NVDA","MSFT"], from_symbol_type="ticker", to_symbol_type="RIC", best_match=False)

The output is:

thomas01

https://community.developers.refinitiv.com/discussion/comment/90239#Comment_90239

Hi, thanks for your reply. Yes I am using RDP but ideally I'd like to use Eikon because RDP requires me to be logged out from the desktop terminal and huge part of my existing code is implemented in Eikon. Can you please suggest a method that would work in Eikon api?

thomas01

https://community.developers.refinitiv.com/discussion/comment/90250#Comment_90250

Hi, thanks for your reply. I have tried just now and got exact results that you show. I guess the b) question is that if I want to get the primary RIC, I should always get the one with .O or the first element in the list? Sorry this maybe a noob question, but I'm really new at the Refinitiv universe

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/90293#Comment_90293

@thomas01

I can't confirm it. However, I have submitted a new case on your behalf to the support team to verify it. The case number is 10921134.