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 T123 » Sun Oct 03, 2010 7:53 pm
Hi, Can I get a sanity check on this. I have just duplicated the Fold BB to SB stat and changed the position to the BTN but would still like to check if this would calculate correctly? Thanks
- Code: Select all
(cnt_p_BB_fold_to_BTN / cnt_p_BB_fold_to_BTN_opp) * 100
And
- Code: Select all
cnt_p_BB_fold_to_BTN
sum(if[substring(lookup_actions_p.action from 1 for 1)='F' AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])
cnt_p_BB_fold_to_BTN_opp
sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])
Thanks
-
T123
-
- Posts: 135
- Joined: Sun Aug 24, 2008 8:40 pm
by kraada » Mon Oct 04, 2010 9:09 am
That looks good to me.
-
kraada
- Moderator
-
- Posts: 54430
- 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 0 guests