new: Fold to Push after CBetRaise (3BP)

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

new: Fold to Push after CBetRaise (3BP)

Postby js2002 » Sun Apr 12, 2009 5:36 am

js2002_cnt_p_3bet_f_cbet_and_allin_def_action_fold
sum(if[ holdem_hand_player_statistics.cnt_p_raise > 0 AND
holdem_hand_player_statistics.flg_p_3bet_def_opp AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND
holdem_hand_player_statistics.enum_f_cbet_action='R' AND
holdem_hand_player_statistics.enum_face_allin='F' AND
holdem_hand_player_statistics.enum_face_allin_action='F'
, 1 , 0 ])

js2002_cnt_p_3bet_f_cbet_and_allin_def_opp
sum(if[ holdem_hand_player_statistics.cnt_p_raise > 0 AND
holdem_hand_player_statistics.flg_p_3bet_def_opp AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND
holdem_hand_player_statistics.enum_f_cbet_action='R' AND
holdem_hand_player_statistics.enum_face_allin='F'
, 1 , 0 ])

Can u check that please?
Villian raises a CBet in 3bet pot, faces a flop allin and reacts with fold, ok?!

oh: I forgot holdem_hand_player_statistics.enum_f_cbet_action='R' in the denumerator....
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new: Fold to Push after CBetRaise (3BP)

Postby WhiteRider » Sun Apr 12, 2009 6:16 am

That looks pretty good, but I think your preflop conditions may be a little restrictive (maybe even incorrect).

You currently have it as the player raises preflop and faces (specifically) a 3-bet, then makes a c-bet on the flop.
This means that they must have 4-bet (or 5- or 6-bet) preflop to be the preflop aggressor. They can't make a flop c-bet if they weren't the last to raise preflop.
So you won't get cases where the player faced a single raise and then 3-bet; then c-bet the flop.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new: Fold to Push after CBetRaise (3BP)

Postby js2002 » Sun Apr 12, 2009 6:25 am

WhiteRider wrote:That looks pretty good, but I think your preflop conditions may be a little restrictive (maybe even incorrect).

You currently have it as the player raises preflop and faces (specifically) a 3-bet, then makes a c-bet on the flop.
This means that they must have 4-bet (or 5- or 6-bet) preflop to be the preflop aggressor. They can't make a flop c-bet if they weren't the last to raise preflop.
So you won't get cases where the player faced a single raise and then 3-bet; then c-bet the flop.



hehe, drink less alcohol and read the stat again, preflop is all correct.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new: Fold to Push after CBetRaise (3BP)

Postby WhiteRider » Sun Apr 12, 2009 8:20 am

Cheeky! It's a bit early to be boozing..

holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_3bet_def_opp
..says that the player raised and faced a 3-bet.

If that's the only case you want to check for then it's correct.
However, this won't count any cases where the player 3-bets, or faces a 4- (or 5-) bet instead of a 3-bet.

If the player raises and faces a 3-bet (and doesn't 4-bet) then they won't be the preflop aggressor, so won't be able to c-bet the flop.

If the player faces a raise (2-bet) and 3-bets, then c-bets the flop (which I think is the case you want) then your column won't count that (because they didn't face a 3-bet).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new: Fold to Push after CBetRaise (3BP)

Postby js2002 » Sun Apr 12, 2009 8:41 am

WhiteRider wrote:Cheeky! It's a bit early to be boozing..

holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_3bet_def_opp
..says that the player raised and faced a 3-bet.

If that's the only case you want to check for then it's correct.
However, this won't count any cases where the player 3-bets, or faces a 4- (or 5-) bet instead of a 3-bet.

If the player raises and faces a 3-bet (and doesn't 4-bet) then they won't be the preflop aggressor, so won't be able to c-bet the flop.

This stat is for the non PFA ! So I shall count: Villian makes a pfr, gets 3betted, just calls this (didnt catch this but I dont have to because of the following columns), so he´s the non-PFA and faced a CBet and raises it and faces a allin and folds to it.

If the player faces a raise (2-bet) and 3-bets, then c-bets the flop (which I think is the case you want) then your column won't count that (because they didn't face a 3-bet).

Again, CBet Raise is only possible when he the non PFA. That was the reason why I made the alc joke
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new: Fold to Push after CBetRaise (3BP)

Postby WhiteRider » Sun Apr 12, 2009 9:01 am

Sorry, you're right - I was reading it as if the active player was making the c-bet.
I still think you might want to check for 4-bet pots preflop, though; or do you want it to be for specifically 3-bet only pots?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new: Fold to Push after CBetRaise (3BP)

Postby js2002 » Sun Apr 12, 2009 9:10 am

for 3 only, because, if somebody calls my 4bet and raises my cbet its ok ;)

or is it easily build?

f.e. if I check "face 4bet" I get even face 5-x Bet", because the 4bet is defined like that in pt3

another question at the stat above:
do I need p_3bet_action="C" ? so that he called the 3bet
Last edited by js2002 on Sun Apr 12, 2009 9:14 am, edited 1 time in total.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new: Fold to Push after CBetRaise (3BP)

Postby WhiteRider » Sun Apr 12, 2009 9:13 am

You could make it:

(holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp)

..easily enough.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new: Fold to Push after CBetRaise (3BP)

Postby js2002 » Sun Apr 12, 2009 9:19 am

well ok
0,5 + 1 + 30 + 30 (low 4bet size) = 61,5 pot at flop
stack left = 70 to 170
case 70: if the raises my cbet i haveto call and even i can pus over the top he cant fold
case 170: me bet 35 in 61,5 pot he raises to at least 80, I have 135 left and if I push it he even cant fold often

ok, your 4Bet thoughts apply to 150BB+ games.

I ll let it 3bet pot, because, my CBet Raise Stat is the same
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new: Fold to Push after CBetRaise (3BP)

Postby WhiteRider » Sun Apr 12, 2009 10:02 am

Sure, it's a rare case, so you don't need to worry about it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

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

Who is online

Users browsing this forum: No registered users and 1 guest