PDA

View Full Version : Pluggin leaks 1: Fixed Limit SH. Got DB let's analyze.



DarthBobo
01-05-2009, 02:51 PM
OK guys

I loaded 9.44 million hands of FL 6max into my database. This took me 2 days :). Now let's plug some leaks!

Limits: $0.25/$0.50 to $5/$10. Most hands are in between these 2 limits though.

I filter for # of players from 3 to 6.
I filter for # of hands: minimum 5000 ==> 1651 players remaining.


I'm nothing special in statistics. So let me know which values you want me to look up (and perhaps how to do it).

Here's some basic info:
average bb/100 for all players is -0.48bb/100
average VPIP for all players is 29.8
average PFR for all players is 16.4
average 3bet for all players is 7.9
average postflop aggr for all players is 1.73
average WTSD for all players is 37.8

If I filter to players with VPIP between 20 - 30:
1651 players remain (Bug in Holdem Manager!?)
average bb/100 for these players is +0.48/100
average PFR for these players is 16.7
average 3bet for these players is 8.4
average postflop aggr for these players is 2.04
average WTSD for all players is 37.1

Optimal stats for VPIP (wish I could copy-paste this from the HM report)
16.40 to 23.90: median winrate is -0.11
23.90 to 27.30: 0.67
27.30 to 32.10: 0.39
32.10 to 39.60: -1.27
39.70 to 76.90: -4.73

These stats were not accurate enough for me, so I decided to filter for people with VPIP 20 - 30:
20.10 to 22.70: -0.05
22.70 to 24.40: 0.20
24.40 to 26.00: 0.67
26.00 to 27.90: 0.48
28.00 to 30.00: 0.33

The sweet spot seems to be VPIP around 25-26.

Optimal stats for PFR (wish I could copy-paste this from the HM report)
0.10 to 11.30: -4.79
11.30 to 14.90: -1.34
14.90 to 17.20: -0.20
17.20 to 19.40: 0.95
19.40 to 35.30: 1.08

This is not accurate enough for me. I wish I could do a filter for players having 17 - 36 PFR, but I can't.

More optimal stats
WTSD: all of them are negative winrates (because of the rake of course).
So I filter for players with VPIP 20 - 30. Optimal WTSD seems to be... anything above 37.80%. Again, this is not accurate. The same thing happened like above (see optimal PFR).

I hope you like the info.
I'll add more later (and a little software support would definately help) :D

Nemesis
01-09-2009, 08:36 AM
When you say that 25-26 is the sweet spot does that imply that you think this vpip is the most profitable? Just because you find the most winning players (in relation to losing players) between 25-26 doesnŽt mean that this is the optimal vpip. I think the optimal one is over 30 but when you filter for this youŽd get too many fishes included.

Is it possible to compare the winning statistics of a 26/20 players against say a 32/23 player? (vpip/pfr)

kiddo
01-09-2009, 09:52 PM
number of players should be 5 or 6 or maybe 5-6... 3-6 makes no sense unless u give us average number of players, also: if rake is different at different limits, optimal VPIP will also be different

blindman
01-20-2009, 04:16 AM
Yep, filter for 5-6. 3 handed is a completely different game. VPIP and PFR should be considered as a pair. 32/0 is a fat fish, whereas 32/23 can be very strong.

El Helado
02-18-2009, 09:41 AM
Cant figure out how u can filter the players with PFR-range? I see the VP$IP-range in the "Players (40 000)".