Excel not updating data when running macro

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.