We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
30 Jan 11
21:23
Joined:
Date Joined:
17 Sep 02
As above. I'm sure there was a simple method involving downloading a report to a spreadsheet and then summing it but I'm shattered and can't quite remember how.
TIA.
TIA.
Show More
Simplest way of getting it in a spreadsheet is to ask BF to email it to you. If you ask for a P&L report for a specific period it will be in there
Oh yes, one of the spreadsheets you can download (you don't need to actually ask to email) simply has a breakdown I THINK that you could configure excel to total for you, or do manually.
Thanks, I'll have another look at it.
I was hoping to calculate it before the end of Sunday so the Premium Portal is too late.
I was hoping to calculate it before the end of Sunday so the Premium Portal is too late.
I don't have excel on this machine but go to profit and loss on your account and select dates and download to spreadsheet, and have a dig.
TP
I just go through the main wallet and Aus wallet net P&Ls for the week, then apply 18.5% and I am never short.
I just go through the main wallet and Aus wallet net P&Ls for the week, then apply 18.5% and I am never short.
If you want the actual amount of comm you've paid just compare the bethistory sums against the bettingPandL sum.
To get a rough idea of the comms you'll be credited towards the PC you can use this formula against your bettingPandL sheet for the period, won't be exact as a lot of markets get rounded up etc but it'll be close enough to get an idea
=((SUMIF(D:D,">0")/0.95)-SUMIF(D:D,">0")-(SUMIF(D:D,"
To get a rough idea of the comms you'll be credited towards the PC you can use this formula against your bettingPandL sheet for the period, won't be exact as a lot of markets get rounded up etc but it'll be close enough to get an idea
=((SUMIF(D:D,">0")/0.95)-SUMIF(D:D,">0")-(SUMIF(D:D,"
Grr this forum always ****s around with formulas
=((SUMIF(D:D,">0")/0.95)
-SUMIF(D:D,">0")
+(SUMIF(D:D,"
=((SUMIF(D:D,">0")/0.95)
-SUMIF(D:D,">0")
+(SUMIF(D:D,"
I give up , looks like the forums just as ****ed as the rest of the site
http://img156.imageshack.us/img156/1538/72958124.png
http://img156.imageshack.us/img156/1538/72958124.png
LOL and that is truncated as well. You've got to laugh :)
Are you guys really that cash sensitive to need to work it out exactly?
To post links in full you have to put a dot in the line above the link.
I just divide my points for the week by 20. Close enough.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539