CANCEL-ALL-LAY

[andrej]

Hello, I have a question regarding this trigger from excel. At a certain moment I want to cancel all Lay bets in the market. The way I do this is that I have a macro to input "CANCEL-ALL-LAY" into trigger cell for each horse.

The problem with this is that the bets are not cancelled imediately but it seems like one bet is cancelled on each refresh going from the first horse down. Is it the way it should be or am I doing something wrong?

is there any simple way of canceling all lay bets at the same time?

thank you

best regards
Andrej

[GaryRussell]

They are all cancelled on the same refresh. I take it your spreadsheet is giving you the impression that this isn't the case, can you provide an example spreadsheet that demonstrates this?

[andrej]

Hi Gary, I have noticed this in the betting assistant. I was watching the odds move and then I saw the bets disapearing one by one for about 5 seconds.
I am not sure how to upload the sheet here so here is part of the code responsible for triggering the cancel

Do Until mybets = ""
If mybets = "B" Then
Do Until horse = ""
trigger = "CANCEL-ALL-LAY"
Set horse = horse.Offset(1, 0)
Set trigger = trigger.Offset(1, 0)
Loop
End If
Set mybets = mybets.Offset(1, 0)
Loop

I believe this is putting in CANCEL-ALL-LAY in one refresh so the cancel should be done on the next.

Andrej

[GaryRussell]

Code: Select all

Set mybets = mybets.Offset(1, 0)

The above statement is updating the cell in the worksheet?
Do you use "Application.EnableEvents = False" to prevent further events firing? If not then this could be the problem. Try changing your code to read as follows.

Code: Select all

Application.EnableEvents = False
Do Until mybets = ""
If mybets = "B" Then
Do Until horse = ""
trigger = "CANCEL-ALL-LAY"
Set horse = horse.Offset(1, 0)
Set trigger = trigger.Offset(1, 0)
Loop
End If
Set mybets = mybets.Offset(1, 0)
Loop
Application.EnableEvents = True