Seconds before start

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

Seconds before start

Postby sion » Thu Apr 12, 2012 10:47 am

Does any one have the excel formula that i can insert into my sheet to place bet 30 secs before start, ive looked at the one in place_bets sheet but i cant change it to 30 secs.
sion
 
Posts: 4
Joined: Wed Apr 11, 2012 3:18 pm

Postby 2020vision » Thu Apr 12, 2012 12:54 pm

Hi :)

Put the following formula to calculate the seconds until the off in cell D2.
It shows a minus figure after the scheduled off.
Then simply use an IF statement in the trigger to fire at x or less amount of
seconds before the off that you require?

Code: Select all
=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))


Hope it helps - Michael :wink:
User avatar
2020vision
Moderator
 
Posts: 604
Joined: Sun Feb 17, 2008 10:24 pm
Location: Nottingham


Return to Find an Excel developer

Who is online

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