Page 1 of 1

Custom Stat: SB Flop Bet vs BB (Limp Pot)

PostPosted: Sat Jun 04, 2022 8:45 am
by 8Texman9
Hey guys,

I've created a custom stat for the situation SB limps first in, BB checks back and SB bets on the flop.

SBvBB Bet F (limp pot):
(cnt_f_bet_limp_pot_sb / cnt_f_open_opp_limp_pot_sb) * 100

cnt_f_bet_limp_pot_sb:
sum(if[tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND NOT(tourney_hand_player_statistics.flg_p_face_raise)
AND tourney_hand_player_statistics.flg_f_bet, 1,0])

cnt_f_open_opp_limp_pot_sb:
sum(if[tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND NOT(tourney_hand_player_statistics.flg_p_face_raise), 1,0])

Edit: Planned to filter for "SB" in Item Properties, to only show the situations where SB limps first in.

Could someone please check if this exactly mirrors my situation stated above?

Thanks

Re: Custom Stat: SB Flop Bet vs BB (Limp Pot)

PostPosted: Sat Jun 04, 2022 1:02 pm
by Flag_Hippo
That's fine but for the opportunities column you should also add tourney_hand_player_statistics.flg_f_open_opp otherwise the column can count hands where there was no opportunity to bet the flop. While that cannot happen if the SB open limps multiway as they will always be first to act in that scenario it will not work correctly if the SB limps in a heads up hand where will they will be acting second postflop or if you are going to use it for other positions when multiway.

Re: Custom Stat: SB Flop Bet vs BB (Limp Pot)

PostPosted: Tue Jun 28, 2022 7:07 am
by 8Texman9
Flag_Hippo wrote:That's fine but for the opportunities column you should also add tourney_hand_player_statistics.flg_f_open_opp otherwise the column can count hands where there was no opportunity to bet the flop. While that cannot happen if the SB open limps multiway as they will always be first to act in that scenario it will not work correctly if the SB limps in a heads up hand where will they will be acting second postflop or if you are going to use it for other positions when multiway.


Thanks for the info, I've added the mentioned part to the expression.

I would like to check another Stat for the situation where BB is facing an openlimp from SB, checks back and folded to a "cbet" on the flop.

BBvSB Fold to F Bet (limp Pot):
(cnt_f_bet_limp_pot_bbvsb / cnt_f_limp_pot_opp_bbvsb) * 100

cnt_f_bet_limp_pot_bbvsb:
sum(if[tourney_hand_player_statistics.flg_blind_b
AND tourney_hand_summary.str_actors_p LIKE '9'
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND (lookup_actions_f.action SIMILAR TO '(F|XF)'), 1, 0])

cnt_f_limp_pot_opp_bbvsb:
sum(if[tourney_hand_player_statistics.flg_blind_b
AND tourney_hand_summary.str_actors_p LIKE '9'
AND tourney_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

Will this work for the situation above?

Thanks

Re: Custom Stat: SB Flop Bet vs BB (Limp Pot)

PostPosted: Tue Jun 28, 2022 10:25 am
by Flag_Hippo
That will work.