by kraada » Wed Nov 17, 2010 11:26 am
No but if you have 4bet yourself and you face a 4bet and you fold to it, the bet you face and fold to must be one higher than the bet you made.
You would do it as:
cnt_p_4b_face_5b: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.flg_p_4bet_def_opp and lookup_actions_p.action LIKE 'RR_%', 1, 0])
Here we make sure you 4-bet, you faced a 4-bet. You raised at least twice, then made some other action - you have your initial raise, then your 4-bet, then your reaction to his 5-bet. This will eliminate times where you 4-bet or 5-bet cold, but those should be quite rare, and it's unlikely that you'd do that and then fold regardless.
cnt_p_4bet_face_5b_action_fold: sum(if[holdem_hand_player_statistics.flg_p_4bet and holdem_hand_player_statistics.enum_folded = 'P', 1, 0])
Here we check for any time you 4-bet preflop and later folded preflop. That you folded implies that you faced a 5-bet of some kind.
It's not perfect, but it should be pretty good.