Hi. I've been trading with Betdaq and have downloaded their 'Market P & L Settled' spreadsheet but it contains all the backs and lays which somehow inflates the totals. Eg the Bet P&L (column G) gives a correct autosum total before commission of £1.63, but the Market P&L (column H) gives an autosum total of £4.95 and the Net P&L (column I) £4.46. There is no total net of commission, in this case £1.55. That figure is given on the web page but not the spreadsheet. As £1.63 x 2% = 0.0326 I presume the net figure will vary, presumably due to round-ups?
Is there any short cut or work around to make Betdaq's P&L Statement resemble Betfair's?