Poker Odds Calculator Excel

POKER PROBABILITIES

Poker Odds Calculator Pro Training Series: Hand Ranges covering concept, creation, editing, favorites, and built-in ranges. Also informally referred to as odds calculators, these mostly browser-based tools are the oldest and simplest aids to understanding some basic poker math. They calculate the probability of a hand winning against one or more other hands, just like the percentages that show up in televised poker graphics.

  • Texas Hold'em Poker
    Texas Hold'em Poker probabilities
  • Omaha Poker
    Omaha Poker probabilities
  • 5 Card Poker
    5 Card Poker probabilities

POKER CALCULATOR

  • Poker calculator
    Poker odds calculator

POKER INFORMATION

  • Poker hand rankings
    Ranking of poker hands

In poker, the probability of each type of 5-card hand can be computed by calculating the proportion of hands of that type among all possible hands.

Frequency of 5-card poker hands

The following enumerates the (absolute) frequency of each hand, given all combinations of 5 cards randomly drawn from a full deck of 52 without replacement. Wild cards are not considered. The probability of drawing a given hand is calculated by dividing the number of ways of drawing the hand by the total number of 5-card hands (the sample space, five-card hands). The odds are defined as the ratio (1/p) - 1 : 1, where p is the probability. Note that the cumulative column contains the probability of being dealt that hand or any of the hands ranked higher than it. (The frequencies given are exact; the probabilities and odds are approximate.)

The nCr function on most scientific calculators can be used to calculate hand frequencies; entering ​nCr​ with ​52​ and ​5​, for example, yields as above.

HandFrequencyApprox. ProbabilityApprox. CumulativeApprox. OddsMathematical expression of absolute frequency
Royal flush40.000154%0.000154%649,739 : 1
Straight flush (excluding royal flush)360.00139%0.00154%72,192.33 : 1
Four of a kind6240.0240%0.0256%4,164 : 1
Full house3,7440.144%0.170%693.2 : 1
Flush (excluding royal flush and straight flush)5,1080.197%0.367%507.8 : 1
Straight (excluding royal flush and straight flush)10,2000.392%0.76%253.8 : 1
Three of a kind54,9122.11%2.87%46.3 : 1
Two pair123,5524.75%7.62%20.03 : 1
One pair1,098,24042.3%49.9%1.36 : 1
No pair / High card1,302,54050.1%100%.995 : 1
Total2,598,960100%100%1 : 1

Poker Odds Calculator Excel Spreadsheets

Calculator

The royal flush is a case of the straight flush. It can be formed 4 ways (one for each suit), giving it a probability of 0.000154% and odds of 649,739 : 1.

When ace-low straights and ace-low straight flushes are not counted, the probabilities of each are reduced: straights and straight flushes each become 9/10 as common as they otherwise would be. The 4 missed straight flushes become flushes and the 1,020 missed straights become no pair.

Note that since suits have no relative value in poker, two hands can be considered identical if one hand can be transformed into the other by swapping suits. For example, the hand 3♣ 7♣ 8♣ Q♠ A♠ is identical to 3♦ 7♦ 8♦ Q♥ A♥ because replacing all of the clubs in the first hand with diamonds and all of the spades with hearts produces the second hand. So eliminating identical hands that ignore relative suit values, there are only 134,459 distinct hands.

The number of distinct poker hands is even smaller. For example, 3♣ 7♣ 8♣ Q♠ A♠ and 3♦ 7♣ 8♦ Q♥ A♥ are not identical hands when just ignoring suit assignments because one hand has three suits, while the other hand has only two—that difference could affect the relative value of each hand when there are more cards to come. However, even though the hands are not identical from that perspective, they still form equivalent poker hands because each hand is an A-Q-8-7-3 high card hand. There are 7,462 distinct poker hands.

Derivation of frequencies of 5-card poker hands

Poker Odds Calculator Excel

of the binomial coefficients and their interpretation as the number of ways of choosing elements from a given set. See also: sample space and event (probability theory).

  • Straight flush — Each straight flush is uniquely determined by its highest ranking card; and these ranks go from 5 (A-2-3-4-5) up to A (10-J-Q-K-A) in each of the 4 suits. Thus, the total number of straight flushes is:
    • Royal straight flush — A royal straight flush is a subset of all straight flushes in which the ace is the highest card (ie 10-J-Q-K-A in any of the four suits). Thus, the total number of royal straight flushes is
      or simply . Note: this means that the total number of non-Royal straight flushes is 36.
  • Four of a kind — Any one of the thirteen ranks can form the four of a kind by selecting all four of the suits in that rank. The final card can have any one of the twelve remaining ranks, and any suit. Thus, the total number of four-of-a-kinds is:
  • Full house — The full house comprises a triple (three of a kind) and a pair. The triple can be any one of the thirteen ranks, and consists of three of the four suits. The pair can be any one of the remaining twelve ranks, and consists of two of the four suits. Thus, the total number of full houses is:
  • Flush — The flush contains any five of the thirteen ranks, all of which belong to one of the four suits, minus the 40 straight flushes. Thus, the total number of flushes is:
  • Straight — The straight consists of any one of the ten possible sequences of five consecutive cards, from 5-4-3-2-A to A-K-Q-J-10. Each of these five cards can have any one of the four suits. Finally, as with the flush, the 40 straight flushes must be excluded, giving:
  • Three of a kind — Any of the thirteen ranks can form the three of a kind, which can contain any three of the four suits. The remaining two cards can have any two of the remaining twelve ranks, and each can have any of the four suits. Thus, the total number of three-of-a-kinds is:
  • Two pair — The pairs can have any two of the thirteen ranks, and each pair can have two of the four suits. The final card can have any one of the eleven remaining ranks, and any suit. Thus, the total number of two-pairs is:
  • Pair — The pair can have any one of the thirteen ranks, and any two of the four suits. The remaining three cards can have any three of the remaining twelve ranks, and each can have any of the four suits. Thus, the total number of pair hands is:
  • No pair — A no-pair hand contains five of the thirteen ranks, discounting the ten possible straights, and each card can have any of the four suits, discounting the four possible flushes. Alternatively, a no-pair hand is any hand that does not fall into one of the above categories; that is, any way to choose five out of 52 cards, discounting all of the above hands. Thus, the total number of no-pair hands is:
  • Any five card poker hand — The total number of five card hands that can be drawn from a deck of cards is found using a combination selecting five cards, in any order where n refers to the number of items that can be selected and r to the sample size; the '!' is the factorial operator:

This guide is licensed under the GNU Free Documentation License. It uses material from the Wikipedia.

Home > 5 Card Poker probabilities

If I end up making a useful poker spreadsheet, I'll add it to this page for you to download and play with.

Poker Odds Calculator Excel

What kind of spreadsheets are they?

Poker

Just anything that might help explain any kind of poker concept that involves numbers.

1. Pot Growth Visualizer - Watch the pot grow.

Download (Mac):pot-growth-visualiser.numbers (original file)
Download (Excel):pot-growth-visualiser.xls (exported from Numbers.app)

  • Description: See how your bets and raises affect how rapidly the size of the pot grows.
  • Features: Find out how much you need to bet to set up a pot-size all-in on the river.
  • Benefits: The deeper your understanding of geometric pot size growth, the better you'll get at controlling and manipulating pot sizes to your advantage.
  • Source:Progressive Bet Sizing

Why use spreadsheets?

Bit old-school aren't they? Well, yeah, but they're simple and effective. You don't see knives going out of fashion.

Poker Odds Calculator Excel Formula

So when I'm writing an article I may create a spreadsheet to help me out. I'll use it to help me calculate things and display information clearly. It allows me to see the strategy.

  • The boxes are perfect for organizing numbers and laying out calculations in an easy to read format. This helps you to 'see' the calculations in your head.
  • The charts are marvelous for visualizing the results of your calculations. This helps you to 'see' the results and the effects of inputs/actions.

Poker Odds Calculator Excel Spreadsheet

Spreadsheets are magic for analyzing statistical things, and poker is one of those statistical things. If you can work with spreadsheets, you have a powerful tool at your disposal for analyzing ideas. Just as a gladiator would benefit from a sexy new weapon, a poker player benefits from Excel.

But what exactly can you do with spreadsheets? Honestly, play with them and see for yourself. EV equations would be a good place to start. Then try some pot odds and other mathematical stuff.

And when you get the hang of it, you'll be thankful you acquired the skill. Excel isn't just for lame databases. It's actually an awesome tool that will develop your skill of decision analysis. And winning the most money from poker is simply a case of making the best possible decisions at every opportunity.

The next time you want to work something out using numbers, try doing it in Excel (or whatever spreadsheet app you prefer).

Popular spreadsheet tools.

Poker odds calculator excel spreadsheets
  • Excel - The original, and the popular choice.
  • Numbers - Snazzy spreadsheet offering from Apple. Sleek and effective.
  • Google Docs - Free web-based app. Perfect for simpler jobs, but lacks the more complex functionality of the downloadable apps above.

Honorable Mention: Soulver (Mac)

I love Soulver. It's a cross between a calculator, a note pad, and a spreadsheet. It's a calculator/note pad mostly, and it's super handy for things like EV equations.

Go back to the handy Texas Hold'em tools.