Need custom stat. Call steal attempt and fold to cbet

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

Need custom stat. Call steal attempt and fold to cbet

Postby Raziel12 » Mon Apr 19, 2010 8:22 am

Hi,

I have a question. Could anybody please create a custom stat for me?

The stats would be about, when I attempt to steal and he calls my steal, then I would like to know what it is his fold to flop cbet. So: Call steal attempt and then fold to flop cbet.

Thanks
Raziel12
 
Posts: 45
Joined: Sat Mar 14, 2009 2:42 pm

Re: Need custom stat. Call steal attempt and fold to cbet

Postby WhiteRider » Mon Apr 19, 2010 9:30 am

You will need two new columns like this:

cnt_steal_call_fold_to_cbet =
sum(if[ holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

cnt_steal_call_face_cbet =
sum(if[ holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

And then a new stat to display the result, with this Value Expression:

(cnt_steal_call_fold_to_cbet / cnt_steal_call_face_cbet) * 100

See the Tutorial - Custom Reports and Statistics for a walkthrough of building a stat using these expressions.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Need custom stat. Call steal attempt and fold to cbet

Postby Raziel12 » Mon Apr 19, 2010 10:34 am

Thanks a lot for the quick help. I really appreciate it
Raziel12
 
Posts: 45
Joined: Sat Mar 14, 2009 2:42 pm

Re: Need custom stat. Call steal attempt and fold to cbet

Postby WhiteRider » Mon Apr 19, 2010 10:43 am

You're welcome.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Need custom stat. Call steal attempt and fold to cbet

Postby stasia42 » Thu Apr 22, 2010 8:15 am

Hi, lets say that CO RFI, and now it's the BU turn to act, what will flg_blind_def_opp will show? Do the active player has to be on one of the blinds that is being "stolen", in order for the flag to be true..?
stasia42
 
Posts: 35
Joined: Tue Aug 25, 2009 12:51 pm

Re: Need custom stat. Call steal attempt and fold to cbet

Postby WhiteRider » Thu Apr 22, 2010 8:37 am

flg_blind_def_opp will be false for the button because he is not defending a blind.

stasia42 wrote:Hi, lets say that CO RFI, and now it's the BU turn to act, what will flg_blind_def_opp will show? Do the active player has to be on one of the blinds that is being "stolen", in order for the flag to be true..?

Yes.
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 0 guests