Fold to flop Check Raise

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Fold to flop Check Raise

Postby Hornstar » Thu Oct 08, 2009 5:49 pm

I am not sure if I am missing something but I can't seem to find a stat that shows the % a player folds to a flop check raise.

I have tried constructing one but I am clueless and can't figure it out.

The repository doesn't have one either.

Any help would be most appreciated.
Hornstar
 
Posts: 13
Joined: Sat Jul 05, 2008 3:50 am

Re: Fold to flop Check Raise

Postby WhiteRider » Thu Oct 08, 2009 5:56 pm

I'm pretty sure kraada has that stat in his Advanced HUD Configuration so I'll let him get back to you when he comes on tomorrow.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to flop Check Raise

Postby 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).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests