Spreadsheet??

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?

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 . 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.

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.

Attached Images

sample 2.JPG (192.6 KB, 30 views)

You can use this: http://www.pokerdominator.com

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.)

Attached Files

nlhe.xls (24.0 KB, 19 views)

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??

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

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.

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

Nice spreadsheet. I like how you've integrated the bankroll guidelines at the bottom.

PM me if you still need me and I will send you a copy of mine.

no prob, enjoy!

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

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!

Attached Images

sng sheet.jpg (148.2 KB, 27 views)