General Betting
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.
sort by:
Show
per page
Replies: 17
|
By:
The premium portal calculates it for you.
|
|
By:
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
|
|
By:
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.
|
|
By:
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. |
|
By:
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.
|
|
By:
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. |
|
By:
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," |
|
By:
Grr this forum always ****s around with formulas
=((SUMIF(D:D,">0")/0.95) -SUMIF(D:D,">0") +(SUMIF(D:D," |
|
By:
last line should read
(SUMIF(D:D," |
|
By:
( SUMIF (D:D, "
|
|
By:
ffs
+(SUMIF(D:D,"[i] |
|
By:
I give up , looks like the forums just as ****ed as the rest of the site
http://img156.imageshack.us/img156/1538/72958124.png |
|
By:
LOL and that is truncated as well. You've got to laugh :)
|
|
By:
Are you guys really that cash sensitive to need to work it out exactly?
|
|
By:
To post links in full you have to put a dot in the line above the link.
|
|
By:
I just divide my points for the week by 20. Close enough.
|
|
By:
funny thread
|