I'm trying to create a custom statistic to track how often the BB makes a 3-bet all-in preflop after facing a large raise (2.5BB - 3.5BB) from the SB in a 3-max game.
Scenario:
BTN folds preflop.
SB raises preflop (2.5BB - 3.5BB).
BB shoves all-in (3-bet push).
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_player_statistics.flg_p_3bet
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5
AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack
AND tourney_hand_summary.cnt_players = 3
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_player_statistics.flg_p_3bet
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5
AND tourney_hand_summary.cnt_players = 3
, 1, 0])
