Where do you get your commission from?
- jamesedwards
- Posts: 2234
- 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.
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.
You can then aggregate the Settled data by race to match that P&L
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 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.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
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.ShaunWhite wrote: ↑Fri Jun 18, 2021 2:22 pmIsn't it easier to reconcile the various files on marketId and selectionId?
- jamesedwards
- Posts: 2234
- Joined: Wed Nov 21, 2018 6:16 pm
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?