time delay between bets

[soccergeez]

Is there a way to put a time delay between bets using the triggered betting in Excel?

Basically when all my criteria are met a bet is fired in and then the reference instantly cleared - however this often results in another 3/4 bets being fired if all the criteria are still current, if there is a way to add in a time delay between bets this would obviously stop happening - or is there another way around the problem?

Many thanks in advance if you can help.

[Castillo]

Is there a way to put a time delay between bets using the triggered betting in Excel?

Basically when all my criteria are met a bet is fired in and then the reference instantly cleared - however this often results in another 3/4 bets being fired if all the criteria are still current, if there is a way to add in a time delay between bets this would obviously stop happening - or is there another way around the problem?

Many thanks in advance if you can help.

Hi soccergeez

I usually get around this by putting a time delay on clearing the bet, example below :-

IF(AND(T5>0,U5>0,V5>1.01,(U5+"00:00:15")<C2),"CLEAR"

Basically there must be a value in T5,U5 and odds matched in V5 then the bet will clear 15 secs after the time stamp in U5 (Bet time).
I'm not sure if this helps you but it's one way around the problem.

If you want to clear the bet only after the full stake is matched, try the following for a stake of £10

IF(AND(T5>0,U5>0,V5>1.01,W5=10,(U5+"00:00:15")<C2),"CLEAR"

Cheers
Castillo

[soccergeez]

Thank you for your reply Castillo, I now have the following formula but it keeps saying there is an error in the formula, any ideas??

=IF(AND(T5>0,U5>0,V5>1.01,(U5+"00:02:00)<C2),"CLEAR",IF(T$16>5,"LAY","PENDING"))

I previously had this formula which worked fine but obviously didnt have the time delay included as I didnt know how to do it!!

=IF(T5>0,"CLEAR",IF(T$16>5,"LAY","PENDING"))

Can you see what I have done wrong at all?

[Captain Sensible]

In the example you posted you're missing the " on the time - should read as

=IF(AND(T5>0,U5>0,V5>1.01,(U5+"00:02:00")<C2),"CLEAR",IF(T$16>5,"LAY","PENDING"))

[soccergeez]

d'oh, so simple - thanks Captain.

[soccergeez]

I am interested in seeing how much money is in the market and if there is more backing or laying certain selections at various times during the day, would it be possible to record this information in Excel using a similar formula to the one above?