Bets not triggering from Excel

[Macd]

I entered ten Lays in the "Selection"sheet of "Place_Bets.xls" this morning.
The Min Odds for eight of the lays were set to 2.95 and for the other two were 1.0
The Max Odds for all were set to 6.05.
The only two lays triggered with Betfair had Min Odds of 1 and an SP of 3.0 and 3.25
The other lays ranged from 1.8 to 6.0 SP yet weren't triggered.
Does anyone have any idea why this should happen?

[gavind]

Hi Macd, it's been days already but have you found any luck on this yet?

[Macd]

I think I'm sorted now, I didn't have the correct trigger boxes ticked in the Excel set up.
But, having said that, I had a couple of lays fail today, one at 2.1 SP (limit set at 6.05) and another at 6.0 (limit 6.05). Five other lays were picked up without any problems.
I need to be able to sit and watch and see what happens. the lays should be triggered at one minute before the race starts and I can see that although the "Racing Post" gives an SP of 6.0 it could have been higher at the one minute before mark, but that doesn't apply ( I wouldn't think) when the SP is 2.1.

[Captain Sensible]

You'd need to make sure your overall liability for the SP bets was at least £10, so at 2.1 SP the stake would have had to be at least £9.10.