Hi , I am aware this question was asked before, but since the advanced time since it was asked in 2017 I was wondering if there was a more elegant and proper way to retrieve the RIC for an instrument at a specific exchange now? Hope there is since the existing solution are not very satisfying. And if there is no direct way, is there a way through the refinitiv library? (Trying to avoid eikon library if possible)
Thanks for the help in advance!
This would be the request I want to do in Python:
=@RSearch("FUND","Search:LU0100938306,ExchangeCode:STU,NBROWS:1")
As an example, obviously then for a whole list of ISIN's...
You can use the RDP /discovery/search/v1/explore endpoint with the Refinitiv Data Python Library.
The code looks like this:
response = search.Definition( view=search.SearchViews.SEARCH_ALL, select="ExchangeCode, RIC, IssueISIN", filter="(IssueISIN eq 'LU0100938306' and ExchangeCode eq 'STU')" ).get_data() response.data.df
The output is:
I used the EX-2.06.01-Search.ipynb example on GitHub.
Awesome thank you! That helps a lot. I saw the example too but couldnt really figure out how to search for what I wanted. Im still pretty new to python. How/Where did u find the necessary syntax to the search function?
Can I use this example in combination for a whole row of ISINs of a dataframe by combining the row instead of the ISIN in the search or would I need to change it?
Thanks again for all the help so far!
You can find more information regarding the RDP /discovery/search/v1/explore endpoint in the API Playground. Search for the RDP /discovery/search/v1 endpoint and then go to the Reference page of the /explore endpoint.
For multiple ISINs, you can try the following fiters:
