What does your spreadsheet look like?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CertainValor
    SBR Hustler
    • 01-30-12
    • 77

    #1
    What does your spreadsheet look like?
    I'm currently in the process of building a new tracking and handicapping spreadsheet and was curious what some of yours look like.

    I've spent the last three months tracking Accuscore 60%> predictions and 4*predictions to see if their most confident picks support their claims. Generally they do not.

    The difference between their handicapping efforts and my own efforts without the benefit of a "service" are about 0.6% over a large sample. Doesn't justify the cost.

    This is something you already know, but figured I'd reiterate.

    So I figure I'll rebuild my spreadsheet to handicap and track based on my own method from the last few months, since my method is free. But curious about the general layout of yours, what you include, etc.

    Screenshots would be fun>
  • HeeeHAWWWW
    SBR Hall of Famer
    • 06-13-08
    • 5487

    #2
    All the usuals, plus expected profit, then variance and 1 or 2 standdev figures. Can then graph the 1/2 standev lines so you know what range is typical. Nice way of remembering quite what a giant range of results you can get ..... only once you get outside 2SD do you start thinking good/bad luck :-)
    Comment
    • TomG
      SBR Wise Guy
      • 10-29-07
      • 500

      #3
      Originally posted by HeeeHAWWWW
      All the usuals, plus expected profit, then variance and 1 or 2 standdev figures. Can then graph the 1/2 standev lines so you know what range is typical. Nice way of remembering quite what a giant range of results you can get ..... only once you get outside 2SD do you start thinking good/bad luck :-)
      be careful if your wagers are not all independent but you are assuming covariances equal to zero. otherwise your stdev calculations will be way off and you're going to see a lot of extreme results.
      Comment
      • TomG
        SBR Wise Guy
        • 10-29-07
        • 500

        #4
        handicapping and tracking spreadsheets should be totally different
        Comment
        • CertainValor
          SBR Hustler
          • 01-30-12
          • 77

          #5
          Originally posted by TomG
          handicapping and tracking spreadsheets should be totally different
          They are. I just keep them in the same xls file. Easier to draw from one another.
          Comment
          • tukkk
            SBR Sharp
            • 10-04-10
            • 391

            #6
            Originally posted by CertainValor
            They are. I just keep them in the same xls file. Easier to draw from one another.
            use xlsb , its a lot faster
            Comment
            SBR Contests
            Collapse
            Top-Rated US Sportsbooks
            Collapse
            Working...