by aelara » Fri May 11, 2007 5:15 pm
Hope the message titles not too confusing!
Basically my question is this: thanks to a few guys on the forum, I can trigger bet certain horses after a race goes in play with the following formula for excel =IF(AND(E$2="IN PLAY",F$2<>"SUSPENDED"),"LAY","WAIT") What I need to do now is that when the race is over, I want to add something to this formula to stop excel logging the prices. What I'm saying is I want to be able to come in an hour or two later and see if any of my prices were matched in running. The way things stand at the moment, once betfair settles the market, excel starts to log zeroes, hence loosing all the data except the last matched prices.
If this makes sense to anybody, is there anything I can add to this formula?
Tony
You never know what is enough, until you know what is more than enough - William Blake