Excel communication speed

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
billeales
Posts: 33
Joined: Fri Jun 03, 2022 11:48 am

I have been using Excel to help with in-play data, I am making calculations in Excel and sending data back to Bet Angel as a stored value using the command line. I have a VBA that keeps the status cell clear to send the data as fast as possible but when watching it back in slow motion the data takes a frame (0.2s) to reach BA Guardian. This is an issue with how the data communicates with my guardian set up. I was wondering if there was a way to make the data pass over in close to real time. I have a bit of VBA experience and did wonder if the API might be a way to do it but i'd rather not if possible. Does anyone know the mechanics in how BA pulls data from Excel?

Many thanks in advance for any advice.
Win
Posts: 27
Joined: Sun Feb 02, 2020 10:16 pm

I can't help you on the Excel/BA communication speed, but thanks to Microsoft Copilot, I've found that creating VBA macros to send/receive data between Excel and BA is very easy. It could be an option worth exploring.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”