Where can I get the full list of RIC code for all US stock in US market, and for each ticker, the code can map to Bloomberg Code.
@RBTK5
Thank you for reaching out to us.
This forum is dedicated to software developers using LSEG APIs. Please confirm the LSEG API products that you are using.
If you are using the Eikon or LSEG Workspace, you can use the Search API in the LSEG Data Library for Python to search for instruments. Please refer to the https://developers.lseg.com/en/article-catalog/article/building-search-into-your-application-workflow article but the number of search's results is limited to 10,000 instruments per request.
Otherwise, please contact the helpdesk support team directly via MyAccount for the required list.
Thanks for the Info, what if getting a static RIC list formatted in csv. or xls.? we might also ask helpdesk for the batch export, right?
Please contact the helpdesk first. The helpdesk may be able provice a RIC list in the csv or xls.
Otherwise, you may need to use the Search API to get the list.
I submitted a help-desk ticket for this exact same request! Is there a way to use the search API to filter for companies based on their country of HQ or the exchange they are listed on? My advisors and myself have the same problem to work on - we need to pull all of the RIC's for every company listed in the US.
thanks so much!
@jph
Yes, you can use the Search API to search for entries. Please check the following articles:
Find content and functionality using the Data Library with Workspace Advanced Search
Building Search into your Application Workflow
For example, the following code searches for the listed organizations that have the Headquarters in US and the Ordinary Share RICs
df = ld.discovery.search( view = ld.discovery.Views.ORGANISATIONS, top = 10000, filter = "OrganisationStatus eq 'Listed' and CountryHeadquartersName eq 'United States' and PrimaryRICRCSAssetCategoryLeaf eq 'Ordinary Share'", select = "DocumentTitle, CountryHeadquartersName, PrimaryRIC,PrimaryRICExchangeName,PrimaryRICExchangeCode,PrimaryRICRCSAssetCategoryLeaf,OrganisationStatus,RCSTRBC2012Leaf" ) df
However, the maximum number of entries in the response is 10,000 entries. You can use the Navigators to refine the query in the filter property, as metioned in the Building Search into your Application Workflow article.
If you are using the Tick History product, you can try to use searches on the DSS Web GUI to search for items.
You can contact the Tick History support team via MyAccount regarding how to use these searches to search for the required items.