Squeeze Flop

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

Squeeze Flop

Postby sethseth » Sat Feb 26, 2011 8:38 am

I would like a stat for squeeze flop, but I'm not really sure how to start this one.
sethseth
 
Posts: 16
Joined: Mon Apr 21, 2008 5:31 am

Re: Squeeze Flop

Postby kraada » Sat Feb 26, 2011 9:50 am

Create and use the following two custom columns to build Squeeze Flop:

cnt_f_squeeze: sum(if[holdem_hand_player_detail.amt_f_bet_facing = 0 and holdem_hand_player_detail.amt_f_raise_facing > 0 and holdem_hand_player_statistics.flg_f_3bet, 1, 0])
cnt_f_squeeze_opp: sum(if[holdem_hand_player_detail.amt_f_bet_facing = 0 and holdem_hand_player_detail.amt_f_raise_facing > 0, 1, 0])

Put the former over the latter and multiply by 100 to get your stat. For more on building custom statistics and reports please see the Tutorial: Using Custom Statistics 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 0 guests