Help with Custom Stat: Fold to SB Open Push as BB in 3-Max

[TIGANCIC]

The scenario is as follows:
BTN folds.
SB open pushes (all-in).
BB faces the push and folds.
Here's what I have so far for the column to count folds to an SB open push:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_facing >= tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.flg_p_fold
    AND tourney_hand_summary.cnt_players = 3
, 1, 0])


For counting all instances of facing an open push from the SB:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_facing >= tourney_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_summary.cnt_players = 3
, 1, 0])


[Flag_Hippo]

If the shove is a 2bet you should be using tourney_hand_player_statistics.amt_p_2bet_facing and the amount faced is the amount the player needs to call so you need to add tourney_hand_player_statistics.amt_blind before comparing it to the effective stack. We have covered this before here.

[TIGANCIC]

Thank you, and sorry, I'm glitching. The answer was obviously right in front of me.

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    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_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_player_statistics.flg_p_fold
    AND tourney_hand_summary.cnt_players = 3
, 1, 0])


Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    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_hand_player_statistics.amt_p_effective_stack
    AND tourney_hand_summary.cnt_players = 3
, 1, 0])


[Flag_Hippo]

No problem. One other thing to note is that tourney_hand_player_statistics.flg_p_fold will be true whenever the player folds preflop so if they 3bet and fold to a 4bet then that would be counted too. Using lookup_actions_p.action = 'F' would be more accurate as this means the player folded with their first preflop action.