Storing prices using bet angel templates

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Azehavi
Posts: 1
Joined: Fri Jan 17, 2014 1:22 am

Hello,

I am using bet angel templates to store market prices on a spreadsheet. Essentially, I've written a macro that copies the prices from the template and stores it on a different sheet.

However, once the macro is running (and it may run for the duration of a game / race), the bet angel templates are not being updated with live prices and the prices 'freeze' until the macro stopped running.

Any advice how to avoid that and make sure the template is being updated while the macro is running, will be appreciated.
6thSense
Bet Angel
Bet Angel
Posts: 375
Joined: Fri Nov 30, 2012 5:02 pm

There is a template here that already does this:

viewtopic.php?f=31&t=2385

But you need 'DoEvents' in your macro to enable it to refresh the external data feed.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”