Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
s2782245 avatar image
1 ●1 ●1 ●5

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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apiricsr
icon clock
10 |1500

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

wasin.w avatar image   wasin.w

Hello @s2782245

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●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 512.0 KiB each and 1.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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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