Cbet And Fold

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

Cbet And Fold

Postby philip77 » Sat Apr 30, 2011 7:42 am

Hi,

I am loking for a stat, for NLH, which is the percentage of folding (Flop, Turn or River), after making a flop CBET. And also folding after calling a Flop Cbet.

Thanks
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am

Re: Cbet And Fold

Postby WhiteRider » Sat Apr 30, 2011 7:50 am

You will need a pair of columns for each - for making the cbet use these:

cnt_f_cbet_fold_later =
sum(if[holdem_hand_player_statistics.flg_f_cbet AND holdem_hand_player_statistics.enum_folded <> 'N', 1, 0])

cnt_f_cbet_fold_later_opp =
sum(if[holdem_hand_player_statistics.flg_f_cbet AND (holdem_hand_player_detail.amt_f_raise_facing + holdem_hand_player_detail.amt_t_bet_facing+holdem_hand_player_detail.amt_t_raise_facing + holdem_hand_player_detail.amt_r_bet_facing+holdem_hand_player_detail.amt_r_raise_facing) > 0, 1, 0])

See the Tutorial: Custom Reports and Statistics for how to build a stat from expressions like these.

For an equivalent stat when you call a c-bet instead of making one, change "holdem_hand_player_statistics.flg_f_cbet" for:
holdem_hand_player_statistics.enum_f_cbet_action='C'
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet And Fold

Postby philip77 » Sat Apr 30, 2011 12:41 pm

Thank you.
But could you explain me, why I need these 2 columns, and how do I combine them.
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am

Re: Cbet And Fold

Postby WhiteRider » Sat Apr 30, 2011 12:55 pm

WhiteRider wrote:See the Tutorial: Custom Reports and Statistics for how to build a stat from expressions like these.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet And Fold

Postby philip77 » Sat Apr 30, 2011 1:32 pm

Thank you.
I think a got it.
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am

Re: Cbet And Fold

Postby concussed » Sat Jun 18, 2011 1:57 pm

WhiteRider wrote:You will need a pair of columns for each - for making the cbet use these:

cnt_f_cbet_fold_later =
sum(if[holdem_hand_player_statistics.flg_f_cbet AND holdem_hand_player_statistics.enum_folded <> 'N', 1, 0])

cnt_f_cbet_fold_later_opp =
sum(if[holdem_hand_player_statistics.flg_f_cbet AND (holdem_hand_player_detail.amt_f_raise_facing + holdem_hand_player_detail.amt_t_bet_facing+holdem_hand_player_detail.amt_t_raise_facing + holdem_hand_player_detail.amt_r_bet_facing+holdem_hand_player_detail.amt_r_raise_facing) > 0, 1, 0])

See the Tutorial: Custom Reports and Statistics for how to build a stat from expressions like these.

For an equivalent stat when you call a c-bet instead of making one, change "holdem_hand_player_statistics.flg_f_cbet" for:
holdem_hand_player_statistics.enum_f_cbet_action='C'


Is my understanding correct....
the first expression is the number of times a player folds sometime in the hand after making a Continuation bet after the flop,
the second expression is number of times a player folds sometime in the hand after re-raising after the flop ?
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Cbet And Fold

Postby WhiteRider » Sat Jun 18, 2011 2:26 pm

concussed wrote:the first expression is the number of times a player folds sometime in the hand after making a Continuation bet after the flop,

Correct.

concussed wrote:the second expression is number of times a player folds sometime in the hand after re-raising after the flop

No - the second expression is the number of times the player makes a c-bet on the flop and then faces some action later in the hand (i.e. has an opportunity to fold).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet And Fold

Postby concussed » Sat Jun 18, 2011 3:15 pm

WhiteRider wrote:
concussed wrote:the first expression is the number of times a player folds sometime in the hand after making a Continuation bet after the flop,

Correct.

concussed wrote:the second expression is number of times a player folds sometime in the hand after re-raising after the flop

No - the second expression is the number of times the player makes a c-bet on the flop and then faces some action later in the hand (i.e. has an opportunity to fold).



Sorry...even more confused now by the difference between the two expressions...
First expression....is it the number of times a player folds on the flop, having made a c-bet and facing a re-raise ?
Second Expression...is it (for example), a player makes a c-bet on the flop, gets called, then after the Turn or River faces a bet, and then folds ?
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Re: Cbet And Fold

Postby WhiteRider » Sat Jun 18, 2011 4:47 pm

The first expression is the "actions" - the number of times it happened. (In this case folding any time in the hand after making a c-bet on the flop)
The second expression is the "opportunities" - the number of times it could have happened. (In this case the opportunity to fold any time in the hand after making a c-bet on the flop)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cbet And Fold

Postby concussed » Sat Jun 18, 2011 5:37 pm

so the stat I need is divide the actions into the opportunities ?
concussed
 
Posts: 38
Joined: Sun May 25, 2008 7:41 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests