SB Limp- 3bet alin 20-30bb

[mikk86it]

Hi, is correct this stat?

SB limp first in, bb 2bet, SB 3bet allin with stack between 20 and 30 bb

(cnt_p_open_limp_raise_SB_ai_2030 / cnt_p_open_limp_faceraise_SB_20_30bb) * 100


cnt_p_open_limp_raise_SB_ai_2030

sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.position = 9 AND lookup_actions_p.action = 'CR' AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack * .5 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 AND 30, 1, 0])

cnt_p_open_limp_faceraise_SB_20_30bb

sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.position = 9 AND tourney_hand_player_statistics.flg_p_face_raise AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 AND 30, 1, 0])

[Flag_Hippo]

The actions column is fine apart from where you are multiplying tourney_hand_player_statistics.amt_p_effective_stack by 0.5 and for the opportunities column you need to add tourney_hand_player_statistics.flg_p_3bet_opp otherwise you are counting hands where the BB went all-in with their 2bet as an opportunity for the SB to raise all-in when there is none.

[mikk86it]

The actions column is fine apart from where you are multiplying tourney_hand_player_statistics.amt_p_effective_stack by 0.5 and for the opportunities column you need to add tourney_hand_player_statistics.flg_p_3bet_opp otherwise you are counting hands where the BB went all-in with their 2bet as an opportunity for the SB to raise all-in when there is none.

tyty <3