Poker Bankroll / Stats Spreadsheet

After searching forever for a simple but useful spreadsheet to track all my poker results I decided to make my own and share it with the world. The idea is that I can use it for tournaments, sit and go's, live games and cash games. I just put the result into the sheet after the game and I can review all my games and keep an eye on my bankroll. I have decided to make it last for 4 years, as Microsoft will probably update excel by then.


You don't need any macros running to use it and you don't need to know anything at all about Excel. It will give me information about how profitable certain games, the effects of playing more than one table at once, the return on my investments, the profitability of sites, venues and home games. and much more. The more that this is used, the more the stats will show you what is needed to improve in your game.

I'll use this page for any questions anyone might have while using it.

How to use:

Go to Personal Preferences page and add a site or venue where you play. Some have been added already but feel free to delete them.
When you play a game click on the Input page. This is where you will log your games after playing them. There are two sheets in one here, one for sit and go's or tournaments (blue), and one for ring games (purple). Make sure you put the data in for all of the requested columns. The Spreadsheet will take care of the rest.

Download Spreadsheet

Some things to note.

The date format at the moment is set as dd-mm-yy, so when you input the dates you must input them that way. For example, the 10th of February 2008 is 10-02-08 and not 02-10-08 as the Americans would use it. The sheet would read the above example as the 2nd of October 2008 which would cause errors when you analyze your data afterwards.

I have put a few sample entries in the Input and Personal Preferences pages to show you how to put them in, so just delete those.

The sites or venues that you play can be deleted but NOT if you have played there already and used it. This is important. It holds a maximum of 50.

The charts, graphs and tables will be very useful once you have input some data into it but as with all data analyzing, will be useless to start with. The more you use it the more it will help you.

This spreadsheet is obviously completely free, but if you could click on the bookmark button underneath this post and help spread the word then that would really be appreciated.