Trigger + ?

[mak]

I set a trigger like this
if(t5>0,"CLEAR",if.....,"BACK-TL1-F10-SL1-L"

I want to clear the betref (t5) only if my position is closed (win or lose)

Any ideas how?

[mak]

I found this in BA Help
Added extra data column to Excel. "Offset bet matched" = Y if tick offset bet fully matched or = N if not matched.

So when that cell turns to Y, it is a flag that my offset bet matched.

What happens next?
If I reformat my formula into =if(and(T5>0,Y5="Y"),"CLEAR",if.....,"BACK-TL1-F10-SL1-L"

Someone please?

[Castillo]

I set a trigger like this
if(t5>0,"CLEAR",if.....,"BACK-TL1-F10-SL1-L"
I want to clear the betref (t5) only if my position is closed (win or lose)
Any ideas how?

Hi Mak

One way I CLEAR my bet in Excel is monitoring the Matched Stake in Column W.

So If my stake is £5, I do not clear the Bet Ref until W5=5
So in your case the formula would be using a £5 stake
IF(T5>0,W5=5,"CLEAR",IF.....,"BACK-TL1-F10-SL1-L"
So if the bet was only partially matched for £3.44 the "CLEAR" function would not fire because W5=3.44

I presume by clearing the Bet Ref it would trigger again if all the criteria in the formula are met.

Cheers
Castillo

[mak]

Thanks Castillo it is now working.

Can you or someone else advise (it is the last thing i hope) how can I add a CANCEL trigger in my formula..?

for example I want to Cancel my bet if col G5 is less than 100

I don't know which is the right order for the trigger

IF(T5>0,W5=5,"CLEAR",if(g5<=100,"CANCEL)",IF.....,"BACK-TL1-F10-SL1-L"

Is the above right?

[Castillo]

Thanks Castillo it is now working.
Can you or someone else advise (it is the last thing i hope) how can I add a CANCEL trigger in my formula..?
for example I want to Cancel my bet if col G5 is less than 100
I don't know which is the right order for the trigger
IF(T5>0,W5=5,"CLEAR",if(g5<=100,"CANCEL)",IF.....,"BACK-TL1-F10-SL1-L"
Is the above right?

With G5<=100,"CANCEL" it would still cancel the bet if it was partially matched, if you don't want this to happen you could add W5=0

So you would have G5<=100,W5=0,"CANCEL"

[mak]

Thanks again
I am fine now