by scarlett3 » Wed Oct 08, 2025 10:13 am
This is my Excel formula to trigger bets.
=IF(A5="","",IFERROR(IF(E$2="In Play","CLEAR",IF(OR(T5="INVALID_SIZE",T5="INVALID_PERSISTENCE",T5="EVENT_SUSPENDED",LEFT(T5,21)="EXPOSURE_OR_AVAILABLE",
T5="CANCELLED"),"CLEAR",IF(AA5<Z5,"LAY-F60",""))),""))
The key part is the IF(AA5<Z5,"LAY-F60","") element.
If the odds in column AA are less than the odds in column Z, a lay bet is placed with a Fill or Kill of 60 seconds.
The bet triggers work, but if there is a part match of the bet, T5 does not clear and the bet trigger reloaded to lay another bet for 60 seconds (at lower stakes so that a target liability is met).
It has been a while since I used BA and this is probably very simple, but can someone help me end the formula?