Custom 3 bet stat from bb

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: Custom 3 bet stat from bb

Postby Mr Tiger » Tue Feb 28, 2012 1:52 pm

WhiteRider wrote:If you want to rule out hands where there was a 4-bet so that we can eliminate most of the error cases you can include "AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp".

What error cases did you mean? I see only new error cases. For example: HJ raises, the player 3bets (in BU), blinds fold, HJ 4bets. And here we face 4bet. Does holdem_hand_player_statistics.flg_p_4bet_def_opp mean that the player face 4bet? If yes, the described situation doesn't count as situation where the player 3bets vs HJ, but he does 3bet vs HJ.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Custom 3 bet stat from bb

Postby WhiteRider » Wed Feb 29, 2012 4:22 am

Yeah, actually that won't help because most of the problems are with the opportunities, and if the button folded instead of raising then the 4bet_def_opp would never be true (so forget that).
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 1 guest