Fold to 3bet IP and OOP

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

Re: Fold to 3bet IP and OOP

Postby kraada » Tue Oct 25, 2011 10:35 am

cnt_p_steal_att_co_btn_3b_nosq_fold: sum(if[holdem_hand_player_statistics.position = 1 and holdem_hand_player_statistics.flg_steal_att and holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 and not(holdem_hand_player_statistics.flg_p_squeeze_def_opp) and holdem_hand_player_statistics.enum_p_3bet_action = 'F', 1, 0])

cnt_p_steal_att_co_btn_3b_nosq: sum(if[holdem_hand_player_statistics.position = 1 and holdem_hand_player_statistics.flg_steal_att and holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 and not(holdem_hand_player_statistics.flg_p_squeeze_def_opp) and holdem_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])

Use these two columns - put the former over the latter and multiply by 100 to build the stat.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby Mr Tiger » Fri Mar 02, 2012 3:37 pm

What if CO raises, BU 3bets, SB folds, BB calls? CO faces 3bet, but does it count as squeeze? Actually, we don't face a squeeze in this spot.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Fold to 3bet IP and OOP

Postby kraada » Fri Mar 02, 2012 4:26 pm

That will count and doesn't count as a squeeze. A squeeze is only when someone raises, that raise is called, and someone else re-raises.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby Mr Tiger » Fri Mar 02, 2012 4:32 pm

So, your stat is not exactly what TopChan asked for:
TopChan wrote:Can I make that sb must fold and bb must fold if I raise from CO and BTN 3betted me?
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Fold to 3bet IP and OOP

Postby kraada » Fri Mar 02, 2012 5:28 pm

In his example CO raised and BTN 3bet - the call is not material this 3bet is not a squeeze.

If you want times when you have no squeeze opportunity (nobody called the 3bet) that is different yes, but that is not what was asked for.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby Mr Tiger » Fri Mar 02, 2012 5:42 pm

It seems I don't understand something...
CO raises, BTN 3bets, then it is impossible for CO to have an opportunity to defend vs squeeze. So, I don't understand, why have you used not(holdem_hand_player_statistics.flg_p_squeeze_def_opp).
And I think TopChan asked for a stat for CO, where CO raises, BTN 3bets, blinds fold and CO has an opportunity to fold or not to fold.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Fold to 3bet IP and OOP

Postby kraada » Fri Mar 02, 2012 5:59 pm

If that is what he asked for then it should read not(holdem_hand_player_statistics.flg_p_squeeze_opp) - you don't have a chance to squeeze, implying there were no in between callers.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby Mr Tiger » Fri Mar 02, 2012 6:14 pm

I haven't understood you yet. If we raise first in from the CO, we have no squeeze opportunity then anyway.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Fold to 3bet IP and OOP

Postby kraada » Fri Mar 02, 2012 6:19 pm

If we raise, get 3bet and that 3bet gets called we then have a chance to make a squeeze 4bet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby Mr Tiger » Fri Mar 02, 2012 6:29 pm

Oh, thats very good: so we can exclude the situation with cold 3bet callers in blinds by adding not(holdem_hand_player_statistics.flg_p_squeeze_opp). Thanks for your answers, kraada.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 3 guests

cron