cnt_p_3bet_def_action_opp_when_coldcall_and_3br_has_position

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

cnt_p_3bet_def_action_opp_when_coldcall_and_3br_has_position

Postby marvin » Sun Jan 10, 2010 1:21 pm

1) i wish count the times that a player cold call, and face a 3bet, but who make the 3bet is in position relative to him (not counting then the squeeze executed by BB or by SB)
2) i wish count the times that a player is the first raiser PF, and face a 3bet, but who make the 3bet is in position relative to him (not counting then the 3bet executed by BB or by SB)
3-4) the same when the 3bettor is out of position to the raiser (is a blind or a limper who was in the pot before his raise)

im having problem about the #1 (and similar for the other) because if i do:
sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_ccall and holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position, 1, 0])

doesnt work why the raise_aggressor_position can be related also to the original raiser (if he makes a 4-bet) or to the hero if he reraises, then actions like: UTG raise, EP cold call, Butt 3bet, UTG call, EP 4bet, everyone fold will not counted (but i wish that was counted).
someone can say like is possible? would be very simple if there was something like holdem_hand_player_detail.val_p_3bettor_aggressor_pos, but i dont see that variable! :mrgreen: :cry:
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: cnt_p_3bet_def_action_opp_when_coldcall_and_3br_has_position

Postby WhiteRider » Sun Jan 10, 2010 1:56 pm

Unfortunately there is only one raise aggressor position, and this is always the last player to make a preflop raise (other than the active player), so you can't build this kind of stat accurately.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cnt_p_3bet_def_action_opp_when_coldcall_and_3br_has_position

Postby marvin » Sun Jan 10, 2010 6:47 pm

is not possible build the stat using something about squeeze_flag?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: cnt_p_3bet_def_action_opp_when_coldcall_and_3br_has_position

Postby WhiteRider » Mon Jan 11, 2010 5:11 am

The cold-caller only faces a squeeze if there are no other raises after the 3-bet/squeeze raise so the same thing applies, I'm afraid.
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