4 bet , then fold

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: 4 bet , then fold

Postby WhiteRider » Wed Oct 29, 2008 4:30 pm

Where does it say 'invalid expression'? What reports are you adding your stat to?
I've just created that stat and it appears to work for me, although I don't have any hands which meet the criteria.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 4 bet , then fold

Postby kflug » Fri Oct 31, 2008 12:03 am

SukitTrebek wrote:
my best attempt at hacking something together was to try to see when people 4bet and did not see flop.


4bet and didn't see flop won't be useful since you aren't noting whether player folded or opponent. To build the stat you need to use holdem_hand_player_statistics.flg_p_4bet (or holdem_hand_player_statistics.enum_p_3bet_action='R' if you want to narrow it down to only 4bets and not 5 bets) and holdem_hand_player_statistics.flg_p_fold.

For the denominator you will need to compare holdem_hand_player_detail.amt_p_raise_facing >holdem_hand_player_detail.amt_p_raise_made_2. (this is the total amount of raises you faced preflop compared to the amount of the second raise you made preflop which is always at least a 4 bet.) This will give you a count of the times player faced further action after his/her second raise.
kflug
 
Posts: 14
Joined: Sun May 18, 2008 1:00 pm

Previous

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

Who is online

Users browsing this forum: No registered users and 6 guests