Excel Trigger LAY question

[struggler148]

Is it possible to LAY at BFSP on selections where I specify odds range as >=3.5 & <=21?

I use this formula, =IF(AND(R11>=3.5,R11<=21,$Y$4>=6,AA11>0,$Y$3<2),"LAY",""), to LAY at present but would prefer to LAY at BFSP.

R11 = BFSP

Using above formula, some bets gets entered into market at SP which is below LAY prices and don't get matched.

e.g. bet entered at 4.7 where BEST LAY odds were at 5.0

I have tried using LAYSP & LAY-SP but both return errors.

Thanks.

[alrodopial]

LAYSP: a bet placed directly at BSP, you can only specify the max limit, the max odds that you are willing to accept
If BSP is lower than yours odds limit it will get matched, the lower the price the better for you
LAY-SP: same as above with the difference that your bet is placed and active in the running market and if odds steam below your limit the bet will get matched at this price. If your bet is not matched during this "market not started" phase it may be matched at BSP if the BSP price is below your upper odds limit