How I track results - Global Poker -- Two Plus Two Poker Forums

Two Plus Two Forums Online Poker Sites & Marketplaces Online Poker Sites Global Poker

How I track results

...

08-12-2017 , 11:43 AM

splayaa

old hand

Join Date: May 2017 Posts: 1,546

Several people have asked me for the spreadsheet I use to track my Global results since other tools end up being more manual anyways.

Feel free to make comments and ask questions about why I set things up a certain way. The only thing I am sure of is I can't have found the best way to do things all on my own.

I use Excel 2007, you know the one with the ribbon. So if you are that version or after you should be fine. I don't know how open office and older versions will work, but give it a shot. Link is below.

biswb.com/WebShare/GlobalTracker.xlsx

08-16-2017 , 03:01 AM

JHair

Bagel Man

Join Date: Dec 2008 Posts: 4,407

im not understanding how this sheet is set up

08-16-2017 , 04:11 AM

Wild Bill

enthusiast

Join Date: Jul 2007 Posts: 89

I'm not sure either what's going on in splayaa's worksheet except he has a column for total cash winnings, and one for tournament winnings.

Here's a sample of what I do.

Key:
date
item
buy = buyin
cash = cashout
fin = finished
p/l = profit/loss
plyrs = #players in tournament
dep/wd = deposit/withdraw amount
tBUY = total buyin (total to date)
tCASH = total cahout (total to date)
tP/L = total to date profit/loss
roi
bal = balance in Global account.

EDITED for better view.

http://i249.photobucket.com/albums/g...psohieanth.jpg

Last edited by Wild Bill; 08-16-2017 at 04:17 AM.

08-16-2017 , 08:14 AM

splayaa

old hand

Join Date: May 2017 Posts: 1,546

Quote:

Originally Posted by JHair

im not understanding how this sheet is set up

Which part?

I can try to explain

08-16-2017 , 12:42 PM

oneday111

newbie

Join Date: Jul 2017 Posts: 20

Quote:

Originally Posted by Wild Bill

Shouldn't we track hours played and # of tables for cash game so we know approximate win rate?

08-16-2017 , 01:09 PM

splayaa

old hand

Join Date: May 2017 Posts: 1,546

Quote:

Originally Posted by oneday111

Shouldn't we track hours played and # of tables for cash game so we know approximate win rate?

I thought about doing it that way, but figured number of BB won/lost per 100 hands as I wasn't sure how to track individual results for multiple tables. But I can look at a hand counter and my balance at the end of a session.

Although if someone has a better idea, I am all ears.

08-23-2017 , 07:08 AM

Wild Bill

enthusiast

Join Date: Jul 2007 Posts: 89

Quote:

Originally Posted by oneday111

Shouldn't we track hours played and # of tables for cash game so we know approximate win rate?

I play tournaments only, but yes, if you play cash, you want to track that.

...