PokerTracker


https://staging.pokertracker.com/forums/

Stat for VPP 6max PS

https://staging.pokertracker.com/forums/viewtopic.php?f=15&t=20085

Page 1 of 2

Stat for VPP 6max PS

PostPosted: Fri Jun 05, 2009 11:47 pm
by koka778
Hi . I have found in repository/statistics the stat that calculates VPP for FL on PS . It says for 6max and for 10max.
With 10max its working fine , but with 6max it does not work at all .
Do you know something abot it , why ?
Thanks .

Re: Stat for VPP 6max PS

PostPosted: Sat Jun 06, 2009 3:56 am
by WhiteRider
What is the exact stat name and poster's name - I'll take a look at it?

Re: Stat for VPP 6max PS

PostPosted: Sun Jun 07, 2009 4:39 am
by koka778
Poster's name is shalder . Name of the stat is Pokerstars VPP Points (Limit: FR, 6-max) . Ty

Re: Stat for VPP 6max PS

PostPosted: Sun Jun 07, 2009 5:02 am
by WhiteRider
The column that the stat uses is defined like this:

sum(if[(
holdem_limit.limit_name = '$0.02/$0.04' OR
holdem_limit.limit_name = '$0.05/$0.10' OR
holdem_limit.limit_name = '$0.10/$0.20' OR
holdem_limit.limit_name = '$0.25/$0.50' OR
holdem_limit.limit_name = '$0.50/$1' OR
holdem_limit.limit_name = '$1/$2') And
holdem_hand_summary.amt_rake >= .40 OR
holdem_hand_summary.amt_rake >= 1, 1, 0] +

if[(
holdem_limit.limit_name = '$0.02/$0.04 (6 max)' OR
holdem_limit.limit_name = '$0.05/$0.10 (6 max)' OR
holdem_limit.limit_name = '$0.10/$0.20 (6 max)' OR
holdem_limit.limit_name = '$0.25/$0.50 (6 max)' OR
holdem_limit.limit_name = '$0.50/$1 (6 max)' OR
holdem_limit.limit_name = '$1/$2 (6 max)' OR
holdem_limit.limit_name = '$2/$4 (6 max)' OR
holdem_limit.limit_name = '$3/$6 (6 max)' OR
holdem_limit.limit_name = '$5/$10 (6 max)' OR
holdem_limit.limit_name = '$10/$20 (6 max)' OR
holdem_limit.limit_name = '$30/$60 (6 max)' OR
holdem_limit.limit_name = '$50/$100 (6 max)' OR
holdem_limit.limit_name = '$100/$200 (6 max)' OR
holdem_limit.limit_name = '$200/$400 (6 max)' OR
holdem_limit.limit_name = '$500/$1000 (6 max)' OR
holdem_limit.limit_name = '$1000/$2000 (6 max)') AND
holdem_hand_summary.amt_rake >= 2 OR
holdem_hand_summary.amt_rake >= 3, 1, 0] +

if[holdem_hand_summary.amt_rake >= 5, 1, 0])


Each limit is named explicitly, so if you are playing at a site where the levels are named differently then this won't work - you will need to edit the column.

It might just be that you're not using the Adjust Qualifying Tables Limits option so your tables aren't being recognized (and named) as 6 max?
Tutorial: Auto Import settings

I think there may be a better way to check for limit types like this, but I'll have to investigate later when I have some time.

Re: Stat for VPP 6max PS

PostPosted: Wed Jun 10, 2009 1:35 pm
by WhiteRider
Sorry it took me so long to get back to you..

There isn't a generic flag for 6 max tables (I was thinking that you were separating NL and limit tables), but you could do the column like this:

sum(if[(
holdem_limit.limit_name NOT LIKE '%max)' ) And
holdem_hand_summary.amt_rake >= .40 OR
holdem_hand_summary.amt_rake >= 1, 1, 0] +

if[(
holdem_limit.limit_name LIKE '%(6 max)' ) AND
holdem_hand_summary.amt_rake >= 2 OR
holdem_hand_summary.amt_rake >= 3, 1, 0] +

if[holdem_hand_summary.amt_rake >= 5, 1, 0])

Re: Stat for VPP 6max PS

PostPosted: Wed Jun 10, 2009 8:36 pm
by koka778
WhiteRider wrote:Sorry it took me so long to get back to you..

There isn't a generic flag for 6 max tables (I was thinking that you were separating NL and limit tables), but you could do the column like this:

sum(if[(
holdem_limit.limit_name NOT LIKE '%max)' ) And
holdem_hand_summary.amt_rake >= .40 OR
holdem_hand_summary.amt_rake >= 1, 1, 0] +

if[(
holdem_limit.limit_name LIKE '%(6 max)' ) AND
holdem_hand_summary.amt_rake >= 2 OR
holdem_hand_summary.amt_rake >= 3, 1, 0] +

if[holdem_hand_summary.amt_rake >= 5, 1, 0])


I made a new column and put it for expression . But it says the statement is not valid SQL .

Re: Stat for VPP 6max PS

PostPosted: Thu Jun 11, 2009 4:18 am
by WhiteRider
I copied that from my column and it validates for me, it's probably to do with the way it's laid out - try this:

Code: Select all
sum(if[( holdem_limit.limit_name NOT LIKE '%max)' ) And holdem_hand_summary.amt_rake >= .40 OR  holdem_hand_summary.amt_rake >= 1, 1, 0] + if[( holdem_limit.limit_name LIKE '%(6 max)' ) AND holdem_hand_summary.amt_rake >= 2 OR holdem_hand_summary.amt_rake >= 3, 1, 0] + if[holdem_hand_summary.amt_rake >= 5, 1, 0])


This is exactly the same, but with the linebreaks taken out.

Re: Stat for VPP 6max PS

PostPosted: Sat Jun 13, 2009 12:36 pm
by koka778
WhiteRider wrote:I copied that from my column and it validates for me, it's probably to do with the way it's laid out - try this:

Code: Select all
sum(if[( holdem_limit.limit_name NOT LIKE '%max)' ) And holdem_hand_summary.amt_rake >= .40 OR  holdem_hand_summary.amt_rake >= 1, 1, 0] + if[( holdem_limit.limit_name LIKE '%(6 max)' ) AND holdem_hand_summary.amt_rake >= 2 OR holdem_hand_summary.amt_rake >= 3, 1, 0] + if[holdem_hand_summary.amt_rake >= 5, 1, 0])


This is exactly the same, but with the linebreaks taken out.


I made this new column , than made a new stat , that used in Value expression that new column . I tried to apply it in tab general , but this stat even doesnt appear there . What wrong did I do ? Ty

Re: Stat for VPP 6max PS

PostPosted: Sat Jun 13, 2009 12:59 pm
by kraada
Did you remember to fill in the Format tab?

Re: Stat for VPP 6max PS

PostPosted: Sat Jun 13, 2009 1:30 pm
by koka778
Oh ye , now I put the name and its appear in the tab , but still working only for 10max ( not for 6max or HU .
Is your stat working for 6max ?
All times are UTC - 5 hours [ DST ]
Page 1 of 2
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/
highfalutin