Connecting odds/line data with a web resource

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nash13
    SBR MVP
    • 01-21-14
    • 1122

    #1
    Connecting odds/line data with a web resource
    Hi,
    i have a good system ongoing for Massey Ratings Data, but the hardest thing is to connect the information from massey with actual lines and odds.
    the ideal solution would be a sheet where the data from massey is combined with ML odds and ATS/HC lines.
    An example:

    Atl ** vs Ceara

    https://www.oddsportal.com/soccer/br...o-**-KfMnPA77/

    Pinnacle odds:
    2.46 - 3.19 - 3.22
    5Dimes odds:
    2.44 - 3.28 - 3.18

    Massey estimations:
    22% for Atl **
    43% for Ceara
    the draw would be the resulting difference from 100% = 35%.

    So my aim is to make it easier to connect the resources.
    Combined in one sheet/table.
  • danshan11
    SBR MVP
    • 07-08-17
    • 4101

    #2
    Pinny has an API and Massey can be scraped, I dont know anything about 5dimes
    Comment
    • nash13
      SBR MVP
      • 01-21-14
      • 1122

      #3
      thank you, will have a deeper look into api's
      Comment
      • Barrakuda
        SBR Wise Guy
        • 02-28-18
        • 786

        #4
        You can also scrape Pinny if you use a Power Query in Excel.

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. Please upgrade to a newer Excel version.)
        Comment
        • danshan11
          SBR MVP
          • 07-08-17
          • 4101

          #5
          I think its really hard to win especially with some automated line scraper, I believe that Massey and Sag and others do a darn good job of creating power rankings for the big 4 sports but personally I would not use them for more than a comparison tool as part of a model. You can simply and very quickly see how OFF Massey and Sag are by just looking at this weeks lines and using 3 and comparing to the sag or massey. Yes they are good, yes they are cool, yes they have some value but I think 90% of their value is as a comparative tool as part of a model example is
          I get Broncos @ Jaguars as Jags -5
          so I will compare that to Massey and Massey has -7
          and Sag has -6
          this would tell me I am probably a hair light and that would probably slide me closer to -5.5 or -6 and that is the max extent of their value as far as I am concerned but of course I am probably completely wrong but this is just my 2 cents. I consider them as about as valuable as a method of checking my math!
          Comment
          • Barrakuda
            SBR Wise Guy
            • 02-28-18
            • 786

            #6
            http://www.thepredictiontracker.com/

            Comment
            • nash13
              SBR MVP
              • 01-21-14
              • 1122

              #7
              i will Not try to beat established markets, the good thing is, that Massey covers smaller sports very well.
              Comment
              • nash13
                SBR MVP
                • 01-21-14
                • 1122

                #8
                I follow a fellow user in a foreign forum, he beats the lines in a special market. Soccer from Venezuela.
                I don't really understand the obsession of people to be productive and successful at the major markets like NFL, NBA or MLB.
                It is much much harder there.
                Comment
                • HeeeHAWWWW
                  SBR Hall of Famer
                  • 06-13-08
                  • 5487

                  #9
                  Originally posted by nash13
                  I don't really understand the obsession of people to be productive and successful at the major markets like NFL, NBA or MLB.
                  It is much much harder there.
                  It is ..... but the limits are massively higher.

                  Generally agree though, not worth it for most trying.
                  Comment
                  • nash13
                    SBR MVP
                    • 01-21-14
                    • 1122

                    #10
                    Originally posted by HeeeHAWWWW
                    It is ..... but the limits are massively higher.

                    Generally agree though, not worth it for most trying.
                    i'd rather win on lower limits than loosing on higher ones
                    Comment
                    • Optional
                      Administrator
                      • 06-10-10
                      • 61243

                      #11
                      Originally posted by Barrakuda
                      You can also scrape Pinny if you use a Power Query in Excel.

                      https://www.microsoft.com/en-us/down...b-5f84fee61dd9
                      How long has that been around?

                      Nice.

                      Anyone can scrape data with that!


                      .
                      Comment
                      • danshan11
                        SBR MVP
                        • 07-08-17
                        • 4101

                        #12
                        Originally posted by nash13
                        i'd rather win on lower limits than loosing on higher ones
                        I always thought small markets had really high margins
                        Comment
                        • Barrakuda
                          SBR Wise Guy
                          • 02-28-18
                          • 786

                          #13
                          Originally posted by Optional
                          How long has that been around?

                          Nice.

                          Anyone can scrape data with that!


                          http://labs.office.com/guides/Discov...or%20Excel.htm
                          Not sure. Stumbled upon it about a year ago. Definitely worth trying whenever a regular web query fails.
                          Comment
                          SBR Contests
                          Collapse
                          Top-Rated US Sportsbooks
                          Collapse
                          Working...