Where do you get your commission from?

News, chat and debate about the Betfair betting exchange.
Post Reply
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Betfair calculate commission differently if you are on PC, so it's a murky area.
User avatar
jamesedwards
Posts: 2234
Joined: Wed Nov 21, 2018 6:16 pm

Euler wrote:
Mon Jun 14, 2021 4:44 pm
Betfair calculate commission differently if you are on PC, so it's a murky area.
What.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Euler wrote:
Mon Jun 14, 2021 4:44 pm
Betfair calculate commission differently if you are on PC, so it's a murky area.
I was just referring to commission paid rather than generated, for accounting purposes. It would be nice if they included commission paid in one of the PL CSV downloads.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

ShaunWhite wrote:
Sun Jun 13, 2021 11:33 pm
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.
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. :x
Capture.GIF
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

FFS!! They've got it on the bet history CSV but now the settled dates missing. :lol:

So you've got to read 2 files and connect the bet ID!
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

...after stripping the "1:" of one of the bet IDs. What's the flipping point of the 1:? :lol:
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

I've given up the idea of automating my accounts, the data is so inconsistent. Racing has the event location where other sports have the sport name, and the distance/type for the race where other sports have the market name. Thanks a flipping lot Betfair. :x :x
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Just drop @BetfairCS a note, I'm sure they would sort all these problems in a jiffy! ;)
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

Derek27 wrote:
Mon Jun 14, 2021 2:59 pm
Anbell wrote:
Mon Jun 14, 2021 5:35 am
You can cross reference BF P&L with BF Betting Activity / Betting History / Settled
Thanks, but that just shows individual transactions, not market profits or commission.
You can then aggregate the Settled data by race to match that P&L
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

jamesedwards wrote:
Mon Jun 14, 2021 6:58 pm
Euler wrote:
Mon Jun 14, 2021 4:44 pm
Betfair calculate commission differently if you are on PC, so it's a murky area.
What.PNG
They use implied commission. So even if you pay commission at a base rate of 10% on an Aussie market, they will re-calculate it so it's only like you paid commission at 3%.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Anbell wrote:
Fri Jun 18, 2021 2:50 am
Derek27 wrote:
Mon Jun 14, 2021 2:59 pm
Anbell wrote:
Mon Jun 14, 2021 5:35 am
You can cross reference BF P&L with BF Betting Activity / Betting History / Settled
Thanks, but that just shows individual transactions, not market profits or commission.
You can then aggregate the Settled data by race to match that P&L
I trade several sports and they concatenate event and selection into one field with just a space separating them. Given that some football teams names consist of two words it feels a bit error-prone. On top of that, it doesn't have all the data I need and what data it has is quite mindlessly split over two files, so I think for now I'll continue to do it manually. It would be so easy for Betfair to just chuck a comma in the file: start/settled date, event, market type, selection, etc.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Derek27 wrote:
Fri Jun 18, 2021 11:55 am
I trade several sports and they concatenate event and selection into one field with just a space separating them.
Isn't it easier to reconcile the various files on marketId and selectionId?
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

ShaunWhite wrote:
Fri Jun 18, 2021 2:22 pm
Derek27 wrote:
Fri Jun 18, 2021 11:55 am
I trade several sports and they concatenate event and selection into one field with just a space separating them.
Isn't it easier to reconcile the various files on marketId and selectionId?
I could do that, but I like to query my data on meetings, leagues, competitions, etc. So I'd still need to enter markets manually.
User avatar
jamesedwards
Posts: 2234
Joined: Wed Nov 21, 2018 6:16 pm

Euler wrote:
Mon Jun 14, 2021 4:44 pm

They use implied commission. So even if you pay commission at a base rate of 10% on an Aussie market, they will re-calculate it so it's only like you paid commission at 3%.
I was aware they used a 3% assumption for all losing markets (an implied comm therefore of 1.5% on all losses).

I thought implied comm on winning markets was always half of actual commission paid? eg 1% on most markets but significantly more on aussie markets. Is this not correct?
Post Reply

Return to “Betfair exchange”