tag:blogger.com,1999:blog-1147658610731565923.post3070443365568506949..comments2023-11-01T18:47:37.538-04:00Comments on MicroRoller: Cash Game Bankroll Management SpreadsheetUnknownnoreply@blogger.comBlogger17125tag:blogger.com,1999:blog-1147658610731565923.post-4696511957378213672021-07-19T07:17:36.276-04:002021-07-19T07:17:36.276-04:00if someone wants to withdraw some money from there...if someone wants to withdraw some money from there bankroll that part is missingAnonymoushttps://www.blogger.com/profile/16868136100535694807noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-87634724903734880882013-01-08T18:32:44.126-05:002013-01-08T18:32:44.126-05:00Is this site still active?
Is this site still active?<br />Anonymoushttps://www.blogger.com/profile/06610410742277689868noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-91226546269503617192011-05-03T12:28:20.350-04:002011-05-03T12:28:20.350-04:00Hi!
Thanks for the quick reply!
Yes, it was a typ...Hi!<br /><br />Thanks for the quick reply!<br />Yes, it was a typo, it showed 0.01/0.02 off course. <br />But after reloading it, it showed correctly the level I shold play at according to my settings.<br /><br />You wrote in one post that you would also start out aggressively with 5 buy ins for 0.05/0.10<br />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.<br />What level would you suggest changing? I have set my buffer at 10%, maybe that will take care of it a little? <br />Also, I have rakeback on Tilt, could you implement a field in the spreadsheet for rakeback? How do you organise this yourself?<br /><br />Thanks again for the quick reply!Annaleena & Frodehttps://www.blogger.com/profile/12328882520705743933noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-57805167430605094522011-05-03T00:38:06.833-04:002011-05-03T00:38:06.833-04:00Annaleena & Frode,
First, did you mean 0.01/0...Annaleena & Frode,<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />If you look at the <b>Worksheet</b> sheet the Max BR column will tell you how much your bankroll needs to be for next stake level.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />Let me know if that helps. If not please let me know all the bankroll rules you have set.MicroRollerhttps://www.blogger.com/profile/08859061638087303080noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-56756973500805365792011-05-02T20:02:07.237-04:002011-05-02T20:02:07.237-04:00I have a couple of questions:
In the spread, I hav...I have a couple of questions:<br />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.<br />I also changed the % of BR for when to leave to 40%<br />And safety to 10%<br /><br />However on the main page, it still says 0.01/0.01 for current stakes, it should be 0.05/0.10<br />Also next to the white space for entering chips in front of me, it says now: $20.99 till $22.99 in play% 3%.<br /><br />None of this makes much sense to me at the moment, and I don't know how to change it. Can you help?Annaleena & Frodehttps://www.blogger.com/profile/12328882520705743933noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-68750149280451128342011-04-19T16:53:03.673-04:002011-04-19T16:53:03.673-04:00Awesome spreadsheet Micro-much appreciated.
Is ver...Awesome spreadsheet Micro-much appreciated.<br />Is version 1 still the most up to date for MTT's?Parky 32https://www.blogger.com/profile/10287060952614602441noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-22794986941786171022011-02-15T10:09:54.875-05:002011-02-15T10:09:54.875-05:00Update: Version 1.2.2 should hopefully fix the err...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.<br /><br />Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-19436280536639581362010-12-30T02:25:45.502-05:002010-12-30T02:25:45.502-05:00I tried it again in Firefox and I got that error y...I tried it again in Firefox and I got that error you guys are seeing for the first time.<br /><br />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)<br /><br />That seemed to fix things.<br /><br />I mainly use the <a href="http://www.google.com/chrome" rel="nofollow">Google Chrome browser</a> for these spreadsheets without issue. If you're still having problems try to see if using Chrome helps.<br /><br />It's intermittent so it's hard to diagnose.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-79168474311685871222010-12-29T22:25:08.390-05:002010-12-29T22:25:08.390-05:00Same issues here, here is a copy of my sheet. the ...Same issues here, here is a copy of my sheet. the #NAME? is supposed to be stakes<br /><br />Current Bankroll: $49.07 Current Stakes: #NAME? Brought to you by http://blog.microrollers.com <br />Overall Stats Session Stats Important Info <br />Total Profit -$0.93 Average Profit -$0.23 Next Buyin (max) getCurrentStakesMinBI(D1), #ERROR!<br />Total Time -7:01:00 Average ROI #DIV/0! Leave Table (chips) $4.91 <br />Total Hands 75 Average Length -1:45:15 Big Blinds at Current Level 0 <br />ROI -1.86% Average # Hands 25 $ Needed for next level $50.93 <br />Buyin ROI -13.10% Average BB/100 #DIV/0! % Earned For Next Level 49.07% <br />$/Hand -$0.01 Average $/hour -$1.68 Chips In Play $2.08 Update your table stack occasionally<br />$/Hr $0.13 Have to Leave Table #ERROR! #ERROR!<br />Sess # Date # Tbls Big Blind Start Time End Time # Hands Start Chips End Chips Profit Length ROI $/HR BB/100 Bankroll Notes<br />0 $50.00 <br />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 <br />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 <br />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 <br />4 12/29/2010 1 $0.02 9:07:00 $0.00 -9:07:00 #DIV/0! $0.00 #DIV/0! $49.07Unknownhttps://www.blogger.com/profile/02854286919637701869noreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-79182078961711774652010-12-17T00:14:35.852-05:002010-12-17T00:14:35.852-05:00It's working fine for me. I primarily use Goog...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,<br /><br />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?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-6483239591944050242010-12-14T21:13:01.082-05:002010-12-14T21:13:01.082-05:00hello micro roller i am having the same problem as...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 systemrickynoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-23725289633609739202010-12-09T16:35:11.649-05:002010-12-09T16:35:11.649-05:00The latest version is 1.2.1 if you check the Versi...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.<br /><br />What browser and operating system are you using?<br /><br />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.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-91042293299408565602010-12-09T15:40:35.066-05:002010-12-09T15:40:35.066-05:00I recently downloaded v1.2. Is anyone else receivi...I recently downloaded v1.2. Is anyone else receiving an error in cell J1 on the Sessions page? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-1799527567690417472010-03-31T22:18:01.467-04:002010-03-31T22:18:01.467-04:00Hey Micro,
Just wanted to say many thanks for doin...Hey Micro,<br />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!Mattnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-4481556743438688412010-03-24T13:11:13.611-04:002010-03-24T13:11:13.611-04:00Thanks Nathan, I'm glad you enjoyed this post....Thanks Nathan, I'm glad you enjoyed this post.<br /><br />I have some more spreadsheets for MTTs and DoN SnGs that I'll be putting up soon.<br /><br />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.<br /><br />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%.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />Hope that helps.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-25830636257321479052010-03-24T12:32:56.132-04:002010-03-24T12:32:56.132-04:00Wow, Micro, this is very helpful information. Than...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!!<br /><br />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!!Nathannoreply@blogger.comtag:blogger.com,1999:blog-1147658610731565923.post-46682121591005322852010-03-16T20:00:17.529-04:002010-03-16T20:00:17.529-04:00New Version 1.2 is out.
There were some problems ...New Version 1.2 is out.<br /><br />There were some problems with the initial version that are now fixed.<br /><br />I've also added a better way to determine when to leave the table. This is more how Chris Ferguson did it.<br /><br />Also added a new field to let you know what % of the way you are to moving up to the next stake level.<br /><br />You can create a new spreadsheet based on the new template, then copy your session data over to it (white fields only).MicroRollerhttp://blog.microrollers.com/noreply@blogger.com