[playz]

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]

Yes, it is possible. See Excel help to find out how to refresh a web query. That can be done at timed intervals.

[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.

[Data]

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

http://www.sportsbookreview.com/forum/handicappe...matchbook.html

[Data]

http://www.sportsbookreview.com/forum/handicappe...matchbook.html

The link above get screwed up, trying again.

[playz]

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.

[Data]

I want up to the sec. lines

That you cannot have in Excel.

[playz]

I would like the lines to refresh like every 15 secs. Is that possible?

[TomG]

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.

[MonkeyF0cker]

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.

[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?

[Data]

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

[Pancho sanza]

thanks data

[Pancho sanza]

nt

[Pancho sanza]

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

[TomG]

Highlight. Copy. Paste Special. Transpose.

[Data]

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.

[MilfDriller]

Data always doing good work.

[Data]

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.