PokerTracker

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])


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])


TIGANCIC wrote: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.

TIGANCIC wrote: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.

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

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])

TIGANCIC wrote: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.

TIGANCIC wrote: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.

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])


TIGANCIC wrote: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.

TIGANCIC wrote: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.

"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])

TIGANCIC wrote:"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'.