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.