Yes, i've had issues myself. Taking time to understand the calculations and keeping your own records is crucialdeestar wrote: ↑Wed Oct 05, 2022 9:52 amYes it is meant to. But as you can see from my statement they have never split it out correctly. I gave up trying to get them to show it correctly after they adjusted it once to an incorrect figure. The two ratios that are important on that statement are
Commission/Gross Profit gives you your underlying com rate (i.e what is your base rate) In my case 19%. Should it get below 10% I'd be on a higher PC rate)
Total Charges/Gross Profit tells you if you need to pay PC in any given week. In my case anything under 40% incurs a PC charge.
There is no way, from the numbers on the statement, of working out your life time Net Profit. You need to keep a tally of that separately.
Premium Charge - Historical number lower than last week?
- jamesedwards
- Posts: 2531
- Joined: Wed Nov 21, 2018 6:16 pm
Thanks for this infonapshnap wrote: ↑Wed Oct 05, 2022 7:57 amTry this, James - viewtopic.php?p=283109#p283109.
I have a script that simply rounds up using the 3% implied comms and pretty much bob on. Problems occur for me because I also bet on the AUS markets etc where the base rate isn't 2% and varies, I can never be arsed to find the actual rates. Plus your lifetime summary affects the final fee as they need to ensure you don't exceed their supposed 40%, depending where that is you may be playing catch up or gain a few pennies.
Thanks, I'll revisit my code. I use a database with the MBR for each course or district so the commission calculation is precise to the penny, it's just the commission generated that's the issue. It may not even be implied commission because if you pay an odd number of pence commission on winnings, that has to be halved and rounded. I've also wondered, if your commission amounts to 14.6 pence, you pay 15 pence but your implied commission could be 7p, 8p or 7.3p, perhaps they don't round but add up the fractions.Trap1 wrote: ↑Wed Oct 12, 2022 2:38 pmI have a script that simply rounds up using the 3% implied comms and pretty much bob on. Problems occur for me because I also bet on the AUS markets etc where the base rate isn't 2% and varies, I can never be arsed to find the actual rates. Plus your lifetime summary affects the final fee as they need to ensure you don't exceed their supposed 40%, depending where that is you may be playing catch up or gain a few pennies.
- jamesedwards
- Posts: 2531
- Joined: Wed Nov 21, 2018 6:16 pm
Can you think of any other situation where a company takes thousands of pounds a week from your account and you can't even view a breakdown of how they reached their chosen number.
How were you calculating comms paid? I was just using the BettingPnL.csv files and work it out by getting the gross figure from the profit and lossDerek27 wrote: ↑Wed Oct 12, 2022 2:59 pmThanks, I'll revisit my code. I use a database with the MBR for each course or district so the commission calculation is precise to the penny, it's just the commission generated that's the issue. It may not even be implied commission because if you pay an odd number of pence commission on winnings, that has to be halved and rounded. I've also wondered, if your commission amounts to 14.6 pence, you pay 15 pence but your implied commission could be 7p, 8p or 7.3p, perhaps they don't round but add up the fractions.Trap1 wrote: ↑Wed Oct 12, 2022 2:38 pmI have a script that simply rounds up using the 3% implied comms and pretty much bob on. Problems occur for me because I also bet on the AUS markets etc where the base rate isn't 2% and varies, I can never be arsed to find the actual rates. Plus your lifetime summary affects the final fee as they need to ensure you don't exceed their supposed 40%, depending where that is you may be playing catch up or gain a few pennies.
So if negative just multiply that figure by -0.03 and round to 2 decimal places.
If positive I'd work out the gross win by multiplying the pnl figure by 100/(100 minus com rate) and again round up to two decimals then take the gross away from the pnl figure to get my comm paid. I think I did it that way as my account statement and betting profit and loss figures would then tally.
Have you done simple checks to see that "Commission & charges from last week" on the PC page tally with yours? Should help you track down any error between your calc and betfair's.
My P/L is always spot on. But commission generated is always a few pence out. I don't use the Betfair files because the market/event information is incomplete and inconsistent. I take half my commission paid and 1.5% of losses but I think the error is in the rounding.Trap1 wrote: ↑Wed Oct 19, 2022 5:40 pmHow were you calculating comms paid? I was just using the BettingPnL.csv files and work it out by getting the gross figure from the profit and lossDerek27 wrote: ↑Wed Oct 12, 2022 2:59 pmThanks, I'll revisit my code. I use a database with the MBR for each course or district so the commission calculation is precise to the penny, it's just the commission generated that's the issue. It may not even be implied commission because if you pay an odd number of pence commission on winnings, that has to be halved and rounded. I've also wondered, if your commission amounts to 14.6 pence, you pay 15 pence but your implied commission could be 7p, 8p or 7.3p, perhaps they don't round but add up the fractions.Trap1 wrote: ↑Wed Oct 12, 2022 2:38 pm
I have a script that simply rounds up using the 3% implied comms and pretty much bob on. Problems occur for me because I also bet on the AUS markets etc where the base rate isn't 2% and varies, I can never be arsed to find the actual rates. Plus your lifetime summary affects the final fee as they need to ensure you don't exceed their supposed 40%, depending where that is you may be playing catch up or gain a few pennies.
So if negative just multiply that figure by -0.03 and round to 2 decimal places.
If positive I'd work out the gross win by multiplying the pnl figure by 100/(100 minus com rate) and again round up to two decimals then take the gross away from the pnl figure to get my comm paid. I think I did it that way as my account statement and betting profit and loss figures would then tally.
Have you done simple checks to see that "Commission & charges from last week" on the PC page tally with yours? Should help you track down any error between your calc and betfair's.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
It's there early again, check it at about 00:30 (mon).
- jamesedwards
- Posts: 2531
- Joined: Wed Nov 21, 2018 6:16 pm