Checking for unmatched bets

[joe lively]

Hi all, Gary, I'm using the special trggers to scroll through the next days quick pick list looking for new markets and placing bets. Once at the end I use -3.1t to refresh the list and start again. By the way I appreciate your recent help on this.

To make sure ba doesn't place bets in any markets where it already has I use the mybets sheets to check for any umatched bets. However occasinally this appears to be failing.

Is it possible that there is a split second difference between the market sheet loading and mybets loading. This would give enough time to cause my triggers in the market sheet to fire thinking there were no bets already placed when in fact there is. All my bets are unmatched.

Is there a better way to check for umatched bets in a market?

Thanks

[Captain Sensible]

You might be better off using VBA to copy the marketID to a static sheet and stick a flag against it once the bets have been placed rather than relying on the refreshes to pull up any data as any blips with your connection might cause it to fire.

[joe lively]

Hi Captain, thanks for that, I had thought about copying the bet refs but using the market id is a much better idea.

I'm sure my vba skills can stretch to that.

I'll give that a try

Cheers.