Probe Bet ip aka "vs missed Cbet"

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: Probe Bet ip aka "vs missed Cbet"

Postby js2002 » Sun Nov 15, 2009 10:16 am

well in combi with NOT(has_position)....

I hope that the HU BB position is TRUE for that.

tested it --> ok works, but only for postflop, theres no posi check for preflop
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Probe Bet ip aka "vs missed Cbet"

Postby kraada » Sun Nov 15, 2009 10:43 am

(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position OR (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_b))

Tells you if you're out of position heads up for certain because when there are two players the big blind is always out of position.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Probe Bet ip aka "vs missed Cbet"

Postby js2002 » Sun Nov 15, 2009 10:59 am

no the BB is OOP. the SB is the BU and IP
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Probe Bet ip aka "vs missed Cbet"

Postby WhiteRider » Sun Nov 15, 2009 11:19 am

js2002 wrote:no the BB is OOP. the SB is the BU and IP

Not preflop, which is what you were asking about. Preflop the BB is last to act, therefore has position.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 0 guests