It seems that the maximum number of instruments retrieved for RSearch function is 2000. From the help file, I notice this limit is defined in administrative service. Can anyone tell me where it is? Much appreciated!
From a developer perspective this limit is hardcoded. It can only be changed centrally by Thomson Reuters, and I'm afraid the company has no plans of changing it.
Hi, I would like to ask if there have been any developments on this and whether it is now possible to change the default limit.
The Eikon help file still includes that the default limit can be changed through editing the POWERLINK.RSEARCH.DEFAULT.NBROWS setting. And having had a look through the Config folder in the installation path, the LMO.USERPROFILE.xml file describes that this setting (as well as the POWERLINK.RSEARCH.MAX.INSTR.PER.QUERY setting) can be overridden at user level.
If it is possible, could you please help me with adjusting the limit?
Many thanks,
Marek
There have been no changes regarding the max number of instruments that can be returned using RSearch Excel function or RSearch COM API. Neither of the parameters you found has any effect.
If you need the search to return more than 2K rows, the only way to do this is to order the result by some criteria and use the result of the previous query to construct then next one. E.g. if you need to retrieve the listing of a stock exchange you can set the exchange as the criteria and order the result by market cap descending. Once you retrieve the first 2K stocks, you can retrieve market cap for them. And then for the next query you add the criteria that market cap is less than the smallest market cap returned for the stocks in the previous query, retrieve the next 2K stocks and so on.
