Call any Flop bet & fold to turn bet

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

Call any Flop bet & fold to turn bet

Postby paradigm24 » Fri Apr 29, 2011 8:58 pm

I'm interested in creating a stat for the percentage of time villian calls a bet on the flop and then fold to a bet on the turn. Similar to a fold to T cbet except regardless of the pf aggressor and regardless of the bet type. Thanks for your help in advance.
paradigm24
 
Posts: 35
Joined: Tue Dec 21, 2010 3:15 am

Re: Call any Flop bet & fold to turn bet

Postby WhiteRider » Sat Apr 30, 2011 4:31 am

The simple version would be with a couple of columns like this:

cnt_f_call_bet_t_fold_bet =
sum(if[holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%') AND holdem_hand_player_detail.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%'), 1, 0])

..based on the built-in columns "cnt_f_bet_def_action_call" and "cnt_t_bet_def_action_fold", and..

cng_f_call_bet_t_face_bet =
sum(if[holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(C|XC)%') AND holdem_hand_player_detail.amt_t_bet_facing > 0, 1, 0])

Add a stat to divide one by the other (*100).
See the Tutorial: Custom Reports and Statistics for help building a stat from these expressions.

These purely count bets faced/called - if you want to exclude hands where there is further action on the flop (such as if the player calls and then is raised behind) let me know and we can extend the expressions.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Call any Flop bet & fold to turn bet

Postby paradigm24 » Sun May 01, 2011 1:01 am

Thanks for the quick response. Worked great.
paradigm24
 
Posts: 35
Joined: Tue Dec 21, 2010 3:15 am

Re: Call any Flop bet & fold to turn bet

Postby WhiteRider » Sun May 01, 2011 4:06 am

No problem - thanks for letting me know. :)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests