MLB, NHL Database Help

**bea$tmode** · 07-02-11, 12:59 PM

also, if it means anything, I would like to import odds from Pinnacle.

**Peregrine Stoop** · 07-03-11, 01:32 PM

Betting %???
You mean the data about who the 'public' is supposedly betting?

**bigvern** · 07-03-11, 01:41 PM

That would indeed be of great interest - come on nerds give us a hand !!!

**JVP3122** · 07-03-11, 02:49 PM

Originally posted by bea$tmode

Hey guys,

I'm trying to make an MLB and an NHL Moneyline database. I want to include: Home team, Road team, open and closing lines, Home score, Away Score, and Betting Percentages.

I am a tech moron. I have an idea of how to import the teams, open and close lines, and scores (I think), but have no idea how to import the betting %s without just inputting them. SportsInsights offers databases for $100 per sport or $200 for all sports, which I have been considering purchasing, but I wanted to explore the possibility of making my own first...

Anybody know of a place to get the betting percentages that will import into Excel?

Any help is greatly appreciated. I know im an idiot when it comes to this.

Thanks guys and GL,
Beast

How are you importing the other things? VBA? Python?

**bea$tmode** · 07-03-11, 09:51 PM

Yes, I mean the public consensus percentages. I haven't imported anything yet...I was hoping to import it into excel like the sportsinsights spreadsheet is...maybe what I am talking about isn't possible? Idk, im a tech moron

**uva3021** · 07-04-11, 09:14 AM

SBR Forum - Sports Betting Talk - Sportsbook Review Forum

http://forum.sbrforum.com/search.php

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

**JVP3122** · 07-04-11, 07:23 PM

Originally posted by bea$tmode

Yes, I mean the public consensus percentages. I haven't imported anything yet...I was hoping to import it into excel like the sportsinsights spreadsheet is...maybe what I am talking about isn't possible? Idk, im a tech moron

There's really only two options. First is to buy the package. $200 is not bad for all sports. My big question, though, is what book they use for opening and closing lines. Second is to read http://forum.sbrforum.com/handicappe...-research.html and learn how to use scrapy in Python. I've spent about 30-35 hours so far working on importing lines data using scrapy, and I've gotten to the point where I have all data for MLB seasons back to 2007 from http://www.sbrforum.com/mlb-baseball/odds-scores/. There are no betting percentages, though, so if you don't want to put in the time then you should just go and buy the packages.

**bea$tmode** · 07-05-11, 05:51 PM

ok, thanks guys. I appreciate it

**arwar** · 07-07-11, 11:43 AM

mlb-2010 season

well - here is a spreadsheet for 2010 season. it has closing lines (Pinny) and final scores, totals, pitchers, but no opening lines.

Attached Files

push.xlsx (621.5 KB, 273 views)

**bea$tmode** · 07-08-11, 07:16 PM

Originally posted by arwar

well - here is a spreadsheet for 2010 season. it has closing lines (Pinny) and final scores, totals, pitchers, but no opening lines.

Thanks man

**the_mathman** · 07-13-11, 05:16 AM

I have used this data too.
great works!
thank you!

**Maverick22** · 07-18-11, 10:13 AM

It always grinds my gears, when people call excel spreadsheets 'databases'