Quick personal fact: I’ve been writing about fantasy baseball online for seven years. And seven years ago, I had the idea to start saving ADP data to better study drafting.

Well, things that seem like good ideas at one point often get staler with time until they are forever abandoned. Such was the fate of my ADP data project… until now.

What’s changed is that I’ve found  a way to get historical ADP data potentially going all the way back to 2002, and not just for baseball but basketball, football, and hockey too.

How is this done?

I’ve been working on building a program that plays fantasy baseball, making extensive use of Yahoo’s fantasy sports API. Lo and behold, one of the sub-resources you can get data from is called “draft_analysis” and returns output that looks like the following:

Screen Shot 2015-07-01 at 1.14.52 AM

This data is this year’s draft analysis for Clayton Kershaw, who we can see was taken in the first round of drafts at pick 4.1 on average. In auctions he went for $48.9 and was selected in 100% of leagues. No surprises there.

Using this awesome Player ID Spreadsheet from Smart Fantasy Baseball to get every player’s Yahoo ID, I’ve pulled the ADP data from this year’s drafts for every player. For convenience I’ve also organized it all in an csv file and make it available for anyone to peruse and/or download.

Click here to view 2015 MLB ADP data (google spreadsheet)

A couple notes about the data:

  • To reiterate, this file is just 2015 mlb data but can be expanded to other sports and back to 2002.
  • It is ADP data from Yahoo
  • Note the file contains only a player’s name with his ADP data. It isn’t too difficult to also include position and team, but some players in the population raised errors because they are free agents or retired or whatever. I’ll add some error-catch coding in the future to avoid this issue, but didn’t have time for that tonight.

To conclude, I’m happy to organize this data for the other seasons and sports, but know it will take a decent amount of time on my end. If you are interested in having the data or are thinking of a project to use it for, let me know! I’ll be that much more motivated to provide this info if other people show interest.

ADP data’s usefulness is weakened by it’s noisiness, but part of the reason for that is people generally only work with a couple seasons worth of ADP data. I will potentially be able to use over a decade’s worth, so my hope is there will be at least a few things we could learn from all that.

Look for more ADP data and an update on the robot project next week.



  1. Grey

    Grey says:

    Good stuff, Paul! Is there a way to figure out which player has consistently beaten his ADP the most in, say, the last five years? I’m gonna guess a random pitcher, like AJ Burnett…

    • Scott says:

      @Grey: Not to mention Catchers!

    • paul

      paul says:

      @Grey: Thanks Grey! Seems easy enough if you have ADP and combine it with some end of season dollar value for each player. My guess for most under-drafted is, idk Brett Gardner. T’will be fun to look at.

  2. Sammy says:

    I have a trade q- in a H2H I have scherzer, kluber, McHugh, Corrasco, and latos as my top sp with latos, gravemen kennedy fiers and cain as my bench support

    have kemp, calhoun and revre in OF

    Should I trade Kluber for cespedes and puig? Or am I better off not making the trade

    Some other notable hitters I have are altuve, machado, carlos santana, and seager… looking to improve my offence but dont know if trade off worth it

    Also a 5 player keeper league


    • Sammy says:

      @Sammy: Cespedes and bruce not puig!!

    • paul

      paul says:

      @Sammy: It wouldn’t be a bad trade to make, but I’m also not a huge Cespedes fan. I’d keep Klubs but having Cespedes and Bruce isn’t a downgrade either. Follow your heart.

  3. Malicious Phenom says:

    FYI: In CBS, Kershaw (who I own) is only owned in 98% of leagues this year..very strange..

    Great write-up by the way..

    • paul

      paul says:

      @Malicious Phenom: Yea… I wouldn’t trust ADP totally, there’s definitely a lot of noise with auto-drafting and pre-rankings. But the benefit of having ADP data for over a decade, is with more data there’s a better chance of finding out something interesting from it.

  4. tentyme says:

    Great idea !!
    I would love to see this info. I think it can definitely help steal some players in the draft and get great value deep in the draft.

    • paul

      paul says:

      @tentyme: Thanks, I’ll pull it for other years and make it available next week. I agree there are things to be learned from it.

  5. Peter Nincompoop says:

    Good stuff Paul…thank you.

  6. Thanks for the shoutout, Paul! Let me know if you ever find holes in the Player ID Map and you need them filled for a project you’re working on.

    Love the spin you’re bringing to fantasy baseball.

Comments are closed.