fold to 3bet OOP / IP

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 3bet OOP / IP

Postby rizzobox » Fri Aug 28, 2009 8:29 am

Does a stat exist that tells you how often someone folds to 3bet when they open raise, and are in position and out of position.

If it does it should also be easy to implement the "fold to cb in 3bet pot" for IP/OOP?
rizzobox
 
Posts: 27
Joined: Sat Jul 19, 2008 3:01 pm

Re: fold to 3bet OOP / IP

Postby kraada » Fri Aug 28, 2009 9:05 am

Preflop stats like these are complicated to get perfectly, specifically because if someone else barges in, you can no longer tell who was the initial 3bettor. I know it's not common but it happens often enough that it makes me worry.

Your fold to flop cbet in 3bet pots example exists as a non-IP/OOP unit. If you install my hud, available in the How To: Advanced HUD Configuration, the stat is in the stat block that comes with the HUD. All you would need to do then is duplicate the columns in question, and add "AND holdem_hand_player_statistics.flg_f_has_position" before the ", 1, 0" for the in position variety, and "AND NOT(holdem_hand_player_statistics.flg_f_has_position)" for the OOP variety. Create new stats using the new columns (mostly duplicate and change names) and you should be good to go on that one.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fold to 3bet OOP / IP

Postby rizzobox » Fri Aug 28, 2009 10:52 am

It won't let me do it, says invalid sql.

sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp AND holdem_hand_player_statistics.flg_f_has_position , 1 , 0 ])
rizzobox
 
Posts: 27
Joined: Sat Jul 19, 2008 3:01 pm

Re: fold to 3bet OOP / IP

Postby kraada » Fri Aug 28, 2009 11:34 am

My apologies, I mistyped.

Try this instead:


sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.flg_f_cbet_def_opp AND holdem_hand_player_detail.flg_f_has_position , 1 , 0 ])
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fold to 3bet OOP / IP

Postby rizzobox » Fri Aug 28, 2009 1:41 pm

works great! tyvm
rizzobox
 
Posts: 27
Joined: Sat Jul 19, 2008 3:01 pm

Re: fold to 3bet OOP / IP

Postby kraada » Fri Aug 28, 2009 2:25 pm

No problem :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fold to 3bet OOP / IP

Postby stevi3p » Tue Sep 01, 2009 5:27 pm

Just saw this - a couple of questions:

I'm not sure the stat correctly handles multiway pots. e.g., if the cbettor bets first, and then we act, and then a third player has position on both of us, I believe the has_position flag will show us out of position even though we have position on the cbettor (which is what we should care about IMO). I created a similar stat and dealt with it by looking at whether the player checks or not; that is enough to tell us whether we have position on the bettor or not - and the bettor must be a cbettor because of the check that we face a cbet.

This is the stat I created:
cnt_f_cbet_IP_def_opp = sum(if[not holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])
etc

Is this OK?
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: fold to 3bet OOP / IP

Postby kraada » Tue Sep 01, 2009 5:44 pm

The stat you created will just simplify to being true whenever you face a cbet. Whenever you face a cbet you cannot check, so it could never be the case that you both face a cbet and check. So the not(checking) part is just redundant.

It is true that flg_f_has_position is only true when you have absolute position in the hand but that sounded like it's what the OP was looking for.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fold to 3bet OOP / IP

Postby WhiteRider » Wed Sep 02, 2009 5:10 am

kraada wrote:The stat you created will just simplify to being true whenever you face a cbet. Whenever you face a cbet you cannot check, so it could never be the case that you both face a cbet and check. So the not(checking) part is just redundant.

I'm not sure I agree with this - you could check if you were out of position with the preflop aggressor, then face a c-bet from him, which is the point of this column.
Your column cnt_f_cbet_IP_def_opp looks good to me.
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