Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
viktor.moortgat avatar image
2 ●0 ●1 ●0

Retrieve data in vba while sub has not ended yet

Dear,

I am currently trying to retrieve data from Thomson Reuters via the Eikon Data APIs in VBA Excel. The problem I have is that the data only is retrieved the moment the sub stops running. In my case, I should be able to get the data, process it for a certain stock and directly do the same several times, without the stopping of the program. Data retrieval for 1 stocks works just fine, it is only when a loop is used for this, that it does not work. Anybody who can help?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-apidata
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chavalit-jintamalit avatar image   chavalit-jintamalit

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

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

@f9a5b5fd-d648-46de-b6c4-745a67cac406
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

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

@f9a5b5fd-d648-46de-b6c4-745a67cac406 try using DoEvents in your loop.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.