Fold Flop to Flop Raise after making CBet percentage?

[el_hombre]

Hi,
i need a stat wich shows the percentage a player folded the flop after making a continuation bet but then faced a raise from another player.
How can i create such a stat? I think i have an idea how to do this: i just have to take the "fold flop to raise percentage" stat, but reduce the opportunity base to these cases where the player made a continuation bet.

[WhiteRider]

This should be pretty straightforward.
There is a Column to record c-bets, and if you add the DB field for fold on the flop:
cnt_f_cbet = sum(if[holdem_hand_player_statistics.flg_f_cbet, 1, 0])
holdem_hand_player_statistics.flg_f_fold

so, this should do it for you:
cnt_f_cbet_fold = sum(if[holdem_hand_player_statistics.flg_f_cbet AND holdem_hand_player_statistics.flg_f_fold, 1, 0])

You'll need to build a count of opportunities Column too, but I'll leave that for you to try.

Custom Statistics and Reports FAQ.

[el_hombre]

Ok but f i only combine the flop cbet count with the fold flop count i include the cases the cbetter folds to a 3bet (maybe in a 3 handed flop and the player after the raiser 3 bets [coldcaller are ok but 3better are not]) and the cases the cbetter 3bets after the raise but then folds after a cap.

if you just could confirm this, i think i can do the corrections by myself.

[WhiteRider]

OK, so you'll have to check for not facing a 3-bet on the flop too.
There is a DB field for this too.
holdem_hand_player_statistics.flg_f_3bet_def_opp
holdem_hand_player_statistics.flg_f_4bet_def_opp
There is also
holdem_hand_player_statistics.enum_f_3bet_action, which will be F, C, or R (fold call raise)