How can I get the RICs for a list of Tickers?

Hi,

how can I get the RICs for a list of tickers, so that I can work with get_timeseries?

I have seen this related post: https://community.developers.refinitiv.com/questions/19371/converting-a-list-of-tickers-to-rics.html

What is the best practice today to find out the RICs?

kind regards

Find more posts tagged with

eikon

rics

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

@s2782245

The thread you referenced is quite old and the answer it provides is outdated. I would recommend using the lookup capability in RDP Library. See examples here and here. Note that stock tickers are not globally unique, so to unambiguously resolve a stock ticker and convert it to a RIC you need to provide additional criteria, for example exchange or exchange country. For German stocks you could use

rdp.lookup(view=rdp.SearchViews.EquityQuotes, 
           scope='TickerSymbol', 
           terms='DAI,LHA,DBK', 
           filter="ExchangeCountry eq 'DEU'", 
           select='RIC')

All comments

Alex Putkov.1

@s2782245

rdp.lookup(view=rdp.SearchViews.EquityQuotes, 
           scope='TickerSymbol', 
           terms='DAI,LHA,DBK', 
           filter="ExchangeCountry eq 'DEU'", 
           select='RIC')

s2782245

Hi and thank you for your answer. Luckily I do have the exchange and exchange country information. However, this raises the question again how for example "Exchange Country" is defined in the REFINITIV universe. For example, you mentioned German stocks, and the string passed to the filter is "DEU" instead of for example "GER"... Is there any kind of list/documention or something else?

s2782245

Thank you very much for your answer. Is there any kind of place where I could turn in for practical help with all of the programming part? Im just a student and a little bit overwhelmed by the steps getting from Ticker to RICs. It should be a simple task for someone that has experience I guess? Any suggestion where I can find practical (paid?) help with this?

EXPLORE OUR SITES