lay-sp and odds

[rollem]

I want to lay-sp what do I need to put in column R in excel?

[rollem]

Sorry column R is the odds column

[GaryRussell]

The odds column should contain the maximum odds you will accept before it turns in play. If not matched when it turns in play then it will then be matched at SP. If you want to ensure matched at SP then 1.01 will ensure it is not matched before the off.

[rollem]

I have the trigger as =IF($AO13="LAY","LAYSP","") in column Q which basically is saying if a certain condition is met AO13=LAY. However when A03 is LAY and the bet is triggered it puts the bet ref on column R and the bet time in column S but on the off the bet keeps being cancelled - any ideas what I am doing wrong?

[rollem]

Just to say I have the stake as £10 so that should not be cancelling the bet.

Thanks

John

[Captain Sensible]

Your liability needs to be £10 not the stake if your odds are under 2 i.e. laying £10 @ 1.5 will only have a £5 liability and won't be entered into the bsp reconciliation process