Stat for VPP 6max PS

[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 .

[WhiteRider]

What is the exact stat name and poster's name - I'll take a look at it?

[koka778]

Poster's name is shalder . Name of the stat is Pokerstars VPP Points (Limit: FR, 6-max) . Ty

[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.

[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])

[koka778]

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 .

[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.

[koka778]

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

[kraada]

Did you remember to fill in the Format tab?

[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 ?