Clearing after tick offset

[pwatson04]

Hi,

im new to betting assistant and ive started using the excel functions. I have set some conditions and i bet will throw up a back with a one tick offset or a lay with a one tick offset but my problem is that i want to be able to clear the bet ref after the tick offset has been matched so that trading can continue on the same market. Does anyone know how to do this as i am lost?

Thanks in advance

Paul

[Ian]

You need to add the CLEAR trigger to your existing formula

eg =IF(S5=W5,"CLEAR",current formula)

This will work providing the amount in the stake column does change after the BET/LAY is submitted.

[Ian]

Having re-read you post I don't think that will work because you want it to CLEAR after the corresponding offset has been matched.

[pwatson04]

Yeah thanks for your help but that would clear the back before the lay offset had been submitted or vice-versa wouldn't it? Its a tricky one because i dont know how you could get excel to know the difference to when a back offset or a layoffset has been submitted and to then clear rather than when the trigger box changes to lay for example. Any ideas would be grateful

[mantas779]

I use this trigger

=ALS(Y17>0,"CLEAR",ALS(F17>=H55,"LAY-T1-F15",""))

ALS=IF ( dutch)

But it goes so fast that it starts to put in double bets!
and some bets dont get deleted!

[yantz]

no solution to this yet? here's how i do mine. i trigger with tick offset and kill delay, BACK-T1-F5. check under MyBets->Matched 5 sec later whether you have any unmatched bet for that selection. if there is, then wait for it to change to "F". if there isn't, then it should have been cancelled.

sorry if this has been solved. or if anyone else has any other ideas kindly contribute. thx

yantz

[Isabel]

Hi Guys, I'm stuck with the same issue as above mentioned. Is there any solutions? Thanx.

[negapo]

There are a number of ways of doing this that have already been proposed.

1. You could check for the profit/loss cells and see if they are the same for the selections (if you are using a level loss/gain) but this is a very week form of doing this.
Formula (In the trigger cell)
If(X5=X6;"CLEAR";Rest of Trigger Formula)
You can allow for a little variation: if(and(X5/X6<1.1;X5/X6>0.90)=TRUE;"CLEAR";Rest of Trigger Formula)

2. You can check for the matched stake in W5 or W6 and so on (depending where your trigger was set) and if this is positive check for a "P" in the end of the Bet Reference
Formula (In the trigger cell)
if(and(W5>0;right(T5;1)<>"P")=TRUE;"CLEAR";Rest of Trigger Formula)

3. You can log your bets (example: your spreadsheet is called 1; so your bets will be logged to 1_MyBets) and check for the letter U in column E. There are a number of ways of doing this, if you want i can give an example.

4. I know you can do this through the COM interface but i don't know how.

There can be other ways but I'm not remembering anything else.
I translated the formulas for the examples but I'm working with another excel language so i don't know if they are right.
Hope i could help.

[Isabel]

Thank you very much negapo. I will try what you have suggested, hopefully i will come right.

[Isabel]

Thanx negapo but I don't think what you have suggested is really what i'm looking for. I have to adjust for the offset, and secondly my bet is fully matched so when looking for a "P" will also not help and in MyBets it will show as matched. The CLEAR function has to clear the bet ref. for the next bet to be placed. Any other suggestions will be appreciated.

[negapo]

Isabel,
I have sended a P.M.