PokerTracker

Fold on a push after isolate 2 max
sb limp
bb isolate
sb push
bb fold

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8
    AND  tourney_hand_summary.cnt_players = 2
    AND  tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND  (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2 AND 3.5
    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
    AND lookup_actions_p.action = '%F%', 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8
    AND  tourney_hand_summary.cnt_players = 2
    AND  tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND  (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2 AND 3.5
    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', 1, 0])

what's wrong?

Looks like I found a mistake. I need to replace AND lookup_actions_p.action = '%F%' on
AND tourney_hand_player_statistics.enum_p_3bet_action = 'F'

Yeah, using tourney_hand_player_statistics.enum_p_3bet_action = 'F' looks correct. I guess you could also use lookup_actions_p.action = 'RF' instead.