Poker Forum

Over 1,232,000 Posts!

REGISTER
Subscribe to FTR web feed
Already Registered?      Username:    Password:   Remember      Forgot Password

Poker Forum

  > 

Tools Of Poker

  > 

Discussion: Bankroll Management Spreadsheet

  
 
LinkBack Thread Tools Display Modes
Eric
Old 04-12-2006, 06:10 AM     Post subject: Discussion: Bankroll Management Spreadsheet #1 (permalink)  
Eric's Avatar
Administrator
Administrator

Join Date: Dec 2003
Location: on my laptop
Posts: 1,778
Eric has disabled reputation
 RE: http://www.flopturnriver.com/phpBB2/...06.html#290826

We hope this excel tool helps people with bankroll management. Please let us know what you like and dislike about it.
Reply With Quote

Play for FREE and practice your game at...

Join the FTR Poker Forum to disable these banners and start posting!
midas06
Old 04-12-2006, 02:41 PM #2 (permalink)  
midas06's Avatar
4-of-a-Kind

Join Date: Jun 2005
Location: NZ
Posts: 2,196
midas06
I really like it. Would you be able to provide a 'blank' copy of it for us? (I'm an Excel n00b and don't want to screw it up by deleting the wrong cells...)
Reply With Quote
siknd
Old 04-12-2006, 03:16 PM #3 (permalink)  
siknd's Avatar
Flush

Join Date: Sep 2005
Posts: 359
siknd
i left the stats in so you could see what it should look like.

all you have to do it put in your own session stats in rows 31 and 32. then select and delete all my sesssions, ie everything in columns B-V (same for cash, tourney and live). the only other thing you will have to do is reset all the deposits and cashouts to zero on the bankroll page, and youre ready to go.
'If you think a weakness can be turned into a strength, I hate to tell you this, but that's another weakness. '
 
Reply With Quote
CrimsonOne
Old 04-12-2006, 07:54 PM #4 (permalink)  

Join Date: Jun 2005
Posts: 13
CrimsonOne
Very nice spreadsheet, thank you for making it available.

I look forward to using it
Reply With Quote
Pelion
Old 04-13-2006, 02:09 PM #5 (permalink)  
Pelion's Avatar
4-of-a-Kind

Join Date: Sep 2005
Posts: 3,206
Pelion
the blank one isnt downloading.

just getting an Error404
gabe: Ive dropped almost 100k in the past 35 days.

bigspenda73: But how much did you win?
 
Reply With Quote
Eric
Old 04-16-2006, 05:01 AM #6 (permalink)  
Eric's Avatar
Administrator
Administrator

Join Date: Dec 2003
Location: on my laptop
Posts: 1,778
Eric has disabled reputation
Quote:
Originally Posted by Pelion
the blank one isnt downloading.

just getting an Error404
Please try again. It looks like the blank one was renamed to
http://poker-tools.flopturnriver.com...ords-empty.xls

Sorry for the confusion.
Reply With Quote
Okok
Old 05-04-2006, 05:11 PM #7 (permalink)  

Join Date: May 2006
Posts: 2
Okok
Hey, I just downloaded it and it looks very promising. However, I have one little issue. When you enter the data "Cash"-page, it also shows up on the "Summary"-page, but it doesn't change the numbers on the "Bankroll" -page. Is it supposed to be like this?

It would almost be TOO good if it changed the "Bankroll"-page, right?

Cheers!
/Oscar
Reply With Quote
siknd
Old 05-04-2006, 06:13 PM #8 (permalink)  
siknd's Avatar
Flush

Join Date: Sep 2005
Posts: 359
siknd
the source data numbers as entered on the cash page will be read on both the summary and bankroll page. the summary page pulls data from the cash page via the month (ie, it is set to read the monthly tags, May 06, in this case)

the bankroll page pulls data from the cash page via the site names. if you have entered the site name differently from how it is set to read on the bankroll page, then it wont work.

check that first:

1. go to bankroll page. say you are playing at party poker. so click on cell E4
2. cell E4 contains the formula which will gather the data. in the equation bar at the top of the spreadsheet, you can view the formula.
3. in this case you will see:=SUMIF(Cash!H31:Cash!H9999,"Party Poker",Cash!U31:Cash!U9999)
4. the quotations indicate the correct moniker, ie PartyspacePoker. This is what you will need to enter in column H of the cash page. If youve entered just Party, or PP or PartyPoker or anythign different, this is proably the reason you are having problems.

if this is not the case, and you still cant figure it out, PM me. i will give you my email, you can send me the spreadsheet, and id be glad to help you out with it one-on-one.

lmk.

sic
'If you think a weakness can be turned into a strength, I hate to tell you this, but that's another weakness. '
 
Reply With Quote
Okok
Old 05-05-2006, 12:32 PM #9 (permalink)  

Join Date: May 2006
Posts: 2
Okok
Thank you so much! Brilliant work with this spread, I'm gonna recommend to it everyone I know.

I especially enjoyed the private e-mail support! :-]
Reply With Quote
Silly String
Old 05-05-2006, 02:46 PM #10 (permalink)  
Silly String's Avatar
Full House

Join Date: Jul 2005
Location: KC, MO
Posts: 1,434
Silly String
I just started poking around with your Bankroll tracker. Wow you did a great job on that spreadsheet!
One minor suggestion. Can you add a column for number of hands played per session, and have it extrapolate a BB/100? BB/100 is how most online players keep their stats since BB/hr can vary widely due to the ability to multi-table. Otherwise that thing is incredible, Cheers!
Playing live . . . thanks alot Bin Laden.
 
Reply With Quote
siknd
Old 05-05-2006, 03:42 PM #11 (permalink)  
siknd's Avatar
Flush

Join Date: Sep 2005
Posts: 359
siknd
i do factor for multitabling. column L on the cash page is where you enter the number of tables played. the subsequent formulas on the summary page compute all figues in big blinds per hour per table. beyond that, and separating longhand from shorthand, i really have no way to refine it further; ie i could only produce BB/100 by rough estimation, which would be worse than what i currently have.

that said, if anyone can suggest a way to incorporate it, my ears are open.
'If you think a weakness can be turned into a strength, I hate to tell you this, but that's another weakness. '
 
Reply With Quote
Spud
Old 06-07-2006, 09:03 PM #12 (permalink)  

Join Date: Jun 2006
Posts: 3
Spud
First, let me just say that the spreadsheet looks terrific. I’m using the empty one and I noticed that when I enter my tournament winnings on the tournament page, it doesn’t transfer those winnings into my bankroll for that particular site.

I don’t use spreadsheets, so I don’t know if it would do that or not, but thought it would be cool if it did. Am I doing something wrong, or do I still have to enter my tournament winnings into my bankroll manually? Thanks
Reply With Quote
Spud
Old 06-10-2006, 02:21 PM #13 (permalink)  

Join Date: Jun 2006
Posts: 3
Spud
Hello?

I figured it out... copy & paste works wonders. Thanks anyway.
Reply With Quote
Random_Hero
Old 06-17-2006, 03:42 PM #14 (permalink)  
Random_Hero's Avatar
Full House

Join Date: Feb 2006
Location: Dundee - Scotland
Posts: 608
Random_Hero
Hi I aint got a clue about spreadsheets and am having trouble getting the correct formula in the tournament section so it shows up on the bankroll page.

anyone tell me what formula to put where so it updates the bankroll page too? cheers all help appreciated.

I play sit &go's so its just the tourney page i need.

fantastic spreadsheet though...

cheers
 
Reply With Quote
Spud
Old 06-19-2006, 05:57 PM #15 (permalink)  

Join Date: Jun 2006
Posts: 3
Spud
Quote:
Originally Posted by Random_Hero
Hi I aint got a clue about spreadsheets and am having trouble getting the correct formula in the tournament section so it shows up on the bankroll page.

anyone tell me what formula to put where so it updates the bankroll page too? cheers all help appreciated.

I play sit &go's so its just the tourney page i need.

fantastic spreadsheet though...

cheers
Remember it is a pre-fabricated spreadsheet, so you will have to enter the data that is pertinent to you.

IE: Go over each CELL that has a function. You will see something like this:
=SUMIF(Cash!H31:Cash!H1029,"Party Poker",Cash!N31:Cash!N1029)+SUMIF(Tournament!H31:Tourna ment!H1029,"Party Poker",Tournament!U31:Tournament!U1029)

If you Play at NordicBet (example), make sure you inesrt NordicBet where Party Poker is.

Also, if you add rows, make sure the ranges coincide.

Ie: SUMIF(Cash!H31:Cash!H1029,"Party Poker",Cash!N31:Cash!N1029)+SUMIF(Tournament!H31:Tournament!H1029,"Party Poker",Tournament!U31:Tournament!U1029

So if you start inputing your data at cell N29 & U29, it won't add it up on the bankroll page.
Reply With Quote
Random_Hero
Old 06-20-2006, 10:36 AM #16 (permalink)  
Random_Hero's Avatar
Full House

Join Date: Feb 2006
Location: Dundee - Scotland
Posts: 608
Random_Hero
cheers spud. got it now.
 
Reply With Quote
Pigskin
Old 08-15-2006, 03:23 AM #17 (permalink)  
Pigskin's Avatar

Join Date: Oct 2004
Location: Toowoomba, Australia
Posts: 7
Pigskin
Hi folks,
Great spreadsheet - appreciate the effort that has gone into it

Quick question if I may - could i get an explanation of what the values on Tournament page G34, G35, G36 etc represent please ? (values like 0.5, 1.0 etc)

I'm probly a dill, but sobeit

thanks in advance

Oink !
Reply With Quote
Pigskin
Old 08-15-2006, 03:32 AM #18 (permalink)  
Pigskin's Avatar

Join Date: Oct 2004
Location: Toowoomba, Australia
Posts: 7
Pigskin
Oops nevermind

Figured it out ... time played ...

Oink !
Reply With Quote
LewsTherin7
Old 08-25-2006, 01:16 PM #19 (permalink)  
LewsTherin7's Avatar

Join Date: Aug 2006
Posts: 46
LewsTherin7
What is the X-Axis on the graph in the tournament worksheet? Right now I want to adjust it because it seems like I am zoomed to far out and I want to know what I am changing before I change it.
Reply With Quote
shysti
Old 08-25-2006, 07:01 PM #20 (permalink)  
shysti's Avatar
Full House

Join Date: Sep 2005
Location: The Internetz
Posts: 838
shysti
Send a message via AIM to shysti Send a message via Skype™ to shysti
 anyway to use this without having microsoft excel?
My Poker Blog:http://shystitalkspoker.wordpress.com/
 
Reply With Quote
Pigskin
Old 12-17-2006, 12:30 PM #21 (permalink)  
Pigskin's Avatar

Join Date: Oct 2004
Location: Toowoomba, Australia
Posts: 7
Pigskin
Hi folks,

Looking for some help from somebody who uses this ... and is probly an Excel forumlae expert

Would like to insert a formula on the Tournament page under column "Q" for representing MTT Final Tables as a percentage

I guess it has to say -
1. Where column "K" is greater than 10
2. AND column "O" is less than or equal to 10
3. Express cell "Q4" as a percentage of all tournaments that meet points 1 and 2

perhaps there is somebody out there that uses this great spreadsheet who already has this set up

help appreciated

Cheers,
Oink !
Reply With Quote
littleogre
Old 12-17-2006, 01:24 PM #22 (permalink)  

Join Date: Oct 2004
Posts: 1,344
littleogre has a little shameless behaviour in the past
Quote:
Originally Posted by shysti
anyway to use this without having microsoft excel?
yes there are a couple free programs out there.
Reply With Quote
Miffed22001
Old 11-04-2007, 01:10 AM #23 (permalink)  
Miffed22001's Avatar
Straight Flush

Join Date: Jun 2005
Location: Marry Me Cheryl!!!
Posts: 8,181
Miffed22001 is on a distinguished road
 year old bump.

Nobody seems to know about this yet its really good.

Thanks X and whoever designed it.
Reply With Quote
SGTChuck
Old 01-05-2008, 07:04 AM     Post subject: Use epassporte instead of netteller #24 (permalink)  
SGTChuck's Avatar

Join Date: Dec 2007
Location: Gillette, WY
Posts: 48
SGTChuck
Send a message via Yahoo to SGTChuck
Hi,

I'm going to try and use this program for the new year and track my poker bankroll. Been terrible tracking my poker spending the last few years. I was wondering though if there is a way to use Epassporte instead of netteller for that link 16 and hyper link it some how instead.

Thanks for any help
Reply With Quote
JG34
Old 01-17-2008, 11:09 PM #25 (permalink)  

Join Date: Jan 2008
Posts: 2
JG34
I just found this spreadsheet and I am very impressed. I've tweaked a couple of things to suit my needs but overall this looks like a fantastic way to manage ones bankroll.

I know this thread is old but thank you and well done to the creators!
Reply With Quote
JG34
Old 01-17-2008, 11:17 PM     Post subject: Re: Use epassporte instead of netteller #26 (permalink)  

Join Date: Jan 2008
Posts: 2
JG34
Quote:
Originally Posted by SGTChuck
Hi,

I'm going to try and use this program for the new year and track my poker bankroll. Been terrible tracking my poker spending the last few years. I was wondering though if there is a way to use Epassporte instead of netteller for that link 16 and hyper link it some how instead.

Thanks for any help
SGTChuck,

This is an easy fix as I just did it. There are three things you need to do...

1) Hover over the NETTeller link. Right click and select edit hyperlink. From here, just change the URL to epassporte's website and hit OK.

2) Hover your mouse in the NETTeller box but so you see the white plus sign (+) instead of the pointer finger. When you see the white cross, double click and change the name to 'EPassporte'. Hit enter.

3) Beneath the account charts but above the pie graphs there is a graphic icon that says 'NETTeller'. There are also graphics that read Live and Online. Hover over the NETTeller and right click. Scroll down to 'Select data' and left click. Select NETTeller and then click the Edit button. Under 'Series Name' change it from NETTeller to EPassporte, without disturbing the rest of it. Click OK, and then Ok again.

Now you are set! Sorry for all of the detail but I am not sure how Excel savvy you are. Hope that helps!
Reply With Quote
kronickiller
Old 02-12-2008, 03:01 AM     Post subject: Question regarding Rakeback & Cake Poker #27 (permalink)  

Join Date: Feb 2008
Location: Minneapolis
Posts: 1
kronickiller
Ok,
My first question is regarding Rakeback......How should one go about keeping track of ur rakeback each month
Second question is regarding poker rooms I do not use. Is there any way to delete them or just leave them in there since really they are not hurting anything. Also I use Cake poker and is it ok if I just put it in "Empires" spot since I do not use that site?
Reply With Quote
Andrew
Old 02-13-2008, 05:02 AM #28 (permalink)  
Andrew's Avatar
Straight

Join Date: Dec 2007
Posts: 210
Andrew
Anychance of a walk through in being able to increase the graphs' data? I've already gone through the 32 games in the cash tab and would hate to leave it at just those first games.
Blog/Journal
http://www.flopturnriver.com/blogs/author/andrew/
http://poker-wolf.insanejournal.com/
 
Reply With Quote
squalito
Old 05-31-2008, 01:11 AM #29 (permalink)  

Join Date: May 2008
Posts: 1
squalito
Hello,

Very good spreadsheat You've done a great job !!

Just a question :

In the Tournament page What is in "English" the PERCENTILE ?
Not sure to understand this formula : Percentile=100-((Rank*100)/(#entries+1))

I'd understand if it was #Rank*100/#entries but here....

Is it a real percentile (like quantile), some explanation would be great

Thanks a ton
Squalito
(sorry for my english)
Reply With Quote
tkisme
Old 07-14-2008, 07:33 AM #30 (permalink)  

Join Date: Jul 2008
Posts: 3
tkisme
I am really dying to see this spreadsheet, but I don't have Excel. Most computers come with Microsoft WORKS these days and not WORD, unfortunately. The two formats are not compatible. Is there a way to get this in WORKS?
Reply With Quote
19RK64
Old 11-08-2008, 05:45 PM #31 (permalink)  

Join Date: Feb 2008
Posts: 1
19RK64
Quote:
Originally Posted by tkisme
I am really dying to see this spreadsheet, but I don't have Excel. Most computers come with Microsoft WORKS these days and not WORD, unfortunately. The two formats are not compatible. Is there a way to get this in WORKS?
Im not shure if you firgured something out by now if not,their are other excell programs that you can use out their that will allow you to use this spreadsheet, one that seem to work ok on most spreedsheets that you will find: OpenOffice . org
Reply With Quote
kRaZyKiRb
Old 09-17-2009, 05:18 PM #32 (permalink)  

Join Date: Sep 2009
Posts: 1
kRaZyKiRb
My screen size is set to its max and that is 1024x768. However, that's still not enough to see the application (it will not scroll to the right). What can I do?


**Update**
If you're using a screen with the above resolution or smaller, you may not be able to view the entire spreadsheet. To fix this (in Excel 2007), simply "Unfreeze" panes by going to View>Windows>Freeze Panes>Unfreeze Panes
Reply With Quote
Chokdee3
Old 01-23-2010, 03:18 PM     Post subject: Re: Discussion: Bankroll Management Spreadsheet #33 (permalink)  

Join Date: Jan 2010
Posts: 1
Chokdee3
Hi Eric, just downloaded the spreadsheet and it looks great. Is there a list of what information should be entered in each field of the tourney section? Or a way to see the field title by hovering or clicking somewhere on the spreadsheet?

Thanks!
Reply With Quote
DenverDave
Old 05-06-2010, 04:48 PM #34 (permalink)  
High Card

Join Date: May 2010
Posts: 1
DenverDave is on a distinguished road
 Hello, I just found the spreadsheet and love it. May save me from having to create one of my own or even a database tool.

Is there a way to remove the Neteller functionality? Being a US player this is not an option anymore.

Do you have any plans to change this in a future version?

Thanks
Reply With Quote
fliperizzz
Old 05-11-2010, 05:02 PM #35 (permalink)  
High Card

Join Date: May 2010
Posts: 2
fliperizzz is on a distinguished road
 Nice, you saved me some time.
Reply With Quote
Reply
Latest Poker News
KoRnholio Old 02-11-2012, 09:04 PM    Tennessee worries that Online Poker could reduce State Lottery revenues
There are a number of officials in Tennessee who believe that legalized online poker would cut into their state lottery revenues, much of which goes towards education programs. Shirley Raines, Preside ...

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 03:47 AM.

Contact Us - Archive - Top

FTR Testimonials

All content
© FlopTurnRiver.com 		Advertising  |   Partners  |   Testimonials  |   T&C  |   Contact Us  |   FTR News & Press  |   Site Map  |   Search FTR

Full Tilt  |   Titan Poker  |   UltimateBet  |   Poker Stars  |   Ladbrokes Bonus  |   Sportsbook  |   Cake Poker  

Play Texas Holdem Online, Online Texas Holdem Strategy, & Poker Forum
This is not a gambling website.