Filter bet not-allin turn

[CaioCapT]

I want to see hands of overbet turn (not-allin). I managed that by aplying your original code and then filtering size bet turn > 100% pot on regular filters. If you know a way to filter this directly with a code, I would like to know. Thank you!

[Flag_Hippo]

You can use simple filters like you have done alongside an expression filter but if you want an expression filter for overbetting the turn (not all-in) you can use this:

Code: Select all

cash_hand_player_statistics.val_t_bet_made_pct > 100 and cash_hand_player_statistics.amt_t_bet_made < cash_hand_player_statistics.amt_t_effective_stack

[CaioCapT]

Nice, that worked perfectly! Thank you again!!

[dave2085]

Hi, I am building a stat Fold to Flop Overbet (100-150%pot) NAI (not allin)

this is my expression:

Code: Select all

cash_hand_player_statistics.amt_f_bet_facing > 0
AND (cash_hand_player_statistics.val_f_bet_facing_pct >50 and cash_hand_player_statistics.val_f_bet_facing_pct <=60) AND (lookup_actions_f.action SIMILAR TO '(F|XF)')
AND cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.amt_f_bet_made < cash_hand_player_statistics.amt_f_effective_stack

why is such a hand not filtered out?
Hero is overbetting effective allin on flop.

Poker Hand #RC3287874767: Hold'em No Limit ($0.5/$1) - 2025/01/31 10:28:15
Table 'RushAndCash4516476' 6-max Seat #1 is the button
Seat 1: 4b47a975 ($109.96 in chips)
Seat 2: Hero ($124 in chips)
Seat 3: e5d034e5 ($200.98 in chips)
Seat 4: 7968f0be ($139.94 in chips)
Seat 5: 35f6d5c8 ($68.83 in chips)
Seat 6: 18d1cc9e ($42.5 in chips)
Hero: posts small blind $0.5
e5d034e5: posts big blind $1
*** HOLE CARDS ***
Dealt to 4b47a975
Dealt to Hero [Ad Kd]
Dealt to e5d034e5
Dealt to 7968f0be
Dealt to 35f6d5c8
Dealt to 18d1cc9e
7968f0be: raises $1 to $2
35f6d5c8: folds
18d1cc9e: calls $2
4b47a975: folds
Hero: raises $11 to $13
e5d034e5: folds
7968f0be: folds
18d1cc9e: calls $11
*** FLOP *** [3s 7s Td]
Hero: bets $111 and is all-in
18d1cc9e: folds
Uncalled bet ($111) returned to Hero
*** SHOWDOWN ***
Hero collected $27.26 from pot
*** SUMMARY ***
Total pot $29 | Rake $1.74 | Jackpot $0 | Bingo $0 | Fortune $0 | Tax $0
Board [3s 7s Td]
Seat 1: 4b47a975 (button) folded before Flop (didn't bet)
Seat 2: Hero (small blind) won ($27.26)
Seat 3: e5d034e5 (big blind) folded before Flop
Seat 4: 7968f0be folded before Flop
Seat 5: 35f6d5c8 folded before Flop (didn't bet)
Seat 6: 18d1cc9e folded on the Flop

Code: Select all

cash_hand_player_statistics.amt_f_bet_made < cash_hand_player_statistics.amt_f_effective_stack

This code is not working in this case, is there any extension to that filter?

[Flag_Hippo]

cash_hand_player_statistics.amt_f_bet_made < cash_hand_player_statistics.amt_f_effective_stack

You cant use cash_hand_player_statistics.amt_f_bet_made because this player isn't betting. You need to compare the players effective stack to the size of bet faced:

Code: Select all

cash_hand_player_statistics.amt_f_bet_facing < cash_hand_player_statistics.amt_f_effective_stack