Handicapper Spreadsheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lsutigahs1978
    SBR Rookie
    • 11-26-12
    • 5

    #1
    Handicapper Spreadsheet
    Hi all. First post; longtime lurker, take it easy on me Great site.

    SIAP, but hypothetically you have 10 people in your office that you take bets from (strictly for fun obviously). I am looking to create a spreadsheet that will download site data from scoresandodds daily to not only keep track of, but also "grade" the bets; i.e. to determine which ones are right and wrong some kind of way by color code, or other method. From that point, I can easily handle the formulas for calculating the losses, wins, dollars, etc...

    So essentially I am looking to create a handicapper/bookie spreadsheet. I have seen other spreadsheets on the web and here to keep up with your own bets and all, but that's not what I am looking for. I am looking to create a spreadsheet from the other end of the spectrum. I know there are some sites that offer a per player fee monthly to do this for you, but am hopeful to do this all in a spreadsheet via excel.

    In my head, i'm thinking of having the downloaded site data in one tab, and then each "user" will have their own tab referencing the downloaded data for formulas. But would every day then become a different tab? Surely there are different ways of doing that, that would get quite cumbersome and create many many tabs and then become almost unusable, unless it would then just replace the daily information in that tab since the web info will always be there to serve as a frame of reference for any disuptes? I just need a little help in the creation and formulas/macros/code for doing so.

    Surely someone has created such a spreadsheet? If so I would love to see one. Any and all help, tips, suggestions, formulas, etc is greatly appreciated. Thanks!!
  • evo34
    SBR MVP
    • 11-09-08
    • 1032

    #2
    I think there are a lot of free options available online, such as http://www.footballfrenzyonline.com/.../features.aspx.
    Comment
    • lsutigahs1978
      SBR Rookie
      • 11-26-12
      • 5

      #3
      Thanks for the reply. Looking for something more detailed, and not really wanting it to be stored online. Trying to create an actual bookie spreadsheet that will score picks and download site data.
      Comment
      • jgilmartin
        SBR MVP
        • 03-31-09
        • 1119

        #4
        Haven't heard of that existing but you could always do it yourself via a Web Queries in Excel.
        Comment
        • lsutigahs1978
          SBR Rookie
          • 11-26-12
          • 5

          #5
          Originally posted by jgilmartin
          Haven't heard of that existing but you could always do it yourself via a Web Queries in Excel.
          Thanks. Any ideas what the formulas for those queries would look like?
          Comment
          • rhino1153
            SBR Wise Guy
            • 07-18-10
            • 999

            #6
            Originally posted by lsutigahs1978
            Thanks for the reply. Looking for something more detailed, and not really wanting it to be stored online. Trying to create an actual bookie spreadsheet that will score picks and download site data.
            What do you plan on tracking for bookies or do you mean the actual picks?
            Comment
            • lsutigahs1978
              SBR Rookie
              • 11-26-12
              • 5

              #7
              Originally posted by rhino1153
              What do you plan on tracking for bookies or do you mean the actual picks?
              The picks. Parsing the data from the site, then a series of If formulas maybe? Seems very complex.
              Comment
              • Harun
                SBR MVP
                • 07-25-11
                • 1513

                #8
                docs.google.com
                Comment
                • delldog
                  SBR Hustler
                  • 02-10-10
                  • 71

                  #9
                  You will probably need an analytic software such as mini-tab and a lot of time to measure trends.
                  Comment
                  • muffins
                    SBR High Roller
                    • 03-03-12
                    • 145

                    #10
                    As jgilmartin noted use Excel webqueries to pull down the data in to one tab, then from your bets tab use lookup functions to find the relevant team/event and score. IF formulas to result, perhaps some conditional formatting if you want color coded.

                    Alternative is to use python for data scraping, but would take some learning.
                    Comment
                    • byronbb
                      SBR MVP
                      • 11-13-08
                      • 3067

                      #11
                      Go big time.

                      Comment
                      • lsutigahs1978
                        SBR Rookie
                        • 11-26-12
                        • 5

                        #12
                        Thanks guys. Will look into all of this.

                        Cheers
                        Comment
                        SBR Contests
                        Collapse
                        Top-Rated US Sportsbooks
                        Collapse
                        Working...