Quote:
Originally Posted by slickolas
i use to let PT4 track my results but nothing ever seemed right and never took it too seriously.
i would track stats with pad and pen if i had to. but if it's basic knowledge about excel, i'm sure it's super easy. i would like to see how your excel ss looks on start up or what the input into each cell is.
First row: Color Code each month. Just alternates between those two shades of blue. This is also where i mark if i happen to get a bonus from bovada and ill just add it to a random cash. Sometimes they give away $50/ week or whatever the bonus is so i track that.
Second Row: MTT #
Third Row: Date Played. Color coded alternating between yellow and green. This just helps me count how many days i played that month easier.
Fourth Row: Buy In Amount
Fifth Row: Place i took in mtt. If i didn't cash i just put 0 cuz i don't care what i got unless i cashed.
Sixth Row: How much i cashed for (sometimes i might have not cashed in the mtt but i did get some K/Os so ill look out for those and put those)
Seventh Row: How much i won or lost for that specific MTT
Eighth Row:: Total Profit Since First MTT
Ninth Row: Its blank now because I'm behind on updating it, but i track if i cashed by typing the word 'Cash'. Then i can filter for the word Cash and find out how many times ive cashed and compare to total mtts and get my cash % (Its ~14%).
Tenth Row: Again, empty right now. If i final table ill track if i got 'First' 'Second' or 'Third'. This helps me know how often I'm getting top 3 and how often I'm closing out the mtt.
Eleventh Row: Current Month Profit.
Nothing between Eleventh and last Row.
Last Row: Year To Date Profits.
This works for me. Ive tinkered with it a lot and this is how i find the most efficient way to track my play and get all the basic stats i want.
For example, if i wanna know how much ive cashed for since i started playing on bovada, i just find the sum of the sixth row, which is
$192,568.88. And other cool little things like this (ROI, etc..)
YOURE WELCOME
Last edited by Agentduque; 07-04-2014 at 04:48 AM.