Back and Lay Within Excel

[DefTouch85]

How do I execute concurrent back and lay orders in Excel? E.g. I want to lay at 1.8, and when any amount is matched, I want to back at say 1.85.

Thanks.

[Mug]

This is just a back bet with an offset isn't it?

[MarketTrader]

I would use the following:

LAY OFFSET:1 FILL_KILL:TRUE KILL_DELAY:5

This will wait 5 seconds to get the entire order filled. Then kill any unmatched portion of the bet before placing the offset bet.

If the bet is matched before 5 seconds then obviously it will not wait before placing the offset.

It won't offset bits as it goes along though. It will wait 5 seconds to get the entire order filled if necessary before placing the offset.

[DefTouch85]

Thanks for the replies.

I am not actually trying to offset by a certain number of ticks. I want the offset odds (i.e. back odds) to be determined by an Excel formula.

E.g. say that I determine the "correct" odds are even money. If I lay at 1.85, I'm happy to back at 2. But if I lay at 1.98, I want to back at 2.02. I have a formula in mind for determining my margins.

Is this possible?

[nigelk]

It would be possible but you would have to be clearer as to what result your formula would return.

You say that you don't want to offset by xx ticks, so I would imagine it's not returning a whole number.

It could be returning a valid % figure, (i,e 2.00= 50%),in which case you would simply match the % figure against the tick value.

If it's returning an approx % figure ( 50.19%), then you would need to specify what nearest value to look for, either 50.25% or 50%, depending on whether you are backing or laying at the time.

Nigel.

[DefTouch85]

Say I want to use this formula for my offset odds:

=max(2,LaidOdds*1.05)

If this returns a non-whole number, then I would want to round up (e.g. if the number was 2.031313, I would want to back at 2.04).

Cheers

[nigelk]

This should be ok:

=SMALL(Sheet5!$A$2:$A$271,COUNTIF(Sheet5!$A$2:$A$271,"<"&$B$2)+1)

If you look at the attached, on sheet5 you'll see a list of all prices from 200 down to 1.01

If you want to add the rest (200 to 1,000), you'll need to adjust the formula to accomodate the new range ( $A$2:$A$300 ) or whatever, and of course, the
$B$2 ref to whatever cell your formula result is in

Hope this helps.
Nigel

Book1.xls

[DefTouch85]

Thanks Nigel.