Shove % and Limp/Call Shove %

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

Shove % and Limp/Call Shove %

Postby wangtangkiki » Thu Sep 29, 2011 9:03 am

I play $0.11 Super Turbo SNGs on Merge.. I can't find a Shove PF % nor can I find a stat where you can see how often a player that limped will call a shove..

These would be big advantages to find out ranges.. I could see what % of hands players shove.. and I can see if I can just shove over a players limp to steal his chips.. If he's never called a shove after limping, then it would be a good stat.. (Limping in these is very bad but everyone does it lol)
wangtangkiki
 
Posts: 133
Joined: Mon Feb 28, 2011 11:01 pm

Re: Shove % and Limp/Call Shove %

Postby WhiteRider » Thu Sep 29, 2011 9:16 am

You will need to build that as a custom stat - see this post for the expression you will need for the "push" stat.
Note that you will need to add tourney_ to the start of the table name in Kraada's expression, as below:


For "Limp Fold to Allin" you'll need columns like these:

cnt_p_limp_face_allin_fold =
sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.enum_face_allin = 'P' AND tourney_holdem_hand_player_statistics.enum_face_allin_action = 'F', 1, 0] )

cnt_p_limp_face_allin =
sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.enum_face_allin = 'P', 1, 0] )

See the Tutorial: Custom Reports and Statistics for how to build stats from expressions like these.
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