PDA

View Full Version : Checking database for averages and other percentiles



luckylucky
01-31-2009, 09:12 AM
Is there a way via reports or a way via postgres sql to find out the average stats such as VPIP, PFr, Bet Flop, Fold Flop, Bet Turn etc etc of players in your database?

Further on from this is there a way to say check the players with the top 20% vPIPs or top 20% flop bettors and other such percentages?

Even if I knew the sql query to return a player's vpip - I could probably work out a lot from that.

morny
02-01-2009, 03:30 PM
You could use thhe PLAYERS tab to find this info although im running a vacuum so im not sure if any of the reports show Bet flop/turn etc but theres quite a few there and you can filter by VPIP no of hands etc