Custom stats query based on 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

Custom stats query based on single session

Postby weaktight » Mon Jan 18, 2010 1:03 am

What's the best way of getting this data:

Given:

-a player's screen name
-game # from hand history
-game level (optional)

I want to get all the stats on the hands played at the table of the given hand up until the given hand. i.e.

hand count,
vpip,
pfr,
3b%,
aggr factor,
$ won,
weaktight
 
Posts: 23
Joined: Sun Mar 02, 2008 5:42 pm

Re: Custom stats query based on single session

Postby WhiteRider » Mon Jan 18, 2010 10:52 am

There's no simple way to do that within PT3 - it may be possible using a custom filter in a custom report but I'm not sure how. Kraada has done a few of this kind of filter so he may be able to help you. He's off today, but I'm sure he'll get back to you tomorrow and let you know whether he thinks it is possible.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom stats query based on single session

Postby kraada » Tue Jan 19, 2010 11:24 am

Yeah that's particularly tough. I certainly can't put it together off the top of my head for you but I'll make a note to look at it and see what I can find out.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stats query based on single session

Postby js2002 » Mon Jan 25, 2010 4:21 am

Puuush ;)
We want this!

Alternative: A Button in the Replayer: "2+2 export" and a checkbox "with stats".
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Custom stats query based on single session

Postby kraada » Mon Jan 25, 2010 9:53 am

The latter is definitely planned though I don't know when it will become available.
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