Bet Trigger Time

[Observer]

Can you make bets trigger at a specific time pre-off via a spreadsheet? I've seen lots of old posts where people are asking but all have no answers. I basically want to say if the countdown is for example less than 2 then "back". Tried everything but it triggers regardless of time

[jamesedwards]

Can you make bets trigger at a specific time pre-off via a spreadsheet? I've seen lots of old posts where people are asking but all have no answers. I basically want to say if the countdown is for example less than 2 then "back". Tried everything but it triggers regardless of time

You can put formulas in the green command cells. Therefore you can use rules such as 'if' statements to only trigger bets when conditions in other cells are reached.

[Lewis_c]

There's a timer in F5 that gives the time until the off in seconds. I've put a second formula in G5 that just subtracts 10 seconds so you can use either or both.



=IF(F5<=85,"BACK","")

=IF(AND(F5<=85,G5>=75),"BACK","")

Note: Won't work if the event timer includes days and will keep on counting even when in play. As mentioned above, just put the formula in with your Back/Lay command.

My Selection.xlsx

[shakey1964]

If you have excel 365 you can use the CONVERT function to convert the countdown timer from hh:MM:SS to seconds
in a new cell type =CONVERT(F4,"day","sec") then you can use the if function in the individual commands cell as follows =IF(C4=6,IF(K4<=12,"LAY",""))

this translates to if there are 6 runners and the timer reaches 12 seconds place a lay bet where K4 is the converted cell and C4 is the number of runners