|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Parlay Calculator for up to 4 teams
I have tried my hand at writing up a parlay calculator using excel, but it turns out wrong.
I'm trying to write a calculator that works out the bet sizes for up to 4 teams. I just enter the teams and the prices and the calculator works out the size of the bet based on the prices. Can someone please help? Mad Gambler |
#2
|
|||
|
|||
To win fixed amount $100.
Mad Gambler |
#3
|
|||
|
|||
Couldn't you just use something like:
eg: A. Team 1 odds = 1.50 x B. Team 2 odds = 1.85 x C. Team 3 odds = 2.00 x D. Team 4 odds = 1.45 E. Total odds = 8.0475 F. Win Total = 100.00 100 / 8.0475 = 12.426219 A x B x C x D = E F / E = Bet amount to reach $100.00 |
#4
|
|||
|
|||
Just tried it in Lotus which is pretty much the same as excel. Worked ok there
Starting at Cell A1 A1 Team 1 odds = 1.50 A2 Team 2 odds = 1.85 A3 Team 3 odds = 2.00 A4 Team 4 odds = 1.45 A5 @SUM(A1*A2*A3*A4) = 8.05 A6 @SUM(100/A5) = 12.43 To check Tally @SUM(A5*A6) = 100.00 Obviously rounding occurs as 8.05 * 12.43 = 100.0615 (there are ways and means around rounding but not much point really when you cant bet in cent percentages anyway. Hope that helps Last edited by Jack Daniels : 14th March 2006 at 07:19 PM. |
Thread Tools | Search this Thread |
Display Modes | |
|
|