How do I (with ease) calculate how much commission I've generated this week?

The premium portal calculates it for you.

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 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.

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,"

Grr this forum always ****s around with formulas

=((SUMIF(D:D,">0")/0.95)
-SUMIF(D:D,">0")
+(SUMIF(D:D,"

last line should read
(SUMIF(D:D,"

( SUMIF  (D:D, "

ffs

+(SUMIF(D:D,"[i]

I give up , looks like the forums just as ****ed as the rest of the site

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.

funny thread