How to use the CLEAR reference

[easternpromise]

Hi all,

How do I use the CLEAR ref so I can place multiple bets.

does it add into my betting trigger or do I just add it into column T ?

Thanks

[GaryRussell]

It goes in column Q like BACK and LAY triggers. All it does is clear columns T to W unless you don't have "CLEAR trigger clears matched odds" ticked when you link to Excel in which case it only clears columns T and U. Because it clears column T this allows another bet to be triggered by BACK or LAY.

[easternpromise]

Gary

Just to check i am using this correctly in a formula.

Taking your trigger from the Back 3 Fav Sheet

Q5=IF(AND(AA5=3,$S$1<=10,$T$1=0,$F$2<>"Suspended"),"BACK","")

would i use the CLEAR trigger like this ?

=IF(t5>0,"CLEAR",AND(AA5=3,$S$1<=10,$T$1=0,$F$2<>"Suspended"),"BACK",""))

Thanks

[GaryRussell]

That's right. Your trigger will insert CLEAR if there is a bet ref. Once it is cleared then it's effectively the same as the trigger from the example.

It's best to try it and see what happens, but I would only use small stakes. Your example will just keep placing bets continuously. I presume you are aware of this.

[easternpromise]

Thanks Gary

betting continuously if my next problem to over come.

If i want to bet every say 5secs is there a way to use the timer in S1 of the Back 3 Fav Sheet ?

Can you help?

[GaryRussell]

A quick and dirty way would be to only bet when s1 equally divides by 5. =MOD(S1,5) will return 0 when it divides equally so the formula could read as follows.

Code: Select all

=IF(t5>0,"CLEAR",AND(AA5=3,$S$1<=10,MOD($S$1,5)=0,$T$1=0,$F$2<>"Suspended"),"BACK",""))

[easternpromise]

Thanks Gary

I'll give it a go