Stop on opening bet

[Trickle]

Hi all

I'm trying to get this to work on the spreadsheet. I get the command cell in Column L to enter "Back Stop:3" or "Lay Stop:3", but if the price drifts away from what I've asked for (back at the lay price or lay at the back price) the stop doesn't kick in.

Any help is very gratefully received.

Trickle

[Polyphemus]

The stop instruction in Excel will only work if used in conjunction with the offset instruction.

You would need to write some code to replicate what you are after.

[Trickle]

Many thanks, Polyphemus. I'll have to try to think of a way round it.

Regards

Trickle