Rolling average of VPIP, PFR, and Aggression

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

Rolling average of VPIP, PFR, and Aggression

Postby Jim McPherson » Fri Sep 25, 2009 7:11 pm

I want a rolling average of the last X number of hands for VPIP, PFR, and post flop aggression. While searching I've seen mention of the merits of doing this, but I can't find any mention of how to get PT3 to give this info.
Jim McPherson
 
Posts: 3
Joined: Thu Jun 05, 2008 8:17 am

Re: Rolling average of VPIP, PFR, and Aggression

Postby mikew » Fri Sep 25, 2009 11:24 pm

yes i want this too.
mikew
 
Posts: 56
Joined: Sat Jan 03, 2009 12:41 am

Re: Rolling average of VPIP, PFR, and Aggression

Postby WhiteRider » Sat Sep 26, 2009 6:46 am

Is this for each player, or as a table average?

You can enable the stats from last X hands option (Tutorial: Configuring HUD Options) but this will affect all players' stats, and I'm not sure whether it affects table averages, although I assume it would. This will prevent use of the cache, though, so can adversely affect performance.

Other than that, this is not currently possible.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Rolling average of VPIP, PFR, and Aggression

Postby Jim McPherson » Sat Sep 26, 2009 8:27 pm

Thanks WhiteRider. That's a help for now. I'd rather have it as a custom stat in PT, but I'll take what I can get. Thanks again.
Jim McPherson
 
Posts: 3
Joined: Thu Jun 05, 2008 8:17 am


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

Who is online

Users browsing this forum: No registered users and 2 guests

cron