How do you calculate parlay odds in Excel?

Convert each leg to decimal odds, then use PRODUCT across the legs to get combined decimal odds. Multiply combined odds by the stake for the total return. For American odds, convert first with an IF formula that handles positive and negative prices separately.

How do you remove the margin from each leg?

Record both sides of the market. For a two-way market, the fair probability of the selected side is its implied probability divided by the sum of both implied probabilities. This proportional method is the simplest of several, so note which one you use.

Why does a spreadsheet parlay calculation assume independence?

Because multiplying probabilities is only valid when one leg's outcome tells you nothing about another's. Legs from the same game or otherwise related outcomes break that assumption, and the spreadsheet cannot detect it, so the product can differ substantially from the true combined probability.

How to Build a Parlay Calculator in a Spreadsheet

Convert each leg to decimal odds, multiply them with PRODUCT to get combined decimal odds, and multiply by stake for the total return. To see the margin, remove the margin from each leg using both sides of its market, multiply the fair probabilities, and compare that with the probability implied by the combined odds.

The basic calculator

Lay out one row per leg, with the price in whatever format you have.

Convert American odds to decimal. With American odds in column A, decimal odds in column B are =IF(A2>0, 1+A2/100, 1+100/ABS(A2)). A price of +150 becomes 2.50, and a price of -200 becomes 1.50. Fractional odds convert by dividing and adding one.

Combine the legs. Combined decimal odds are =PRODUCT(B2:B5) for four legs. That is the entire combination rule when legs are independent.

Calculate the return. With the stake in a cell named, say, E1, total return is =E1*PRODUCT(B2:B5) and profit is that minus the stake. Decimal odds include the returned stake, which is why this works without adding it back.

Implied probability per leg. =1/B2 gives the probability implied by each leg's price. The implied probability of the whole combination is =1/PRODUCT(B2:B5), which is the same as multiplying the individual implied probabilities.

Convert back to American if needed. For combined decimal odds D, American odds are =IF(D>=2, (D-1)*100, -100/(D-1)).

That is a working calculator. Everything else on this page is about making it informative rather than just arithmetic.

Keep the intermediate columns

It is tempting to collapse everything into one formula. Keeping decimal odds, implied probability, and fair probability in separate visible columns makes errors obvious at a glance, and makes the calculator useful for understanding rather than only for producing a number.

Adding fair probabilities

Implied probabilities from posted prices include the bookmaker's margin. For a two-way market, the two implied probabilities add up to more than one. To estimate the fair probability of each side, you need both prices.

For each leg, record both sides. Put the price of the selected side in B and the opposing side's decimal price in C.

Remove the margin proportionally. Fair probability for the selected side is =(1/B2)/((1/B2)+(1/C2)). This is the simplest method and assumes the margin is spread in proportion to each side's probability. Other methods exist and give slightly different answers, particularly for heavy favourites and long shots, so note which one you used.

Combine the fair probabilities. =PRODUCT(D2:D5) gives the fair probability of all legs occurring, again assuming independence.

Compare. Put the implied probability of the combined price, =1/PRODUCT(B2:B5), next to the fair combined probability. The ratio between them shows how much margin the combination carries. Because each leg's margin multiplies through, that gap grows with every leg added, which the calculator will show directly as you add rows.

For markets with more than two outcomes, sum the implied probabilities of every outcome in the denominator rather than just two.

What the spreadsheet cannot tell you

It assumes legs are independent. Multiplying probabilities is only correct when the outcome of one leg says nothing about another. Legs from the same game, or otherwise related outcomes, violate this, and the true combined probability can be quite different from the product. A spreadsheet has no way to detect that; you have to know which legs are related.

Fair probability is an estimate. Removing the margin gives the market's probability with the margin stripped out, which is not the same as the true probability of the event. It is a useful reference, not a ground truth.

Prices change. A calculator reflects the prices you typed at the moment you typed them. Record the time alongside the prices if you intend to review the calculation later.

The numbers do not recommend anything. The calculator describes the arithmetic of a combination. Whether any combination is sensible is not a question arithmetic can answer.

This page describes calculation and is not betting advice.

Checking your sheet

Test the calculator with legs whose answers you know. Two legs at decimal 2.00 each should combine to 4.00, with an implied probability of twenty five percent. A two-way market priced at 1.91 on both sides should give a fair probability of exactly fifty percent for either side. If both checks pass, the formulas are wired correctly.

Frequently asked questions

How do you calculate parlay odds in Excel?: Convert each leg to decimal odds, then use PRODUCT across the legs to get combined decimal odds. Multiply combined odds by the stake for the total return. For American odds, convert first with an IF formula that handles positive and negative prices separately.
What is the Excel formula to convert American odds to decimal?: With American odds in A2, use =IF(A2>0, 1+A2/100, 1+100/ABS(A2)). A price of +150 becomes 2.50 and a price of -200 becomes 1.50. To convert decimal odds D back, use =IF(D>=2, (D-1)*100, -100/(D-1)).
How do you remove the margin from each leg?: Record both sides of the market. For a two-way market, the fair probability of the selected side is its implied probability divided by the sum of both implied probabilities. This proportional method is the simplest of several, so note which one you use.
Why does a spreadsheet parlay calculation assume independence?: Because multiplying probabilities is only valid when one leg's outcome tells you nothing about another's. Legs from the same game or otherwise related outcomes break that assumption, and the spreadsheet cannot detect it, so the product can differ substantially from the true combined probability.