Limp and fold to raise or 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

Limp and fold to raise or to Cbet

Postby philip77 » Sun May 01, 2011 6:02 pm

Hi,

I'm looking to build a stat which will be the percentage of the times someone limp preflop and then either fold to a raise preflop or to a flop cbet.

Thanks
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am

Re: Limp and fold to raise or to Cbet

Postby WhiteRider » Mon May 02, 2011 4:15 am

This tutorial explains how to make a new version of an existing stat, and what you want is basically a combination of "Preflop Limp Fold" and "Fold to F CBet".

As an example..
The expressions for the actions columns for these two stats are:

cnt_p_limp_fold =
sum( if[holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF', 1, 0] )

cnt_f_cbet_def_action_fold =
sum(if[holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

So the action column for your new stat could be:

cnt_p_limp_fold_to_raise_or_cbet =
sum( if[holdem_hand_player_statistics.flg_p_limp AND (lookup_actions_p.action = 'CF' OR holdem_hand_player_statistics.enum_f_cbet_action='F'), 1, 0] )

Similarly the opportunities column could be:

cnt_p_limp_face_raise_or_cbet =
sum(if[holdem_hand_player_statistics.flg_p_limp AND (holdem_hand_player_statistics.flg_p_face_raise OR holdem_hand_player_statistics.flg_f_cbet_def_opp), 1, 0])

The Tutorial: Custom Reports and Statistics also has a walkthrough of how to build a stat from expressions like these.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Limp and fold to raise or to Cbet

Postby philip77 » Mon May 02, 2011 12:22 pm

Thanks
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am


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

Who is online

Users browsing this forum: No registered users and 0 guests