Excel Problem

[horsesystemagic]

Hi All

I have a problem where I have set up to back or lay a selection 10 seconds before race off and the bet get taken. The problem is that my formula carry on analsying the race untill suspended and if market changes will add another bet. How can I write my formula to stop after a bet has been placed and not add any further bets and move on to the next race.


Thanks in Advance Shaune

[JIFFIJAW]

Hi I have a master cell on my Excel sheet that shows 1 for bet conditions and 0 for no bet conditions. You can then write any number of "if" calculations that turn that master cell on or off. So a no bet could be that if(now) = race time plus ten seconds then it could switch off or perhaps more simply for you if cell e2 = "In Play" then make it a no bet condition. Personally I'd probably belt and braces it and have multiple ways of switching off -- the two above and probably one of the relevant T or F cells that showed that if a bet had been matched then no further bets would be placed (even before it went in play -- unless you would like to place multiple bets). You then make your trigger reference the master cell and bingo it will not place bets if any "no bet" condition exists. Hope that makes sense.