How to trigger bet 1 minuts before the off

[flanna]

My first attempt at using BA with Excel. I want the bet to be placed in the market at a set time before the off. i.e. 1 min or 20 seconds. How can I do this?

[GaryRussell]

You could use the following formula to create a cell containing the number of seconds until start.

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,"-",""))))

You can then refer to this in your trigger formula. For example if you put the above formula in cell Z1 you can use the following formula to trigger a back bet at 1 minute before the start.

Code: Select all

=if(Z1<=60,"BACK","")

[flanna]

Thanks Gary. That does the trick!