F
FISH
I want to create a Excel workbook that will help in specific poker
situations.
Short version: I want to be able to calculate how often my opponent will
need to fold for an all-in raise to show a positive expectation.
Explanation:
In poker you can win a hand by having the best hand at the end OR getting
your opponent to fold.
A common situation comes up where you have a "drawing hand" and face a bet
by your opponent. In this situation you know you are currently behind in the
hand, but have a chance to win if you catch some of your "outs" (cards that
will give you the winning hand).
Example:
You have one of these drawing hands and it will become the winning hand
about 1/3 of the time if you stay in until the end.
There is $150 in the pot and your opponent bets another $100.
If you were to re-raise all in it would be for a total of $300 ($200 in
addition to his $100).
x% of the time my opponent will fold in this spot
I want to be able to solve for x (the amount my opponent will need to fold)
to show me the break even point of this re-raise.
When I re-raise all in he is only left with two options so we need to
account for both. He can call or he can fold:
100% of the time he folds I will win $250
2/3 of the time he calls I miss my draw and lose $300 (the amount I
re-raised all in with)
1/3 of the time I will hit my draw and win $450 ($150 in the original
pot+his $100 bet+his $200 call of my all in re-raise)
So, how can I create an excel workbook/calculation that will calculate the %
my opponent will need to fold for my all in re-raise to break even?
Thanks in advance for any help with this.
situations.
Short version: I want to be able to calculate how often my opponent will
need to fold for an all-in raise to show a positive expectation.
Explanation:
In poker you can win a hand by having the best hand at the end OR getting
your opponent to fold.
A common situation comes up where you have a "drawing hand" and face a bet
by your opponent. In this situation you know you are currently behind in the
hand, but have a chance to win if you catch some of your "outs" (cards that
will give you the winning hand).
Example:
You have one of these drawing hands and it will become the winning hand
about 1/3 of the time if you stay in until the end.
There is $150 in the pot and your opponent bets another $100.
If you were to re-raise all in it would be for a total of $300 ($200 in
addition to his $100).
x% of the time my opponent will fold in this spot
I want to be able to solve for x (the amount my opponent will need to fold)
to show me the break even point of this re-raise.
When I re-raise all in he is only left with two options so we need to
account for both. He can call or he can fold:
100% of the time he folds I will win $250
2/3 of the time he calls I miss my draw and lose $300 (the amount I
re-raised all in with)
1/3 of the time I will hit my draw and win $450 ($150 in the original
pot+his $100 bet+his $200 call of my all in re-raise)
So, how can I create an excel workbook/calculation that will calculate the %
my opponent will need to fold for my all in re-raise to break even?
Thanks in advance for any help with this.