Looking for some extra stats

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

Looking for some extra stats

Postby Peacemaker » Sun Apr 04, 2010 1:30 pm

Hello I am looking for some extra stats, can someone tell me how I do this?

Squeeze preflop
When people is earlier positions limp or raise/call raises and the squeezer raises or 3bets in late position.

BB blindraise
Percentage that the BB raises after the SB completed the blind and there were no previous limpers

SB completes blind
No limpers or raisers and sb completes the blind.

These are also future requests :). If anyone can help me :)?>
Peacemaker
 
Posts: 6
Joined: Mon Jun 08, 2009 3:22 pm

Re: Looking for some extra stats

Postby WhiteRider » Sun Apr 04, 2010 3:30 pm

Squeeze stats were added in Beta 30.9.
Download page
PT3 Build History / Release Notes

The second one can be built, but is a little tricky - it is explained here.

Your third one is easier:

cnt_p_limp_first_in_sb =
sum( if[holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_blind_s, 1, 0] )

You can divide that by the built-in column: cnt_steal_opp_sb to make your stat. (If you have an opportunity to steal from the SB then you also have an opportunity to limp/complete the SB with no previous action.)

So the stat is:
(cnt_p_limp_first_in_sb / cnt_steal_opp_sb) * 100

Tutorial - Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Looking for some extra stats

Postby Peacemaker » Mon Apr 05, 2010 7:43 am

Thanks a lot!
Peacemaker
 
Posts: 6
Joined: Mon Jun 08, 2009 3:22 pm


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

Who is online

Users browsing this forum: No registered users and 1 guest