Just got subscripted to donbest - How to structure the 1H lines information?

**SolidDala** · 10-02-10, 11:20 AM

the structure for it is like this

11/02 07:26:24am #509 Minnesota 96½u05
11/02 07:26:25am #509 Minnesota 96½u05 OPENER
11/02 07:33:33am #509 Minnesota 96½u05
11/02 07:33:33am #510 LA Clippers 4½-12
11/02 07:47:33am #505 Houston
11/02 07:47:33am #506 Utah
11/02 07:47:58am #506 Utah 5-05
11/02 07:47:58am #505 Houston 103u05
11/02 07:48:07am #509 Minnesota 96½u12
11/02 07:48:39am #509 Minnesota 96½u19
11/02 07:48:59am #509 Minnesota 96½u15
11/02 07:49:15am #509 Minnesota 96½u11

**mminkovski** · 10-02-10, 11:34 AM

How can I download their historical info for lines, scores, totals, etc...?
I have pretty good statistical analysis software but still cannot find data extracts for past 10 years in MLB, NBA, NFL. Someone mentioned donbest have all this and I signed up for a free trial but cannot find the information.

**SolidDala** · 10-02-10, 12:01 PM

retrosheets.org have a lot of valuable mlb stats... does the java platform start when login at donbest?

If so then click on the grey headers and a new page will come up in your browser

**SolidDala** · 10-02-10, 12:03 PM

I really like retrosheets for the fact that I can download 10 season with stats in just one click, pretty hard to beat that, then comes the hard part to use it

**jgilmartin** · 10-02-10, 01:23 PM

If you go to http://www.donbest.com/site-map/ and click 'Opening/Closing Lines' under 'Subscriber Tools', you only get the opener and the closer, not all the moves in between. The output you get once you pick which sportsbook you want, the sport, and the date range is a regular HTML table; you should be able to copy the entire table and paste it into Excel. It should come out properly formatted then.

**SolidDala** · 10-02-10, 01:30 PM

Awesome, thanks! .. still one day at the time, but like my grandpa just to say, nothing beats hard work

**SolidDala** · 10-02-10, 01:38 PM

3-01: a spread like this would mean +3 at -101
and 96u13 would mean 96 under at +113

So that last two numbers are the cents?

**mminkovski** · 10-02-10, 01:53 PM

yes, but it's hard to split this column

**SolidDala** · 10-02-10, 02:04 PM

the column in grey I posted? .. I checked out the link martin gave and that worked fine, one problem though:

the results for 1 game is in 2 rows:

Score(D) DATE GAMENUMBER UNDERDOG Closer1H(Spread)
Score(F) TIME GAMENUMBER FAVORITE Closer1H(totals)

So not sure how to search this later on, If I search for say Cleveland as hometeam, then I will see The totals but not the spread for them

**mminkovski** · 10-02-10, 02:13 PM

yes, that's why you need to split column and merge cells in order to get the spread, total and price in separate columns

**jgilmartin** · 10-03-10, 12:32 AM

Originally posted by SolidDala

the column in grey I posted? .. I checked out the link martin gave and that worked fine, one problem though:

the results for 1 game is in 2 rows:

Score(D) DATE GAMENUMBER UNDERDOG Closer1H(Spread)
Score(F) TIME GAMENUMBER FAVORITE Closer1H(totals)

So not sure how to search this later on, If I search for say Cleveland as hometeam, then I will see The totals but not the spread for them

You can put them into one row pretty easily...for example, suppose:
Cell A1 has the date
Cell B1 has the road rotation #
Cell C1 has the road team name
Cell D1 has the spread or the total (depending on which team is the favorite)
Cell A2 has the time
Cell B2 has the home rotation #
Cell C2 has the home team name
Cell D2 has the spread or the total (depending on which team is the favorite)

In Cell E1, enter '=A2'
In Cell F1, enter '=B2'
In Cell G1, enter '=C2'
In Cell H1, enter '=D2'

Paste the code from cells E1, F1, G1 and H1 into E3, F3, G3, and H3, and so on, so every other row also has the data from the row below it.

Edit > Cut everything from columns E, F, G and H.

Edit > Paste Values (or Edit > Paste Special > Values) back into the same cells you just cut the data from.

Sort the spreadsheet by column H, so that all of the rows with all the data from a game are at the top of the spreadsheet, and all the rows with only half the data from a game are at the bottom of the spreadsheet.

Delete all the rows with only half the data. Now you have each game's data on only one row.

**brewers7** · 10-03-10, 01:49 AM

Originally posted by SolidDala

Awesome, thanks! .. still one day at the time, but like my grandpa just to say, nothing beats hard work

I agree Sir that nothing beats hard work, but someone already did all the hard work (me) as I have all NBA 1H lines (and more) from the 1991-92 season through 2009-10 (19 seasons)...

Maybe I can post a one season sample here so people can see the format I have it in, but I don't know if attachments like that are allowed here or if my Excel file might be too big to attach...

**SolidDala** · 10-03-10, 01:10 PM

That sounds great, yer you can attach a excel file, have seen a couple of threads in here with attachments.. How did you gather all this info, is there a quicker way for me to gather it then just saving one html page at a time?

**SolidDala** · 10-03-10, 01:14 PM

Thanks Martin thought about doing this, a lot of work if one would want to structure +10 seasons, but then again solid information doesn't come easy, glad people here can help out at stage A, so I can focus directly in stage B - the working part

**brewers7** · 10-03-10, 05:48 PM

Originally posted by SolidDala

That sounds great, yer you can attach a excel file, have seen a couple of threads in here with attachments.. How did you gather all this info, is there a quicker way for me to gather it then just saving one html page at a time?

I gathered it over time from personal records that I have been keeping in Excel for several years and I did set up a spreadsheet in Excel and entered manually whatever scattered lines I happened to be missing from DonBest and other sites...