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

Fold to 3bet IP and OOP

Postby TopChan » Mon Oct 24, 2011 3:50 pm

How can I build custom stat "fold to 3bet in position" for UTG, MP and CO?
Thanks in advance.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold to 3bet IP and OOP

Postby kraada » Mon Oct 24, 2011 4:01 pm

How do you define being in position or out of position? For example, if you raise in EP which is called by the button and the BB 3 bets are you in position or out of position? Does that change if the button comes over the top with a 4bet?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby TopChan » Mon Oct 24, 2011 4:06 pm

Let's say for simplicity not take into account squeeze situations. Just two people. Hero raise, someone 3bet, everybody else fold.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold to 3bet IP and OOP

Postby kraada » Mon Oct 24, 2011 4:26 pm

You can't ignore multi-way pots entirely with our schema - if you raise and there's a 3bet and someone calls the 3bet before it gets to you we can't tell from your perspective that the pot is multi-way.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby TopChan » Mon Oct 24, 2011 4:34 pm

Another variant. In position - Hero - UTG, 3better - BB. Out of position - Hero - UTG, 3better - CO. Position of caller doesn't matter. Heads-up or multi-way pot doesn't matter too.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold to 3bet IP and OOP

Postby TopChan » Mon Oct 24, 2011 5:06 pm

Seems like I found the solution.
I have custom stat "fold to 3bet in position"
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.enum_p_3bet_action='F' AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )
I just need to add AND holdem_hand_player_statistics.position = 3 for UTG ?
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold to 3bet IP and OOP

Postby kraada » Mon Oct 24, 2011 5:15 pm

That will work so long as there is no cold 4betting going on.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby TopChan » Tue Oct 25, 2011 10:04 am

Can I make that sb must fold and bb must fold if I raise from CO and BTN 3betted me?
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold to 3bet IP and OOP

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

Yes I think that can be managed - you want the fold percentage in that spot?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Fold to 3bet IP and OOP

Postby TopChan » Tue Oct 25, 2011 10:24 am

Yes.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Next

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

Who is online

Users browsing this forum: No registered users and 25 guests

cron
highfalutin