Moving to next quick pick race Q:2

[delboy123]

New to using Gruss so still learning especially the Excel integration.
How is everybody handling cycling to the next race once one has finished? Currently I have VBA code monitoring cell F:2 and once it shows Closed, enter -1 in cell Q:2. It works 75% of the time, but sometimes I can check in and it will be sat on a race that closed a while ago with ‘Closed’ in F:2. But nothing has fired and I can’t figure out why. It just fails to cycle to the next race.
Sorry if this has already been discussed. Had a browse through the forum but couldn’t find an answer

[Civitas]

I don't use excel but maybe it's something to do with which 'Auto Select Markets' been selected? Just a thought.

[MollyMoo]

I know this was posted a long time ago, but as no-one has answered it I thought I'd jump in.

In the Worksheet_Calculate routine I start a timer when the race goes in play. I also set a boolean public variable, RaceHasStarted to True. After all the betting code I then check if RaceHasStarted is True, Range F2 is = "Suspended" and the timer is greater than than 5 seconds in order to get clear of the In Play Suspended event:

Code: Select all

If (RaceHasStarted = True And .Range("F2") = "Suspended" And Timer - StartTime > 5) Then

Hope this helps.