Kingston Town wrote:Hi all, I want to LAY at SP but only if the SP is within a certain range.
What formula for the odds column would I need and what trigger?
Thanks
Hi,
You can use the LAYSP trigger but you can only specify the maximum odds that you are prepared to accept which is what you put in the trigger odds column.
In the trigger stake column put the liability for the lay bet which must be a minimum of £10 or currency equivelant for Betfair to accept it.
The other option is to wait until the SP price has been resolved just after in play and then you can decide whether the odds are in your range using an IF statement in the trigger column.
If you go for this option you will need to output the SP from the additional columns list when you first start logging to Excel and you will need to monitor for when the market is turned in play.
Regards,
Mark