GUIDO22
Registered User.
- Local time
- Today, 17:41
- Joined
- Nov 2, 2003
- Messages
- 515
Hi
I have been stumped by the following that I have attempted to solve with a SUMIF formula...
I need to calculate the profit/loss for bets on Betfair. If you dont know - Betfair charges (nominally 5%) commission on the net profit only ie. the Betfair commission/fee is only charged after all losing bets have been subtracted from winning bet/s.
So, in the attachment you will see the red bounding rectangle enclosing four horses that ran at Haydock. One was a winner returning of 8.6, but there were three losing bets too... so the commission would be charged on 5.6 ie. 5.6 * 0.95 = 5.32 PROFIT
The key criteria in this calculation is that the calculations are carried out on all horses that are RUNNING IN THE SAME RACE! (so perhaps the date, course and time can be used to group the horses...? )
As a worst case it is simple enough to charge 5% on the winning bet and then subtract the loses but this is not sufficiently accurate for my purposes...
If anyone has any clever way to do this and can share the knowledge, it would be much appreciated.
Thank you.
I have been stumped by the following that I have attempted to solve with a SUMIF formula...
I need to calculate the profit/loss for bets on Betfair. If you dont know - Betfair charges (nominally 5%) commission on the net profit only ie. the Betfair commission/fee is only charged after all losing bets have been subtracted from winning bet/s.
So, in the attachment you will see the red bounding rectangle enclosing four horses that ran at Haydock. One was a winner returning of 8.6, but there were three losing bets too... so the commission would be charged on 5.6 ie. 5.6 * 0.95 = 5.32 PROFIT
The key criteria in this calculation is that the calculations are carried out on all horses that are RUNNING IN THE SAME RACE! (so perhaps the date, course and time can be used to group the horses...? )
As a worst case it is simple enough to charge 5% on the winning bet and then subtract the loses but this is not sufficiently accurate for my purposes...
If anyone has any clever way to do this and can share the knowledge, it would be much appreciated.
Thank you.
