by kraada » Fri Oct 09, 2009 8:55 am
Yes, it's there.
The column definitions are as follows:
cnt_f_face_xr:
sum ( if[ flg_f_bet AND holdem_hand_player_statistics.flg_f_face_raise AND (holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position), 1, 0 ] )
cnt_f_face_xr_fold:
sum ( if[ lookup_actions_f.action LIKE 'BF' and holdem_hand_player_statistics.flg_f_face_raise AND (holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position), 1, 0 ] )
You are facing a check/raise on the flop if: (1) you bet the flop, (2) you face a raise and (3) the position of the raiser is further from the button than you are.
There are a few cases which are going to be caught imperfectly - if you are second to act of three players, A checks, you bet, C raises and A 3-bets, that will be caught. But it is a check/raise, even if it's not a "pure" one. In the same scenario if you fold to A's check/3-bet and C shoves and A calls, it won't be caught, but there's little we can do about that at this point. Since this scenario and other multiway 4-bet wars are so rare on the flop, I think this stat will still work quite well (and when the weird spots do come up, they won't count as opportunities or folds, so it won't affect the stat at all).