Hi all,
I need to retrieve some information on various asset of different asset classes (Fx, Indexes, ...)
I have ISIN, CUSIP and SEDOL information for each asset, and i can get basically any information, except RIC code.
Here is what I tried, to get for exemple the RIC of isin : IE00B4L5Y983, which is an ETF
df = rd.discovery.search( view = rd.discovery.Views.SEARCH_ALL, filter="ISIN eq 'US4592001014'", select = "BusinessEntity,DocumentTitle,RIC,RicRoot", top = 100)
it returns and empty dataframe.
I also tried using other codes like cusip or sedol but same, no results.
I also tried doing a general search, but the results are unreliable
response = rd.content.search.Definition("IE00B4L5Y983").get_data() response.data.df
I am aware that RIC code isn't unique to an asset, but i'm trying to get any valid RIC code for a given ISIN, if possible the main RIC code.
I don't think that it is possible that there is 0 way of doing this, there has to be a map from ISIN to main RIC for all asset classes, but I haven't found it yet.
For testing, here is another exemple that doesnt have a ISIN => RIC bridge. Isin : EU0009652759 (eur/usd fx pair)
I'm really looking for any reliable way to get RIC code from non-refintiv data.
Thanks for your help.