Messages

Forum Index : Systems & Strategies : Messages
Author: [Systems & Strategies] Topic: anyone know of a site to find this info
Texan send a private message View Space | Blog | Friends | Playbook | My Sportsbook: bet365 |
Texan
Participation Meter
Veteran
Joined: Aug 2002
Posts: 2782
Location: Texas
#1
Posted: 6/18/2012 11:48:42 AM

originally posted in the MLB forum but it quickly got moved to the bottom as everyone is searching for picks....

 

 

I am looking for a results database to check on something that I have been doing lately.

Here it goes, I have played every play Run line or alternate run line (even picks and dogs, I never play any fave greater than -150). It has been doing well of late, but I want to see how it has done over the last 3 years. With 2400 games a years I am still calculating a good sample size for now I just want to see how this will have played out over the last 3 seasons ceratinly 7200 will not be the desired sample in the end.

I noticed that all my favorite plays were either winning by 2 or more or losing outright, as were my dog plays. occasionally I have been bitten by this (thanks blowjays on saturday) but for the most part I have reduced my losses and seen a better ROI on my wins.

Any sites you know of let me know.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#2
Posted: 6/18/2012 2:04:38 PM
QUOTE Originally Posted by Texan:

originally posted in the MLB forum but it quickly got moved to the bottom as everyone is searching for picks....

 

 

I am looking for a results database to check on something that I have been doing lately.

Here it goes, I have played every play Run line or alternate run line (even picks and dogs, I never play any fave greater than -150). It has been doing well of late, but I want to see how it has done over the last 3 years. With 2400 games a years I am still calculating a good sample size for now I just want to see how this will have played out over the last 3 seasons ceratinly 7200 will not be the desired sample in the end.

I noticed that all my favorite plays were either winning by 2 or more or losing outright, as were my dog plays. occasionally I have been bitten by this (thanks blowjays on saturday) but for the most part I have reduced my losses and seen a better ROI on my wins.

Any sites you know of let me know.

 

You can use some online sports databases - like killerpsorts.com or sportsdatabase.com

 

if you use killerpsorts.com - the results are below - but not sure if I understand what you are betting. 

 

IF you BET EVERY run line greater then -150 and up to even (0)


SQL Query:
-150 < t:line and 0 >= t:line and season >= 2009


2009 to date - RL: 2277-3340 (-0.9 rpg) average line: +143 / -156 on / against: -$16,289 / -$10,946 ROI: -2.7% / -1.2%


if you BET EVERY run line greater then -150 and up to even and they must be a favorite.


SQL Query:
-150 < t:line and 0 >= t:line and t:line < o:line and season >= 2009


2009 to date - RL: 1891-2974 (-1.0 rpg) average line: +152 / -165 on / against: -$14,877 / -$8,530 ROI: -3.0% / -1.1%

 

Unfortunately a bit fat loser 2009 to date - may be profitable in a short run - or an individual season, but without additional filters - looks like a loser.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#3
Posted: 6/18/2012 2:05:30 PM
sorry - killersports.com
quote
gallotron send a private message View Space | Friends | Playbook |
gallotron
Participation Meter
Prospect
Joined: Nov 2010
Posts: 26
Location:
#4
Posted: 7/18/2012 12:21:42 AM
Hey Degen,

Is there anywhere I can basically download the data available at those two sites you've listed and maintain my own DB and write my own queries?

Basically I'm looking to do some data mining and need as much historical data as possible.  I figure something must exist but I am having trouble finding it.  To start I would just need summary details of every game over the last few years.  Something like
Date,Away Team,Home Team, Away Team Score,Home Team Score,Line,O/U.  If the line and O/U are not available I figure I could find this elsewhere and merge the two data sets.

Let me know if anything like this exists I am interested in combining two of my interests sports and data mining primarily for fun possibly for profit later.

PS I've seen some of these automated spreadsheets you have been putting together and they are very impressive.  I'll defs be checking out your VBA to see how you put them together.

Thanks!
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#5
Posted: 7/18/2012 12:33:33 AM

Check out my spreadsheet that pulls the past lines from Vegas Insider.

MLB LINES FROM VEGAS INSIDER

This spreadsheet displays the current and past lines from Vegas Insider

Features:

·         Current lines can be viewed and refreshed when you click the “Refresh Lines” button

·         Past lines are updated every time you click on the “Update Past Lines” button

You can download from the link below:

https://docs.google.com/open?id=0B5dydT9Oe6JbUjU3SktaZFB5b0E

 

If you know you're way around VBA - it can be tweaked to pull in past seasons - right now it's set up to pull in 2012 data.

 

quote
Forum Index : Systems & Strategies : Messages
You have entered the forum as a GUEST. 
You must login/register to post or reply.