Flop Cbet % in 3bet Pots

[swizz]

Hello,

i found the stat Turn Cbet % in 3bet Pots in the repository.
It is defindes by

(cnt_t_cbet_3b_pot / cnt_t_cbet_opp_3b_pot) * 100

with
cnt_t_cbet_3b_pot
sum(if[holdem_hand_player_statistics.flg_t_cbet and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])

cnt_t_cbet_opp_3b_pot
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])

Am i right, that...
cnt_t_cbet_opp_3b_pot shows, how often a player 3bet preflop, got called, made a cbet on the Flop, got called an now have the opportunity to make a Turn cbet.
cnt_t_cbet_3b_pot shows, how often a player 3bet preflop, got called, made a cbet on the Flop, got called and made a cbet on the Turn?

In the repository i found this stat for Turn und River. What do i have to change to get the same stat for the Flop?

[kraada]

Yes, but one other note: those columns in particular also eliminate the chance for a 4bet pot - it's exactly 3bet pots only.

Change them as follows to make the flop version:

cnt_f_cbet_3b_pot
sum(if[holdem_hand_player_statistics.flg_f_cbet and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])

cnt_t_cbet_opp_3b_pot
sum(if[holdem_hand_player_statistics.flg_f_cbet_opp and (holdem_hand_player_statistics.flg_p_3bet or holdem_hand_player_statistics.flg_p_3bet_def_opp) AND NOT (holdem_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])

I didn't change the overall structure so you could find the exact change that I made. However, the stats as built are a bit redundant - since we're not allowing Hero to 4bet or face a 4bet, and Hero is cbetting, Hero cannot have faced a 3bet either, so the following columns are actually logically equivalent to the ones above:

cnt_f_cbet_3b_pot
sum(if[holdem_hand_player_statistics.flg_f_cbet and holdem_hand_player_statistics.flg_p_3bet AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

cnt_t_cbet_opp_3b_pot
sum(if[holdem_hand_player_statistics.flg_f_cbet_opp and holdem_hand_player_statistics.flg_p_3bet AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

[bryanclark]

kraada what am i doing wrong? i built the columns just like you have them below

cnt_f_cbet_3b_pot
sum(if[holdem_hand_player_statistics.flg_f_cbet and holdem_hand_player_statistics.flg_p_3bet AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

then updated cache
then went to build a stat

(cnt_f_cbet_3b_pot / cnt_f_cbet_opp_3b_pot) * 100

and it comes up as invalid
am i missing something

[WhiteRider]

Have you created the "cnt_f_cbet_opp_3b_pot" column too?
You will need to have both columns before you can create the stat.

[bryanclark]

that was the problem. thanks