Excel processing bet speed (Video)

[jc0r]

Hi all, i am currently looking at how fast Excel triggers process. In this following video, which i have slowed down, you can see that the bet is submitted at 18 seconds but it takes until 26 seconds into the video before the bet is executed. It would appear that the bet is only sent on when the next refresh inside BA occurs. Is there a way that the bet can submit as soon as i trigger the cell rather than having to wait for BA's refresh?

For reference i am using Win XP / Excel 2003

http://www.youtube.com/watch?v=gnLK9WKyces

[GaryRussell]

No, it reads the triggers on each refresh so will not know about the trigger until the next refresh.

What you want to do is "push" the request to Betting Assistant and the only way to do that is using the COM interface. You can read about the COM interface in the user guide. It basically involves a VBA statement to place the bet.

[jc0r]

Thanks a lot Gary, nice to know it is possible. Can COM be used alongside the Excel logging function or should i rewrite my sheet to specifically use just one method or the other?

Thanks

[GaryRussell]

Thanks a lot Gary, nice to know it is possible. Can COM be used alongside the Excel logging function or should i rewrite my sheet to specifically use just one method or the other?

Thanks

It can be used alongside Excel logging.