1. #36
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by louis.ana View Post
    I always wondered about this trend..

    Can you tell me how many times (win rate) an underdog covered when a top 25 team plays a non-top 25 team, for the last year, 2 years, whatever. I always feel the lines for top 25 teams are inflated, had no way to prove it.

    Can anybody look this up?
    No, I don't have rankings in my DB. Maybe the OP does?

  2. #37
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    I do have rankings in mine. AP going back to 1990. The record for this one is I think pretty close to 50-50. I'll run it.

  3. #38
    ManBearPig
    ManBearPig's Avatar Become A Pro!
    Join Date: 12-04-08
    Posts: 2,473

    SporsDatabase basically does the same thing, one just needs to learn a little SDQL.

  4. #39
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Umm........ mine has a few more fields than SportsDatabase.

  5. #40
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Ranked faves vs unranked dogs - 1873-2009, -0.29 pts/game

  6. #41
    MartinBlank
    Going to be a good weekend
    MartinBlank's Avatar Become A Pro!
    Join Date: 07-20-08
    Posts: 8,382

    What say the Magic 8 Ball......was the OP trying get himself some points for absolutely worthless data?

    Do tell, what does the Arkansas team of 1990 have to do with anything going on in today's world of college football.

    Nothing. Neither does any other team. You never had to create a database for 23 years worth of CFD because they game itself has changed----from new teams, to conference affiliations to the increase in television exposure---to schools being hammered by the NCAA----all those insane variable make that date worthless.



    Last edited by MartinBlank; 09-30-11 at 10:49 PM.

  7. #42
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    It is.

  8. #43
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Like your avatar. That's where I grew up.

  9. #44
    G's pks
    Update your status
    G's pks's Avatar Become A Pro!
    Join Date: 01-01-09
    Posts: 22,251


  10. #45
    Inkwell77
    Inkwell77's Avatar Become A Pro!
    Join Date: 02-03-11
    Posts: 3,227
    Betpoints: 2413

    Can someone tell me (spread wise) how 3-0 ats teams fare against 0-3 ats teams?

    Or undefeated teams ats versus winless ats teams with more than 2 games played for each team?

    That would be awesome!

  11. #46
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    The changing landscape only creates opportunities for my stuff.

    FWIW, I do think that in 1990 they still played with 11 per side. I think. Maybe I'm wrong on that.

  12. #47
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    That just doesn't happen enough to generate a meaningful sample. For your second formulation I get only a couple dozen games with a big nothingburger mark.

    Quote Originally Posted by Inkwell77 View Post
    Can someone tell me (spread wise) how 3-0 ats teams fare against 0-3 ats teams? Or undefeated teams ats versus winless ats teams with more than 2 games played for each team? That would be awesome!

  13. #48
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    I'm pretty sure that the Hogs still play *in* Arkansas.

    Quote Originally Posted by MartinBlank View Post
    Do tell, what does the Arkansas team of 1990 have to do with anything going on in today's world of college football.

  14. #49
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    road favs of -3 to -6.5 vs. conference opponent ?

  15. #50
    vagolf
    vagolf's Avatar Become A Pro!
    Join Date: 09-26-11
    Posts: 26

    I like this. How about ranked opponents playing each other. Lower ranked as a dog v. Higher ranked as fav and vice versa (break it down home/away if you can)

  16. #51
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    In general, ranked vs ranked have gone to the home teams and the faves.

    Quote Originally Posted by vagolf View Post
    I like this. How about ranked opponents playing each other. Lower ranked as a dog v. Higher ranked as fav and vice versa (break it down home/away if you can)

  17. #52
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    419-439 ATS, -0.14 pts/game

    Nothing, in other words.

    Quote Originally Posted by chopperocker View Post
    road favs of -3 to -6.5 vs. conference opponent ?

  18. #53
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    The counter to this argument is that if you can find something that works thru all those different environments you're a bit more likely to be looking at something that is real.

    Quote Originally Posted by MartinBlank View Post
    You never had to create a database for 23 years worth of CFD because they game itself has changed----from new teams, to conference affiliations to the increase in television exposure---to schools being hammered by the NCAA----all those insane variable make that date worthless.

  19. #54
    MartinBlank
    Going to be a good weekend
    MartinBlank's Avatar Become A Pro!
    Join Date: 07-20-08
    Posts: 8,382

    Quote Originally Posted by TheEditor View Post
    I'm pretty sure that the Hogs still play *in* Arkansas.
    You're missing the point.

    For the most part----The kids playing on today's Arkansas team-----weren't even alive in 1990.

    You can't possibly believe that there is any correlation between Arkansas (and they are my example) in 1990 and Arkansas in 2011, I mean besides the fact that they both play for the same university.

    It's a silly exercise.

    I mean, my god--- Penn State wasn't even in the Big 10 in 1990---so how can you possibly draw any relationship between the schedule they played 21 years ago, and the one they play today?

    Bottom line this for everyone.

    What are you trying to sell? Software? I mean, week 4 is usually when the Touts make their SBR appearance---you seem to be going in another direction....selling shit.

  20. #55
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Quote Originally Posted by MartinBlank View Post
    You're missing the point.
    Its called sarcasm.

    I don't do a lot of team trend stuff. Not a big enough sample size. Occasionally a coach develops some tendencies so I do look a bit. Tom O'Brien, Frank Beamer. The guy at Oregon State. I miss Jim Wacker. Before Bowden's FSU entered a conference he had some tendencies. Tressel had some too. But spending much time on that ain't worth it.

    Though I do agree there is shit here.

  21. #56
    ManBearPig
    ManBearPig's Avatar Become A Pro!
    Join Date: 12-04-08
    Posts: 2,473

    Quote Originally Posted by TheEditor View Post
    Umm........ mine has a few more fields than SportsDatabase.
    ummm....I can query them and can't query your unless I put in a request...or I can just request them to add and they will...problem solved.

  22. #57
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    I'm not selling anything. Do what you will. Thought as a newcomer I'd try to contribute before taking. But hey, if you local poobahs think me evil I can go.

    Do you treat all newbies like this?

  23. #58
    MartinBlank
    Going to be a good weekend
    MartinBlank's Avatar Become A Pro!
    Join Date: 07-20-08
    Posts: 8,382

    Well, we are gamblers, and as such---are cynical and jaded.

    When someone shows up with something "free", it usually isn't free. And my cynical meter was buried when you asked for points.

    If you really are offering up something for free-----much appreciated.

  24. #59
    Inkwell77
    Inkwell77's Avatar Become A Pro!
    Join Date: 02-03-11
    Posts: 3,227
    Betpoints: 2413

    Quote Originally Posted by TheEditor View Post
    Its called sarcasm.

    I don't do a lot of team trend stuff. Not a big enough sample size. Occasionally a coach develops some tendencies so I do look a bit. Tom O'Brien, Frank Beamer. The guy at Oregon State. I miss Jim Wacker. Before Bowden's FSU entered a conference he had some tendencies. Tressel had some too. But spending much time on that ain't worth it.

    Though I do agree there is shit here.

    Seriously, I have known about his inept ability to coach in September for years now and I still did not bet against them this year, would have been 3-0 ats.

  25. #60
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by MartinBlank View Post
    What say the Magic 8 Ball......was the OP trying get himself some points for absolutely worthless data?

    Do tell, what does the Arkansas team of 1990 have to do with anything going on in today's world of college football.

    Nothing. Neither does any other team. You never had to create a database for 23 years worth of CFD because they game itself has changed----from new teams, to conference affiliations to the increase in television exposure---to schools being hammered by the NCAA----all those insane variable make that date worthless.



    You are talking about team-specific data, which I agree is worthless even with many short term trends. The goal is to find league-wide data that can be useful, as those don't care about the teams and are generally only affected by rule changes that have a major impact on the game. The last such rule was the addition of overtime in 1998, so it is fine to use data since then to find something useful. Even there though, be careful what you use and look for. If you find something like home favorite of -7 to -9.5 are hitting at 58%, that is bullshit variance and means nothing. But if you find something like teams that have lost 2 straight games by at least 25 points each are 59%, then you may be on to something because there are undervalued teams that nobody wants to bet.
    Last edited by LT Profits; 10-01-11 at 05:35 AM.

  26. #61
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    one more kind sir ?

    Home Teams of -1 to +1 vs. Conference opponent.

  27. #62
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    I'll get that for you in about 90 mins. Life intrudes.

  28. #63
    Wrecktangle
    Wrecktangle's Avatar Become A Pro!
    Join Date: 03-01-09
    Posts: 1,524
    Betpoints: 3209

    Quote Originally Posted by LT Profits View Post
    How far back do you go? I go back to 1985 but I usually only use data since 1998 (first year of overtime).
    The NCAA Rules Committee began addressing this issue in 1992. For a detailed explanation and history of over time please know Overtime was instituted by the NCAA Football Rules Committee in 1996. The tie game was eliminated in Division I-A under rules that went into effect with the 1996 regular season. The system, already used in other divisions, had been installed for postseason play in 1995 and first was used in the Las Vegas Bowl, where Toledo edged Nevada 40-37 in overtime.

    http://en.allexperts.com/q/College-F...ule-Change.htm

  29. #64
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Quote Originally Posted by Wrecktangle View Post
    The NCAA Rules Committee began addressing this issue in 1992. For a detailed explanation and history of over time please know Overtime was instituted by the NCAA Football Rules Committee in 1996. The tie game was eliminated in Division I-A under rules that went into effect with the 1996 regular season. The system, already used in other divisions, had been installed for postseason play in 1995 and first was used in the Las Vegas Bowl, where Toledo edged Nevada 40-37 in overtime.

    http://en.allexperts.com/q/College-F...ule-Change.htm
    I'm sorry, overtime did start in 1996, BUT 1998 was the year the rule was instituted requiring teams to go for two points beginning with the third overtime. Correct?

  30. #65
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    OT didn't change the game *that* much. More important were changes like the BCS.

  31. #66
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    147-143 ATS, +0.52 pts/game

    Sorry for being late.

    Quote Originally Posted by chopperocker View Post
    one more kind sir ? Home Teams of -1 to +1 vs. Conference opponent.

  32. #67
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Didn't think there was much here, but decided to futz with it because that's what I do.

    Occurred to me to look at the records of the two teams, because the line say the roadie is a little bit better than the home team.

    If the home team has a better than or equal record, the mark is 49-66 ATS, -2.22 pts/game. That is a little more interesting. Because that is a pretty sharp split - when the road team's record is better (as it usually is) the record is 84-71 ATS, +1.88 pts/game. That is a pretty sharp cleavage. Food for thought. And more futzing.

  33. #68
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    Quote Originally Posted by TheEditor View Post
    Didn't think there was much here, but decided to futz with it because that's what I do.

    Occurred to me to look at the records of the two teams, because the line say the roadie is a little bit better than the home team.

    If the home team has a better than or equal record, the mark is 49-66 ATS, -2.22 pts/game. That is a little more interesting. Because that is a pretty sharp split - when the road team's record is better (as it usually is) the record is 84-71 ATS, +1.88 pts/game. That is a pretty sharp cleavage. Food for thought. And more futzing.
    good stuff editor. i had New Mexico State +1 @ New Mexico. it cashed easily, but made me ponder the point spread trend.

  34. #69
    TheEditor
    TheEditor's Avatar Become A Pro!
    Join Date: 09-29-11
    Posts: 95
    Betpoints: 696

    Ack! I ran this thru my *NFL* db! Its Monday, and I was thinking MNF. Sorry. Busy now; I'll run the CFB later.

    Quote Originally Posted by chopperocker View Post
    good stuff editor. i had New Mexico State +1 @ New Mexico. it cashed easily, but made me ponder the point spread trend.

  35. #70
    kiknit
    kiknit's Avatar Become A Pro!
    Join Date: 12-20-09
    Posts: 116
    Betpoints: 36

    Ive got 2 for your DB: % of Home Dogs Under The Lights that covered and how many dogs/favs covered/did not cover as a result of the hook at the major number (2.5 vs 3 vs 3.5...6.5 vs 7 vs 7.5...9.5 vs 10 vs 10.5)

First 123 Last
Top