filter players by VPIP/PFR

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

filter players by VPIP/PFR

Postby banshee » Thu Jun 25, 2009 10:04 am

hi,

what I would like to do is some sort of combined filter, i.e. sth. like "player raised river, players VPIP is between 15 and 30 and players PFR is between 10 and 25". Is this somehow possible? I can do one or the other but not both at the same time. My idea was to firstly do the VPIP/PFR filter, import all hands that match into a new DB and filter whatever I want on this DB but how can I export filtered results?
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: filter players by VPIP/PFR

Postby kraada » Thu Jun 25, 2009 11:18 am

It's not possible to filter on both a player's general stats and details on a specific hand at the same time. Nor is it possible to export hands which match certain critera.

However I do think you can work around it.

First create a custom report in the Player Statistics section for players that match your stat requirements (#VP$IP# > 15 AND #VP$IP# < 30 AND #PFR# > 10 AND #PFR < 25). Show the stat Player and Hands. Run the report, sort by Hands so you can see the players with the most hands, in descending order. Now you've got a list of players to look at - and we can ignore people without a lot of data. Expand that report using the four arrows icons.

Now use the regular filters button to filter for raised river, then go to the player with the most hands from your list. Now you're looking at hands where someone who matches your criteria raised the river. Once you've gone through his hands, go to the player with the next most hands on the list, etc. Since this sort of filtering and exporting seems like you're going to want to end up reviewing the hands directly this should work. If you had something else in mind, feel free to elaborate and we'll see what we can work out :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: filter players by VPIP/PFR

Postby banshee » Thu Jun 25, 2009 1:11 pm

/edit: That was bullshit :D
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: filter players by VPIP/PFR

Postby banshee » Thu Jun 25, 2009 1:34 pm

Yeah, that's basically not bad but a little operous. Another option would be to use SQL but then I can't open the hands in the replayer. If there exists some kind of wishlist I would like to add that point :)
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: filter players by VPIP/PFR

Postby kraada » Thu Jun 25, 2009 5:09 pm

I know there are plans to add the ability to play hands from the custom reports section in the replayer; once you can do that you could simplify it a bit by adding back in the names of the players as filters for a report in the hands section - but since you'd have to replay them one by one right now, I don't think that'd be any faster - once it is though, that'd certainly save quite a bit of time.
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