Forums

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

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
westham dave
08 Jun 15 23:40
Joined:
Date Joined: 03 Feb 09
| Topic/replies: 28 | Blogger: westham dave's blog
Can someone tell me the % profit in green under betfair results for BSP against ISP includes the 5% comm
or do you have to take another 5% of that price?
Show More
Loading...
Report westham dave • June 9, 2015 1:17 AM BST
anyone know the answer to this?
Report Deltâ • June 9, 2015 8:44 AM BST
I'm confused - as the % difference dont seem to calculate so how do they do it


latest race example - surely a 25% uplift = 3.0 not 2.84, any clues ...


02:56 Mountaineer Casino Racetrack & Resort (US)     Industry SP     Betfair SP
1st     Circus Game     2.4     2.84
2nd     Velvet Halo     14.9     15
3rd     Patch O'gold     31     18.01
Winner SP Advantage: 25%
Ran: 7
Non Runners: None
Status: Result
View full result
Report elise • June 9, 2015 8:48 AM BST
any help?
.
http://www.betfair.com/help/Help.SP.Betting/
Report Deltâ • June 9, 2015 9:03 AM BST
cheers elise, I looked at that as was trying to answer OP ?

but that doesnt really explain the % difference and more I looked at it - I cant see how the % is calculated
Report top2rated • June 9, 2015 9:27 AM BST
In response to the OP, yes, 5% commission is factored in to the percentage figure when BSP is compared to ISP.

Deltâ

In your example the 25% figure has been rounded up,it's actually 24.86%.

Just plug the BSP and ISP figures, 2.84 and 2.4 in to a spreadsheet in cells A1 and A2 respectively.

In cell A3 copy and paste the formula below...

=(((A2-1)*0.95)-(B2-1))/(B2-1)

Love
Report Deltâ • June 9, 2015 9:32 AM BST
that formula correct?
Report Deltâ • June 9, 2015 9:37 AM BST
gotcha - as in using the calc top 2, thanks


altho if i put that formula in A3 - didnt come out right
...


but get the theory

tar
Report Deltâ • June 9, 2015 9:42 AM BST
got it

A1 not 2

and

A2 not B2

Grin
Report top2rated • June 9, 2015 9:46 AM BST
Sorry, should have mentioned....

Format cell A3 for 'Percent', two decimal places.

Grin
Report Deltâ • June 9, 2015 9:47 AM BST
obvs   Laugh
Report westham dave • June 9, 2015 10:16 AM BST
Anyone know the answer to this?
Report The Sawyer • June 9, 2015 10:31 AM BST
dave

the green figure includes the 5% reduction
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com