LAY @ 3Ticks Below Current Last Matched.

[Happy Harry]

What I want to do is allow the Market to open at the default 1 minute, then put a Lay in the market @ 3 Ticks below the last matched and also keep it as an SP bet if it is not matched.

So, if the market tightens and then goes out I get the Lay in at the better price than SP.

Currently the Lay bets that I am doing are simply SP lay bets using

$40.00 LAY-SP 1.1 2

If possible I don't want to alter the formulae in columns AA through AI of the default spreadsheet too much as I am also placing simultaneous BACK bets @ SP.

Thanks

HH

[GaryRussell]

I created some VBA code to add or subtract ticks. See http://gruss-software.co.uk/forum/viewt ... =plusticks

[Happy Harry]

Many thanks for that.

All very interesting and doesn't totally complete what I need to do however this is a learning journey. I had no idea that Excel was capable of doing things that easily.

HH

[Captain Sensible]

Many thanks for that.

All very interesting and doesn't totally complete what I need to do however this is a learning journey. I had no idea that Excel was capable of doing things that easily.

HH

Should be able to do what you asked for

What I want to do is allow the Market to open at the default 1 minute,

Monitor the time to the off in D2 or auto select markets 1 min before the off

then put a Lay in the market @ 3 Ticks below the last matched

minusTicks(O5,3) in your triggered odds column will give you 3 ticks below the last matched price in O5

and also keep it as an SP bet if it is not matched.

LAY-SP in the trigger cell will ensure it's a keep bet