Hi,
Hoping someone can help. I am trying to replicate the calculator found at the site below to calculator the required lay stake:
http://www.arbcruncher.com/
The exact calculator is the one under the drop down 'Back/Lay'
I have set this up in Excel 2010 and can calculate the Lay Stake for selection 1 when the commission is set to zero by the following formula:
(Back Price * Stake Back)/Lay price
However, I want to be able to calculate the Lay Stake when Lay has a commission (comm) of 5% and back commission of zero.
So if I use the calculator on the following example, I get a lay stake of 46.67
Back Selection Price 1 = 7
Back Commission = 0
Back Stake =13
Lay Price = 2
Commission will always be 5% for lay and zero for back.
Grateful if someone could adjust my English formula above to include lay commission.
Many thanks!
