stats/hands for different eff stack

[RedRat]

Ok how can i make limping stats in each offered effective stack levels 0-8 bb, 7-13 bb,... ? I am playing hu sng tournaments

Hey Minotaurs!

Try this:

Columns:

cnt_p_limp_sb_12_18:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_positions.flg_sb AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 18, 1, 0])

cnt_p_limp_opp_sb_12_18:

Code: Select all

sum( if[ (NOT(tourney_hand_player_statistics.flg_p_face_raise) OR (tourney_hand_player_statistics.flg_p_limp) OR (tourney_hand_player_statistics.flg_p_first_raise)) AND NOT(tourney_hand_player_statistics.flg_blind_b) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 18, 1 , 0 ] )

Stat:

Preflop Limp SB 12-18Bbb

Code: Select all

(cnt_p_limp_SB_12_18 / cnt_p_limp_opp_SB_12_18) * 100

I think, you'll be able to change the code for the big blind and other effective stack sizes on your on