Time trigger when using excel

[813615]

Hi guys, new user to excel and created a bot which has been going OK, placing a bet at the SP however quite a few get cancelled due to, I assume the markets moving too quick? I'd prefer to submit the bet 30 seconds or so from the off but can't seem to get it right, initially I reset the trigger simply to 'back' but then found it was placing the bet in play when the criteria was met which i didn't want, then tried using the countdown to say when it gets to between 30-40 seconds from the off put a '1' in a cell that counts towards other trigger cells to then place the 'back' bet but although the '1' was placed in the cell as i wanted it is not being recognised when totalling up so the trigger didn't work?? i've searched but to no avail so can anyone help please?
Many thanks

[vanbuuts]

Use a spare cell to calculate the time til off (plenty of examples on the forum). Then you just need a bit of code in the trigger column using =if(and(A1<30,A1>0),”BACK”,””)

Changing A1 to the cell of your newly created time format

[813615]

Hi, many thanks for your reply, I found some code which I used in a spare cell to convert the time, then in my trigger I used a similar code but instead of saying "back" I needed it to enter a "1" in a trigger cell. I also have trigger cells for odds and number of runners then a total column so when each trigger cell has a "1" in it the bet gets triggered, for some reason the "1" in the trigger cell generated by the countdown is not getting recognised? So assuming all criteria is matched I have the time cell trigger with a "1" in it, an odds trigger cell with a "1" in it, a number of runners trigger cell with a "1" in it but the totals cell which triggers the "back" bet (sum of all 3) still shows "2" not "3"? Hope that makes sense thanks

[813615]

I think I've sorted it, the "1" wasn't getting recognised as it was inside speech brackets...many thanks