Trigger modifiers

[johnnic]

Would someone be so kind as to check the following Excel code to ensure it does what I want it to do?

BACK-IP-PL10-SL7P-L

(1) I want the bet to remain in place when the market goes in play.
(2) If the back bet is achieved at the odds I have set, I want an offsetting lay bet to be placed at 10% higher than the original bet and the bets to be 'greened up'.
(3) If the bet goes against me, I want to be stopped out at 7% above the original bet price and the bets to be evenly red.

As an example, if I make a back bet at $1.45, I want an offsetting lay bet to be made if the market hits $1.32 and to be stopped out if the price hits $1.55. To further the example, if my inital bet was $100, the offsetting lay bet would be $88.34 at $1.32 (with a green book of $11.66) and my stop loss would be $111.31 at $1.55 (with a red book of -$11.31)

Does this seem right?

John

[johnnic]

Having studied the manual more closely, I realise that the order of the modifiers in my previous example are not correct. How about:

BACK-PL10-SL7P-L-IP

Thanks

John

[GaryRussell]

The trigger should be BACK-PL10-SL7P-L-IP

I can see that you expect the percentage to be calculated in a certain way. You need to tick "Calculate tick % on decimal odds" in general preferences.

The lay bet will actually be placed at 1.30. 1.45 minus 10% is 1.305 and it is rounded down to 1.30.

If the back bet is achieved at the odds I have set, I want an offsetting lay bet to be placed at 10% higher than the original bet and the bets to be 'greened up'.

Don't you mean 10% lower? You can't green up laying at higher odds. The stake would be £111.54 if placed at 1.30 with a green book of £11.54

The stop loss stake would be £93.54 with a red book of -£6.46

[johnnic]

Thanks Gary, much appreciated.

[johnnic]

One further question, if I may?

Is it possible to have the n (number of ticks) variable determined by another cell? Something like BACK-PL[cell reference].

John

[mak]

if the cell reference is A1 try the formula
="BACK-PL"&A1

[johnnic]

Thanks, when combined with CONCATENATE to include other modifiers, it works a treat.

John

[johnnic]

To my absolute frustration, I have just realised that adopting any betting strategy that involves offsetting or applying a stop loss to an event once it is in play will not work in Australia! Online, in play betting is not allowed in Oz.

Very, very annoying.

John