help - clear bets in play

[mikefoxnaps]

I'm trying to set up a spreadsheet to submit lays on all horses under 2.0 when race turns in play and then if only one horse reaches say 1.2 to back this horse. My sheet works to a degree but it falls down around the clear trigger.
Does anyone use the clear trigger on a sheet inplay? My sheet does the clear and then backs ok, but, I realy want it to only lay once and then only back once on the winner (if its the only horse under 2 which then get to under 1.2ish) As I said it does sort of work but its very messy.
Any Ideas??

[mikefoxnaps]

Have i upset everyone?

[Ian]

I've kind of answered this recently on another thread. Use one sheet for the lays and another for the backs using the same market in two tabs on BA.