Today I'm sharing my Double or Nothing SnG Bankroll Management Spreadsheet. It's the spreadsheet I use to keep track of my DoN SnG Challenge progress and it allows me to easily post charts on my site. This spreadsheet will work with both standard and turbo DoN
DoNs are a great way to build up a bankroll because they are relatively low variance games and pretty easy to beat. Using this spreadsheet can help you build a nice sized roll from a relatively small deposit on PokerStars. Just enter a few parameters and start playing. The spreadsheet will let suggest when you should move up (or down) in stakes. If you don't have PokerStars, you can download it and create an account free here.
VersionThis spreadsheet is free to use. All you need is a Google Docs account which is also free.
Current Version: 1.0
You can check your current version but clicking on the About/Version sheet. 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 DoN Bankroll Management SpreadsheetStep 1: Get a Copy
Click on this link to create a copy of the spreadsheet. You'll need to sign into Google Docs using your Google Account. If you don't already have a Google Account there are steps to create one along the way.
Ste 2: Set up Your Bankroll Management Rules
The third sheet in the spreadsheet contains areas where you determine the parameters for your bankroll management strategy. These settings will determine what stakes you play and how many tables to play at a time. Click on the Bankroll Rules link on the bottom of the spreadsheet to open it up.
Your bankroll management strategy is defined by the following parameters:
- Starting Bankroll
- This is how much you're starting your DoN Bankroll with. Usually a portion of your current bankroll set aside for DoNs.
- Buyin % of BR
- The % of your bankroll you risk per buy-in. Somewhere between 1-5% is a good starting point. 5% translates to 20 buy-ins per level, 1% is 100 buy-ins. The lower your winrate, the more conservative you want to be with this figure. As you move up levels you may choose to decrease this number. If you play turbo DoNs stick to a lower number.
- Max at Risk Per Sess
- The maximum amount of your bankroll you risk per session. This determines how many tables you can have open simultaneously. A number around double your Buyin % of BR number is a good starting point. I wouldn't recommend going above 10%. Use this as a guide, if you're win rate decreases significantly when you increase the number of simultaneous tables you play then stick to what you're comfortable with.
The top portion of the DoN Session sheet provides some information to let you know how well you're doing. Most of it should be pretty self explanatory. All the grey cells are information only, do not edit them. There are two white cells that you should edit whenever you change level or the number of tables you regularly play. Actual Buyin and Actual Tbls/Sess. Filling these in is necessary for the stats that show up below. These stats give you an idea of how much you're putting at risk per game and per session.
Two important numbers you should pay attention to are Game BuyIn and Recc Tables/Sess. These numbers suggest which level you should play in and how many simultaneous tables you can have open based on the rules you defined for your bankroll management strategy.
Entering Session DataNow that you set up your bankroll management rules and know what buyin and how many tables to play, it's time to record data and fire up some tables.
You'll enter your session details in the DoN Sessions sheet. The spreadsheet comes populated with some sample data. If you're starting new, delete the data in the white cells of the sessions data table. Do not make any changes to any grey cells. They are calculated for you.
When you need to add a new row, copy and paste the previous row to copy all the calculated fields then delete the white fields and enter the new session data.
Enter the Date, Start Time, and BuyIn then load up your tables. As each game finishes update the Wins and Loses fields to reflect your actual number of wins and losses. When you're done playing, record the end time of your session.
Some people prefer to play a certain number of tables from start to finish then open up a new batch of tables, others prefer to always keep a certain number of tables open and play for a certain amount of time. Either way you can use this spreadsheet.
Updating and Publishing Your Bankroll ChartYou need to take a few steps to update your bankroll chart. You can also publish your chart so that you can post it on the web like I have on the side of my blog. Whenever you update the chart in your spreadsheet, the chart on the web will also be updated.
The instructions are the same as for the cash game spreadsheet. You can read the directions here.
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.