PDA

View Full Version : What's my win rate? Sample graphs from 110K hands!


Adde
12-23-2005, 05:26 PM
There has been some posts about win rates lately, so I thought I should investigate my own stats a little closer. Perhaps others are interested, so I post the results here.

When: Dec 1 2004 - Dec 1 2005
Site: PartyPoker
Game: $2/$4 Limit Holdem
Hands: 110K
Win rate: 2.17 BB/100

The problem with finding out your win rate is that the variance can be a bitch (and it will be!). To see what degree of bitchiness it can acheive, I took my PokerTracker data and split it up in chunks of 100 hands (PostgreSQL PG Admin is your friend). I then calculated the win rate for all subsets of 10K hands in the total sample size of 100K. That is, first sample of 10K hands contains hand 1-10000; second sample is hand 101-10100; ...; last sample is hand 100001-110000. This is repeated for all subsets of 20K up to 100K hands.

Each graph below shows how the win rate for a sample size fluctuates around the win rate calculated for all hands (110K). I'm a little sloppy and call the last value a "True" win rate, but only in the meaning of "true win rate for all 110K hands", not my acutal true win rate (which I don't know). There's also Min and Max values for win rate, and a Diff value for Max minus Min (even though the interesting Diff value is Min/Max versus True).

Some random note/s...

(1) Quite often people post or quote their Pokertracker stats after some 10K hands. I've had bad runs of (at least) 10K hands where I have lost money. 10K hands may sound quite much, but it isn't. It may sound strange to Average Joe that a winning player is down for that many hands, but it isn't. The numbers fool you.

(2) I'm tired and hungry.

Adde

http://img406.imageshack.us/img406/7924/winrate26xr.jpg

12-23-2005, 06:54 PM
this is very interesting stuff, thanks for tkaing the time do it!

Adde
12-24-2005, 07:22 PM
More random notes...

(*) Anyone got way more hands (than my 110K), and want to share? If you have converted your PT database to SQL I can give you easy instructions to generate an export file, which I can concert to Excel graphs. It would be interesting to see how the stats for a sample of 100K hands converge for a larger total (say 200K+ hands).

Adde

Sniper
12-24-2005, 07:29 PM
It would be useful to put the graphs in context by adding another graph of cumulative winnings in BB, ploted after each 100 hand block.

Adde
12-24-2005, 07:51 PM
It would be useful to put the graphs in context by adding another graph of cumulative winnings in BB, ploted after each 100 hand block.

Like this?

("Linjär" = Linear; trend line)

http://img359.imageshack.us/img359/8733/bbcum29kr.jpg

XChamp
12-24-2005, 08:08 PM
This is very interesting. Thanks a lot.

MrEngenic
12-25-2005, 07:43 AM
You have played 110k 2/4 hands on party in december???
What is your screen name?

Adde
12-25-2005, 07:55 AM
You have played 110k 2/4 hands on party in december???
What is your screen name?

110k hands from last december til now, one year, not one month.

Adde

Sniper
12-25-2005, 02:54 PM
[ QUOTE ]
Like this?

[/ QUOTE ]

Yes, exactly what I meant... and what I expected it to look like /images/graemlins/wink.gif

Have you given consideration to any further analysis to help evaluate the short term variations?

For example... how about an overlay of the 1st original chart (the 10K), with expected vs actual results based on your card distribution?

Adde
12-25-2005, 03:45 PM
For example... how about an overlay of the 1st original chart (the 10K), with expected vs actual results based on your card distribution?

That's a very interesting thought. Pokerroom has extensive EV data for starting hands on their site which could be used for this. A bit more complicated to generate (edit: the data for) these graphs though, but I'll look into it.

Adde

Sniper
12-25-2005, 10:14 PM
Adde...

You could do the quick math, using your own BB/Hand calcs from PT /images/graemlins/wink.gif

jtr
12-26-2005, 09:33 AM
[ QUOTE ]
You could do the quick math, using your own BB/Hand calcs from PT /images/graemlins/wink.gif

[/ QUOTE ]

I think that might start to get a bit circular, as the two types of data (per hand win-rates and per 10,000 hand win-rates) are far from independent.

theRealMacoy
12-27-2005, 04:42 AM
[ QUOTE ]
[ QUOTE ]
You could do the quick math, using your own BB/Hand calcs from PT /images/graemlins/wink.gif

[/ QUOTE ]

I think that might start to get a bit circular, as the two types of data (per hand win-rates and per 10,000 hand win-rates) are far from independent.

[/ QUOTE ]


...now that is an understatement.

/images/graemlins/wink.gif

Sniper
12-27-2005, 04:58 AM
[ QUOTE ]
[ QUOTE ]
You could do the quick math, using your own BB/Hand calcs from PT /images/graemlins/wink.gif

[/ QUOTE ]

I think that might start to get a bit circular, as the two types of data (per hand win-rates and per 10,000 hand win-rates) are far from independent.

[/ QUOTE ]

I figured Adde would understand what I meant...

If you take the Avg BB/Hand for each type of hand dealt (AA, KK, etc)... and apply it to the actual distribution of cards in each 1K segment... it will help identify when your win rate diverges from your expected win rate based on card distribution...

You could then do a deeper analysis of the times when actual diverges from expected based on the cards, to help identify true leaks /images/graemlins/wink.gif

Does that make more sense?

madmisha
12-27-2005, 12:25 PM
great info, thanks