Problem with delayed River Cbet IP and saw Showdown

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

Problem with delayed River Cbet IP and saw Showdown

Postby shahrad » Tue Nov 09, 2010 6:10 pm

PFR = True (no 3bet, no 4 bet, no squeeze preflop)
In position on the flop = true
Cbet Flop = true
opportunity to Cbet turn = true
turn check = true
River first bet = true
Faced river checkraise = false
saw show down = true
Sum(if[substring(lookup_actions_f.action from 1 for 1)<>'X' and NOT(flg_r_bet AND omaha_hand_player_statistics.flg_r_face_raise AND (omaha_hand_player_detail.val_r_raise_aggressor_pos > omaha_hand_player_statistics.position)) and omaha_hand_player_statistics.flg_f_cbet and NOT(omaha_hand_player_statistics.flg_p_3bet) and NOT(omaha_hand_player_statistics.flg_p_squeeze) and NOT(omaha_hand_player_statistics.flg_p_4bet) and omaha_hand_player_statistics.flg_t_cbet_opp and omaha_hand_player_statistics.flg_t_check and omaha_hand_player_statistics.flg_r_bet and omaha_hand_player_statistics.flg_showdown, 1 , 0])
I did also add river open opportunity, but I get some more hands shown in the Hud than it should.
shahrad
 
Posts: 118
Joined: Fri Oct 08, 2010 1:51 pm

Re: Problem with delayed River Cbet IP and saw Showdown

Postby kraada » Tue Nov 09, 2010 6:57 pm

Some of that is redundant, and a few things are missing. What you want is:

Sum(if[omaha_hand_player_statistics.cnt_p_raise = 1 and omaha_hand_player_detail.flg_f_has_position AND NOT(omaha_hand_player_statistics.flg_p_3bet) and NOT(omaha_hand_player_statistics.flg_p_squeeze) and NOT(omaha_hand_player_statistics.flg_p_4bet) and omaha_hand_player_statistics.flg_t_cbet_opp and omaha_hand_player_statistics.flg_t_check and omaha_hand_player_statistics.flg_r_bet and not(omaha_hand_player_statistics.flg_r_face_raise) and omaha_hand_player_statistics.flg_showdown, 1 , 0])

You raised preflop exactly once, did not 3-bet, squeeze or 4-bet. You had a chance to cbet the turn - this implies that you cbet the flop (and thus did not check) and were called. You were in absolute position on the flop. You checked the turn, bet the river, did not face a raise and got to showdown.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Problem with delayed River Cbet IP and saw Showdown

Postby shahrad » Wed Nov 10, 2010 1:16 am

This works fine. Thank you.
shahrad
 
Posts: 118
Joined: Fri Oct 08, 2010 1:51 pm


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

Who is online

Users browsing this forum: No registered users and 1 guest