Using Excel formulae (rather than VBA, at which I am useless), I have developed my Results worksheet so that I get a running analysis of my gross/net profit and loss for the day's racing, where I may have several bets on any given race. Obtaining the overall gross profit is easy - simply sum Column D in your Results worksheet. Breaking that down by race and adding the commission costs has proven to be a little trickier but I now have it working just fine
If anyone is interested in the formulas to achieve this outcome I'd be happy to provide them. There may be a simpler way than my method but I haven't yet discovered it.
