Excel Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • playz
    SBR Sharp
    • 01-31-09
    • 493

    #1
    Excel Question
    Is it possible to import lines from 2 different books into excel and then have excel identify when they hit deserved odds? Odds would have to be refreshed often. Is there a way to do this? I would want the lines to refresh within Excel.
  • Data
    SBR MVP
    • 11-27-07
    • 2236

    #2
    Yes, it is possible. See Excel help to find out how to refresh a web query. That can be done at timed intervals.
    Comment
    • playz
      SBR Sharp
      • 01-31-09
      • 493

      #3
      Here are the problems I am running into.. When I log into a sportsbook and try and import the data Excel says that I need to edit my query. If I don't login and go to their "public" lines which are not accurate and import that it works. I need to be logged in though to see the lines. Number 2.... I cant seem to be able to import matchbook lines. Any help would be appreciated.
      Comment
      • Data
        SBR MVP
        • 11-27-07
        • 2236

        #4
        Originally posted by playz
        Here are the problems I am running into.. When I log into a sportsbook and try and import the data Excel says that I need to edit my query. If I don't login and go to their "public" lines which are not accurate and import that it works. I need to be logged in though to see the lines. Number 2.... I cant seem to be able to import matchbook lines. Any help would be appreciated.
        You are going to need to set up an XML feed.

        http://office.microsoft.com/en-us/excelHA011895301033.aspx?pid=CL100570551 033

        Sports betting and handicapping forum: discuss picks, odds, and predictions for upcoming games and results on latest bets.
        Last edited by Data; 05-02-09, 09:17 AM.
        Comment
        • Data
          SBR MVP
          • 11-27-07
          • 2236

          #5
          Sports betting and handicapping forum: discuss picks, odds, and predictions for upcoming games and results on latest bets.


          The link above get screwed up, trying again.
          Comment
          • playz
            SBR Sharp
            • 01-31-09
            • 493

            #6
            I would like the lines to update faster than every 30 secs. From what I see from the post I would need the API from matchbook but do other books offer this. Just say I want up to the sec. lines from thegreek how would I do this? I do not even fully understand what the API is.
            Comment
            • Data
              SBR MVP
              • 11-27-07
              • 2236

              #7
              Originally posted by playz
              I want up to the sec. lines
              That you cannot have in Excel.
              Comment
              • playz
                SBR Sharp
                • 01-31-09
                • 493

                #8
                I would like the lines to refresh like every 15 secs. Is that possible?
                Comment
                • TomG
                  SBR Wise Guy
                  • 10-29-07
                  • 500

                  #9
                  You can setup an XML data source in Excel and you can manually refresh it as often as you like. Some caveats though. If you refresh too often you draw the ire of the bookmaker for the burden you're putting on their servers. It will also take a few moments to refresh in Excel. It's not practical to use Excel for anything near real-time odds. It's best for using Excel's formulas for post-processing analysis on non-moving lines.
                  Comment
                  • MonkeyF0cker
                    SBR Posting Legend
                    • 06-12-07
                    • 12144

                    #10
                    The best way to go about this would be to code a scraper/XML reader that scrapes the data from certain bookmakers' web pages and imports the line feeds from the various books that offer them into a database. From there you can run queries against your database and draw the latest line info. I honestly wouldn't be too concerned about getting updates every 15 seconds. Pinnacle, for example, will cut off your access to their XML feed if you update more than every 60 seconds. It rarely makes a difference anyway. You won't miss that many moves in this timespan.
                    Comment
                    • Pancho sanza
                      SBR Sharp
                      • 10-18-07
                      • 386

                      #11
                      if you've set auto refresh every hour, do you need to open the file in order for the refreshed values to feed to other spreadsheets?
                      Comment
                      • Data
                        SBR MVP
                        • 11-27-07
                        • 2236

                        #12
                        Originally posted by Pancho sanza
                        if you've set auto refresh every hour, do you need to open the file in order for the refreshed values to feed to other spreadsheets?
                        yes, an unopened file does not get updated
                        Comment
                        • Pancho sanza
                          SBR Sharp
                          • 10-18-07
                          • 386

                          #13
                          thanks data
                          Comment
                          • Pancho sanza
                            SBR Sharp
                            • 10-18-07
                            • 386

                            #14
                            nt
                            Comment
                            • Pancho sanza
                              SBR Sharp
                              • 10-18-07
                              • 386

                              #15
                              This table is pass attempts in chronological order by a QB, for three different games, the #'s represent outcomes, 2 = complete, 5 = incomplete, 6 = interception etc.

                              Date result

                              20070910 2
                              20070910 5
                              20070910 2
                              20070917 5
                              20070917 2
                              20070917 6
                              20070924 1
                              20070924 2
                              20070924 3

                              Theres more than 40 rows (attempts per game) but i've shortened things to illustrate.

                              How do i organize the attempts so i can arrange them horizantally into another file, I want it to look like this, cells would be A1 through D5

                              date pass att 1 pass att 2 pass att 3

                              20070910 2 5 2
                              20070917 5 2 6
                              20070924 1 2 3

                              thanks
                              Comment
                              • TomG
                                SBR Wise Guy
                                • 10-29-07
                                • 500

                                #16
                                Highlight. Copy. Paste Special. Transpose.
                                Comment
                                • Data
                                  SBR MVP
                                  • 11-27-07
                                  • 2236

                                  #17
                                  C2=IF($A2=$A3,B3,"")
                                  Copy and paste C2 to fill the whole sheet to the bottom and as much as needed to the right.
                                  Insert a new column B.
                                  B2=IF(A2=A1,0,1)
                                  Fill the new column B with that formula. You will get 1s for the first records of every day.
                                  Select all, copy, paste special, values. Sort by column B and remove block of lines where B equals 0 leaving only 1s. Delete column B. That's all.
                                  Last edited by Data; 05-08-09, 10:41 AM. Reason: correcting steps to produce more transparent results
                                  Comment
                                  • MilfDriller
                                    Restricted User
                                    • 11-23-08
                                    • 10186

                                    #18
                                    Data always doing good work.
                                    Comment
                                    • Data
                                      SBR MVP
                                      • 11-27-07
                                      • 2236

                                      #19
                                      Originally posted by MilfDriller
                                      Data always doing good work.
                                      Thanks, I am trying.

                                      Please note, doing good work includes making mistakes. Putting in an effort to correct those mistakes and getting it right is an everlasting process. Thanks to all participating in that quest by asking and answering questions in this forum.
                                      Comment
                                      SBR Contests
                                      Collapse
                                      Top-Rated US Sportsbooks
                                      Collapse
                                      Working...