cnt_ccpf_sbe

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

cnt_ccpf_sbe

Postby Alexkidd103 » Thu Oct 30, 2008 4:23 am

Description:
Amount of times a player called a simple raise from an UTG or HJ player

sum(if[ holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_blind_def_opp=false AND holdem_hand_player_statistics.flg_p_3bet = false AND holdem_hand_player_statistics.flg_p_3bet_opp AND holdem_hand_player_statistics.flg_vpip = true, 1,0 ])

is this correct?
Alexkidd103
 
Posts: 40
Joined: Thu Jul 17, 2008 3:59 pm

Re: cnt_ccpf_sbe

Postby WhiteRider » Thu Oct 30, 2008 5:27 am

Yes, that looks pretty good.

What I do when I want to test something like this is create the same column in the 'holdem cash hands' section (but without the SUM part) and create a boolean stat from that so that you can see which hands it applies to and then you can check the correct hands are selected.
e.g. add your 'holdem cash player statistics' stat to the top Hands report, and your HCH stat to the bottom Hands report.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 3 guests