Timed Trigger?

[vilnius]

Hi All

A simple question to which I hope there is a simple answer, could anyone please enlighten me on how to place a triggered bet at a pre defined time using excel?

Cheers

Al

[thunderfoot]

You can always use the cells C2 or D2 and then use IF statement in the Trigger Column (Q).

[vilnius]

Thanks Thunder, If, say I wanted to back a horse ten minutes before the off in the 1400 at Beverley at say odds of 4.0 with a £2 stake and leave it in play I can do all this except the timing, how do i incorporate the timing into the trigger with an IF? would it be somnething like IF-C2>13:50:00-BACK-IP and would I just put my required odds in the R column?

All I really need is a Conditional bet that can go IP

Cheers

Al

[GaryRussell]

Put the following formula in cell Z1.

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

It calculates the number of seconds until the start.

You can then use something like =if(z1<=600,"BACK","")

[vilnius]

Not as simple as I thought it might be then!

Thanks for the replies anyway

Al