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.
Excel Question
Collapse
X
-
playzSBR Sharp
- 01-31-09
- 493
#1Excel QuestionTags: None -
DataSBR MVP
- 11-27-07
- 2236
#2Yes, it is possible. See Excel help to find out how to refresh a web query. That can be done at timed intervals.Comment -
playzSBR Sharp
- 01-31-09
- 493
#3Here 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 -
DataSBR MVP
- 11-27-07
- 2236
#4Here 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.
http://office.microsoft.com/en-us/excelHA011895301033.aspx?pid=CL100570551 033
Last edited by Data; 05-02-09, 09:17 AM.Comment -
playzSBR Sharp
- 01-31-09
- 493
#6I 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 -
playzSBR Sharp
- 01-31-09
- 493
#8I would like the lines to refresh like every 15 secs. Is that possible?Comment -
TomGSBR Wise Guy
- 10-29-07
- 500
#9You 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 -
MonkeyF0ckerSBR Posting Legend
- 06-12-07
- 12144
#10The 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 sanzaSBR Sharp
- 10-18-07
- 386
#11if 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 -
Pancho sanzaSBR Sharp
- 10-18-07
- 386
#13thanks dataComment -
Pancho sanzaSBR Sharp
- 10-18-07
- 386
#14ntComment -
Pancho sanzaSBR Sharp
- 10-18-07
- 386
#15This 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
thanksComment -
TomGSBR Wise Guy
- 10-29-07
- 500
#16Highlight. Copy. Paste Special. Transpose.Comment -
DataSBR MVP
- 11-27-07
- 2236
#17C2=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 resultsComment -
MilfDrillerRestricted User
- 11-23-08
- 10186
#18Data always doing good work.Comment -
DataSBR MVP
- 11-27-07
- 2236
#19Thanks, 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
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code