New Posts For Thread: Help With Working Out Stakeshttps://community.betfair.com/general_betting/go/thread/view/94082/28236697/help-with-working-out-stakesI 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?Thank you. I spent all night going round in circles. That is exactly what I needed.https://community.betfair.com/general_betting/go/thread/view/94082/28236697/help-with-working-out-stakes?post_id=505949065#505949065Thank you. I spent all night going round in circles. That is exactly what I needed.Mon, 29 Aug 2011 10:14:12 -0500Try ~Bet Stake = Profit required / ((back price / lay price)-1) Lay Stake = Back price * Stake / Lay pricePut these in cells stipulated.Cell A1 ~ Profit requiredCell A2 ~ Back price Cell A3 ~ Lay price Cell A4 ~ Stake to backCell A5 ~ Stake to lay Cehttps://community.betfair.com/general_betting/go/thread/view/94082/28236697/help-with-working-out-stakes?post_id=505943193#505943193Try ~Bet Stake = Profit required / ((back price / lay price)-1) Lay Stake = Back price * Stake / Lay pricePut these in cells stipulated.Cell A1 ~ Profit requiredCell A2 ~ Back price Cell A3 ~ Lay price Cell A4 ~ Stake to backCell A5 ~ Stake to lay CeMon, 29 Aug 2011 07:20:42 -0500I 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?https://community.betfair.com/general_betting/go/thread/view/94082/28236697/help-with-working-out-stakes?post_id=505939841#505939841I 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?Mon, 29 Aug 2011 05:15:59 -0500