For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
s2782245 avatar image
1 ●0 ●1 ●1

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonricsr
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

@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')
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

s2782245 avatar image 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?
Alex Putkov.1 avatar image Alex Putkov.1 s2782245

For a good intro to RDP Search service see the article titled Building Search into your Application Workflow. The documentation for RDP Search service is available from the Reference tab on the Search API page on API Playground. Navigate to https://apidocs.refinitiv.com/, sign in using your Eikon credentials, then navigate to /discovery/search/v1/lookup endpoint and click on Reference tab.

s2782245 avatar image 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?
Alex Putkov.1 avatar image Alex Putkov.1 s2782245
I'm afraid Refinitiv does not offer such a service, and I'm not in a position to suggest any 3rd parties that may offer consulting services with Refinitiv APIs. My suggestion is that you use the simple example I provided. And if you have any specific questions, you can post them on this forum. To get the most useful answer from the forum, describe your use case in as much detail as is practical.
Click below to post an Idea Post Idea