PokerStars homepage
  • If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Spreadsheet/Graphs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spreadsheet/Graphs

    Im looking for an excel spreadsheet that can calculate my Sit and Go ROI and ITM%

    Just something simple so I can just plug in the numbers and it will calculate all that.

    Also I am wondering how to make graphs that show games and money won.

    I don't know if there is one out there but if anyone has a link or something let me know.

    2 Time Bracelet Winner



  • #2
    Well, this isn't an excel spreadsheet, but before I got the jr version of PT3 I was using this free software I downloaded from cnet: Poker Tracker

    I remember worrying though that it might not have been completely accurate though?

    Hopefully somebody will come along with something better

    EDIT: It used to be free, now I see it costs $5. Meh, not worth the money I don't think
    Last edited by TrustySam; Fri Dec 23, 2011, 04:10 AM.

    Comment


    • #3
      Thanks for your reply TrustySam. I had pt3 before but expired so that might not work. Im gunna try to download that and see if it works tho.
      2 Time Bracelet Winner


      Comment


      • #4
        This is the sort of thing spreadsheets were made for..

        Very easy to do, but then, I used to do spreadsheets for a living..

        Anyway, here's the spreadsheet I made to track my cowboy results. Does everything you ask. Took me 5 minutes to create.

        The graph is just a line graph of the PnL column
        Attached Files

        Comment


        • #5
          Wow thank your so much tomcrockpot. umbup: Cool an early christmas gift thanks
          2 Time Bracelet Winner


          Comment


          • #6
            Originally posted by pokerstar671 View Post
            Wow thank your so much tomcrockpot. umbup: Cool an early christmas gift thanks
            Happy to help. Merry xmas

            Comment


            • #7
              Thanks Tomcrockpot it's very useful in tracking your challenge progress with graphic presentation. I insert new column to add the numbers of games played to make sure i did not miscount the games again buy just looking at the lines numbers only. Great Helpumbup:

              Comment


              • #8
                Tomcrocpot Anyway i can put code on place finished? exemple: 1=5.46 2=3.94 so on so forth so when i put 1(mean 1st place) automatically 5.46 will add on Price. Thanks in advance.umbup:

                Comment


                • #9
                  Originally posted by PINOY_HITMAN View Post
                  Tomcrocpot Anyway i can put code on place finished? exemple: 1=5.46 2=3.94 so on so forth so when i put 1(mean 1st place) automatically 5.46 will add on Price. Thanks in advance.umbup:
                  Yeah, that's not a bad idea. Lookup tables are the way to go. Lookup the vlookup and hlookup functions. I'll make the changes tomorrow and upload a new version.

                  Comment


                  • #10
                    Originally posted by Tomcrockpot View Post
                    Yeah, that's not a bad idea. Lookup tables are the way to go. Lookup the vlookup and hlookup functions.

                    I'll make the changes tomorrow and upload a new version.
                    thanks man it will save a lots of time in updating the table

                    Comment


                    • #11
                      umbup:Got it man, just watched how vlookup was done via video in you tube.

                      Comment


                      • #12
                        Originally posted by PINOY_HITMAN View Post
                        umbup:Got it man, just watched how vlookup was done via video in you tube.
                        umbup: glad you're learning. Excel is not as hard as some people think and you can do a lot with it. The version I've just attached has multiple tables for the 25c and 50c and formulas to look up the appropriate table for the tournament type you've entered
                        Attached Files

                        Comment


                        • #13
                          Originally posted by Tomcrockpot View Post
                          umbup: glad you're learning. Excel is not as hard as some people think and you can do a lot with it. The version I've just attached has multiple tables for the 25c and 50c and formulas to look up the appropriate table for the tournament type you've entered
                          Thanks Tomumbup:

                          Comment

                          Working...
                          X

                          X Cookies Information

                          We have placed cookies on your computer to improve your experience on our website. You can change your cookie settings at any time. Otherwise, we'll assume you're OK to continue.