I have this statistic to measure the percentage of times that the big blind folds to a rise from the small blind greater or equal to three big blinds and less than 40% of the effective stack when BU folds or in a heads up situation:
HU FB 17bb+
- Code: Select all
(cnt_hu_p_fold_vs_sb_br_17bb / cnt_hu_p_fold_vs_sb_br_opp_17bb) * 100
cnt_hu_p_fold_vs_sb_br_17bb
- Code: Select all
sum(if[lookup_actions_p.action = 'F' and tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb > 17 and (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb >= 3 and (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_hand_player_statistics.amt_p_effective_stack < 0.4 and tourney_hand_summary.str_aggressors_p LIKE '89%' and tourney_hand_summary.str_actors_p LIKE '9%', 1, 0])
cnt_hu_p_fold_vs_sb_br_opp_17bb
- Code: Select all
sum(if[tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb > 17 and (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb >= 3 and (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_hand_player_statistics.amt_p_effective_stack < 0.4 and tourney_hand_summary.str_aggressors_p LIKE '89%' and tourney_hand_summary.str_actors_p LIKE '9%', 1, 0])
In the next hand the value of this statistic for ArcticTurn9 change from "-(0/0)" to "0(0/1)" and i can't find the why, i raise 2x, this does not meet the condition "(tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb >= 3", Why counts as an opportunity to fold? :
PokerStars Hand #174370707365: Tournament #1998350790, €9.30+€0.70 EUR Hold'em No Limit - Level II (15/30) - 2017/08/15 19:35:01 CET [2017/08/15 13:35:01 ET]
Table '1998350790 1' 3-max Seat #2 is the button
Seat 1: ArcticTurn9 (985 in chips)
Seat 2: nemonik (515 in chips)
nemonik: posts small blind 15
ArcticTurn9: posts big blind 30
*** HOLE CARDS ***
Dealt to nemonik [Kc Qd]
nemonik: raises 30 to 60
ArcticTurn9: raises 120 to 180
nemonik: folds
Uncalled bet (120) returned to ArcticTurn9
ArcticTurn9 collected 120 from pot
ArcticTurn9: doesn't show hand
*** SUMMARY ***
Total pot 120 | Rake 0
Seat 1: ArcticTurn9 (big blind) collected (120)
Seat 2: nemonik (button) (small blind) folded before Flop