Looking for a baseball stat site, help????

kidman232 · May 16, 2009

Im looking for a site out there that breaks down records for totals on games. Im thinking betting over on 7.5 lined games has a very high hit ratio, but didnt want to search every teams o/u for the yr to find all the games (although most of those lines should be NL west involved).

kidman232 · May 17, 2009

SpreadOffense · May 17, 2009

Try pops' pivot tables..

kidman232 · May 18, 2009

what is that

YourAllAmerican · May 18, 2009

sportsdatabase.com

twjd · May 18, 2009

http://experts.covers.com/sports-statistics/sports-stats.aspx?t=0

TheJackal · May 18, 2009

25-18-2 this year in favor of the over.

letsgohoosiers · May 18, 2009

kidman232 said:
Im looking for a site out there that breaks down records for totals on games. Im thinking betting over on 7.5 lined games has a very high hit ratio, but didnt want to search every teams o/u for the yr to find all the games (although most of those lines should be NL west involved).

You need to learn how to use www.sportsdatabase.com as this is far and away the best and to my knowledge only site that allows you to backtrack lines and games. They have a large variety of variables you can include in analysis.

http://sportsdatabase.com/mlb.py/query?text=total=7.5 and season&sort=query_header

This should have what you're looking for. 40-30 (57.1%) in 2009 and +720. Overall a profitable trend with some losing years.

TheJackal · May 18, 2009

letsgohoosiers said:
You need to learn how to use www.sportsdatabase.com as this is far and away the best and to my knowledge only site that allows you to backtrack lines and games. They have a large variety of variables you can include in analysis.

http://sportsdatabase.com/mlb.py/query?text=total=7.5 and season&sort=query_header

This should have what you're looking for. 40-30 (57.1%) in 2009 and +720. Overall a profitable trend with some losing years.

You did it wrong. My record is the correct one.

http://sportsdatabase.com/mlb.py/query?text=season and site=home and total<=7.5&sort=query_header

EDIT: I noticed an issue with 5/1 BJ and O's. Total was listed at 3 which is wrong. It was 9. I sent them an email and they fixed it. With the corrected data, record is 24-18-2

letsgohoosiers · May 18, 2009

TheJackal said:
You did it wrong. My record is the correct one.

http://sportsdatabase.com/mlb.py/query?text=season and site=home and total<=7.5&sort=query_header

EDIT: I noticed an issue with 5/1 BJ and O's. Total was listed at 3 which is wrong. It was 9. I sent them an email and they fixed it. With the corrected data, record is 24-18-2

Your trend is for home teams only and that exclusion wasn't in the OP's post. In addition, your trend shows all games 7.5 or less while he was asking for lines of 7.5.

TheJackal · May 18, 2009

letsgohoosiers said:
Your trend is for home teams only and that exclusion wasn't in the OP's post. In addition, your trend shows all games 7.5 or less while he was asking for lines of 7.5.

wrong again. If you omit 'site=home' then every game will be double counted on the summary page as there is a record in the DB for each team. Don't believe me? Click on your link and then click on '2009'.

same game listed twice. Once for Mets home and once for Marlins away. Even better, click on the 'view' link which will take you to the boxscore. Same exact game.
<TABLE bgColor=#ffffff><TBODY><TR><TD align=middle bgColor=#ffffff>view</TD><TD align=middle bgColor=#f5f5f5>04-29-2009</TD><TD align=middle bgColor=#ffffff>home</TD><TD align=middle bgColor=#f5f5f5>Mets</TD><TD align=middle bgColor=#ffffff>[SIZE=-1]Santana - L[/SIZE]</TD><TD align=middle bgColor=#f5f5f5>Marlins</TD><TD align=middle bgColor=#ffffff>[SIZE=-1]Johnson - R[/SIZE]</TD><TD align=middle bgColor=#f5f5f5>3-4</TD><TD align=middle bgColor=#ffffff>-1</TD><TD align=middle bgColor=#f5f5f5>L</TD><TD align=middle bgColor=#ffffff>-0.5</TD><TD align=middle bgColor=#f5f5f5>U</TD><TD align=middle bgColor=#ffffff>11-7</TD><TD align=middle bgColor=#f5f5f5>1-1</TD><TD align=middle bgColor=#ffffff>-170</TD><TD align=middle bgColor=#f5f5f5>7.5</TD><TD align=middle bgColor=#ffffff>9</TD></TR><TR><TD align=middle bgColor=#f0f0f0>view</TD><TD align=middle bgColor=#e6e6e6>04-29-2009</TD><TD align=middle bgColor=#f0f0f0>away</TD><TD align=middle bgColor=#e6e6e6>Marlins</TD><TD align=middle bgColor=#f0f0f0>[SIZE=-1]Johnson - R[/SIZE]</TD><TD align=middle bgColor=#e6e6e6>Mets</TD><TD align=middle bgColor=#f0f0f0>[SIZE=-1]Santana - L[/SIZE]</TD><TD align=middle bgColor=#e6e6e6>4-3</TD><TD align=middle bgColor=#f0f0f0>1</TD><TD align=middle bgColor=#e6e6e6>W</TD><TD align=middle bgColor=#f0f0f0>-0.5</TD><TD align=middle bgColor=#e6e6e6>U</TD><TD align=middle bgColor=#f0f0f0>7-11</TD><TD align=middle bgColor=#e6e6e6>1-1</TD><TD align=middle bgColor=#f0f0f0>160</TD><TD align=middle bgColor=#e6e6e6>7.5</TD><TD align=middle bgColor=#f0f0f0>9</TD></TR></TBODY></TABLE>

Yes, I made an assumption that he was looking at low totals of 7.5 'or less'. You'll have to ask him what he meant exactly but that is how I interpreted it.

If there is one thing I know, it's sportsdatabase and stats. I stand by the query and the record I posted. Thanks for checking up on me though. (<)<

letsgohoosiers · May 18, 2009

TheJackal said:
wrong again. If you omit 'site=home' then every game will be double counted on the summary page as there is a record in the DB for each team. Don't believe me? Click on your link and then click on '2009'.

same game listed twice. Once for Mets home and once for Marlins away. Even better, click on the 'view' link which will take you to the boxscore. Same exact game.
<table bgcolor="#ffffff"><tbody><tr><td align="middle" bgcolor="#ffffff">view</td><td align="middle" bgcolor="#f5f5f5">04-29-2009</td><td align="middle" bgcolor="#ffffff">home</td><td align="middle" bgcolor="#f5f5f5">Mets</td><td align="middle" bgcolor="#ffffff">[SIZE=-1]Santana - L[/SIZE]</td><td align="middle" bgcolor="#f5f5f5">Marlins</td><td align="middle" bgcolor="#ffffff">[SIZE=-1]Johnson - R[/SIZE]</td><td align="middle" bgcolor="#f5f5f5">3-4</td><td align="middle" bgcolor="#ffffff">-1</td><td align="middle" bgcolor="#f5f5f5">L</td><td align="middle" bgcolor="#ffffff">-0.5</td><td align="middle" bgcolor="#f5f5f5">U</td><td align="middle" bgcolor="#ffffff">11-7</td><td align="middle" bgcolor="#f5f5f5">1-1</td><td align="middle" bgcolor="#ffffff">-170</td><td align="middle" bgcolor="#f5f5f5">7.5</td><td align="middle" bgcolor="#ffffff">9</td></tr><tr><td align="middle" bgcolor="#f0f0f0">view</td><td align="middle" bgcolor="#e6e6e6">04-29-2009</td><td align="middle" bgcolor="#f0f0f0">away</td><td align="middle" bgcolor="#e6e6e6">Marlins</td><td align="middle" bgcolor="#f0f0f0">[SIZE=-1]Johnson - R[/SIZE]</td><td align="middle" bgcolor="#e6e6e6">Mets</td><td align="middle" bgcolor="#f0f0f0">[SIZE=-1]Santana - L[/SIZE]</td><td align="middle" bgcolor="#e6e6e6">4-3</td><td align="middle" bgcolor="#f0f0f0">1</td><td align="middle" bgcolor="#e6e6e6">W</td><td align="middle" bgcolor="#f0f0f0">-0.5</td><td align="middle" bgcolor="#e6e6e6">U</td><td align="middle" bgcolor="#f0f0f0">7-11</td><td align="middle" bgcolor="#e6e6e6">1-1</td><td align="middle" bgcolor="#f0f0f0">160</td><td align="middle" bgcolor="#e6e6e6">7.5</td><td align="middle" bgcolor="#f0f0f0">9</td></tr></tbody></table>

Yes, I made an assumption that he was looking at low totals of 7.5 'or less'. You'll have to ask him what he meant exactly but that is how I interpreted it.

If there is one thing I know, it's sportsdatabase and stats. I stand by the query and the record I posted. Thanks for checking up on me though. (<)<

So the correct query, combing your incorrect query and my incorrect query, would be the following:

http://sportsdatabase.com/mlb.py/query?text=total=7.5+and+season+and+site=away&submit=query

Which gives us a 20-15 (57.1%) +360 trend in 2009. Since 2004 446-408 +583.

kidman232 · May 18, 2009

anything 7.5 or below is what i was really looking for if i did not word it properly, so its a winning bet overtime.

TheJackal · May 18, 2009

letsgohoosiers said:
...combing your incorrect query and my incorrect query...

haha. You're funny. :laugh:

Kidman, see my query for the results you are looking for.

kidman232 · May 18, 2009

jackal if it could hold 57% for the yr, think its worth continuing to track and bet?

letsgohoosiers · May 18, 2009

kidman232 said:
if it could hold 57% for the yr, think its worth continuing to track and bet?

Don't bet on overs on games under 7.5. The trend is terrible.

If you're betting 7.5 overs only, it's an OK trend hitting 52.222%.

letsgohoosiers · May 18, 2009

Here's the table, I couldn't get it to format properly in the quick reply.

<table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="228" height="80"><col style="width: 48pt;" span="5" width="64"> <tbody align="left"><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" width="64" height="20">TOTAL</td> <td class="xl65" style="width: 48pt;" width="64">W</td> <td class="xl65" style="width: 48pt;" width="64">L</td> <td class="xl65" style="width: 48pt;" width="64">T</td> <td class="xl65" style="width: 48pt;" width="64">$</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">6.5</td> <td>30</td> <td>32</td> <td>0</td> <td>-730</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">7</td> <td>232</td> <td>276</td> <td>76</td> <td>-7160</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">7.5</td> <td>892</td> <td>816</td> <td>0</td> <td>1166</td> </tr> </tbody></table>

TheJackal · May 18, 2009

Considering you would have lost 3 out of the last 5 years and would be down overall, it is not a trend I would put my $$ on. You would have risked almost 1300 units ($130,000 for $100 bettor) and lost over 32 on this trend since 2004. 'Not good' in the simplest terms.

If you do think you are on to something here then you are far from done and the right thing to do would see if you could improve the trend by trying to filter on pitchers with ERA < X or look at only teams with winning percentage > X Or only HP Umpires with Overs > X, or all of the above, etc... Just my 2 cents.

I will not take this any further and will leave the rest to you as I have my system in place. I will continue to tweak mine throughout the season as needed but it seems to be doing pretty good so far.

http://www.therxforum.com/showthread.php?p=6694199#post6694199

ScreaminPain · May 18, 2009

TheJackal said:
If there is one thing I know, it's sportsdatabase and stats. I stand by the query and the record I posted. Thanks for checking up on me though. (<)<

Using the database, is there a way to query all 2008 games to find how many games had runs scored in the 1st inning.....and by team?

I'm working on a model and that information would be helpful and would save me tons of work.

TheJackal · May 18, 2009

ScreaminPain said:
Using the database, is there a way to query all 2008 games to find how many games had runs scored in the 1st inning.....and by team?

I'm working on a model and that information would be helpful and would save me tons of work.

Yes there is. inning runs is a list so to see runs in the first inning use 'inning runs[0]'. To see runs in the second inning use 'inning runs[1]', etc. Of course, you want the total number of runs by both teams so what you really are asking for is 'inning runs[0]+o:inning runs[0]'.