Folded BB to ATS by BTN

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

Folded BB to ATS by BTN

Postby 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

Re: Folded BB to ATS by BTN

Postby 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]

Who is online

Users browsing this forum: No registered users and 0 guests