Clearing triggered bets

[rickwakefield]

Hi guys, I'm sure this is obvious or clearly listed in the user guide, but when using trigger bets in excel how do I clear a matched bet in order for the same circumstances to trigger that bet again ie: repeat a triggered bet, do I use BACK-T3-CLEAR in trigger column. I have ticked the clear ref and clear trigger etc when setting up but once in excel the trigger works perfectly but even when all instances are matched ie trigger BACK is matched and my Lay bet is matched ref columns and stake and odds columns remain filled and wont clear.

Thank you
Rick

[GaryRussell]

"CLEAR" is not a trigger modifier, it is a trigger by itself therefore you can only use "CLEAR". It is up to the user to decide when to use the CLEAR trigger, it is not fired automatically.

You haven't exactly said, but I am guessing you want to clear the bet ref when your offset bet has been matched. When you set up the Excel link tick "Offset bet matched flag" under "Additional columns". This will output "Y" to column Y (assuming you don't have any other additional columns selected) if the offset bet has been matched. You can then use something like the following formula in the trigger column.

Code: Select all

=if(Y5="Y","CLEAR","BACK-T3")

[rickwakefield]

So simple, thanks so much...