Correct ime before off Trigger.

[siony1974]

My excel sheet is looking for the Fav in the place market so it tracks the Fav using a RANK function. Seems to work okay and the text "BACK" appears in a column on the sheet next to the horse with the lowest price and therefore rank . Formulas on the sheet sort out the stake etc.

How do I set it so say 10 seconds before the official off it triggers a back bet on whichever horse is ranked 1 at that point. I can see the clock in the top left corner, I'm a little unsure how to to make use of it to trigger the bet. Once it hits the 10 second mark I want it to make use of the clock and set the sheet so at that point is copies the "BACK" text into the trigger column and puts the bet on.

Any and all help would be much appreciated.

P.S Any way to make specific races go into specific worksheets not just All UK Win Markets or all UK PLace Markets going to one sheet.

[osknows]

The following Excel formula can be used to provide a countdown to the official off in seconds

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 use something similar to

Code: Select all

=if(AND(cond1=true, cond2=true,cond3=true),"BACK","")

cond1 checks no existing bets have been placed
cond2 checks time to off <=10
cond3+ is anything else you want to include

[siony1974]

Many thanks Osknows, that is exactly what I was looking for.