I was testing the Lay The Field spreadsheet yesterday in Demo mode and came across the following situation a couple of times:
In the following photo, the horse on row 9 had been favourite, dropped below 2 in the odds and was therefore laid. Then the horse on row 8 took over favouritism, dropped below 2 (1.99) in the odds, but failed to trigger a LAY bet.
Later, the horse on row 8 again fell below 2 in the betting and triggered the LAY bet (so obviously the Command formula was working). The screenshot was taken after the price had risen again above 2.
The horse on row 8 continued to rise in the odds and eventually lost the race. Therefore the Lay bet on it failed to get matched and my only matched lay bet lost. If the initial fall in the odds of the horse on row 8 had triggered the LAY bet, it would have got matched the second time the odds fell below 2.
I thought this might have been a connection issue, but then surely Excel should still have issued the LAY command? I have increased the number of horses covered down to row 40 and added the "Stop at" formula suggested in another post. Confused.