Betdaq Profit & Loss

The purple place, the most viable alternative to the Betfair exchange
Post Reply
ged1200
Posts: 43
Joined: Sun Oct 30, 2016 2:40 pm

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?
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

There isn't a particulary good way of doing it as they sub total each bet. So I tend to put it on a pivot table and then do further analysis from there.
ged1200
Posts: 43
Joined: Sun Oct 30, 2016 2:40 pm

Thanks Peter. Haven't encountered pivot tables before but it looks like there's plenty on the interweb to learn from. I shall make a start...
Post Reply

Return to “Betdaq exchange”