Re: ROI?
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
|