filter out cold4bets

Posted:
Tue Nov 14, 2023 8:40 pm
by maggu5
Would appreciate help to remove cold4bets in this stat. Also open to ideas to do the same via Tournament filters
Re: filter out cold4bets

Posted:
Wed Nov 15, 2023 1:01 am
by maggu5
Could there be a way to alternate this one
Re: filter out cold4bets

Posted:
Wed Nov 15, 2023 2:02 am
by maggu5
sum(if[ char_length(tourney_hand_summary.str_aggressors_p) >= 4 AND substring(tourney_hand_summary.str_aggressors_p from 4 for 1)::int = substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int AND tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])
:heart:
Re: filter out cold4bets

Posted:
Thu Nov 16, 2023 9:14 am
by Flag_Hippo
- Code: Select all
char_length(tourney_hand_summary.str_aggressors_p) >= 4 AND substring(tourney_hand_summary.str_aggressors_p from 4 for 1)::int = substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int
That's correct. This means that the player who made the 4bet also made the 2bet so it wouldn't include cold 4bets. For more information
this post has information on how the actors and aggressors strings work while
this thread and
this thread discuss how you can compare/test the strings.