CANCEL-ALL-LAY-KO and "Offset bet matched" column

[gizzard]

I am using the CANCEL-ALL-LAY-KO trigger as designed but am having trouble then with the Offset bet matched indicator in an additional column.

What I am trying to do is to select the next market once all of the offset Back bets have been matched. I am trying to use the Offset bet matched indicator to tell me when they are matched by looking for a "Y" in that column for any remaining back bets.

I find that CANCEL-ALL-LAY-KO removes the Bet Reference once activated (it also removes Offset bet references in another additional column)i. From that, my understanding is that the Offset bet matched indicator is only effective if there's a Bet Reference so I don't know how I can then check the Offset bet matched indicator to see if the offset bet has been fully matched.

I realise that I can use the MyBets sheet (which I don't currently need) and check if all bets are matched from there but thought that the Offset bet matched indicator would do the job for me.

Can someone confirm whether the only way of doing this is through MyBets or how I use the Offset bet matched indicator?

[Daywalker]

Did you solve this?

Are you using VBA? Not sure if it would work but you could try save the bet ref before cancelling, then paste back after to check for match?

[gizzard]

Thanks for the reply. Yes, I'm using VBA.

In the end the only solution that I could find was to use the MyBets sheet. I feel that there's a design flaw and this was the only way that I could find around it.

This forum used to be really good at providing fast, helpful answers but that seems to be in the distant past so I appreciate your suggestion.