4bet preflop and fold to 5bet?

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: 4bet preflop and fold to 5bet?

Postby Randoom » Sun Dec 23, 2012 2:24 pm

Hi! Is there a chance to modify this stat for 4bet/Fold from late position when facing 3bet ? (Player raises from CO/BU, faces 3bet from BU/SB/BB, 4bets and fold to 5bet)?
Randoom
 
Posts: 52
Joined: Thu Oct 23, 2008 9:06 am

Re: 4bet preflop and fold to 5bet?

Postby kraada » Sun Dec 23, 2012 9:58 pm

Certainly. Add in AND (holdem_hand_player_statistics.position BETWEEN 0 and 1) for raises from the CO and BTN. You can't specify the position of the 3bet in PT3 (but you can in PT4) - but you could make sure that it was a steal (AND holdem_hand_player_statistics.flg_steal_att) and then the 3bet would have to come from someone after them.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 4bet preflop and fold to 5bet?

Postby Randoom » Mon Dec 24, 2012 12:05 pm

Sorry I didn't get where should I add it?
cnt_p_4B_fold: sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' and holdem_hand_player_statistics.enum_p_4bet_action='F', 1, 0])
cnt_p_4B_face: sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' and holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0]) here?
at the and of the line?
Randoom
 
Posts: 52
Joined: Thu Oct 23, 2008 9:06 am

Re: 4bet preflop and fold to 5bet?

Postby WhiteRider » Mon Dec 24, 2012 12:11 pm

The basic format of those expressions is this:

sum( if[ expression, 1, 0 ])

..and you need to add the extra bit into the 'expression' part.

So:

cnt_p_4B_fold: sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' and holdem_hand_player_statistics.enum_p_4bet_action='F' AND (holdem_hand_player_statistics.position BETWEEN 0 and 1), 1, 0])
cnt_p_4B_face: sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' and holdem_hand_player_statistics.flg_p_4bet_def_opp AND (holdem_hand_player_statistics.position BETWEEN 0 and 1), 1, 0])
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 4bet preflop and fold to 5bet?

Postby Randoom » Thu Dec 27, 2012 10:59 am

Thank you!
Randoom
 
Posts: 52
Joined: Thu Oct 23, 2008 9:06 am

Re: 4bet preflop and fold to 5bet?

Postby OFFTITL » Sat Jan 12, 2013 2:57 pm

Could you make this Stat downloadable please? Also, is there a Turn Cbet% in 3Bet Pot Stat available for download anywhere? thanks!
OFFTITL
 
Posts: 41
Joined: Tue Mar 25, 2008 5:31 pm

Re: 4bet preflop and fold to 5bet?

Postby kraada » Sun Jan 13, 2013 10:05 am

That one is available by default in PT4 . . .
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 4bet preflop and fold to 5bet?

Postby OFFTITL » Mon Jan 14, 2013 1:55 am

Sorry is there one available for PT3?
OFFTITL
 
Posts: 41
Joined: Tue Mar 25, 2008 5:31 pm

Re: 4bet preflop and fold to 5bet?

Postby kraada » Mon Jan 14, 2013 10:15 am

There's a fold to 5bet or higher after 4betting stat available here that you can use - I don't think you can specify folding to a 5bet exactly in PT3, though I'm not certain you necessarily care either.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 4bet preflop and fold to 5bet?

Postby OFFTITL » Wed Jan 16, 2013 3:16 am

appreciate it. what about Cbet turn in 3bet pot?
OFFTITL
 
Posts: 41
Joined: Tue Mar 25, 2008 5:31 pm

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 12 guests

cron