Pokerstars VPP for pokertracker4

[socorrista5]

Hello,
I want to have a stat with the related pokerstars.es VPP earned per session (or per hand or whatever).

I know there is a VPP stat in the stats warehouse, but it was for pokertracker3 (although i gess it should not change a lot in the PT4). I use it but this stat is not giving me the same amount that I have in the cashier of pokerstars.es

I say pokerstars.es because I am not sure that the formula is supposed to work the same in the pokerstars.es than in the pokerstars.com

Thanks

[WhiteRider]

There is a version for PT4 in the warehouse too. If you type 'vpp' in the search box you should find it.
You may need to alter the multipliers to correct the number of points awarded - go to Configure > Statistics to make that change.

Custom Stats Guide

[socorrista5]

Great!, I did t, and it works. There are some hands that were not saved because I have just started with pokerstars and the first hands where not beeing saved, but the VPPs now are very similar!!!!! (I had to reconfigure your stat to have a multiplier of 6 to all EUR games.

But, I have another question:
I created the following stat: vpp_test=format_number(amt_rake_weighted_contributed_curr_conv * 6, 2, false, false)

With your stats (with a multiplier of 6) gives me in my first 2000 hands a value of: 8.01
With my vpp_test it gives me a value of 8.04

There is a slight difference, I do not know which is better. I will follow the points in future sessions.

Thanks

[socorrista5]

First session, and here are the data:

previous (1):
VPP PS=8.23, VPP Kraada=8.01, vpptest=8.04

after new first session (2):
VPP PS=9.02, VPP Kraada=8.8, vpptest=8.85

Difference between PS: VPP PS(2) - VPP PS(1) = 0.79
Difference between PS: VPP Kraada(2) - VPP Kraada(1) = 0.79
Difference between PS: VPPtest(2) - VPPtest(1) = 0.81

So it seemd that someting is wrong.
Could it be that the kraada stat uses more decimals than my VPPtest expresion????
Could it be that the kraada expression is done hand by hand multiplying each hand contributed rake by a factor 6 (which is more or less giving one more decimal precision), and my expression multiplies the factor 6 not by hand but by the total amount of rake (which has a precision offset due to roundings that are avoided in the kraada expression when adding an extra decimal)????
If that is the reason, it might be considered change the precision of the function "amt_rake_weighted_contributed_curr_conv", when calculating it be hand????. At least for microlimits it seems to be inducing a small error.

note:
Kraada stat with multiplier=6 (the downloaded one, and changed)
vpptest= format_number(amt_rake_weighted_contributed_curr_conv * 6, 2, false, false)

[WhiteRider]

Yes, I suspect that the difference is in rounding. I notice that Kraada's VPP stat formats "amt_vpps" to 2 decimal places so you could increase the accuracy a little by changing the very end of the column expression to:

AS numeric(11,3) ))

[socorrista5]

but the problem in rounding that I told you was about the function "amt_rake_weighted_contributed_curr_conv" which is internal and I can not change its format (I guess........).

Nevertheless, where did you suggested me to include the "AS numeric(11,3) ))" ?????, because maybe you mean that I can change the numeric format of the system stats... ?

[WhiteRider]

I don't think the column "amt_rake_weighted_contributed_curr_conv" is rounded, so calculations done on that should be accurate.

If you look at the very end of kraada's column "amt_vpps" you will see "AS numeric(11,2) ))" - change the 3 to a 2.