Efficiently Retrieving a Large Volume of Company Names using Excel RDP.Search

nicola.fiore

I'm currently facing a challenge with the following Excel code snippet:

=RDP.Search("EQUITY","IsPrimaryIssueRIC eq true and SearchAllCategoryv2 eq 'Equities' and RCSAssetCategoryGenealogy eq 'A:1L' and RCSIssuerCountryGenealogy eq 'M:DQ\\G:AM\\G:6J' and RCSExchangeCountryLeaf eq 'United States';query="&A2&"","NBROWS:1",,)

My aim is to retrieve around 1 million company names using the RDP.Search function. However, I'm concerned about hitting request limits or encountering inefficiencies in the process.

Could anyone provide insights or strategies on how to achieve this without running into limitations? I greatly appreciate any advice or experiences shared regarding this endeavor.

Jirapongse

@nicola.fiore

Thank you for reaching out to us.

If the question is about the RDP.Search function in Excel, please contact the helpdesk support team directly via MyRefinitiv.

As I know, the search endpoint in RDP limits the number of results to 10000 entries.