Fold to a flop raise after making a bet

[PeteX]

I want to make a stat showing the % player folds on the flop to a raise but ONLY when he has made a bet. So it doesn't count if there is a bet then raise and then next player folds before acting at all.

Just to confirm, is this correct:
sum(if[cash_hand_player_statistics.flg_f_3bet_opp AND cash_hand_player_statistics.flg_f_bet AND cash_hand_player_statistics.flg_f_fold, 1, 0])

divided by

sum(if[cash_hand_player_statistics.flg_f_3bet_opp AND cash_hand_player_statistics.flg_f_bet, 1, 0])

There is already a built-in stat "Fold to F 2Bet" that would include these cases but as far as I can tell, it seems to also take into account the cases where a player has not yet afted on the flop but folds to a raise that someone made before him and I want to exclude such cases.

So obviously I'm looking for information about how easy it is to make a player fold specifically by raising his flop bet. The betting could go me check - villain bet - me raise -> villain folds. Or just villain bet - me raise -> villain fold. Both cases should be covered by this stat but I don't think I need to differentiate between them.

[PeteX]

Ok, I think I forgot to take possible reraises into account so how about this:

sum(if[cash_hand_player_statistics.flg_f_3bet_opp
AND cash_hand_player_statistics.flg_f_bet
AND cash_hand_player_statistics.flg_f_fold
AND cash_hand_player_statistics.cnt_f_raise = 0
AND cash_hand_player_statistics.cnt_f_call = 0, 1, 0])

divided by

sum(if[cash_hand_player_statistics.flg_f_3bet_opp AND cash_hand_player_statistics.flg_f_bet, 1, 0])

So this would exclude the BRF-cases that the previous condition would not. And I guess there is a possibility to have a call somewhere in there as well... So I guess the same would be achieved just with lookup_actions_f.action = 'BF' on the first formula, as Bet-Fold is really the patternt we are interested in.

[PeteX]

Ok, final version:

sum(if[cash_hand_player_statistics.flg_f_3bet_opp AND lookup_actions_f.action = 'BF', 1, 0])
divided by
sum(if[cash_hand_player_statistics.flg_f_3bet_opp AND cash_hand_player_statistics.flg_f_bet, 1, 0])

Am I missing some scenario there?

[WhiteRider]

That's pretty good!
The only minor complication would be if the raise was for more than the player's remaining stack, in which case they wouldn't have a 3Bet opportunity. I guess it may be OK to exclude those hands since that would be a somewhat different situation anyway, but if you do want to include them then you could replace the 3bet-opp with this:

cash_hand_player_statistics.amt_f_2bet_facing > 0

..which says that the player faced a 2bet (if they didn't face a 2bet then the value would be 0).