by DJSpinThat » Mon Oct 18, 2021 11:23 pm
Thank you Hippo.
I summed it up, looks ok?
1. 3H. BU fold. SB limp. BB iso up to 4x. SB Folds. Eff stack between 10-12bb.
Preflop Limp Fold_SB=<4x_10to12bb
(cnt_p_limp_fold_SB_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100
cnt_p_limp_fold_SB_4x_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 AND
tourney_hand_summary.str_actors_p LIKE '9%' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 AND
lookup_actions_p.action = 'CF', 1, 0])
cnt_p_limp_faceraise_4x_10to12bb:
sum(if[tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 AND
tourney_hand_player_statistics.position = 9 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 AND
tourney_hand_player_statistics.flg_p_limp, 1, 0])
2. 3H. BU fold. SB limp. BB iso up to 4x. SB calls. Eff stack between 10-12bb.
Preflop Limp Call_SB=<4x_10to12bb
(cnt_p_limp_call_SB_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100
cnt_p_limp_call_SB_4x_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 AND
lookup_actions_p.action LIKE 'CC%', 1, 0])
3. 3H. BU fold. SB limp. BB iso up to 4x. SB shoves. Eff stack between 10-12bb.
Preflop Limp Shove_SB=<4x_10to12bb:
(cnt_p_limp_shove_SB_4x_10to12bb / cnt_p_limp_faceraise_4x_10to12bb) * 100
cnt_p_limp_shove_SB_4x_10to12bb:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb between 1 and 3 AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 and 12 AND
(tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack) AND tourney_hand_summary.str_actors_p LIKE '9%' AND
lookup_actions_p.action LIKE 'CR%', 1, 0])