Round Robin Bets

[arsqldba]

I've poked around and searched on the forum but i'm unclear on the spreadsheet best handles Round Robin bets.

See here for a good explanation:

https://www.sportsbookscout.com/sports-betting-guides/round-robin-bet

[admin]

Hi arsqldba,

Round Robin bets are a challenge because the winning odds depend on which combination of bets win(s).

Currently the only way to enter these bets is either:

1. (Exact) Input every combination as a separate bet

2. (Crude) Enter the Round Robin bet as one bet and then manually update the odds at the conclusion of the bets to reflect the pay out. If you have a pay out that is less than the total stake then split the bet into two. One would contain the winning leg(s) and the other would be entered as a losing bet containing the combined stakes of all of the losing legs.

[arsqldba]

Hi arsqldba,

Round Robin bets are a challenge because the winning odds depend on which combination of bets win(s).

Currently the only way to enter these bets is either:

1. (Exact) Input every combination as a separate bet

2. (Crude) Enter the Round Robin bet as one bet and then manually update the odds at the conclusion of the bets to reflect the pay out. If you have a pay out that is less than the total stake then split the bet into two. One would contain the winning leg(s) and the other would be entered as a losing bet containing the combined stakes of all of the losing legs.

So how would that look using this (https://imgur.com/a/5CU4cb7) as an example? I'm wondering if it doesn't provide enough detail as I can't get it to add up right in the sheet.

[admin]

My interpretation for that bet is it consists of two-leg multis (parlays) consisting of every combination of the five bets.

For option 1:
This would involve entering ten bets using every combination of two bets from the five.
1. Over 7.5 & Texas Rangers
2. Over 7.5 & Oakland
3. Over 7.5 & Washington
4. Over 7.5 & Boston
5. Texas & Oakland
6. Texas & Washington
7. Texas & Boston
8. Oakland & Washington
9. Oakland & Boston
10. Washington & Boston

For option 2:
Stake of $10 at US odds of -1030.93 (1.097 decimal odds if you're using that system). Those odds are calculated based on your actual winnings.

To calculate multi odds using the US odds system, one option is to use the Odds Conversion Calculator - Australia Sports Betting (aussportsbetting.com) to convert the American odds to decimal odds. You then multiply the decimal odds for each selection to get the combined odds for that pairing. For example, in Bet 1 above, the decimal odds are -105 => 1.9524 for the first bet and +140 => 2.400 for the second. The combined odds for these selections are 1.9524*2.40 = 4.68576. If you enter this value back into the calculator you get +368.58 American odds.

As you can see, option 1 is time-intensive unless you tweak the spreadsheet to automatically calculate the combined odds for you. My recommendation for 5+ Round Robins is to use option 2.