1. 03-16-10 10:38 AM #1
    gLonghorn
    gLonghorn's Avatar Become A Pro!
    Join Date: 01-28-09
    Posts: 12
    Betpoints: 66

    NCAA Tourney Results 1998-2009 in Excel

    I'm sure that this will be useful for some people out there. Use it however you want. Share your insights with me through PMs if you are comfortable. Just trying to get good info out there for everyone...

    I think it is interesting to look at the first and second round games where the vegas lines are most different from the game outcomes.

    It is also interesting to see the distribution of outcomes (straight up, not vs spread). You will notice that with the season on the line, teams will foul and press and push the deficit past 5-7 points more frequently than in the regular season. This is well known, but it is interesting to put some numbers with it.

    This is also a good tool to compare the outcomes of mid-majors vs bcs conference teams.

    I think you can also get some insight on the large spreads also from this list. If you go back and do some research, you can see which kinds of 15 and 16 seeds will cover those 20ish point spreads.

    Share your thoughts...
    -gLonghorn
    Attached Files
    Points Awarded:

    Justin7 gave gLonghorn 2 SBR Point(s) for this post.

    subs gave gLonghorn 2 SBR Point(s) for this post.
    Reply With Quote Reply With Quote
  2. 03-16-10 12:46 PM #2
    dwaechte
    dwaechte's Avatar Become A Pro!
    Join Date: 08-27-07
    Posts: 5,481
    Betpoints: 235

    Thanks Longhorn.. very nice tool.
    Reply With Quote Reply With Quote
  3. 03-16-10 01:29 PM #3
    djiddish98
    djiddish98's Avatar Become A Pro!
    Join Date: 11-13-09
    Posts: 345
    Betpoints: 237

    Great Data set - thanks a bunch for sharing. Do you mind sharing where you got the data from?
    Reply With Quote Reply With Quote
  4. 03-16-10 01:51 PM #4
    djiddish98
    djiddish98's Avatar Become A Pro!
    Join Date: 11-13-09
    Posts: 345
    Betpoints: 237

    One thing I noticed was that the line column was a little weird if an underdog won* - I'm guessing the line should be negative for every game. To fix this, you can create a new column next to the line and use excel sign functionto determine if the line is positive (If it equals 1) - if it is, just take the negative of the line in question, and everything should be good.
    Last edited by djiddish98; 03-16-10 at 03:46 PM. Reason: *grammar
    Reply With Quote Reply With Quote
  5. 03-21-10 11:29 PM #5
    jackpot269
    jackpot269's Avatar SBR PRO
    Join Date: 09-24-07
    Posts: 11,495
    Betpoints: 8377

    interesting stuff !!!!!!!!!!!!!!
    Reply With Quote Reply With Quote
  6. 03-07-11 10:58 AM #6
    SparJMU
    SparJMU's Avatar Become A Pro!
    Join Date: 02-18-10
    Posts: 1,648
    Betpoints: 7523

    I am unable to download this file, but would love to look at it. Any chance someone would be kind enough to e-mail it to me? Please PM me.
    Reply With Quote Reply With Quote
  7. 03-12-11 12:27 PM #7
    gohabsgo
    gohabsgo's Avatar Become A Pro!
    Join Date: 03-19-10
    Posts: 1,903
    Betpoints: 204

    Ill convert your spreadsheet in an mysql database and make it possible to make queries into it form a website.
    Do you have 2010 data?
    Last edited by gohabsgo; 03-12-11 at 12:31 PM.
    Reply With Quote Reply With Quote
  8. 03-13-11 03:27 PM #8
    officepoolguy
    officepoolguy's Avatar Become A Pro!
    Join Date: 07-19-10
    Posts: 384
    Betpoints: 63

    Love the data...looking at just the 1st round from 2007-2009, if you bet all the favorites of 6 points or more you would have went 19-1, 18-3 and 17-2 for a total record of 54-6 ATS (if I read the info right). This is pretty interesting...do you know where I can get 2010 data like that? pm if you want. thanks.
    Reply With Quote Reply With Quote
  9. 03-13-11 05:46 PM #9
    dwaechte
    dwaechte's Avatar Become A Pro!
    Join Date: 08-27-07
    Posts: 5,481
    Betpoints: 235

    Awesome stuff, thanks.
    Reply With Quote Reply With Quote
  10. 03-14-11 07:46 AM #10
    slatter
    slatter's Avatar Become A Pro!
    Join Date: 11-15-10
    Posts: 472
    Betpoints: 0

    This is excellent, thanks a ton for sharing this.
    Reply With Quote Reply With Quote
  11. 03-14-11 07:47 AM #11
    jennahazeplays
    jennahazeplays's Avatar Become A Pro!
    Join Date: 03-15-10
    Posts: 474
    Betpoints: 0

    best gdamn time of the year!!!
    Reply With Quote Reply With Quote
  12. 03-14-11 04:46 PM #12
    cornfay
    cornfay's Avatar Become A Pro!
    Join Date: 11-19-08
    Posts: 4
    Betpoints: 0

    Quote Originally Posted by officepoolguy View Post
    Love the data...looking at just the 1st round from 2007-2009, if you bet all the favorites of 6 points or more you would have went 19-1, 18-3 and 17-2 for a total record of 54-6 ATS (if I read the info right). This is pretty interesting...do you know where I can get 2010 data like that? pm if you want. thanks.
    I checked this with 2009 and it would of gone 13-13-2 am I lookin at it wrong?

    17-9-1 in 2008
    14-10-2 in 2007

    edit to add 08-07
    Last edited by cornfay; 03-14-11 at 05:13 PM.
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »