Bet trigger not working after partial bet match

Please post any questions regarding the program here.

Moderator: 2020vision

Bet trigger not working after partial bet match

Postby 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?
scarlett3
 
Posts: 31
Joined: Sat Jan 16, 2010 1:53 am

Re: Bet trigger not working after partial bet match

Postby alrodopial » Wed Oct 08, 2025 8:45 pm

It's not clear in your description, do you want an extra bet or not?
Your current formula will clear cell T5 if
1. race is in play
or
2. all the uncommon bet/acount status you have in your formula (included if the bet is cancelled)
alrodopial
 
Posts: 1389
Joined: Wed Dec 06, 2006 9:59 pm

Re: Bet trigger not working after partial bet match

Postby scarlett3 » Wed Oct 08, 2025 11:14 pm

Sorry, for not being clear.

I want to bet to a liability of £50. If a bet is matched for less than £50, the unmatched part of the bet is cancelled via the Fill or Kill switch. However, the new bet (to bring the liability up to £50) is not triggered as the bet reference cell is not cleared if the original bet is partly matched.
scarlett3
 
Posts: 31
Joined: Sat Jan 16, 2010 1:53 am


Return to Help

Who is online

Users browsing this forum: No registered users and 41 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.