1. #1
    LVBOUND
    Living the DREAM!!
    LVBOUND's Avatar Become A Pro!
    Join Date: 07-25-08
    Posts: 2,658
    Betpoints: 119

    Help with Excel formula (FOR GOOGLE DOCS)

    I am working on a spreadsheet and need help with an excel formula, that I want to use in Google docs.

    I am trying to duplicate the US2Dec formula that ganchrow has on his excel template. for a 2 team parlay

    A1 = Unit
    E2= Team1 odds
    G2= Team2 odds
    H2=Parlay odds

    I am then trying to find the amount needed to be RISKED CELL I2 to make 1 UNIT.

    (20 SBR to someone that can give me an answer for both of these please)

    Thanks,

    Matt

  2. #2
    LVBOUND
    Living the DREAM!!
    LVBOUND's Avatar Become A Pro!
    Join Date: 07-25-08
    Posts: 2,658
    Betpoints: 119

    I found this, but it doesn't seem to work, I am not sure what I was doing wrong?

    I entered this (1+100/E2)*(1+10/G2)) into the parlay odds and ?????

    Quote Originally Posted by Ganchrow View Post
    You take the product of the decimal odds.

    Hence, true parlay odds on two bets at would be (1+100/110)*(1+10/110) ≈ .

    True parlay odds on one bet at and another at would be (1+100/105)*(1+100/110) ≈ .

    This means that when parlaying 2 teams at -110 for +260 you're actually getting each team at odds of about .

    Similarly, when parlaying 3 teams at -110 for +600 you're actually getting each team at odds of about .

    Books will frequently offer 2- and 3- team parlays ot odds of +260 (13:5) and +600 (6:1), respectively. This is a throwback to the old days when (apparently) calculators were hard to come by and weighted several tons each (most of that weight was of course due to the wise-crackin' Pterodactyl that provided the calculator its juice). It was easier for a book maker (or is his customers) to calculate payout amounts at 13:5 or 6:1 than at 2.6446:1 or 5.9579:1.

  3. #3
    Pokerjoe
    Pokerjoe's Avatar Become A Pro!
    Join Date: 04-17-09
    Posts: 704
    Betpoints: 307

    First, translate the team's odds into decimal format.

    Then, to get the parlay odds in H2, just multiply each team's odds:
    =E2*G2

    Then, with parlay odds in H2, risk amount, with A1 being your unit, is:

    =1/(H2-1)*A$1

  4. #4
    LVBOUND
    Living the DREAM!!
    LVBOUND's Avatar Become A Pro!
    Join Date: 07-25-08
    Posts: 2,658
    Betpoints: 119

    =(100/((1+100/F2)*(1+100/H2)))*-1

    F2 and H2 are my lines

    -475
    -310

    I get -187

    SBR Parlay Calc has -166?????

    what am I doing wrong

  5. #5
    LVBOUND
    Living the DREAM!!
    LVBOUND's Avatar Become A Pro!
    Join Date: 07-25-08
    Posts: 2,658
    Betpoints: 119

    Ok Fixed it

Top