Hi I want to get the RIC symbol from a company's name, how to do that in Excel?
You can use =RSearch in Eikon Excel to retrieves a list of instruments based on the specified search criteria. For example:
=RSearch("EQUITY","search:Apple","NBROWS:1")
It returns AAPL.O. For more information regarding =RSearch in Eikon Excel, please refer to Thomson Reuters Eikon - Microsoft Office Help in Eikon Excel Help menu.
Moreover, to use RSearch with COM APIs for use in Microsoft Office, please refer to Tutorial 7 - Instrument Search - RSearch.
Using formula -
I get the results -
No results were found matching your criteria.
Please try to wrap Apple in the single quotes.
=RSearch("EQUITY","Search:'Apple'","NBROWS:1")
Any suggestions for a similar solution using Python API?
@mdziel
When asking a new question, please always start a new thread. Old threads are not monitored by forum moderators. If you need to reference an old thread, include a link to the thread in your post.To answer your question, see the article titled "Building Search into your Application Workflow", which describes how to implement various searches using RDP Libraries.
