Turn Cbet % in 3Bet Pots by kraada

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

Turn Cbet % in 3Bet Pots by kraada

Postby js2002 » Mon Jun 18, 2012 6:58 am

sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

this is 3bet+ and not 3bet only right?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Turn Cbet % in 3Bet Pots by kraada

Postby kraada » Mon Jun 18, 2012 8:38 am

Yes, this is 3Bet+.
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 4 guests