Newbie I'm afraid.
I want to set the following trigger
At the scheduled start time lay the selection for £x at SP if the back odds at the scheduled off time are between 5.8 and 7.2 or are between 12.0 and 18.0.
I can can come up with a if / and statement that I can make work in a normal excel spreadsheet but keep getting error in the status column when I put it into a Betangel spreadsheet.
Can anyone advise of a suitable trigger formula that will work?
Steven
help with a trigger
If you're still looking this will work:
=IF(AND($C$3=$F$3,OR(AND(G9>=5.8,G9<=7.2),AND(G9>=12,G9<=18))),"LAY","")
Would be better to specify a range on the start time to avoid the risk of skipping over the specific start second or volatility in the price.
=IF(AND($C$3=$F$3,OR(AND(G9>=5.8,G9<=7.2),AND(G9>=12,G9<=18))),"LAY","")
Would be better to specify a range on the start time to avoid the risk of skipping over the specific start second or volatility in the price.