Number of horses in a race

Please post any questions regarding the program here.

Moderator: 2020vision

Number of horses in a race

Postby christine » Mon May 31, 2010 9:55 pm

Hi all, I'd like to alter a formula to only place a bet if there are at least 5 horses in the race. I currently use this formula, which relates to laying the 2nd favourite at a certain number of seconds before the off, but don't know how to amend it or even if it can be amended:

=IF(AND($T$1>88,$T$1<91,AA5=2,H5<6.1,$F$2="",COUNT(T$5:T$55)=0,$E$2="Not in Play"),$T$3,"")

Many thanks in anticipation,
Christine
christine
 
Posts: 33
Joined: Sat May 08, 2010 6:18 pm

Postby Kentucky » Tue Jun 01, 2010 7:28 am

Hi Christine
Just add to the formula

=IF(AND(COUNTA(A$5:A$34)>5,$T$1>88,$T$1<91,AA5=2,H5<6.1,$F$2="",COUNT(T$5:T$55)=0,$E$2="Not in Play"),$T$3,"")

Kentucky
Kentucky
 
Posts: 22
Joined: Tue Aug 04, 2009 8:01 am

Postby doris_day » Tue Jun 01, 2010 8:34 am

Just a small amendment as Christine wanted the lay to be triggered if there were at least 5 runners.

COUNTA(A$5:A$34)>5 should read COUNTA(A$5:A$34)>=5
'He was looking for the card so high and wild he'd never need to deal another' - Leonard Cohen
User avatar
doris_day
 
Posts: 968
Joined: Fri Nov 02, 2007 12:34 am

Postby christine » Fri Jun 04, 2010 4:07 pm

Many thanks for the advice!
christine
 
Posts: 33
Joined: Sat May 08, 2010 6:18 pm


Return to Help

Who is online

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