Fold to 3-Bet Push After a Big Raise from SB in 3-Max

[TIGANCIC]

Hi!
I’m having trouble creating a statistic for the following scenario:
Scenario:
SB raises between 2.5 and 3.5 BB.
BB responds with a 3-bet push (all-in).
SB folds to the 3-bet push.
Objective:
Build a statistic to track how often SB folds to a 3-bet push from BB after making a big raise.
Conditions used:
Player is on SB.
The format is 3-max.
SB’s raise size is between 2.5 and 3.5 BB.
BB makes a 3-bet push (all-in).
SB folds to the push.
However, the statistic doesn’t seem to work. There might be an issue with the logic of the filters or conditions related to amt_p_raise_made or amt_p_3bet_facing.

A special thank you to Hippo for your previous guidance! I’d appreciate your input if you could help clarify how to build this statistic for PT4.

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9 
    AND tourney_hand_summary.cnt_players = 3 
    AND tourney_hand_summary.str_actors_p LIKE '9%' 
    AND ((tourney_hand_player_statistics.amt_p_raise_made + (tourney_hand_player_statistics.amt_blind / 2)) / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5
    AND tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.enum_p_3bet_action = 'F' 
, 1, 0])


Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9 
    AND tourney_hand_summary.cnt_players = 3 
    AND tourney_hand_summary.str_actors_p LIKE '9%' 
    AND ((tourney_hand_player_statistics.amt_p_raise_made + (tourney_hand_player_statistics.amt_blind / 2)) / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5 
    AND tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])


[Flag_Hippo]

((tourney_hand_player_statistics.amt_p_raise_made + (tourney_hand_player_statistics.amt_blind / 2)) / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5

You shouldn't be adding the size of the amount of the blind posted by the player. tourney_hand_player_statistics.amt_p_raise_made is the absolute raise size of the first preflop raise made by the player:

Code: Select all

tourney_hand_player_statistics.flg_p_first_raise and (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2.5 AND 3.5

tourney_hand_player_statistics.amt_p_3bet_facing >= tourney_hand_player_statistics.amt_p_effective_stack

As I've mentioned previously the amount faced by the player is the amount needed to call so that's not going to be suitable as the player made the initial 2bet:

Code: Select all

tourney_hand_player_statistics.amt_p_3bet_facing > 0 and (tourney_hand_player_statistics.amt_p_3bet_facing + tourney_hand_player_statistics.amt_p_raise_made) >= tourney_hand_player_statistics.amt_p_effective_stack