Commision on back testing

News, chat and debate about the Betfair betting exchange.
Post Reply
Luke.B
Posts: 100
Joined: Wed Dec 25, 2019 1:28 pm
Location: Australia

I have weekly results going back a couple of years.
i for the life of me cant work out commission that i would pay over those years.
Without going and breaking results down into event is there a way to workout rough commission on a weekly basis.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Luke.B wrote:
Thu Dec 16, 2021 11:56 am
I have weekly results going back a couple of years.
i for the life of me cant work out commission that i would pay over those years.
Without going and breaking results down into event is there a way to workout rough commission on a weekly basis.
Not from weekly profits. Commission is based on winning markets only and not your overall P/L, so a trader that wins/loses £600/£100 will pay far less comms than a trader that does £2000/£1500.
Luke.B
Posts: 100
Joined: Wed Dec 25, 2019 1:28 pm
Location: Australia

Yeah thanks. Was after a bit more of a generic formula some of you old pros use.
Im getting pretty close with.
Ratio of winning to losing weeks. Assuming that is the same for markets.
Transferring that to returns and multiplying comms.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Luke.B wrote:
Thu Dec 16, 2021 11:38 pm
Yeah thanks. Was after a bit more of a generic formula some of you old pros use.
Im getting pretty close with.
Ratio of winning to losing weeks. Assuming that is the same for markets.
Transferring that to returns and multiplying comms.
If you want an average rate it would be: Commission / (Profits - Losses). But I doubt it would be very accurate as everybody's profits,losses and commission varies substantially week to week.
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

Luke.B wrote:
Thu Dec 16, 2021 11:56 am
I have weekly results going back a couple of years.
i for the life of me cant work out commission that i would pay over those years.
Without going and breaking results down into event is there a way to workout rough commission on a weekly basis.
If you do a pivot-table for results by event it is easy
Post Reply

Return to “Betfair exchange”