Verification of C-Bet Stats for Limped and Raised Pots

[TIGANCIC]

Hi,
I want to verify if my c-bet statistics for limped and raised pots are correct.
C-Bets in Limped Pots
I used standard PokerTracker 4 columns as a base:
Flop:
cnt_f_bet_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and
tourney_hand_player_statistics.cnt_p_raise = 0, 1, 0])


cnt_f_open_opp_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_open_opp and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and
tourney_hand_player_statistics.cnt_p_raise = 0, 1, 0])


Turn (based on flop stats):
cnt_t_bet_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_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, 1, 0])


cnt_t_open_opp_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_open_opp 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, 1, 0])


River (based on flop stats):
cnt_r_bet_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_bet and
tourney_hand_player_statistics.flg_r_bet and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and 
NOT(tourney_hand_player_statistics.flg_f_face_raise) and
NOT(tourney_hand_player_statistics.flg_t_face_raise) and 
tourney_hand_player_statistics.cnt_p_raise = 0, 1, 0])


cnt_r_open_opp_limp_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_bet and
tourney_hand_player_statistics.flg_r_open_opp and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and 
NOT(tourney_hand_player_statistics.flg_f_face_raise) and
NOT(tourney_hand_player_statistics.flg_t_face_raise) and 
tourney_hand_player_statistics.cnt_p_raise = 0, 1, 0])


C-Bets in Raised Pots
I adapted the above logic for raised pots:
Flop:
cnt_f_bet_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and
tourney_hand_player_statistics.cnt_p_raise = 1, 1, 0])


cnt_f_open_opp_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_open_opp and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and
tourney_hand_player_statistics.cnt_p_raise = 1, 1, 0])


Turn:
cnt_t_bet_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_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 = 1, 1, 0])


cnt_t_open_opp_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_open_opp 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 = 1, 1, 0])


River:
cnt_r_bet_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_bet and
tourney_hand_player_statistics.flg_r_bet and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and 
NOT(tourney_hand_player_statistics.flg_f_face_raise) and
NOT(tourney_hand_player_statistics.flg_t_face_raise) and 
tourney_hand_player_statistics.cnt_p_raise = 1, 1, 0])


cnt_r_open_opp_raise_pot

Code: Select all

sum(if[tourney_hand_player_statistics.flg_f_bet and
tourney_hand_player_statistics.flg_t_bet and
tourney_hand_player_statistics.flg_r_open_opp and
NOT(tourney_hand_player_statistics.flg_p_face_raise) and 
NOT(tourney_hand_player_statistics.flg_f_face_raise) and
NOT(tourney_hand_player_statistics.flg_t_face_raise) and 
tourney_hand_player_statistics.cnt_p_raise = 1, 1, 0])


Are these formulas correct for calculating c-bet frequencies in limped and raised pots?
Did I miss any important conditions?

Thanks for your help!

[Flag_Hippo]

That looks fine assuming you only want single raised pots for the raised pot columns.