Please help me generate this data:

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

Please help me generate this data:

Postby tokeRJallDAY » Sat Dec 18, 2010 8:05 pm

I've been a regular in certain games for several months and have a pretty fair sample hands on most of the other regs that I encounter. I would like to show a report showing me the following information:

Player Name, # of hands, VPIP, PFR, AFq.

This is pretty simple in reports, but I want to run it over all players in my database, or at least all players that I've got, say, 500 hands on (regs).

Any way to do this?

Also, any way to configure the HUD to show stats specific to blind levels like +/- a few. Say if tournament blind levels are 80/160, only show me data from the levels 50/100 up to 120/240?
tokeRJallDAY
 
Posts: 9
Joined: Tue Jan 29, 2008 8:14 am

Re: Please help me generate this data:

Postby gkeuler » Sun Dec 19, 2010 12:04 am

The report is possible, I suggest reading and going over the Doc's and stickies on the how-to boards if you dont know how to do this, they cover it very well,

http://www.pokertracker.com/products/PT3/docs/?doc=custom-reports
http://www.pokertracker.com/forums/viewtopic.php?f=45&t=22599 #Hands#>500

For the report, go to the report tab, in the selection area select "xxxxx Player Statistics". Next look to the Available stats section, double click ALL STATS, add the stats from the list by double clicking its name.

Directly above the Available Stats section are "Filters, Sorting, Advanced" all highlighted in blue, click "Filtering". First thing is to UNcheck the "filter on active player" checkbox. This makes the report run over all players in DB. To filter to the report further, hit "INSERT", goto Statistics tab, scroll down to "Hands", highlight it and hit OK. " #Hands# " should be inserted into the filter expression box. Now hit insert again, this time the Operators tab, Select "> Greater then", hit ok. Finally add "500" ending up with a filter expression

#Hands#>500

You have to hit Save aswell to add the filter.

As for the HUD, theoretically it is possible, but I dont know any method that isn't quite complicated.
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am


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

Who is online

Users browsing this forum: No registered users and 2 guests