Sheet freezing !!!

[telglam]

novice seeking help here !.
My macro fires a lay into the market when condition is met. Then when lay is matched fires a back into the market.
I have formatted the sheet for my viewing experience
The problem i have is when the lay is fired the spread sheet data freezes for a few seconds before continuing to display as normal.
I am only using pennies for stakes ......so , is this the reason for the long delay?.
All comments would be very much appreciated.
Cheers!

[GaryRussell]

Is it on an in play market? Betting Assistant won't refresh the sheet again until the bet has been placing so on an in play horse racing market it will be 3 seconds before another bet can be triggered when placing a below minimum stake bet due to the delay imposed by Betfair. During this time the bet ref column will show "PENDING". It shouldn't actually cause Excel to freeze during this time though.

[telglam]

ahh!........i thought the in-play delay for submitting bets was one second.
Never mind.........
Thanks for your informative reply.
Cheers.

[GaryRussell]

It is a second, but if it's below minimum stake the program has to "cheat" to get the bet on and this takes 3 transactions which each are subject to 1 second delay.

See http://www.youtube.com/watch?v=nk_J8ry2iKw for an explanation of how below minimum bets are placed manually. This is how Betting Assistant does it in the background.

[telglam]

Gary......thank's for clarifying the submitting process.

I will have to stake the Befair minimum in future
too speed things up !