Excel not updating data when running macro

Modified on Tue, 25 Apr, 2023 at 12:47 PM

If you use a looped macro within Excel and connect to Bet Angel you may find the live market data will no longer update whilst the macro is running.

This is due to Excel giving priority to the macro and suspending external data feeds whilst the macro is running.

The solution is to add the 'DoEvents' instruction inside your macro. This tells Excel to interuppt what it is doing and update the data.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article