% Green Up _ Excel Calculation

[mak]

Hi
can someone help with the following please?

Example
Stake 10€
Back Odds 3
Lay Odds 2

How can I calculate a percentage of potential profit 10% ? Say I believe that the particular selection will win

So the right answer is Lay 11€ and if selection win you get 9€ or if lose you get 1€

Thanks in advanse & Merry Christmas

[mak]

Maybe is not clear from the above..
The answer is provided from a web based calculator & I need to calculate it in excel

[GaryRussell]

Can you post the address of the web calculator. If they are using javascript to calculate it then I maybe able to work out the formula. Can't promise anything though.

[milfor]

So the right answer is Lay 11€ and if selection win you get 9€ or if lose you get 1€

That doesn't make any sense. What back and lay bets are used exactly? If the back odds were 3 and the lay odds were 2 the potential profit would be much higher than 10%.

[GaryRussell]

I think he means 1€ is 10% of (1€ + 9€)

[mak]

That's right Gary
I pm'ed you

[osknows]

If
Back odds = Ob
Back Stake = Sb
Lay odds = Ol
Percentage = p

Then Stake to Lay

Sl = (Ob -2) * Sb * p) + Sb

Sl = (3- 2)*10*0.1) + 10
Sl = 11

[mak]

THANKS OS

[osknows]

Hang on it's not right..... scrap that last equation

[GaryRussell]

See http://www.gruss-software.co.uk/Excel/P ... entage.xls

Enter stake in cell A2
Enter back odds in cell B2
Enter lay odds in cell D2
Enter percentage required in cell G2
The calculated stake is in cell H2

This appears to match the website you sent me.

Maybe osknows can simplify it.

[mak]

Os
I think that your formula is ok.
Are you sure that is something wrong?

Gary thanks

[osknows]

My brain hurts now... I had a calc and tried to fit but as 2 was the lay odds it cancelled most of the terms out

correct formula is
0.1 A1 = percentage
3.00 A2 = Back Odds
10.00 A3 = Back Stake
2.00 A4 = Lay Odds
11.00 A5 = Lay Stake to achieve A1 percentage

A5 formula is
=((A1*A3*A2)+(1-A1*2)*A3)/((A1*A4)+(1-A1*2))

[osknows]

I had a look at the link and it works slightly differently to the way I was expecting. The percentage is based on amount of max profit to hedge, so 10% would reduce the max profit by 10% on the back side to allocate to the lay side. My earlier formula made the lay side profit 10% of the sum of the back and lay profit. They are different things.

So new formula is

p = percentage
Sb = Back Stake
Ob - Back odds
Ol = Lay odds

Lay Stake

Sl = [(1 - p) * Sb * (Ob-Ol)] - [Sb *(Ob -1)] / -(Ol-1)

Sl = [(1-0.1) * 10 * (3-2) ] - [10 *(3-1)] / -(2-1)
Sl = 0.9 * 10 * 1 - 20 / -1
Sl = -11/-1
Sl = 11

[mak]

Os thanks you
Great support as always
Merry Christmas to you & your family & all the forum