24 Responses

  1. Keith
    Keith at |

    Love this stuff though not very good at it. IMPORTHMTL function did not work for me? Checked formula several times and its right but getting circular dependency error, can you help!

    1. Tanner
      Tanner at |

      Hi Keith, could you share your Google Sheet with me so that I can edit it/see the formula you’re using? I can try to troubleshoot it for you.

  2. Michael Underhill
    Michael Underhill at |

    Single digit month and day no longer working? How do you make it double digit? Example 2016-04-04. Thanks in advance!

    1. Tanner
      Tanner at |

      It just looks like it’s not up and running yet. I’ll keep an eye on it and see if it shows up and starts working.

      1. Tanner
        Tanner at |

        Is this link any different than the 2015 one: http://www.fangraphs.com/leaders.aspx?pos=all&stats=pit&lg=all&qual=0&type=8&season=2015&month=0&season1=2015&ind=0&team=0&rost=0&age=0&filter=&players=p2016-04-03

        I see it doesn’t work for 2016-04-04, but maybe they’re still getting things going for the season.

  3. Mike M
    Mike M at |

    Hi Tanner,
    I’m having an issue importing my probable pitchers list into Excel. It imported the player ID and team ID maps no problem, but when I try the probable pitchers list from Google Sheets, step 1 of the import wizard gets stuck on “Loading…” in the preview, and nothing happens. Any idea what’s going on here?

    1. Tanner
      Tanner at |

      Hey Mike,

      Are you saying you’re having a hard time importing the probables into Google Sheets? Or are you saying the Google Sheets part was fine but the Excel piece to pull in from Google is where it’s slowing down?

      The Google piece seems to be working for me. But one small change for the 2016 season is that you may want to change the URL to only include 2016 stats. To do that the URL becomes:

      =”http://www.fangraphs.com/leaders.aspx?pos=all&stats=pit&lg=all&qual=0&type=8&season=2016&month=0&season1=2016
      &ind=0&team=0&rost=0&age=0&filter=&players=p”&A1

  4. Jacon
    Jacon at |

    This post was really informative and well laid out. The issue I have is trying to get the projections data from Fangraphs automatically. Since there no longer seems to be way to access the entire list via URL variables, so you have to clickthrough each page manually with the mouse or you have to either download the Excel file manually. Any ideas?

    1. Tanner
      Tanner at |

      Yeah, I agree. I don’t think the projections have ever been able to be pulled in all at once. They’ve always required click throughs to get to the subsequent pages.

      It’s not perfect, but I just set my Excel file up to import a CSV file. And just replace that CSV with a fresh download when I want the projections to update.

  5. Jonathan
    Jonathan at |

    Thanks for the article! The data from fangraphs is loading into my google sheet by the sheet is asking to set the page size. I figured it had something to do with the amount of players being pulled over from fangraphs so I’ve adjusted the page size there to no avail. Have you seen this before? Everything else works perfectly, it just looks messy when I bring the data over to excel.

    1. Tanner
      Tanner at |

      Hi Jonathan,

      I don’t think I’ve seen this before. I’ll e-mail you to see if you’re able to send me a screenshot of what you’re seeing.

      Thanks,

      Tanner

  6. Kaz Kalita
    Kaz Kalita at |

    Hello,

    Great article. How do I do step two under the import published CSV file on a Mac, since there is no spot to copy the Google Sheet URL?

    Thanks.

  7. Ari
    Ari at |

    Hi, thanks for this post. I was able to include the probable pitchers into my spreadsheet but now i am wondering how i export all the hitters in as well as their stats so that i can create a formula that helps me cut it down to a few guys that will just get a hit for that day. Please help.

    thanks

  8. Kaz Kalita
    Kaz Kalita at |

    Yeah, I’m looking to do the same thing as Ari. I’m looking to somehow import the starting lineups into a tab as they are released and then based off of that import hitter data of those players from FanGraphs. I’m thinking of having a tab for each position that only includes players that are playing on that particular day so we can eliminate most of the noise.

    Any tips or suggestions on how to do this or where to begin?

    Thanks,
    Kaz

  9. Stephen Coz
    Stephen Coz at |

    Hey Tanner,

    First off, I love your site. I just came across it trying to find an Excel import for MLB schedules/probables, and I think this might work for what I need. Anyways, I’m having a weird issue that has not been discussed – the first row of data being imported into my Google Sheet is the “Page Size” dropdown from FanGraphs. I think I can just hide those rows in the Excel import, but was just wondering if you’ve encountered that or had a fix. I can send you a screenshot of what is happening.

    Thanks!

  10. Stephen Coz
    Stephen Coz at |

    Never mind, I fixed it. Just had to start the import at the row with the headers. Best of luck and thanks for making such a great site!

  11. Ricky
    Ricky at |

    This information is freaking awesome. I will have to incorporate a lot of this to my current process… Currently I have an excel document, call it “source” for both pitchers and batters. It has overall stats, and also a tab for handedness (SP v. RHB or LHB and Batters v. LHP and RHP). On my main sheet I will import the DK and FD CVS file for the slate and once I do that, I have vlookups to the source sheet that will input all the information. I havent found a way to automate SP information the night before, I have just been inputting it manually from fantasylabs – this will hopefully make it much easier. Thanks for this!

Comments are closed.