trigger formula

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

trigger formula

Postby slochin » Sun Jan 26, 2025 4:51 am

Hello, Hoping for some help please with trigger.
I have my selections in a sheet named sel.
If my selection is the favourite and its odds are between 1-6 and 4.6 I want to place a bet.
If that happens I also want to place abet on the second favourite if there are equal to or less than 10 runners (no odds limits)
Stake would be level.
I have not been successful with the first part, and not sure where to put odds and staking amount.

=INDEX(sel!A1:A40,MATCH(MIN(F5:F30,F5:F30,0)),BACK)
slochin
 
Posts: 67
Joined: Sat Nov 28, 2015 1:20 am

Re: trigger formula

Postby Tyrobot » Tue Feb 04, 2025 1:13 pm

Sorry if I'm wrong but it sounds like you need to get the basics straight first (we've all been there).

You need an IF formula in column Q to output "BACK" (or "LAY" etc) for the selection you want to bet on. E.g. if your selection is in A5 then you want the formula in Q5 to output the trigger keyword (and not Q6 or some other row). So you'll need to work some conditions into your formulas so that the trigger shows for the selection you want, when you want.

The odds and stake go in columns R and S respectively and need to be populated for the trigger to work and you can use formulas for those too (which could be as simple as =F5 for the odds column, for example).

Things get trickier when you start placing multiple bets although once you get clear on the mechanics it's all quite intuitive and simple enough. I'm still learning but the best advice I can give is to read through the triggered betting section in the user guide and maybe watch some videos, and then fire more questions if you're not clear on anything you find there.
User avatar
Tyrobot
 
Posts: 25
Joined: Tue Jul 30, 2024 3:22 pm

Re: trigger formula

Postby Tyrobot » Wed Feb 05, 2025 6:39 pm

Hmm I'm now wondering if I jumped the gun a bit here... With the runners in say A5:10, for the first bet the formula in Q5 should basically look something like this:

=IF(AND(ISNUMBER(MATCH(A5,[your selection list],0)),F5=SMALL(F$5:F$10,1),F5>1.59,F5<4.7),"BACK","")

But the second bet will need more work - perhaps this was the main reason behind your post? My first thought would be to create a helper column to the side where you use the above logic to create a flag for each runner instead:

=IF(AND(ISNUMBER(MATCH(A5,[your selection list],0)),F5=SMALL(F$5:F$10,1),F5>1.59,F5<4.7),1,0)

With the flags in say Z5:Z10, in Q5 you can then use something like:

=IF(OR(Z5=1,AND(SUM(Z$5:Z$10)>0,F5=SMALL(F$5:F$10,2),COUNTA(A$5:A$10)<11)),"BACK","")

This is all untested and just my initial thoughts to get you unstuck. One important caveat right away is that if the odds change between refreshes such that your criteria are no longer met then this could mess things up, in which case you may need to also check the Bet ref column to make sure the logic still holds... I'm not entirely sure I've got my head around this myself so proceed with caution!
User avatar
Tyrobot
 
Posts: 25
Joined: Tue Jul 30, 2024 3:22 pm

Re: trigger formula

Postby Tyrobot » Thu Feb 06, 2025 11:59 am

COUNTA(A$5:A$10)<11 ... obviously the range will be larger in your sheet so this condition won't be redundant!

And if you have any questions feel free to ask.
User avatar
Tyrobot
 
Posts: 25
Joined: Tue Jul 30, 2024 3:22 pm


Return to Discussion

Who is online

Users browsing this forum: No registered users and 17 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.