This came out of a
recent discussion I had with JJack. I have am suspicious of a few things, and would like to get a dataset that included the playing styles of people other than me. I would hope that you have at least 10k hands in your database, but I'll take whatever is out there from whoever is willing to do it.
The baseline filter:
* Hands with exactly 3 players who see the flop
* No preflop raise
* Money in or saw flop for free
Record the following information for each hand:
* # of hands
* BB/hand
* VPIP
Filter #1: Big blind
Filter #2: Big blind, steal attempted against your blind and called/raised
Here are my values:
Filter #1: 749 hands @ -0.11 BB/hand, 23.90 VPIP
Filter #2: 66 hands @ -0.49 BB/hand, 100 VPIP
Then I want you to compute the actual wins/losses in terms of BB and number of hands VPIP by straight multiplication:
Computation #1: -82.39 BB with 179 VPIP hands
Computation #2: -32.34 BB with 66 VPIP hands
From each pair of filters, it is now possible to get primarily hands that are limped pots -- this method does not get rid of raises from early or middle position.
Computation #1 - Computation #2: -50.05 BB in 113 VPIP hands
We also need to reduce the total number of hands to account for removing the blind defense hands:
Big blind: 749 - 66 = 683
We are also going to add back the money lost due to the blinds because I like positive numbers:
Big blind: -50.05 BB + (.5 BB/hand)*(683 hands) = 291.45 BB
Finally, reduce the number to BB/hand and compute adjusted VPIP:
Big blind: 291.45 BB/683 hands = 0.427 BB/hand @ 113/683 = 16.54 VPIP
So... how do your stats look?