Bet Ref error

[Shaun]

I have created a sheet that acts like a bookmaker ledger, you price up a market then place your lays, if they are unmatched then you cancel them and change the price.

Problem i am having is when i put in the CANCEL-ALL then put in the LAY bet sometimes i get an error ERROR_LOGGING_REF i am not sure if it is cause by the lay being placed before the bet has had enough time to cancel or what it may be.

I am looking for a more efficient way of canceling bets then resubmitting them at a different price and stake.

[GaryRussell]

ERROR_LOGGING_REF suggests a bug as I didn't really expect to ever see this error. Next time you see this can you send the file name BA_Diagnostic.txt in the "C:\temp\Betting_Assistant_Logs" folder to admin@gruss-software.co.uk

LAYR and BACKR can be used to resubmit bets at different odds and stakes. You asked about these triggers previously, see http://www.gruss-software.co.uk/forum/v ... php?t=5320
Can you not get these triggers to work? If you use these triggers you don't need to use CANCEL-ALL, you only need to remove N from the bet ref each time.

[GaryRussell]

Also if you are willing to send me a copy of the spreadsheet it should help me trace this bug. Your sheet may be doing something I didn't anticipate.

[Shaun]

The reason i changed from using that trigger as i needed more VBA and that seamed to slow the sheet down, i will send you info as requested.