Repeat Triggers?

[AndyG]

Hi, I have set up a trigget to back a certain horse if its price is below 3.0.

It works fine but only once.

I want to back it continaully each time its price goes that low.

Is there a way to do this or does excel only do a bet once for each trigger?

Any help much appreciated as currently I close everything down and do it all again to place the next bet. Seems a bit daft although maybe it is me that is daft!

Cheers

[mikeeboy]

Presumably you would only wan to do it if it went above 3.0 after you have triggered.

You'll need to use the CLEAR trigger to clear the bet cells so that you could resubmit a new bet. This is no good on its own of course becasue otherwise you would be continually firing bets as long as the price < 3.0.

So each time you back you'll need to set a flag of some sort to indicate that a BACK bet has been made and when the price goes above 3.0 you'll need to clear the flag. You'd need to include a check on this flag in your trigger.

You're getting into VB macro stuff here though I would think.

[Mitch]

Do you want to continually back it if it remains below 3.0 or only back it again if the price goes above 3.0 then below again?

[AndyG]

Thanks guys, I just want to keep backing it to the set stake when it is below 3.
I have criteria set re total amount to bet etc.

But it is just getting it to clear the data so that another bet gets sent that I need.

Sounds like I need to use the CLEAR function but how do I do that please?

[Mitch]

I think this works but please test it for your situation without money if you can because I haven't been able to.

=IF(AND(A5<>"",F5<3,Q5="",F5<>0,O5<>0,P5<>0),"BACK",IF(AND(Q5<>"",T5=P5),"CLEAR","HOLD"))

That goes in N5, and copy down as far as you need to. If you have other criteria then you'll need to amend it or let me know and I will do it for you.

It will place a bet if all of the following are true....

Col A has a name in AND
Back odds are under 3.0 and above 0 AND
There is no bet ref in col Q AND
There are odds in col O AND
There is a stake in col P

It will enter the CLEAR trigger if....

There is a bet ref in col Q AND
The stake matched in col T is the same as the stake requested in col P

If criteria for clearing a ref or placing a bet aren't met it will display HOLD.


Obviously it can be changed to do whatever you want, but as I said before, please test it first.

[AndyG]

Thanks Mitch, you are a gent.

I will try it today and let you know how it goes.

Cheers