Fold to Limp Reraise Stat

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

Fold to Limp Reraise Stat

Postby sethseth » Thu May 05, 2011 7:12 pm

I can't find anything on this with the search. Is it possible to build? so player(s) limp, guy raises, and then folds when one of the limpers reraises him.
sethseth
 
Posts: 16
Joined: Mon Apr 21, 2008 5:31 am

Re: Fold to Limp Reraise Stat

Postby WhiteRider » Fri May 06, 2011 4:07 am

We can't tell the position of the limper(s), but if there is no action other than the limp, player's raise, and reraise then we should be able to do it.

You will need these two columns:

cnt_p_raise_limper_fold =
sum( if[ (NOT holdem_hand_player_statistics.flg_p_open_opp) AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position AND holdem_hand_player_detail.val_p_raise_aggressor_pos < 8) AND holdem_hand_player_statistics.enum_p_3bet_action='F', 1 , 0 ] )

cnt_p_raise_limper_face_3bet =
sum( if[ (NOT holdem_hand_player_statistics.flg_p_open_opp) AND holdem_hand_player_statistics.flg_p_first_raise AND (holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position AND holdem_hand_player_detail.val_p_raise_aggressor_pos < 8) AND holdem_hand_player_statistics.flg_p_3bet_def_opp, 1 , 0 ] )

See the Tutorial: Custom Reports and Statistics for a walk-through of how to build a stat from these expressions.
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