btn preflop (only) raise

[payforview]

Hi, I would create a stat for spin&go from btn that show me only pf raise action, excluding limp, openshove and 4bet. So oppo is the first player to play and he must raise preflop equal or more than x2 without shove.

Can you help me to create this stat?
thx

[payforview]

Maybe solved using att to steal filtered by position

[payforview]

I think that openshove is included in att to steal (can you confirm it?), so I have to exclude it.

((cnt_steal_att_10_20 / cnt_steal_opp_10_20)-(cnt_p_open_shove_10_20 / cnt_p_open_opp_10_20)) * 100

is this formula correct? att to steal minus open shove

[Flag_Hippo]

Those are custom columns so I don't know the expressions for them. Furthermore the 10-20 in the naming implies that it is also based on stack size which you haven't specified in this thread so far. If this is not based on stack size you can just use the built-in statistic as the basis for a new statistic but to specify that the steal wasn't a shove then this information needs to be added to the steal column:

Code: Select all

tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack

[payforview]

yes it is based on stack size between 10 and 20bb

for cnt_steal_att_10_20:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_att and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 10 and 19.99, 1, 0])

for cnt_steal_opp_10_20:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 10 and 19.99, 1, 0])

for cnt_p_open_shove_10_20:

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 10 and 19.99, 1, 0])

for cnt_p_open_opp_10_20:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 10 and 19.99, 1, 0])

[Flag_Hippo]

If you are going to do it that way you would need to use:

Code: Select all

((cnt_steal_att_10_20 - cnt_p_open_shove_10_20) / cnt_steal_opp_10_20) * 100

or if you want it displayed as a ratio vs number of shoves then:

Code: Select all

((cnt_steal_att_10_20 - cnt_p_open_shove_10_20) / cnt_p_open_shove_10_20) * 100