PlayerVsPlayer Poker Graph Software

Cash Game Bankroll Management Spreadsheet

Comments: 17
A common reason many new (and even experienced) poker players go broke is because they fail to follow good bankroll management practices.

One of the most important aspects of good bankroll management is keeping records of your sessions so you can track your progress and know when to move up or down in stakes.
You don't need any fancy software to practice good bankroll management. For my own cash game challenge I've just been using a spreadsheet on Google Docs. The nice thing about using Google Docs is that I can access the spreadsheet from anywhere using a web browser, it's free and I can include a bankroll chart on my blog. It instantly gets updated when I update the spreadsheet.

Because a lot of people have been willing to share their knowledge online I've been able to have good results in online poker I figured I'd try and do the same and share my spreadsheet. I even made significant updates to it so it's even easier than what I first started using.

Hopefully my bankroll management spreadsheet helps your game but to really improve check out my BlueFirePoker review as well.
These Bankroll Management Spreadsheets are free but if you find them useful please
consider clicking the button below and donating at least $5 to help continue enhancements.



Versions

Things don't work out perfectly the first time and there may be changes and updates as time goes by. Check back here to make sure you're using the latest version of this spreadsheet. There is a Subscribe by email link  further down the page by the Comment Form. If you subscribe you'll receive emails whenever there is a new comment. I'll add a new comment when there is an updated version.

To find out what version you have check the last sheet named About/Version. If your spreadsheet does not contain an About/Version sheet, you need to upgrade. Click on the version number below for the current version of the template.

Current Version: 1.3

To upgrade your version, use the new template to create a new spreadsheet, then copy your session data to the new spreadsheet, as well as your bankroll rules.

Getting Started With the Bankroll Management SpreadSheet

Step 1: Get a Copy

Click on this link to create your own copy of the spreadsheet. You'll need a Google Docs account. If you don't already have one there are steps on how to create one.

Step2: Set up Your Bankroll Management Rules

First thing you'll want to do is define the rules for your bankroll management strategy. To do so, open the Bankroll Rules sheet by clicking on the link marked Bankroll Rules at the bottom left of the spreadsheet as shown below.


This will open up the following sheet:


The spreadsheet comes pre-filled with example rules but you are free to change them to suit your preferences.
Starting Bankroll
This is pretty straight forward. How much money are you depositing or setting aside for your cash games? Just enter the number in the cell. This number along with # Big Blinds Per Level will determine what stakes you start playing at. If you want to start out at higher stakes, I recommend increasing your starting bankroll instead of decreasing # Big Blinds Per Level too much. 
Buyin % of BR
This number should be entered as a percent. Make sure it didn't accidentally get changed or it will screw other parts of the spreadsheet up. If it doesn't have the % sign after it, add it. This number determines how much you will buy-in to a table with. The lower the number, the more conservative the bankroll management strategy is. The higher, the more aggressive. A number most people would recommend is around 5%. That's what Chris Furgeson used in his Bankroll Challenge. If you want to be more aggressive you can enter a bigger number. To simulate Daniel Negreanu's Bankroll Challenge you would enter 20%. Personally I think that's a little high. I'm going with 5% myself.
Leave when % of BR
You need to know when to take your winnings and leave the table. Both Chris Ferguson and Daniel Negreanu would leave the table when after they basically doubled their initial buy-in. So a safe number would be to set this to twice Buyin % of BR. Ferguson's idea was to never have more than 10% of his bankroll at risk at any one time and I think that's a safe rule to follow. The spreadsheet isn't going to give you exactly the number Ferguson would use but it's close enough.
# Big Blinds Per Level
As your bankroll increases (or decreases) you'll want to move up (or down) in stakes to increase your profits. You're not going to win every session so you're going to want to give yourself a cushion to account for bad beats, bad decisions and variance. A good rule of thumb is to try and buy in for the maximum and give yourself 20 buyins. Since the maximum buyin at PokerStars is 100 Big Blinds, a conservative value for this field is 2000. If you want to have a more aggressive approach and move up in stakes faster set this number lower. Daniel Negreanu's bankroll challenge used 500 big blinds per level. I wouldn't recommend going too low. The relationship between this value and your Buyin % of BR determines if you're playing deep stacked or short stacked. It's better to play deep stacked to maximize your profits.
Safety %
As you move up in stakes, you'll encounter tougher competition and your variance will likely increase. To account for this I added a safety factor. For each new stake level the # Big Blinds Per Level will increase by this amount. So for example if you have 2000 BB's set up with a 5% safety factor, for the first level you'll use 2000 big blinds, the next level will require 2100 BBs before you advance and the one after that 2200. Chris Ferguson didn't implement anything like this in his bankroll management strategy, Daniel Negreanu had some loosely defined provision for it when he reached higher stakes, but this is a common practice by many. A number between 5%-10% should be adequate for most people.

Entering Session Data

Now you're all set to start playing cash games and enter in your session information on the sheet named Sessions

On the top middle portion of the sheet you'll find Current Stakes which will tell you which stakes you should be playing. Under that and towards the right is a field marked Next Buyin (max) which will tell you how much you should buyin for. These values are determined based on your current bankroll and the bankroll management rules you set up previously.


You'll also notice on the top portion of the sheet is information to let you know how you're doing and also let you know what stakes to play, how much to buyin for, when to leave the table, how many big blinds you have for your current level and how much more money you need to make before you can move up to the next level.

These fields are all calculated for you automatically and you should not overwrite the data in them. Any field that has a colored background should be left as is.

You'll enter your session data in the lower portion of the spreadsheet in the cells with a white background. Cells with grey backgrounds are calculated based on the data you enter.

The template you started with has 4 rows of sample data to give you and idea of what to enter. The easiest thing to do is copy the entire last row into the row below and then update the data in the white cells with the new session information. If you're using the spreadsheet for the first time, delete the sample data in the white cells and replace it with your actual session data.
Date
The date of the session in format month/day/year. ex: 3/15/2010
# Tbls
The number of simultaneous tables you played in the session. 
Big Blinds
The amount of the big blind for the tables you played. if you're playing $0.2/$0.05 stakes enter $0.05
Start Time
The time you started your session in the format hour:minutes:seconds. The time gets displayed in 24 hour format but you can enter 9:12 pm and it will convert it for you. You don't have to enter seconds if you don't want to. I don't.
End Time
The time you ended the session and left the table. Same format as Start Time.
# Hands
The number of hands you played in that session. On PokerStars there's a tab marked Stats where the chat box and note box is. Click the Reset button before you start your session then at the end of the session, just see how many hands you played.
Start Chips
How much you bought in for. ex: $10.00. If you rebought during the session, make sure to add those amounts to this field. You can use formulas here so if you started with $10 and added $5 in the middle of the session you can enter =10 + 5 so you have more detailed information. If you're playing multiple tables, enter the amount for all your tables. If you bought in for $10 on 2 tables, enter $20.
End Chips
The amount of chips you left the table with. Again, if you're playing multiple tables add the chips up from all the tables. You can use formulas again here so if you had 2 tables and you left one with $25 and the other with $0 you can enter =25 + 0.
Notes
It's a good idea to leave yourself some notes of how the session went. Why you lost or won. How you think you played. Also it's a good idea to enter the name of the table you played at to make it easier to find the hand history files if you choose to review the session later.

When to Leave the Table

I added a new feature that gives you a more accurate chip count to decide when to leave the table based on how much you have won.


Before you start a session you can see how much your next buy in should be based on the Next Buyin (max) field. Underneath that you see Leave Table (chips) which gives you a rough idea how much you should win before your bankroll management rules tell you to leave the table.

The problem with that is it doesn't factor in the chips in play and should only be used as a guide. Those count towards your bankroll. Once you enter your starting chips in your new session, the Leave Table (chips) field is useless.

To give you a more accurate a new field was added, Chips In Play. After winning a big pot, or a lot of small ones, enter the amount of chips you have in front of you at the table. The Have to Leave Table field will let you know if it's time for you to leave the table or if you can keep playing. Next to that field is a summary that tells you your current bankroll including the chips in play and what percent of your bankroll is in play.

To change when you should leave the table, edit the Leave when % of BR field in the Bankroll Rules sheet.

Updating the Bankroll Chart

I couldn't figure out a way to have the chart update automatically so you have to take a couple of steps after your session to have the chart include the new data.

Click on the Bankroll Chart link at the bottom of the spreadsheet to open up the Bankroll Chart sheet. Then highlight the last row in the table. On the lower right you'll see a blue square. Click on it and drag it down to fill the rows below it with the data from the new sessions. (You can also copy and paste the last row into the row below it. Whichever you find easier.)


After that you have to update the chart to read the new rows. Click on the chart and you'll see a light blue box surround it. On the upper left hand portion of that box will be the word Chart with a down arrow. Click on it and select Edit Chart to bring up the following dialog box.


Under the label What data? is a text field that defines the range used in the chart. It will look something like A1:Bxx where xx  is the number of the last row of information. So if you're last session was session number 14 this field should read A1:B15. The last row is one more than the session number because the headings take up the first row.

Publishing your Chart

You can post your bankroll chart on your blog or in a forum post if you wish to let others see how you're doing.

To do this, click on the chart to show the Chart menu in the light blue box and this time select Publish chart...


The first thing you'll get is a message asking you if you want everyone to see the chart. Click OK.

Next you'll get the following box that provides you with the HTML code to display the image. Just copy and paste the code into your blog. Click Done to close the popup.


If you are trying to post the image in a forum that uses BBCode instead of HTML, just copy the URL and use that. The URL is what's in the src attribute (between the quotes) and starts with http://

That's it. I hope some of you find this useful. If you have any questions or comments feel free to leave them below.

If you use this spreadsheet and include the chart in your blog I'd love to know about it. Just leave the link in a comment.

Disclaimer: This spreadsheet is provided free of charge with no guarantee or warranty for entertainment purposes only. Use at your own risk. When you gamble with real money there's no guarantee you won't lose.

17 Response to "Cash Game Bankroll Management Spreadsheet"

MicroRoller Says....

New Version 1.2 is out.

There were some problems with the initial version that are now fixed.

I've also added a better way to determine when to leave the table. This is more how Chris Ferguson did it.

Also added a new field to let you know what % of the way you are to moving up to the next stake level.

You can create a new spreadsheet based on the new template, then copy your session data over to it (white fields only).

Nathan Says....

Wow, Micro, this is very helpful information. Thank you so much, first of all, for doing this challenge! I am a young poker player just looking to really start to build my bankroll after a few years of ups and downs, and I am so excited to have stumbled upon this through Daniel's Twitter!!

I do have one question, though. I love to play low-buy in SnGs on Pokerstars (the 1.75 18-players, etc.). I find that I'm consistently successful in them, often cashing, and sometimes winning/placing very high, and I was wondering what advice you would give me as to factor that enjoyment and success into this BR strategy? Thanks again for your hard work and good luck on the felt!!

Anonymous Says....

Thanks Nathan, I'm glad you enjoyed this post.

I have some more spreadsheets for MTTs and DoN SnGs that I'll be putting up soon.

A spreadsheet for regular SnGs is going to be a little tricker to come up with. I'll include it when I post the others but It might not have all the same features.

For low buy-in single table SnGs a good rule of thumb is to have at least 20 buy-ins. As you move up in stakes add around 25%.

You can expect higher variance in the two table turbo SnGs you're playing so you want to give yourself a few more buyins to work with. Maybe 25-30. I don't play turbos regularly so you might want to confirm this advice elsewhere.

A lot depends on your winrate as well. If you're barely profitable you want to give yourself a bigger cushion than if you have a killer roi.

One thing to remember is that just because you have the bankroll to play a certain stake doesn't mean you have to play that high. You want to move up to make more money but when you do the games get a little harder so keep your ability and the speed at which you can adapt to higher stakes in mind.

Hope that helps.

Matt Says....

Hey Micro,
Just wanted to say many thanks for doing this, have a very basic spreadsheet of my own which i will be able to improve alot with this info. Keep up the good work mate!

Anonymous Says....

I recently downloaded v1.2. Is anyone else receiving an error in cell J1 on the Sessions page? Thanks!

Anonymous Says....

The latest version is 1.2.1 if you check the Version sheet that's what it should say but that particular cell hasn't changed.

What browser and operating system are you using?

If you want, you can share the spreadsheet in Google Docs which will give you a link to that spreadsheet. You can then email me that link using the Contact form from the top menu link and I'll take a look at it.

ricky Says....

hello micro roller i am having the same problem as anonymous i have an #ERROR! message in cell 1 j, 3 n-o, 6 n-o and 7 n-o how can i email you the link where do i find your email address i am using firefox as my browser and a mac as my operating system

Anonymous Says....

It's working fine for me. I primarily use Google Chrome for these spreadsheets but I tested them in Firefox and IE as well and they work fine for me,

Can one of you that are having problems please share the actual copy of the spreadsheet you're using so I can take a look at it?

Unknown Says....

Same issues here, here is a copy of my sheet. the #NAME? is supposed to be stakes

Current Bankroll: $49.07 Current Stakes: #NAME? Brought to you by http://blog.microrollers.com
Overall Stats Session Stats Important Info
Total Profit -$0.93 Average Profit -$0.23 Next Buyin (max) getCurrentStakesMinBI(D1), #ERROR!
Total Time -7:01:00 Average ROI #DIV/0! Leave Table (chips) $4.91
Total Hands 75 Average Length -1:45:15 Big Blinds at Current Level 0
ROI -1.86% Average # Hands 25 $ Needed for next level $50.93
Buyin ROI -13.10% Average BB/100 #DIV/0! % Earned For Next Level 49.07%
$/Hand -$0.01 Average $/hour -$1.68 Chips In Play $2.08 Update your table stack occasionally
$/Hr $0.13 Have to Leave Table #ERROR! #ERROR!
Sess # Date # Tbls Big Blind Start Time End Time # Hands Start Chips End Chips Profit Length ROI $/HR BB/100 Bankroll Notes
0 $50.00
1 12/29/2010 1 $0.02 7:44:00 7:59:00 3 $2.00 $0.00 -$2.00 0:15:00 -100.00% -$8.00 -1,666.67 $48.00
2 12/29/2010 1 $0.02 8:00:00 9:00:00 34 $3.10 $3.01 -$0.09 1:00:00 -2.90% -$0.09 -6.62 $47.91
3 12/29/2010 1 $0.02 8:09:00 9:00:00 38 $2.00 $3.16 $1.16 0:51:00 58.00% $1.36 76.32 $49.07
4 12/29/2010 1 $0.02 9:07:00 $0.00 -9:07:00 #DIV/0! $0.00 #DIV/0! $49.07

Anonymous Says....

I tried it again in Firefox and I got that error you guys are seeing for the first time.

I then went in and deleted all copies of the spreadsheet and emptied the trash and tried create a new copy. (Make sure you back up the session data so you can paste it back in)

That seemed to fix things.

I mainly use the Google Chrome browser for these spreadsheets without issue. If you're still having problems try to see if using Chrome helps.

It's intermittent so it's hard to diagnose.

Anonymous Says....

Update: Version 1.2.2 should hopefully fix the errors some users were getting with some of the scripts. Can you let me know if it's working for you now or not? Use the link above.

Thanks.

Parky 32 Says....

Awesome spreadsheet Micro-much appreciated.
Is version 1 still the most up to date for MTT's?

Annaleena & Frode Says....

I have a couple of questions:
In the spread, I have changed the buyin % of BR to 20% since I want to start a bit more frisky, and then get more conservative after a while if all goes well.
I also changed the % of BR for when to leave to 40%
And safety to 10%

However on the main page, it still says 0.01/0.01 for current stakes, it should be 0.05/0.10
Also next to the white space for entering chips in front of me, it says now: $20.99 till $22.99 in play% 3%.

None of this makes much sense to me at the moment, and I don't know how to change it. Can you help?

MicroRoller Says....

Annaleena & Frode,

First, did you mean 0.01/0.02 not 0.01/0.01? There shouldn't be any reason for it to display 0.01/0.01. If it does there's something seriously wrong. If that's the case change the sharing settings on your spreadsheet and email me the link using the Contact link in the top menu of this site.

Current Stakes is determined by the #Big Blinds Per Level setting, your current bankroll and the safety factor. If you want to move up whenever you have 5 buyins, which sounds like what you're trying to do?, for the next level set that value to 500.

If the 0.01/0.01 above was a typo I guess that's the issue you're having. If your normal buy-in is 100 big blinds multiply however many buy-ins you want by 100 before you move up in stakes.

If you look at the Worksheet sheet the Max BR column will tell you how much your bankroll needs to be for next stake level.

It's a little confusing because that worksheet isn't meant to be used. So on the 0.01/0.02 line if it says Max BR $25 that means your bankroll needs to be $25 before Current Stakes will change to 0.02/0.05.

The chips in play messages can be a little confusing and may be a little off. It's more of a guide. It adjusts your current bankroll based on how much you've won.

Play around with the $Big Blinds Per Level and Safety Factor to see how different settings affect the Max BR in the Workesheet and try to get the the Max BR to look like what you want.

Let me know if that helps. If not please let me know all the bankroll rules you have set.

Annaleena & Frode Says....

Hi!

Thanks for the quick reply!
Yes, it was a typo, it showed 0.01/0.02 off course.
But after reloading it, it showed correctly the level I shold play at according to my settings.

You wrote in one post that you would also start out aggressively with 5 buy ins for 0.05/0.10
This is what I am doing now, as if I go broke, I don't have any problem putting in some more cash. I have a normal job, poker is a nice hobby, so I can afford a new deposit every now and then, but I'd rather be able to get to not needing it, and make some nice money on the side.
What level would you suggest changing? I have set my buffer at 10%, maybe that will take care of it a little?
Also, I have rakeback on Tilt, could you implement a field in the spreadsheet for rakeback? How do you organise this yourself?

Thanks again for the quick reply!

Unknown Says....

if someone wants to withdraw some money from there bankroll that part is missing

Leave A Reply