Pokerstars VPPs player stat?

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

Pokerstars VPPs player stat?

Postby Twizz » Sun Jan 06, 2013 6:36 pm

I've downloaded the 2012 PokerStars VPP stat and It's usable in hand reports, but I would like to have something like a VPPs/hand or VPPs/100 stat on player reports (by stake for example). Ican't figure out how to do this, is it even possible?
Twizz
 
Posts: 19
Joined: Mon Feb 04, 2008 3:41 pm

Re: Pokerstars VPPs player stat?

Postby kraada » Mon Jan 07, 2013 10:39 am

Sure, this is possible.

Click Configure -> Statistics, on the $, Player, Stats section highlight the VPP stat and click the Duplicate button. Change to the Definition page and change the various descriptions as you desire (name, short desc, title). In the Value Expression divide by cnt_hands, so you get:
amt_vpps / cnt_hands

That will give you VPP/hand - just save your new stat and use it.

To get VPPs per hundred hands, use instead the value expression:
amt_vpps / (cnt_hands / 100)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokerstars VPPs player stat?

Postby Twizz » Mon Jan 07, 2013 2:43 pm

Thanks

Appearently I didn't download the VPP player stat, only the stat for hand reports.
Twizz
 
Posts: 19
Joined: Mon Feb 04, 2008 3:41 pm

Re: Pokerstars VPPs player stat?

Postby kraada » Mon Jan 07, 2013 3:10 pm

Then you'll want to go back and grab the Player version and then follow those steps.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokerstars VPPs player stat?

Postby tops10 » Thu Feb 28, 2013 12:54 pm

Hi, this is the first custom stat I'm trying to import but can't figure out how. When I download the file I get a very long formula in Notepad, which I've saved. This is how I've tried importing the VPP stat:

Configure->Statistics
Options->Import
Select the file saved on my computer

This is the error message I get before PT4 crashes:
PokerTracker has detected an out of memory condition.
PokerTracker will now attempt to close to prevent data loss.

Can someone please let me know if I'm importing custom stats incorrectly? Thanks.
tops10
 
Posts: 10
Joined: Mon Jan 21, 2013 8:09 pm

Re: Pokerstars VPPs player stat?

Postby kraada » Thu Feb 28, 2013 3:09 pm

If you opened it up in notepad and saved it that might be causing problems. Redownload the .pt4stat file from our warehouse. You don't need to open it in any program - just click File -> Import Statistic in PT4 and then choose the file and click OK and that will import it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokerstars VPPs player stat?

Postby tops10 » Thu Feb 28, 2013 3:18 pm

Thanks very much, that did it.
tops10
 
Posts: 10
Joined: Mon Jan 21, 2013 8:09 pm

Re: Pokerstars VPPs player stat?

Postby lkpearson12 » Thu Apr 25, 2013 10:14 am

But I don't know where the stats are saving so having a hard time to locate them to import??
lkpearson12
 
Posts: 7
Joined: Mon Sep 27, 2010 11:39 am

Re: Pokerstars VPPs player stat?

Postby kraada » Thu Apr 25, 2013 12:40 pm

What browser are you using to download the file?
kraada
Moderator
 
Posts: 54431
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 7 guests

cron