Calculating Commision Any Easy Tips?

[billstraightener]

Hi Guys I have just downloaded the betfair starting prices from their website and have them all merged into files according to what month the races were in.

I have a Total P/L figure but that figure will obviously be effected by commission.

Example :
Race 1 we lose 16, we pay 0%

Race 2 We Win 36, we pay 5%

Our Total profit is 20,but we pay the commission on the 36 as opposed to the 20 profit.

I have the files set up so that its a total P/L rather than individual races, now I could split it but we are talking an excel file with 13000 lines of data in it

Can anyone suggest a way of getting my head around this. I will post anything interesting if I find it.

[gazuty]

To get the total PL you must have summed individual cells.

For any cell that is positive multiply it by 0.95 or by say 0.9375 (if you are covering Aussie racing).

IF (A1>0, A1*0.95, A1)

[billstraightener]

Hi Gaz, Thanks for your reply I have done this
and included a photo

http://imgur.com/zNpO1dF


=IF(G2>0.9,-100,100/(H2-1)*0.95)

Its for Laying, If it wins we lose 100 if not the BSP-1 divided by 100 multiplied by .95 for commission.


I have a total for 2013 of +27880 without commission (yellow column)

But when I add the commission in that way I get a loss of -62718.(red column)

Surely the commission cannot eat that much out of it?

[gazuty]

Red column looks ok in terms of the raw output.

Something else is going on but without the sheet, can't tell.

[billstraightener]

Hi Gaz, I uploaded my excel file if you wish to have a look at it, does that Red column generally mean that laying at BSP is simply unprofitable, I may have done some things incorrectly but I'm pretty sure my filters etc are reasonably ok.

Code: Select all

http://speedy.sh/UnZDV/MASTER-USA-2013.xlsx

That link ^ doesn't seem to be working I am uploading it on a different site now.

Here is another site

Code: Select all

http://www.sendspace.com/file/1f4u7t

[LinusP]

I think your spreadsheet is correct but commission isn't calculated exactly like that. You pay 5%ish on your profit so when laying multiple runners you can't just times each winnings by 0.95, which means you will pay less commission.

[billstraightener]

Hi Linus thanks for the response,yes I know that as stated in the original post, There is just a huge discrepancy between +20000 and -40000.

I have the No of races, The No of runners and total profit and the average made per race, would that be able to help me. I'm scratching my head here

[LinusP]

I agree thats a big difference but I don't think this would be profitable unless you were very selective or lay at odds below BSP like bookies do . There is talk about this strategy on the betfair forum..

http://community.betfair.com/general_be ... liveView=0