Fold squeeze to 4bet

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

Fold squeeze to 4bet

Postby TopChan » Thu Dec 08, 2011 10:12 am

How can I build that stat?
Thanks in advance.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold squeeze to 4bet

Postby kraada » Thu Dec 08, 2011 10:56 am

Create the following columns:

cnt_p_squeeze_fold: sum(if[holdem_hand_player_statistics.flg_p_squeeze and holdem_hand_player_statistics.enum_p_4bet_action='F', 1, 0])

and
cnt_p_squeeze_face_4b: sum(if[holdem_hand_player_statistics.flg_p_squeeze and holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

Put the former over the latter and multiply by 100. For more on creating custom statistics and reports please see the Tutorial: Using Custom Stats and Reports.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 7 guests