Where do you get your commission from?
Up until now I've been entering my market P/Ls manually into an Access database. But that won't be practical if I leave automation running on hundreds of markets so I'm wondering, how do you guys calculate the commission you pay per market? I've looked at the Betfair data and it only includes profits post-commission.
- jamesedwards
- Posts: 2478
- Joined: Wed Nov 21, 2018 6:16 pm
Perhaps naively I just use a simple calculation to work my implied commission back out based on my net Betfair P&L figure. Mind you my calculated weekly commission total never quite corresponds to the Betfair value.Derek27 wrote: ↑Sun Jun 13, 2021 11:10 amUp until now I've been entering my market P/Ls manually into an Access database. But that won't be practical if I leave automation running on hundreds of markets so I'm wondering, how do you guys calculate the commission you pay per market? I've looked at the Betfair data and it only includes profits post-commission.
Calc I use is below where X is the P&L value of a single market result.
=IFERROR(ROUND(IFS(X<0,X*-0.015,X>0,X*0.01*1.02040816326531),2),0)
For actual commission paid I just use the X*1.02040816326531 to work back 2% on non-Aus winning markets.
The problem with trying to reverse engineer Betfair data is that if you win 24 pence, there's no way of knowing if you've won 24 pence, or if you've won 25 pence and paid a penny commission.jamesedwards wrote: ↑Sun Jun 13, 2021 9:03 pmPerhaps naively I just use a simple calculation to work my implied commission back out based on my net Betfair P&L figure. Mind you my calculated weekly commission total never quite corresponds to the Betfair value.Derek27 wrote: ↑Sun Jun 13, 2021 11:10 amUp until now I've been entering my market P/Ls manually into an Access database. But that won't be practical if I leave automation running on hundreds of markets so I'm wondering, how do you guys calculate the commission you pay per market? I've looked at the Betfair data and it only includes profits post-commission.
Calc I use is below where X is the P&L value of a single market result.
=IFERROR(ROUND(IFS(X<0,X*-0.015,X>0,X*0.01*1.02040816326531),2),0)
For actual commission paid I just use the X*1.02040816326531 to work back 2% on non-Aus winning markets.
I suppose this should be on the rant thread, but there's a lot of crap information on the downloadable Betfair data that nobody's likely to want, but crucial information like commission paid for a market is left out! What's even more annoying is that they have a field containing information like, Football / SE Palmeiras v Corinthians / Over/Under 3.5 Goals
Football, or the name of the sport should be in a separate field, so should the event name and market type. Even if you write code to separate the text between the "/" , "Over/Under" throws a spanner in the works.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
I log my own gross then cross ref with the BF pl download (net) on sport/time. But I only do it because there's usually one or two that were void races or selections withdrawn late and I've logged a gross for bets that were void. Otherwise I just assume an avg if I'm backtesting. I guess it wouldn't be too hard to create a lookup for the various aus base rates and then apply your discount rate.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
You could replace "over/under" with "over~under" before it goes through the parse? It's easier to prevent bad data going in to a system than it is to deal with it once it's in there.
What if there's a new sport or football team called over or under?ShaunWhite wrote: ↑Sun Jun 13, 2021 11:33 pmYou could replace "over/under" with "over~under" before it goes through the parse? It's easier to prevent bad data going in to a system than it is to deal with it once it's in there.
It's quite frustrating that Betfair compile and provide so much data and still skip the essentials. You can probably guess what film clip you've reminded me of.
https://www.youtube.com/watch?v=NfDUkR3DOFw&t=40s
- jamesedwards
- Posts: 2478
- Joined: Wed Nov 21, 2018 6:16 pm
They really make work for you!! No separator between market and selection and they throw in the saddlecloth number in front of the horse's name! It's crazy we need to write code just to detect what sport we're trading. A simple "soccer" or "racing" wouldn't go amiss.ShaunWhite wrote: ↑Sun Jun 13, 2021 11:33 pmYou could replace "over/under" with "over~under" before it goes through the parse? It's easier to prevent bad data going in to a system than it is to deal with it once it's in there.
You do not have the required permissions to view the files attached to this post.