PDA

View Full Version : VPIP and PFR % wrongly calculated



Spec
01-19-2011, 07:15 AM
In BB I have following stats (Hands / VPIP / PFR)
10.319 / 42.5 / 12.0

If I filter with VPIP = True I get
4.028 / 100 / 100

If I filter with PFR = True I get
1.139 / 100 / 100

So I have 4.028 hands that I VPIP. If I divide that by the total of 10.319 I get 39.0% and not 42.5%.

Same for PFR 1.139/10.319 = 11.0% and not 12.0%.

I thought this was odd so I selected all hands and Exported csv to Grid.

Then in Excel I made a Pivot table and using the field Action I could see:
PFR 1139
VPIP 2889
BLANK 6291

Which confirms the above.

So something is wrong when calculating the %.

I tried in another player which has a lot of hands and discrepancies are also around 2%.

Can you please have a look or provide an explanation ?

Thanks

morny
01-20-2011, 02:20 PM
Hi,

I can reproduce this although my database is quite small at the moment. It might be possible that some of the hands were imported with an older version that had a bug. Can you send me some original hands you can replicate this with and ill investigate it further

support@holdemmanager.com

roy.goncalves
01-20-2011, 03:17 PM
When the action is folded to you in the big blind it counts as a hand but does not count towards the VPIP/PFR. So, for example, if you have 5 hands in the BB and you raise once, call once and it is folded to you 2 times then your VPIP is actually 2/3 = 66.7% not 2/5 40% because out of the 3 times you could have played you did VPIP 2 times.

Roy

Spec
01-20-2011, 10:27 PM
I excluded the hands in BB that I won when everybody folded to me (Won Hand = True ; Saw Flop = True).

This results in 856 hands.

If I deduct those from the 10.319 total hands, the stats % become consistent.

Thanks a lot for the clarification Roy (and was very interesting because I never noticed that I win 8.3% of the hands in BB without any fight :cool:)

The Minder
02-04-2011, 01:35 AM
When the action is folded to you in the big blind it counts as a hand but does not count towards the VPIP/PFR. So, for example, if you have 5 hands in the BB and you raise once, call once and it is folded to you 2 times then your VPIP is actually 2/3 = 66.7% not 2/5 40% because out of the 3 times you could have played you did VPIP 2 times.

Roy

Needless to say that perhaps your presence back here is a sign of better things to come.