Need help creating 2 stats for Single session...

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

Need help creating 2 stats for Single session...

Postby luckymindy » Mon Nov 15, 2010 12:38 am

Hi everyone, I'm new to creating stats in PT. I need to create 2 stats for the "Session Hands" category that, from what I can see, are not available. It's really important that I have it in the "Session Hands" and not another category or tab. These are the 2 stats I need:

1) Number of players dealt in hand, per hand
2)Position at table. Specifically I need the utg+1, utg+2, utg+3 numbers. So what I'm looking for is just the number and not a category (i.e. whether it is early, middle late)

Are these possible? If so how do I do it? The reason I need this is for a study I'm doing for my PhD dissertation in Psychology.

If someone could help me with this I would appreciate it!

Thanks
luckymindy
 
Posts: 5
Joined: Fri Mar 28, 2008 2:06 pm

Re: Need help creating 2 stats for Single session...

Postby WhiteRider » Mon Nov 15, 2010 4:15 am

In the Holdem Cash Hands section:

1. Create a column with expression:
holdem_hand_summary.cnt_players
..and a stat to display it. (see attached)

2. It depends exactly how you want to see the position number - if you want to use the built-in positions (where 0 is the button, 1 is the cutoff, etc) that's really easy - create a stat to display the value of the built-in column "position". (see attached)
If you want to see it as "UTG", "UTG+1", etc it will take a bit more work - "UTG" is a different position depending on the number of players active in the hand.
To do that you would need to use quite complicated "if" statement. If that's what you want let us know and we'll show you how to build it.

Players and Position.zip
Extract the files from the .zip and on the Configure Statistics window, Statistics tab click import and select both files.
(662 Bytes) Downloaded 96 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Need help creating 2 stats for Single session...

Postby luckymindy » Mon Nov 15, 2010 2:39 pm

Amazing...thanks! I'll try these out and see if I need to clarify anything else with you:)
luckymindy
 
Posts: 5
Joined: Fri Mar 28, 2008 2:06 pm

Re: Need help creating 2 stats for Single session...

Postby luckymindy » Mon Nov 15, 2010 2:45 pm

Works perfectly and was exactly what I wanted!! Thanks White Rider!
luckymindy
 
Posts: 5
Joined: Fri Mar 28, 2008 2:06 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests