Excel Help

[Mattmid]

Don't know if anyone could help with this at all.


What I want to do is when a market that I want to lay on goes in play is to put in 4 automated lays/stakes straight away. I can get the markets listed and get them to come up in play via BA I just need to work out the formulas to lay the prices.

I want to use just one excel sheet for this. I've been playing around with it but I'm having problems clearing the bets to lay again.


For example, I want to put say 4 lays in on a team/player/horse - whatever. Let's say 1.20 for £5, 1.10 for £10, 1.05 for £20 and 1.01 for £100. I want them to go in once the market is in play. They don't have to be matched for the next lay to go in. I can't seem to get the right formula to clear each lay once pended so as the next lay can get triggered. I