View New Posts
  • Thread Tools
  1. #1
    Hanger
    NCAA '10 59.45% | 129-88-5
    Hanger's Avatar Become A Pro!
    Join Date: 01-25-09
    Posts: 2,102
    Betpoints: 102

    MLB Excel Question...

    I am trying to automatically populate the L10 of teams into a spreadsheet for both Total Games, Home and Away and cannot find it on the net...I have been scouring baseball reference with little luck. Can anyone point me in the right direction to capture the info from into excel?

    Thanks

  2. #2
    EXhoosier10
    EXhoosier10's Avatar Become A Pro!
    Join Date: 07-06-09
    Posts: 2,897
    Betpoints: 1755

    I'd start by pulling in data from day 1 of the season, day by day, and creating a db from the start. from there, pull in data each day and append to the YTD db

  3. #3
    Hanger
    NCAA '10 59.45% | 129-88-5
    Hanger's Avatar Become A Pro!
    Join Date: 01-25-09
    Posts: 2,102
    Betpoints: 102

    Thanks EXHoosier,

    I was hoping to not populate yet another DB. I was able to find a team vs team grid on espn now just have to figure out the correct way to query it for both teams vs each other.

    Will probably have to populate my own DB for for the Home vs Away L10 tho..

    Appreciate the help

  4. #4
    EXhoosier10
    EXhoosier10's Avatar Become A Pro!
    Join Date: 07-06-09
    Posts: 2,897
    Betpoints: 1755

    if you have the entire season, you can countif when a team is at home and another column when away. then countif W & Away & game# < max(away) - 10 or so.

    that'd be the way i'd do it. Assuming you're ever going to use the db to backtest, might as well collect info now and have for later

  5. #5
    Hanger
    NCAA '10 59.45% | 129-88-5
    Hanger's Avatar Become A Pro!
    Join Date: 01-25-09
    Posts: 2,102
    Betpoints: 102

    Hey Hoosier......thanks for the help..definitely getting along with my ideas here.....you have an idea of where I can find a daily schedule table that includes probables? Everything I'm finding is including either 3 days or 7 days and throwing off my vlookup for the main interface page.

    Thanks

  6. #6
    EXhoosier10
    EXhoosier10's Avatar Become A Pro!
    Join Date: 07-06-09
    Posts: 2,897
    Betpoints: 1755

    Sucks that MLB.com has L10 on their standings, but it pulls in data using js rather than having each day on a separate page.

    http://mlb.mlb.com/mlb/standings/#20121002

    if you want to copy each day of the season and paste into excel, you could.

    No Idea where you could find H/A L10 though. I don't think I've ever seen those anywhere (and it's my guess that they're less meaningful than a full season of H/A record, which I would imagine are already probably pretty meaningless)

  7. #7
    Hanger
    NCAA '10 59.45% | 129-88-5
    Hanger's Avatar Become A Pro!
    Join Date: 01-25-09
    Posts: 2,102
    Betpoints: 102

    MLB.com even has their schedule so I can't differentiate between the table for today's games and tomorrow's games without importing the entire page into excel. That would have been the easiest since they have a good format and show probables on the same table.

    I think I have moved past trying to find H/A L10, thats going to have to be a computation in the DB.

  8. #8
    rfr3sh
    Blind Knucklehead
    rfr3sh's Avatar Become A Pro!
    Join Date: 11-07-09
    Posts: 10,153
    Betpoints: 605
    Points Awarded:

    EXhoosier10 gave rfr3sh 20 SBR Point(s) for this post.


  9. #9
    EXhoosier10
    EXhoosier10's Avatar Become A Pro!
    Join Date: 07-06-09
    Posts: 2,897
    Betpoints: 1755

    Quote Originally Posted by rfr3sh View Post
    You win. While I'll still have to use FG, this should be very useful. Thanks, rfr

  10. #10
    Hanger
    NCAA '10 59.45% | 129-88-5
    Hanger's Avatar Become A Pro!
    Join Date: 01-25-09
    Posts: 2,102
    Betpoints: 102

    Quote Originally Posted by rfr3sh View Post

    Thank you, will definitely try to incorporate this.

  11. #11

Top