triggered betting help

[delboy2405]

Hi Newbie here,

Just to let you know excel about average, don't know VBA

at the moment i've setup triggered betting so that 2 min before the off, if the odds are sitting between certain odds if will trigger bet.

R1 = first odds
R2 = Second odds
Z2 = time countdown
Q9 = H9

here's my current formula =IF(AND(H9>=R1, H9<=S1,Z2<0.033333,T9=0, U9=0, W9=0),"LAY", "WAIT")

I'm look to place a better a specific odds i choose ie. 5.5 at 10min before off, then if this is not matched then clear bet and use the formula above. Anybody have any ideas. Help much appreciated

[delboy2405]

whats maybe a better way to do it is, at a specific time before race is to lay last best price.

anyone know a way to do this?