SP rank

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

Moderator: 2020vision

SP rank

Postby davidsteel1964 » Sun Oct 31, 2021 6:25 pm

HI, Hope someone can point me in the right direction.

My system involves the selection being in the top 4 SP rank, does anyone know if i can use my Gruss software to perform this request.

Many thanks

David
davidsteel1964
 
Posts: 3
Joined: Sun Oct 31, 2021 6:22 pm

Re: SP rank

Postby vanbuuts » Mon Nov 01, 2021 2:48 pm

If you have gruss connected to excel you can use the rank formula to a column and then trigger your bets accordingly. Bear in mind the rank will change pre race as odds move so the “actual” BFSP rank will not be known until the race has started. Without knowing what you’re looking to do it’s hard to say if this will or won’t be an issue for you
vanbuuts
 
Posts: 321
Joined: Thu Oct 16, 2014 8:55 pm

Re: SP rank

Postby davidsteel1964 » Tue Nov 02, 2021 4:15 pm

Many thanks.

My selection has to be in the top 4 in the betting, so i can by using excel trigger a bet say 5 seconds before the off to hopefully achieve this?

Thanks
davidsteel1964
 
Posts: 3
Joined: Sun Oct 31, 2021 6:22 pm

Re: SP rank

Postby vanbuuts » Tue Nov 02, 2021 9:44 pm

How are you going to know when it’s 5 seconds before the off??
vanbuuts
 
Posts: 321
Joined: Thu Oct 16, 2014 8:55 pm

Re: SP rank

Postby brumbie » Wed Nov 03, 2021 12:43 am

For the sake of argument, if we use column Z then:
In Z5 =IFERROR(RANK($Y5,$Y$5:$Y$35,1)," ")
run that down to Z35 then:
In Z1 =IF(LEFT($D$2)<>"-",(HOUR($D$2)*3600)+(MINUTE($D$2)*60)+SECOND($D$2),-((HOUR(SUBSTITUTE($D$2,"-",""))*3600)+(MINUTE(SUBSTITUTE($D$2,"-",""))*60)+SECOND(SUBSTITUTE($D$2,"-",""))))
Z1 will count down the time for scheduled off

You can then refer to Z1 and corresponding rows in the Z column in your formula
brumbie
 
Posts: 197
Joined: Tue Dec 28, 2010 2:00 am
Location: Brisbane,Australia

Re: SP rank

Postby vanbuuts » Wed Nov 03, 2021 12:28 pm

But that will only give you the rankings “x” seconds before post time. Odds and indeed ranking order can and does change between scheduled off snd actual off
vanbuuts
 
Posts: 321
Joined: Thu Oct 16, 2014 8:55 pm

Re: SP rank

Postby davidsteel1964 » Tue Dec 07, 2021 9:20 pm

Many tthanks
davidsteel1964
 
Posts: 3
Joined: Sun Oct 31, 2021 6:22 pm


Return to Discussion

Who is online

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

cron