Spreadsheet??

BEERM4N

BEERM4N

Visionary
Silver Level
Joined
May 10, 2009
Total posts
619
Chips
0
Ok i relise there are programs that track your results out there (e.g. PT and Hold'em) but i was wondering if anyone here has made a excel spreadsheet up to track there results. I don't have the bankroll to pay for these programs but i really want to keep track of my money and alos practise better BRM.

So my question is has any1 made a spreadsheet that records these results? and would you be willing to share it with me?
 
ryodejaneiro

ryodejaneiro

Rock Star
Silver Level
Joined
Jan 13, 2008
Total posts
459
Chips
0
Well, I have a rudimentary spreadsheet that I use to keep track of my winnings. I could've tracked more info but if opted to do that, the info wouldn't have fit in one screen so I just included the main stuff that I had interest in. I'm hoping to get a tracking program sooner rather than later but until then, this is my main mode of tracking my winnings. I also justify things by remembering that there are no tracking programs to rely on during live play :)

I pared down this spreadsheet to keep some of my info private, but somewhat shamelessly began with my ccop win :p. Of course this is a tedious way of keeping track, so one of the issues is that the more you play, the more you'll have to scroll down and shift through when reviewing. The color coding scheme I adopted was blue for profit, red for loss, and then black for freerolls (if I don't cash in the freeroll, it stays black, if I win, it's blue). I use a calculation function so that whatever amount you enter for "amount won", the balance adjusts accordingly.

I hid the ring game details but I still use the same format as tourneys. Basically, I just put a bar in the box for sections that don't apply (e.g., payout structure, finish, etc). I wiped out the section on notes too, but basically, after my session, I just write some thoughts down - this ranges widely from memorable hands, my overall impression of how I played, to thoughts on what I need to work on (e.g., lost $ money from blinds, don't overplay hands out of position, etc), to cursing out my opponents. :D

Last section at the bottom details my bankroll management rules, which I believe are the same as the Ferguson Challenge since I began from 0 as well. I found out that having this info visible doesn't always translate into following these rules as I've made a few exceptions, but hasn't been an issue of late.

If people are interested, I can create a blank template that you guys can work off of, but I may not be able to send one out immediately. Let me know if something doesn't make sense.
 

Attachments

  • sample 2.JPG
    sample 2.JPG
    192.6 KB · Views: 41
roundcat

roundcat

Creature of leisure
Silver Level
Joined
Aug 25, 2005
Total posts
2,464
Chips
0
Here's a scaled-down version of the spreadsheet I use. I deleted most of the entries but left some examples from each category. The original tracks different levels of cash games, plus has separate sheets for different games (NLHE, LHE, Omaha etc.)
 

Attachments

  • nlhe.xls
    24 KB · Views: 27
BEERM4N

BEERM4N

Visionary
Silver Level
Joined
May 10, 2009
Total posts
619
Chips
0
thanks alot ryode alot of help. I just made one based on yours. thanks again mate, hopefully i can master BRM now :p

I'll check it out Belgo

i couldn't see yours roundcat??
 
Infamous1020

Infamous1020

Visionary
Platinum Level
Joined
Jul 17, 2007
Total posts
759
Chips
0
Beerman i have a sick spreadsheet that is much more detailed then the ones above, if you would like it I can email it or something. send me a PM.

I dont think i can attach it on here because it is multiple pages with graphs and such
 
P

pokerfan19

Rising Star
Bronze Level
Joined
Jul 6, 2009
Total posts
11
Chips
0
Well, I have a rudimentary spreadsheet that I use to keep track of my winnings. I could've tracked more info but if opted to do that, the info wouldn't have fit in one screen so I just included the main stuff that I had interest in. I'm hoping to get a tracking program sooner rather than later but until then, this is my main mode of tracking my winnings. I also justify things by remembering that there are no tracking programs to rely on during live play :)

I pared down this spreadsheet to keep some of my info private, but somewhat shamelessly began with my ccop win :p. Of course this is a tedious way of keeping track, so one of the issues is that the more you play, the more you'll have to scroll down and shift through when reviewing. The color coding scheme I adopted was blue for profit, red for loss, and then black for freerolls (if I don't cash in the freeroll, it stays black, if I win, it's blue). I use a calculation function so that whatever amount you enter for "amount won", the balance adjusts accordingly.
happy.gif

I hid the ring game details but I still use the same format as tourneys. Basically, I just put a bar in the box for sections that don't apply (e.g., payout structure, finish, etc). I wiped out the section on notes too, but basically, after my session, I just write some thoughts down - this ranges widely from memorable hands, my overall impression of how I played, to thoughts on what I need to work on (e.g., lost $ money from blinds, don't overplay hands out of position, etc), to cursing out my opponents. :D

Last section at the bottom details my bankroll management rules, which I believe are the same as the Ferguson Challenge since I began from 0 as well. I found out that having this info visible doesn't always translate into following these rules as I've made a few exceptions, but hasn't been an issue of late.

If people are interested, I can create a blank template that you guys can work off of, but I may not be able to send one out immediately. Let me know if something doesn't make sense.
Damn, that $78 winning day looks a little out of place in that list. :p And I usually just track my winnings in notepad... i might have to start using spreadsheets.
 
BEERM4N

BEERM4N

Visionary
Silver Level
Joined
May 10, 2009
Total posts
619
Chips
0
Beerman i have a sick spreadsheet that is much more detailed then the ones above, if you would like it I can email it or something. send me a PM.

I dont think i can attach it on here because it is multiple pages with graphs and such

Just got your email mate. Your right that spreadsheet is sick. I will be definatly using this. Thank you very much. Cheers.
 
S

shortshanks

Enthusiast
Silver Level
Joined
Apr 18, 2007
Total posts
26
Chips
0
Nice spreadsheet. I like how you've integrated the bankroll guidelines at the bottom.
 
Paw_kit Aces

Paw_kit Aces

Rock Star
Silver Level
Joined
Feb 24, 2008
Total posts
200
Chips
0
PM me if you still need me and I will send you a copy of mine.
 
FTPHeHaTeMe

FTPHeHaTeMe

Enthusiast
Silver Level
Joined
Jan 24, 2008
Total posts
72
Chips
0
This is a very good idea. I think I am going to start using one. Time to see when I run hot and when I need to just run
 
M

MaxiRodriguez

Rock Star
Silver Level
Joined
Jan 12, 2009
Total posts
403
Chips
0
I've just recently started tracking my sng results with a spreadsheet, and it's the great. It helps me turn what used to be the odd sng here and there, having a bit of fun into what seems to be me making money for a change!

It helps keep me focused and has even helped me spot some gaps in sng game, although still prone to the odd stupid mistake. Seing as its only a week old its a little crude but I hope to keep it going for as long as possible which might mean a change to the format. For now though it does the job well and was the best help to my sngs since the wiz. Here's a quick screenie, now i got 8 more sngs to play!
 

Attachments

  • sng sheet.jpg
    sng sheet.jpg
    148.2 KB · Views: 38
Top