Calling "All-In" when villains stack is smaller

[DOMIATED89]

Hello,

There seems to be an error where some all-in situations aren't counted as all-in. When an opponent has fewer chips and makes the final bet, if I call with a larger stack, this is not counted as an all-in. How can I modify the all-in stat to include these situations?

[Flag_Hippo]

If you call another players all-in with chips left behind then you are not all-in however there is a database field for facing all-ins:

cash_hand_player_statistics.enum_face_allin

This is 'N' when no all-in is faced otherwise it will be an uppercase or lowercase letter for the street. The uppercase letter is for hands where the player faces an all-in that would put them all-in if they call or lowercase if they face an all-in with chips behind.

[DOMIATED89]

What if I put the short stack allin? Aka, i'm not "all-in" and my opponent hasn't put themself all-in.

I want to combine all scenarios together because they are all all-in situations, regardless of how they happen.

[Flag_Hippo]

Do you only want hands that the opponent called? Or do you want to all hands regardless of whether the opponent called or not? If it's the former then you can use this:

Code: Select all

cash_hand_player_statistics.amt_bet_ttl >= cash_hand_player_statistics.amt_p_effective_stack and lookup_actions_p.action NOT LIKE ''

That should give you all of your all-in hands that went to showdown whether you were betting/raising/calling at the point of an all-in and regardless of which player has the largest stack.

[DOMIATED89]

This does not seem to be true. When I use the expression:

Code: Select all

NOT (cash_hand_player_statistics.amt_bet_ttl >= cash_hand_player_statistics.amt_p_effective_stack and lookup_actions_p.action NOT LIKE '')

To test hands outside this parameter. I can see there are still plenty of hands where the last action was before the river and a showdown was seen with a "final hand" (Aka there was an all-in).

[Flag_Hippo]

Ah yes there are some cases where the preflop effective stack isn't necessarily relevant if an all-in occurs on a different street. Instead you can use a filter that compares the relevant amounts on each street:

Code: Select all

cash_hand_player_statistics.flg_showdown and ((cash_hand_player_statistics.amt_bet_p >= cash_hand_player_statistics.amt_p_effective_stack and lookup_actions_p.action NOT LIKE '') OR (cash_hand_player_statistics.amt_bet_f > 0 AND cash_hand_player_statistics.amt_bet_f >= cash_hand_player_statistics.amt_f_effective_stack) OR (cash_hand_player_statistics.amt_bet_t > 0 AND cash_hand_player_statistics.amt_bet_t >= cash_hand_player_statistics.amt_t_effective_stack) OR (cash_hand_player_statistics.amt_bet_r > 0 AND cash_hand_player_statistics.amt_bet_r >= cash_hand_player_statistics.amt_r_effective_stack))

[DOMIATED89]

Hello,

Testing the code with "NOT (xxx)", there are still plenty of all-in situations that haven't been included:

Code: Select all

NOT (cash_hand_player_statistics.flg_showdown and ((cash_hand_player_statistics.amt_bet_p >= cash_hand_player_statistics.amt_p_effective_stack and lookup_actions_p.action NOT LIKE '') OR (cash_hand_player_statistics.amt_bet_f > 0 AND cash_hand_player_statistics.amt_bet_f >= cash_hand_player_statistics.amt_f_effective_stack) OR (cash_hand_player_statistics.amt_bet_t > 0 AND cash_hand_player_statistics.amt_bet_t >= cash_hand_player_statistics.amt_t_effective_stack) OR (cash_hand_player_statistics.amt_bet_r > 0 AND cash_hand_player_statistics.amt_bet_r >= cash_hand_player_statistics.amt_r_effective_stack)))

[DOMIATED89]

With the following code:

Code: Select all

cash_hand_player_statistics.flg_showdown
AND NOT
(cash_hand_player_statistics.val_equity>0 AND
(cash_hand_player_statistics.enum_allin='P' OR ((cash_hand_player_statistics.enum_face_allin='P' OR cash_hand_player_statistics.enum_face_allin='p') AND cash_hand_player_statistics.enum_face_allin_action<>'F')))
AND NOT
(cash_hand_player_statistics.val_equity>0 AND
(cash_hand_player_statistics.enum_allin='F' OR ((cash_hand_player_statistics.enum_face_allin='F' OR cash_hand_player_statistics.enum_face_allin='f') AND cash_hand_player_statistics.enum_face_allin_action<>'F')))
AND NOT
(cash_hand_player_statistics.val_equity>0 AND
(cash_hand_player_statistics.enum_allin='T' OR ((cash_hand_player_statistics.enum_face_allin='T' OR cash_hand_player_statistics.enum_face_allin='t') AND cash_hand_player_statistics.enum_face_allin_action<>'F')))
AND NOT
(cash_hand_player_statistics.val_equity>0 AND
(cash_hand_player_statistics.enum_allin='R' OR ((cash_hand_player_statistics.enum_face_allin='R' OR cash_hand_player_statistics.enum_face_allin='r') AND cash_hand_player_statistics.enum_face_allin_action<>'F')))
AND NOT
(cash_hand_player_statistics.flg_showdown and ((cash_hand_player_statistics.amt_bet_p >= cash_hand_player_statistics.amt_p_effective_stack and lookup_actions_p.action NOT LIKE '') OR (cash_hand_player_statistics.amt_bet_f > 0 AND cash_hand_player_statistics.amt_bet_f >= cash_hand_player_statistics.amt_f_effective_stack) OR (cash_hand_player_statistics.amt_bet_t > 0 AND cash_hand_player_statistics.amt_bet_t >= cash_hand_player_statistics.amt_t_effective_stack) OR (cash_hand_player_statistics.amt_bet_r > 0 AND cash_hand_player_statistics.amt_bet_r >= cash_hand_player_statistics.amt_r_effective_stack)))


There are still some all-in hands listed in the hand report. From the few I have reviewed, it seems the pot size is more than double the effective stack size, due to a 3rd player folding or because of the blinds. But looking at the code provided, it should be the bet size and not pot size that impacts the hands it filter. EIther way, some hands are still absent from the above code

[DOMIATED89]

Is there a way of saying "stack size of any player = 0bb at showdown"?

[Ventilatorrr]

Hello,

If you want to create a stat, then we'll have to think about it and get back to you, as it is a bit tricky, because we can't filter for "any player" in the hand.

If you just want to filter these hands, then you can open a Hand report, go to Filters > Edit Existing Expression Filters, uncheck "Filter on Active Player" and paste the following expression: cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.amt_bet_ttl >= cash_hand_player_statistics.amt_before