Calculate back and lay price

[richards007]

Hello,

Does anybody have an excel sheet what calculate 2 bets:

1 back bet with odds of X
1 Lay bet with odds of X

The sheet needs to calculate the + and - of both bets with the winning bet -0.5% commission.

Thank you..!

Richard

[pdupre1961]

Hi Richard,

Are you just placing one back bet and one lay bet.

OR a combination of back and lay bets...

Regards, Paul

[richards007]

Hello Paul,

Just one back bet and 1 lay bet.
example:

back 0 - 0 and lay the draw.

Richard

[pdupre1961]

Hi Richard,

Assuming you place the back bet first then the lay bet. Here is the formula:-

[Lay Bet] = ROUND([Back bet]*(1/([Lay Odds]-[Lay market commission]))/(1/(1+((-[Back Bet]*([Back Odds]-1)*(1-[Back market commission]))/-[Back Bet]))),2)

The attached spreadsheet will do the calculation for you, please let me know of any problems.

Regards,
Paul

[richards007]

Ty Paul works great !!!

Greetings
Richard

[pdupre1961]

Your welcome Richard,

How are you going to use the spreadsheet.

Do you need something that connects to Bet Angel as I could do that as well...

Paul

[pdupre1961]

Forgot to mention - you can set different commission rates for each market...

[cooljay72]

Hi i was wandering if anyone can do spreadsheet that does 2 back bets and 1 lay bet at the same time, odds normally higher on the back bets (so not just back and lay).
Or if a spreadsheet that could do 1 back bet and 2 lay bets, or even a sheet that does both?
Also there would be no commission on the back bets only lay

Thanks Jay