Betfair exchange : Premium Charge question

News, chat and debate about the Betfair betting exchange.
User avatar
Naffman
Posts: 2219
Joined: Sun Aug 11, 2013 5:46 am

Sun Jan 21, 2018 2:09 pm

Exactly so in that example we should really be paying next to nowt in PC.

BF are the ones losing out though as if I place any straight bet I'll either use Betdaq or the bookies.

Derek27
Posts: 1645
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Sun Jan 21, 2018 2:20 pm

Spare a thought for the guys paying 40%+. I've managed to avoid PC for the time being because I've been arbing most of last year, but I can't see myself continuing when, or if, I have to pay 40%.

Derek27
Posts: 1645
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Sun Jan 21, 2018 11:04 pm

Geordie wrote:
Sun Jan 21, 2018 7:21 am
Derek27 wrote:
Sat Jan 20, 2018 2:50 pm
Commission discount is only relevant ton non PC payers - if you pay PC it gets taken back because your PC will be bigger. If anybody is interest I'll post my premium charge spreadsheet which calculates accurately your premium charge for the week. It's usually no more than a penny out due to rounding off ?
Yes please, Derek, that would be great. Thanks.
Sorry Geordie, I overlooked your post. When I've got time I'll post it with instructions, hopefully tomorrow.

Geordie
Posts: 97
Joined: Fri Sep 12, 2014 10:54 am
Location: North East

Mon Jan 22, 2018 6:32 am

Sorry Geordie, I overlooked your post. When I've got time I'll post it with instructions, hopefully tomorrow.
Great, thanks :)

spreadbetting
Posts: 1320
Joined: Sun Jan 31, 2010 8:06 pm

Mon Jan 22, 2018 1:14 pm

Derek27 wrote:
Sun Jan 21, 2018 2:20 pm
Spare a thought for the guys paying 40%+. I've managed to avoid PC for the time being because I've been arbing most of last year, but I can't see myself continuing when, or if, I have to pay 40%.
Never really understood how people are able to maintain the bookie accounts needed to churn the large amount of comms you need to avoid PC on a weekly basis and trade at the same time. But I guess if people like some bloke etc are able to do it it must be possibe, maybe you could write a walkthrough for that too, Derek?

Derek27
Posts: 1645
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Mon Jan 22, 2018 2:28 pm

spreadbetting wrote:
Mon Jan 22, 2018 1:14 pm
Derek27 wrote:
Sun Jan 21, 2018 2:20 pm
Spare a thought for the guys paying 40%+. I've managed to avoid PC for the time being because I've been arbing most of last year, but I can't see myself continuing when, or if, I have to pay 40%.
Never really understood how people are able to maintain the bookie accounts needed to churn the large amount of comms you need to avoid PC on a weekly basis and trade at the same time. But I guess if people like the Old Centaur employee etc are able to do it it must be possibe, maybe you could write a walkthrough for that too, Derek?
I'm not a big-time trader and you don't have to lose much, or even lose on Betfair to offset the PC. Look at it this way. A winning arb that loses £300 on Betfair means you need to win back a straight £400 before reaching PC levels.

spreadbetting
Posts: 1320
Joined: Sun Jan 31, 2010 8:06 pm

Mon Jan 22, 2018 3:01 pm

Unfortunately I've never been good enough to choose which side of the arb wins with the bookie or even maintain the bookie accounts when you do get those winning arbs though ,Derek, that's the side of things I need the help with.

Derek27
Posts: 1645
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Mon Jan 22, 2018 3:17 pm

spreadbetting wrote:
Mon Jan 22, 2018 3:01 pm
Unfortunately I've never been good enough to choose which side of the arb wins with the bookie or even maintain the bookie accounts when you do get those winning arbs though ,Derek, that's the side of things I need the help with.
You don't need to choose which side of the arb wins, as long as their not all on one side it will reduce your premium charge. However, I'm in the same boat as you now. All the bookies that price up US racing have stopped taking my bets except for Coral and Ladbrokes. Ladbrokes seems to be hard-wired to the exchange - they knock their prices down as quickly as exchange punters do so you can't arb with them. I might have one more go with coral but their not the most generous.

Derek27
Posts: 1645
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Mon Jan 22, 2018 9:49 pm

Here it is Geordie. Macros need to be enabled and it doesn't cater for the 40% charge though it could easily be modified to do so.

Instructions

Look at your Betfair Premium charge page and enter last weeks dates (Monday-Sunday) in cells F3 and H3, in dd/mm/yy format.

Enter your total markets in cell F5.

Enter your lifetime P/L in cell F7.

Enter your lifetime commission in cell F9. (Other charges is dormant because I've never had them, so the spreadsheet would need to be modified if you incur them.)

If you've paid premium charges enter your lifetime total in cell B11.

If you've never paid PC you have two options. Either
  1. Enter 1000 in cell B11 (as though you've paid £1000 PC). Your premium charge allowance (cell B17) should indicate your remaining allowance, or
  2. Subtract your remaining allowance from 1000 and enter that in B11. (eg. an allowance of 300 would result in 700 being entered). The spreadsheet will apply PC but you don't actually pay it until cell B11 reaches £1000
Enter your largest profit for a market in cell B20. This is only effective if you've had a win that amounts to more than half of your lifetime gross profit. Don't really know why I bothered with that one.

When you're done, click the 'Close Week' button and the 'this week' values will be transferred to your lifetime profile. Your lifetime markets and g/p won't change because it includes this weeks data, but this week's values will be reset to zero. You can then update this week's figures at the end of week, or even on a daily basis. Just press the close week button when you've updated this week's values to include your last market of the week. The PC week ends midnight Sunday/Monday GMT.

Premium charge allowance (cell B17)

If you're paying PC this will usually be zero or negative, indicating how much PC is due for the current week.

If you previously paid PC but no longer pay it due to losing or less profitable weeks, your lifetime charges will exceed 20% for your lifetime gross profit, so you effectively have a premium charge allowance again. This cell should indicate how much it is.

Hope it's helpful. :)
You do not have the required permissions to view the files attached to this post.
Last edited by Derek27 on Tue Jan 23, 2018 4:42 pm, edited 1 time in total.

Geordie
Posts: 97
Joined: Fri Sep 12, 2014 10:54 am
Location: North East

Tue Jan 23, 2018 6:56 am

Derek27 wrote:
Mon Jan 22, 2018 9:49 pm
Here it is Geordie.
...
Hope it's helpful. :)
Lovely, really appreciate your efforts, Derek. Cheers :D

Post Reply

Return to “Betfair exchange”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests