Fold to Flop C-Bet After Preflop Raise – BB vs SB in 3-Max

[TIGANCIC]

Hi,

I'm trying to create a custom statistic to track how often the BB folds to a flop c-bet after calling a preflop raise from the SB in a 3-max game.

The scenario is as follows:

BTN folds preflop.
SB raises preflop.
BB calls the raise.
SB c-bets on the flop.
BB folds to the c-bet.
Here's what I have so far for counting folds to a c-bet:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND tourney_hand_player_statistics.enum_f_cbet_action = 'F'
, 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_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND tourney_hand_player_statistics.flg_f_cbet_def_opp
, 1, 0])


[TIGANCIC]

And an additional question: if we want a statistic for folding on the turn after calling on the flop, do we add...?

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND tourney_hand_player_statistics.enum_f_cbet_action = 'C'
    AND tourney_hand_player_statistics.enum_t_cbet_action = 'F'
, 1, 0])


and river

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
    AND tourney_hand_player_statistics.enum_f_cbet_action = 'C'
    AND tourney_hand_player_statistics.enum_t_cbet_action = 'C'
    AND tourney_hand_player_statistics.enum_r_cbet_action = 'F'
, 1, 0])


[Flag_Hippo]

Here's what I have so far for counting folds to a c-bet:

That is OK but bear in mind that if the BB ever faces to a cbet in a 4bet pot in these games then that would be counted too since these columns do not restrict the hand to a single raised pot. You also don't need tourney_hand_player_statistics.flg_p_face_raise since you've already specified that the BB is facing a preflop 2bet of a specific size.

And an additional question: if we want a statistic for folding on the turn after calling on the flop, do we add...?

Yes that is fine.

[TIGANCIC]

Is there another solution for this stat? For some players, the river is not showing up for some reason.

[TIGANCIC]

A similar stat, but for a preflop limp. What's wrong?

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.enum_f_cbet_action = 'F'
, 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_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.flg_f_cbet_def_opp
, 1, 0])

[Flag_Hippo]

Is there another solution for this stat? For some players, the river is not showing up for some reason.

Try rebuilding your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild' otherwise please provide a more detailed explanation of "For some players, the river is not showing up for some reason" and an example hand history.

A similar stat, but for a preflop limp. What's wrong?

It's not possible for the player to face a cbet in a limped pot. Cbets can only be made/faced in raised pots.

[TIGANCIC]

Is this version okay?

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND lookup_actions_f.action = 'F'
, 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_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0
    AND (lookup_actions_f.action SIMILAR TO '(F|С)')
, 1, 0])


[Flag_Hippo]

AND tourney_hand_summary.str_actors_p LIKE '9%'

This means the SB was the first player to VPIP (call OR raise) so this is going to include raised pots as well. You were using tourney_hand_player_statistics.cnt_p_face_limpers = 1 to establish the limp in your original example but you have now removed it for some reason.

AND (lookup_actions_f.action SIMILAR TO '(F|С)')

With this you are not counting flop raises which are also an opportunity to fold (and raises can have subsequent preflop actions). You don't even need to use lookup_actions_f.action in this column anyway - you just need to know that they faced a flop bet and the specific flop actions the BB takes doesn't matter.

[TIGANCIC]

"But I'm getting an error, and I don't know why."

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
    AND tourney_hand_player_statistics.amt_p_raise_made = 0
    AND tourney_hand_player_statistics.amt_f_bet_facing > 0 
    AND tourney_hand_player_statistics.enum_f_action = 'F' 
, 1, 0])

[Flag_Hippo]

"But I'm getting an error, and I don't know why."

Code: Select all

tourney_hand_player_statistics.enum_f_action = 'F'

tourney_hand_player_statistics.enum_f_action does not exist in the PokerTracker 4 database schema. Change that back to what you were using before - lookup_actions_f.action = 'F'.