Small Fixed Stop Loss

[gizzard]

I'm trying to set up a Stop Loss that is triggered when there is just a 1 tick movement against my bet.
For example, Lay at 5, Stop Loss should be 4.9.

I have tried a couple of methods using Excel Triggers without much luck, the Stop Loss price is more often than not lower than 4.9, in this example.

First I tried: LAY-SL1
(there were other modifiers too but I haven't included them).
My understanding of this is that the Stop Loss would be triggered at 4.9, in the example above, but the odds used would be one tick lower ie 4.8. The match was often then at 4.8 as the market was moving quickly.

I then tried: LAY-SLF4.9
to try and force 4.9 as the odds to be used but, again, most bets were taken at 4.8.

What method can I use, if any, to try and get the Stop Loss set at the desired odds?

Is this just impossible if the market is moving quickly as any odds <= 4.9 will be taken?

Is the only alternative to not use th -SL trigger but place an offset Back bet using VBA?

Thanks

[GaryRussell]

None of the stop loss functions actually specify the odds the stop loss bet will be placed at, they all specify the odds it will be triggered at.

LAY-SL1: If the matched odds are 5.0 then the stop loss will be triggered if the best lay odds are 4.9 or less. The back bet will actually be placed at the best lay odds minus 1 tick which explains why it is placed at 4.8. It does this to give a better chance of being matched. If it placed it at 4.9 then you would be joining the queue of backers at 4.9.

Basically there isn't a function to do exactly what you want so VBA or possibly a more complex trigger formula is your only option.