BVB Limped - BX2 + Bet-fold Turn Stat

[ontheway]

Hi, I'm trying to gain better visibility on BVB spots, either limped or SRP. For now I'm trying to create a stat where, the hand started three handed preflop (for spins), it's two handed on the flop (BVB), we're BB and in position (i set this up later in hud profiles), and the pot was limped. On the flop the action was SB check, BB bet, SB call. Turn now I'm trying to see how often BB bet-fold in this spot but it seems the stat isn't picking up all the hands.

My stat is like this:
(cnt_f_bet_limp_pot_hu_t_2bet_def_action_fold / cnt_f_bet_limp_pot_hu_t_3bet_opp) * 100


cnt_f_bet_limp_pot_hu_t_2bet_def_action_fold
sum(if[tourney_hand_player_statistics.flg_f_bet and NOT(tourney_hand_player_statistics.flg_p_face_raise) and NOT(tourney_hand_player_statistics.flg_f_face_raise) and tourney_hand_player_statistics.cnt_p_raise = 0 AND tourney_hand_summary.cnt_players_f = 2 AND tourney_hand_player_statistics.flg_t_face_raise AND ((tourney_hand_player_statistics.amt_t_bet_facing = 0 AND lookup_actions_t.action SIMILAR TO '(F|XF|BF)%') OR (tourney_hand_player_statistics.amt_t_bet_facing > 0 AND lookup_actions_t.action SIMILAR TO '(XCF|CF)')), 1, 0])

cnt_f_bet_limp_pot_hu_t_3bet_opp
sum(if[tourney_hand_player_statistics.flg_f_bet and NOT(tourney_hand_player_statistics.flg_p_face_raise) and NOT(tourney_hand_player_statistics.flg_f_face_raise) and tourney_hand_player_statistics.cnt_p_raise = 0 AND tourney_hand_summary.cnt_players_f = 2 AND tourney_hand_player_statistics.flg_t_face_raise, 1, 0])

Any ideas? I used tourney_hand_player_statistics.flg_t_face_raise instead of tourney_hand_player_statistics.flg_t_3bet_opp because I want to include the XRAI as well.

[Flag_Hippo]

the hand started three handed preflop (for spins)

That's not specified in your expressions:

Code: Select all

tourney_hand_summary.cnt_players = 3

it's two handed on the flop (BVB), we're BB and in position (i set this up later in hud profiles)

In the examples below I will be specifying the players preflop and postflop position.

the pot was limped. On the flop the action was SB check, BB bet, SB call.

You can just use:

Code: Select all

tourney_hand_summary.str_aggressors_p LIKE '8' and lookup_actions_f.action = 'B'

If the players flop action was to only bet without any further actions then they wouldn't have faced a raise. Also if the player had turn actions which will also be specified then the flop bet wasn't all-in.

Turn now I'm trying to see how often BB bet-fold in this spot

((tourney_hand_player_statistics.amt_t_bet_facing = 0 AND lookup_actions_t.action SIMILAR TO '(F|XF|BF)%') OR (tourney_hand_player_statistics.amt_t_bet_facing > 0 AND lookup_actions_t.action SIMILAR TO '(XCF|CF)'))

If the player is bet-folding the turn then there is no need to test for them facing a bet or having any turn action that isn't specifically 'BF'. For the opportunities column you can just specify that they made a turn bet and took at least one other turn action which means they must have faced a raise.

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.cnt_players = 3 and tourney_hand_summary.str_aggressors_p LIKE '8' and tourney_hand_summary.cnt_players_f = 2 and tourney_hand_player_statistics.flg_f_has_position and lookup_actions_f.action = 'B' and lookup_actions_t.action = 'BF', 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 and tourney_hand_summary.cnt_players = 3 and tourney_hand_summary.str_aggressors_p = '8' and tourney_hand_summary.cnt_players_f = 2 and tourney_hand_player_statistics.flg_f_has_position and lookup_actions_f.action = 'B' and lookup_actions_t.action LIKE 'B_%', 1, 0])