Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by DOMIATED89 » Thu Jul 18, 2024 6:56 am
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?
-
DOMIATED89
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by Flag_Hippo » Thu Jul 18, 2024 12:34 pm
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.
-
Flag_Hippo
- Moderator
-
- Posts: 15123
- Joined: Tue Jan 31, 2012 7:50 am
by DOMIATED89 » Thu Jul 18, 2024 1:11 pm
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.
-
DOMIATED89
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by Flag_Hippo » Fri Jul 19, 2024 6:35 am
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.
-
Flag_Hippo
- Moderator
-
- Posts: 15123
- Joined: Tue Jan 31, 2012 7:50 am
by DOMIATED89 » Fri Jul 19, 2024 7:44 am
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).
-
DOMIATED89
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by Flag_Hippo » Fri Jul 19, 2024 8:13 am
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))
-
Flag_Hippo
- Moderator
-
- Posts: 15123
- Joined: Tue Jan 31, 2012 7:50 am
by DOMIATED89 » Sat Jul 20, 2024 10:25 am
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
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by DOMIATED89 » Sat Jul 20, 2024 10:41 am
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
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by DOMIATED89 » Sat Jul 20, 2024 10:50 am
Is there a way of saying "stack size of any player = 0bb at showdown"?
-
DOMIATED89
-
- Posts: 36
- Joined: Sat Jun 29, 2024 3:52 am
by Ventilatorrr » Sun Jul 21, 2024 7:16 am
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
-
Ventilatorrr
- Moderator
-
- Posts: 50
- Joined: Sun Jul 19, 2015 12:39 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 10 guests