4bet vs sqz 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

4bet vs sqz and fold to 5bet+

Postby js2002 » Sun Mar 25, 2012 3:06 pm

Hi,

I had this for pt3 and wanna ask if this works for pt4 too:

sum(if[cash_hand_player_statistics.flg_p_first_raise AND
cash_hand_player_statistics.flg_p_4bet AND
cash_hand_player_statistics.flg_p_4bet_def_opp AND
cash_hand_player_statistics.enum_p_squeeze_action='R' AND cash_hand_player_statistics.flg_p_squeeze_def_opp AND cash_hand_player_statistics.enum_p_4bet_action='F', 1, 0])

In PT3 "cash_hand_player_statistics.flg_p_4bet_def_opp" was 4bet+.
I heard that in PT4 the border ist noch 5bet, so 5bet+. I could NOT find anything like "cash_hand_player_statistics.flg_p_5bet_def_opp"

So, does my numerator still represent the action: 4bet vs a squeezer and then fold vs push or 5bet+?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: 4bet vs sqz and fold to 5bet+

Postby kraada » Mon Mar 26, 2012 10:02 am

The database flag in PT4 is still for 4bet+ - we just added other things in order to allow you to be more discerning. If you want to pick out 5bets or higher if you add:

char_length(cash_hand_summary.str_aggressors_p) >= 4 AND substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int != cash_hand_player_statistics.position

that will make certain that the player in question was not the 4bettor (the first piece checks to see if there was at least a 4bet in the hand, the second piece looks at the position of the 4bettor and compares it to the position of the current player).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests