How retrieval all rics from an exchange (exceeding 10,000 rows)

liu.chen
liu.chen Newcomer
edited December 2024 in Refinitiv Data Platform

I want to retrieval all rics from NYSE for example, but following code return the top+skip can never exceed 10,000. Is there any way to retrieval all rics? If any other modules work is ok as well, doesn't have to be search.definition. This is not a lot of data, can't image why set this limit.

Screenshot 2024-11-28 at 21.46.20.png

Best Answer

  • jason.ramchandani01
    edited November 2024 Answer ✓

    @liu.chen Thanks for your question - so you are correct that the search query returns a max of 10,000 results per API call - so there are a couple of other methods you can deploy to iterate over a particular universe you are interested in. Some examples could be companies beginning with A, B, C or companies beginning with A in Sector X or some similar kind of logic then checking to see if the result returned was over 10k. We have written an article which can help you with this here. We also have a Bulk Search API - also available via the same Data Platform as the normal Search and Searchlight services - which can allow users to pull lists of RICs into the 10+ Million range. You can find out more information about that here. We also wrote an article about this new API which I think is exactly what you are looking for - however it is not available as part of the Desktop offering. You can speak to your account manager to provide you with access. I hope this can help.

Answers