1. #1
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Austin's NFL Spreadsheet Trial Run

    Just got my spreadsheet up and running, so I am going to post the weekly picks v the line and see how it does.

    Feel free to ask any questions. I am still in the process of weighing certain factors such as, teams off of a loss, off of a win, b2b road games, b2b home games...etc...

    Week 8

    1. Cleveland @ St Louis +3 ... Edge: Cleveland -12.71
    2. Detroit @ Chicago -5 ... Edge: Chicago -5.2
    3. Indianapolis @ Carolina +6.5 ... Edge: Indianapolis -15
    4. NY Giants @ Miami +9.5 ... Edge: NY Giants -12.37
    5. Oakland @ Tennessee -7 ... Edge: Tennessee -15.11
    6. Philadelphia @ Minnesota +1 ... Edge: Philadelphia -.24
    7. Pittsburgh @ Cincinnati +4 ... Edge: Pittsburgh -7.43
    8. Buffalo @ NY Jets -3 ... Edge: NY Jets -.62
    9. Houston @ San Diego -9 ... Edge: San Diego -11.2
    10. Jacksonville @ Tampa Bay -3.5 ... Edge: Jacksonville -10.19
    11.New Orleans @ San Francisco +1 ... Edge: San Francisco -.33
    12. Washington @ New England -16 ... Edge: New England -13.62
    13. Green Bay @ Denver -3 ... Edge: Green Bay -10.07


    *Lines posted are current lines at Pinnacle.
    Last edited by austintx05; 10-29-07 at 06:04 PM.

  2. #2
    dwaechte
    dwaechte's Avatar Become A Pro!
    Join Date: 08-27-07
    Posts: 5,481
    Betpoints: 235

    Hey, not sure what all this involves but it certainly seems like you've done your homework. Maybe theres more of an explanation in another thread, but what exactly is the meaning of the number next to the team with the "edge"? Is it how much you're assuming they SHOULD be favoured by? That was my presumption but then the games you've bolded don't seem to back that up.

    Anyways, as I said I'm very interested in hearing more on this and seeing how it works out.

  3. #3
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Quote Originally Posted by dwaechte View Post
    Hey, not sure what all this involves but it certainly seems like you've done your homework. Maybe theres more of an explanation in another thread, but what exactly is the meaning of the number next to the team with the "edge"? Is it how much you're assuming they SHOULD be favoured by? That was my presumption but then the games you've bolded don't seem to back that up.

    Anyways, as I said I'm very interested in hearing more on this and seeing how it works out.
    The edge is basically a predicted margin. I have a lot of factors that go into the spreadsheet and I don't know what you mean by that don't back that up?

  4. #4
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Week 8 Totals

    1. Cleveland @ STL 45 ...48.53
    2. Detroit @ Chicago 45 ...44.9
    3. Indianapolis @ Carolina 44.5 ...43.42
    4. NY Giants @ Miami 47.5 ...51.64
    5. Oakland @ Tennessee 40 ...42.17
    6. Philadelphia @ Minnesota 37.5 ...37.16
    7. Pittsburgh @ Cincinnati 48 ...49.08
    8. Buffalo @ NY Jets 38 ...41.43
    9. Houston @ San Diego 45 ...45.83
    10. Jacksonville @ Tampa Bay 32 ...32.88
    11. New Orleans @ San Francisco 40 ...38.83
    12. Washington @ New England 47.5 ...46
    13. Green Bay @ Denver 42.5 ...43.25

    Week 8 Final Card

    1. Tennessee -7
    2. Jacksonville +3.5
    3. Green Bay +3
    4. Cleveland @ St Louis Over 45
    5. NY Giants @ Miami Over 47.5
    6. Buffalo @ NY Jets Over 38


    Last edited by austintx05; 10-28-07 at 02:27 AM.

  5. #5
    etothep
    etothep's Avatar Become A Pro!
    Join Date: 09-14-07
    Posts: 1,299
    Betpoints: 6826

    doesn't appear as though you're taking jax's starting qb into consideration here


    and if the edges are predicted margins, shouldn't you be going with the largest differences (cle, ind, & ten)?

  6. #6
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Quote Originally Posted by etothep View Post
    doesn't appear as though you're taking jax's starting qb into consideration here


    and if the edges are predicted margins, shouldn't you be going with the largest differences (cle, ind, & ten)?
    there are different road edge's and home edge's....different parameters
    injury is already in the line and numbers
    Last edited by austintx05; 10-28-07 at 02:42 AM.

  7. #7
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    2-3 with GB pending.....the interesting fact is if you played the sides where the sheet shows a 7 pt+ edge, it would be 4-3 so far....still taking notes and tweaking....

  8. #8
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    one last thing I will add, is I am trying to determine exactly how many points off my line needs to be v the vegas line to declare it a play.

    By saying 7 points or more, it would become more selective, but I know as handicappers if we feel the line is off by about 3 we deem it as a play...

    again, still taking notes....

  9. #9
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,173
    Betpoints: 438

    Quote Originally Posted by austintx05 View Post
    one last thing I will add, is I am trying to determine exactly how many points off my line needs to be v the vegas line to declare it a play.

    By saying 7 points or more, it would become more selective, but I know as handicappers if we feel the line is off by about 3 we deem it as a play...

    again, still taking notes....

    this is a question you will need time to answer. the amount the line is off is irrelevant if your predictions are not solid. once you've tracked your predictions for a decent amount of time you will have the data to see what amount of differential produces a big enough % play for you to make it.

    the biggest issue with the nfl is there are so few games, it can take a few years to figure the accuracy of your rankings.

    good job making a rating system, it's something i think every handicapper should have without a doubt.

  10. #10
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Quote Originally Posted by durito View Post
    this is a question you will need time to answer. the amount the line is off is irrelevant if your predictions are not solid. once you've tracked your predictions for a decent amount of time you will have the data to see what amount of differential produces a big enough % play for you to make it.

    the biggest issue with the nfl is there are so few games, it can take a few years to figure the accuracy of your rankings.

    good job making a rating system, it's something i think every handicapper should have without a doubt.
    thanks, I have my hypothesis...I will be backtesting it over the last 10 years to give it 3 separate tests...we will see if it passes.


  11. #11
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    *fyi, hypothesis - 6pt edge or greater for sides, 3 pt or greater for totals

  12. #12
    dwaechte
    dwaechte's Avatar Become A Pro!
    Join Date: 08-27-07
    Posts: 5,481
    Betpoints: 235

    Quote Originally Posted by austintx05 View Post
    The edge is basically a predicted margin. I have a lot of factors that go into the spreadsheet and I don't know what you mean by that don't back that up?
    Ok thats what I thought. All I meant was what eptothep said, that the games you were playing weren't the ones with the largest difference.

  13. #13
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Well according to my hypothesis on sides 3-1(GB Pending), totals 1-2...still of lot of backtracking to do....

    keep in mind, no money is being placed on these....


  14. #14
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    well a good week for sides 4-1, totals 1-2...

  15. #15
    regularguy
    regularguy's Avatar Become A Pro!
    Join Date: 09-12-07
    Posts: 781

    Hey austin. I was keeping my eye on this. Excellent work. I would be interested in seeing your chart this week. I'll be looking around. Thanks.

    This caught my eye, because I have been thinking about how I might reduce my jumble of stuff to a more numerical approach. If I ever get organized ....
    Last edited by regularguy; 10-30-07 at 02:09 AM.

  16. #16
    austintx05
    austintx05's Avatar Become A Pro!
    Join Date: 08-24-06
    Posts: 3,156

    Quote Originally Posted by regularguy View Post
    Hey austin. I was keeping my eye on this. Excellent work. I would be interested in seeing your picks this week. I'll be looking around. Thanks.
    thanks reg guy...I am interested as well...haha


Top