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
by PokerFedor82 » Fri Mar 29, 2013 4:47 am
is it possible to make a stat of "3B resteal % btn vs co steal" in pt3?
-
PokerFedor82
-
- Posts: 20
- Joined: Sun May 20, 2012 11:43 pm
by PokerFedor82 » Fri Mar 29, 2013 5:22 am
sum(if[holdem_hand_player_statistics.flg_p_3bet_opp AND
NOT(holdem_hand_player_statistics.flg_p_limp) AND
holdem_hand_player_detail.val_p_raise_aggressor_pos =1 AND
holdem_hand_player_statistics.position = 0, 1, 0]
would this fit?
-
PokerFedor82
-
- Posts: 20
- Joined: Sun May 20, 2012 11:43 pm
by kraada » Fri Mar 29, 2013 7:57 am
This isn't possible to build in a completely accurate fashion in PT3. In PT4 you use the default built in stat 3Bet vs CO Open stat and set it to the Button position in the Hud Editor's Item Properties area you'll see exactly this value and it will be totally accurate.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 7 guests