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

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
widnesbernie
29 Aug 11 11:15
Joined:
Date Joined: 11 Jan 02
| Topic/replies: 4 | Blogger: widnesbernie's blog
I am trying to work out a formula in Excel with little success.

I want to back at 6.0 and offer a lay at 4.0 before an event begins, to win £21.05. How do I calculate the back & lay stakes to guarantee equal profit?
Pause • Switch to Standard View Help With Working Out Stakes
Show More
Loading...
Report Compound Magic • August 29, 2011 1:20 PM BST
Try ~

Bet Stake = Profit required / ((back price / lay price)-1)
Lay Stake = Back price * Stake / Lay price

Put these in cells stipulated.

Cell A1 ~ Profit required
Cell A2 ~ Back price
Cell A3 ~ Lay price
Cell A4 ~ Stake to back
Cell A5 ~ Stake to lay

Cell B1 ~ 21.05
Cell B2 ~ 6.00
Cell B3 ~ 4.00
Cell B4 ~ =B1/((B2/B3)-1)
Cell B5 ~ =B2*B4/B3

You need to enter your variables on cells B1, B2 and B3
Report widnesbernie • August 29, 2011 4:14 PM BST
Thank you. I spent all night going round in circles. That is exactly what I needed.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com