Allin % PF and/or Average Stack Played 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

Allin % PF and/or Average Stack Played Stat

Postby madskills » Fri Feb 05, 2010 10:26 am

Trying to classify a player as a pro shortstacker. I'm thinking either of these will do. Doesn't look like they're in the repository. Are either of these stats available?

Thanks and my apologies if they are in the repository and I missed them.
madskills
 
Posts: 28
Joined: Mon May 19, 2008 7:42 pm

Re: Allin % PF and/or Average Stack Played Stat

Postby kraada » Fri Feb 05, 2010 10:55 am

Either of these stats shouldn't be too hard to build, which would you prefer? I'll walk you through it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Allin % PF and/or Average Stack Played Stat

Postby madskills » Fri Feb 05, 2010 4:49 pm

Average stack size played would be ideal.

Thanks!
madskills
 
Posts: 28
Joined: Mon May 19, 2008 7:42 pm

Re: Allin % PF and/or Average Stack Played Stat

Postby kraada » Fri Feb 05, 2010 4:59 pm

Create a new column in the Holdem Cash Player Statistics section that reads:
cnt_avg_stack:
sum(if[holdem_hand_player_detail.amt_before > 0, holdem_hand_player_detail.amt_before, 0])

Create a new statistic in the Stats tab that has value expression:
cnt_avg_stack / cnt_hands

Don't forget to give it a title and width on the Format tab (/%.2f will work as a format expression). This will give you that player's average stack in dollars. Note that if you have a player playing multiple limits and you are using data from all limits, that will skew this expression (you can set PT3 to use stats from the current limit only on the Hud Options tab).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Allin % PF and/or Average Stack Played Stat

Postby madskills » Fri Feb 05, 2010 6:02 pm

Works perfectly.

Thanks!
madskills
 
Posts: 28
Joined: Mon May 19, 2008 7:42 pm

Re: Allin % PF and/or Average Stack Played Stat

Postby kraada » Fri Feb 05, 2010 6:24 pm

You're welcome :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests