ROI?

[Ajax410]

I'm just curious how all of you guys manage to come up with statistics telling you how well you perform in the long run on these SNG tournaments. Sorry if this is a stupid question, but I really have no idea. I play on PartyPoker and would love to keep track of how well I do. Thanks.

[tolbiny]

I will assume you know nothing about excel so i might sound condesending- it is unintentional.

open an excel spreadsheet. In cell A1 type = sum(A2:A65000) In cell B1 Type = average(B2:B65000) in cell C1 type = sum(c2:c65000) in cell E1 type = (C1+A1)/-A1.

In Column A you are going to enter the buy in for your tourney in Negative ( ie -11 for a 10+1 tourney)
in column B you are going to enter the place you took in the tourney and in Column C you will enter how much you won in the tourney (Do NOT take off your buyin from this amount). Cell E1 will be your ROI.

I do some other minor things, i put the start and finish time in columns D and E and the length of the tourney in row F so i know how long it takes to play an average tourney. In cell H1 i have = C1+A1 which is my total profit and in J1 = -average(A2:A65000)*F1 which is my return per tourney. In cells L1,M1,N1 i put my total 3rd,2nd and 1st place finishes respectively and in O1 = (L1+M1+N1)/-(A1/average(A2:A65000) which is your ITM.
hope this answers your Questions

[eastbay]

[ QUOTE ]
I will assume you know nothing about excel so i might sound condesending- it is unintentional.

open an excel spreadsheet. In cell A1 type = sum(A2:A65000) In cell B1 Type = average(B2:B65000) in cell C1 type = sum(c2:c65000) in cell E1 type = (C1+A1)/-A1.


[/ QUOTE ]

Another option is to shell out a few bucks for pokertracker. google for it.

eastbay

[Kurn, son of Mogh]

Keep a record of every session you play.

I use My Poker Diary

For more detailed info on your hands and opponents, try Poker Tracker