Excel triggered spreadsheet needed

[meldge]

Hi

I'm looking to automate backs and lays as follows:

If a selection is say below 1.5 or comes through 1.5 from above back 1.5, have a stop to fire on what was matched at 1.5 when it gets to 2.0 and then keep doing this so back again at 1.5 lay again at 2.0 with the option to increase the stakes each time a new 1.5 is placed.

Also for example lay at 10.0 when last price matched more than 10.0 and then back at 5.0 when LPM 5.0 or less and lay at 10.0 again etc etc or indeed starting with a back at 5.0 then a lay at 10 and a back at 5.0 again then a lay at 10.0 etc. The triggers are the LPM.

I also just might start with a back at the start at say 2.5 and lay at 5.0s back at 2.5's lay again at 5.0 etc so the first price has no trigger and is set my me. I am using this for tennis and cricket.

Any help would be appreciated.

Thanks

Alastair