Hello
I want to download all the equities from Eikon. Because of the limitation of 2000 raws,
i searching for vba code which do that.
Hello
I want to download all the equities from Eikon. Because of the limitation of 2000 raws,
i searching for vba code which do that.
Hello @mounir.shal
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
I cannot help but wonder what the purpose of this exercise might be. If you're looking to use Eikon for industrial data consumption, then Eikon is not designed for this purpose. Consider Refinitiv products from the Enterprise family, which are built to provide data on an industrial scale.
To workaround the limit of 2K rows returned by RSearch function you may request to order the results of the search by say market cap and request data in batches of 2K rows each using the result of the previous request as input for the next. E.g. order the results in descending order by market cap and in each request ask for all stocks with the market cap lower than the lowest market cap returned in the previous batch. You could do this in a loop using RSearch and DEX2 COM libraries.
Alternatively you may want to use more modern Eikon Data APIs and Screener instead of Search. Although Eikon Data APIs provide more modern interface, you'd still need to retrieve data in batches because it's still Eikon product, which is not designed for industrial data consumption.