FanGraphs Fantasy Baseball

Comments

RSS feed for comments on this post.

  1. Thanks, will definitely be taking advantage of this, I also hate following prospects! For every Strasburg, there seem to be 10 Izzy Alcantaras or Brian Roses! Will you be making the more comprehensive list available, at some point?

    Comment by Paul M. — February 22, 2012 @ 5:19 pm

  2. How do you choose between a higher ranked player that’s slightly farther away from a worse one who is closer? As in, if there was a #10 who was going to start the year and a #1 who was getting called up in June/July, which would you choose? (Obviously this depends on the particular players, but in general I’m curious how you decide. Is Montero your first choice this year?)

    Comment by Matt H — February 22, 2012 @ 5:21 pm

  3. Do you have a projected call up date? How do you know who’s closest to arriving in the bigs?

    Comment by Benjigil — February 22, 2012 @ 5:22 pm

  4. Wisdom of the Crowds for the win.

    I never understood why Fangraphs didn’t do the same thing for projections. You have Bill James, Marcels, ZIPS, Rotochamps, and the FG fan crowdsourced projections.

    Why not combine all of that, plus like Oliver, ESPN, CBS, whatever else you can get for free, and just have a combined wisdom of the crowds projection thing. Seems right in Fangraphs wheelhouse.

    Comment by Jeff Akston — February 22, 2012 @ 5:24 pm

  5. Does Wil Myers see the big leagues this year? With Frenchy, Gordon and Cain blocking his path I don’t see it happening unless there is an injury or a trade.

    Comment by Pops — February 22, 2012 @ 5:27 pm

  6. I second this.

    Comment by Rich — February 22, 2012 @ 5:40 pm

  7. Just wait my friend.

    Comment by Jeff Zimmerman — February 22, 2012 @ 5:55 pm

  8. Yeah that’s not really a complete “how to” without explaining how you project “closeness” and how you balance it with rank. I expect that it’s most intuitive, but you say you sort the list two different ways and pick the highest as if it’s expected to be the same player which is rarely the case.

    Comment by d_i — February 22, 2012 @ 6:00 pm

  9. ESPN and Scout seem to be duplicates, and I believe KLaw’s are the ones missing. I think it’s skewed the rankings a bit in the process. Just a heads up.

    Comment by Nate Grimm — February 22, 2012 @ 6:10 pm

  10. Your Keith Law rankings are incorrect and its messing up your composite

    Comment by Jason — February 22, 2012 @ 6:51 pm

  11. Jeff, I think you need to check your spreadsheet. Besides Scout and ESPN having identical rankings, your BP rankings do not match up with the BP website. You have the top 5 under BP as:
    Trout
    Harper
    Moore
    Montero
    Miller

    At the BP website, they have:
    Moore
    Harper
    Trout
    Profar
    Teheran

    I love the idea here, but the spreadsheet looks like it needs to be corrected. I just did this for one of my leagues using BP, Keith Law, and Baseball America.

    Comment by Bobby Mueller — February 22, 2012 @ 6:52 pm

  12. Dang. I will correct later tonight.

    Comment by Jeff Zimmerman — February 22, 2012 @ 7:07 pm

  13. You have Jacob Marisnick (120) as well as Jake Marisnick (66) listed for Toronto. Pretty sure they’re the same guy.

    Comment by AndrĂ© Babyn — February 22, 2012 @ 7:10 pm

  14. I would use John Sickles rankings at Minorleagueball before Mayo’s.

    Comment by Ogre39666 — February 22, 2012 @ 7:10 pm

  15. I’ve been manually doing this myself for the last 5 years for fantasy baseball prep only because nobody else has been doing it. It’s a 10-20 hour project every year cutting and pasting and rearranging the columns every year to do the excel queries.

    Someone make this happen.

    Comment by Galt — February 22, 2012 @ 7:22 pm

  16. It’s actually quite easy if you know the formulas to do VLookups. The problem is I only see I have access to Fans and RotoChamps right now. If anyone can point me in the right direction to an easily transferred to excel version of Bill james, Zips and Marcel then i could get it done.

    Comment by Peoples Champ — February 22, 2012 @ 7:50 pm

  17. MLB has Teheran at #4 as well. I was wondering what he’d done so wrong to fall from grace. Maybe a repost of the article is needed after the corrections to the spreadsheet are made.

    Comment by Dale — February 22, 2012 @ 9:37 pm

  18. I am very close to having this done. Right now I have CBS, ESPN, and rotochamp completed. Just waiting for FanGraphs to post Marcel and ZiPS. Not only does it average all of the projections, it will:

    -assign each stat a value for an overall ranking
    -project salary
    -project keeper inflation salary
    -able to turn on/off site projections in case you do not like that site
    -tab to enter your league setup to help calculate values and salary

    One aspect that is needed is an adjustment for position scarcity.

    Only issue is with the amount of math involved sorting and filtering is very slow. However, this can be helped by cutting down the total number of players on the spreadsheet, currently it has every player listed in the CBS system.

    If there is enough interest I don’t mind sharing this,

    Comment by Bill — February 22, 2012 @ 9:37 pm

  19. At no point was Izzy Alcantara highly regarded. Brian Rose was, but certainly not on the level of a Steven Strasburg. Obviously the aren’t comparable, I just saw Izzy Alcantara and Strasburg in the same sentence and had to speak up.

    Comment by EarlSweatshirt — February 22, 2012 @ 9:47 pm

  20. This has already been done (in spades I might add) if you purchase the spreadsheet from fantasyrundown.com. For $4 it not only does all the sites listed above, it also gives about 10-15 more sites as well. And, he re-releases updated versions every week to your inbox as new rankings come out. Great resource and highly recommended for prospect drafting (and trading).

    Comment by Joe — February 22, 2012 @ 10:11 pm

  21. I’m not sure if anything aside from ESPN, BP and BA will be very helpful. All compiled by (as far as I can tell) full-time prospect analysts, who are experienced, smart and well-connected, and who put a lot of time and effort into their top 100s. Not sure if any of those other lists fit all those criteria.

    Comment by theeiffeltower — February 22, 2012 @ 10:15 pm

  22. One thing to keep in mind is that while extreme youth for the level is a big plus for a prospect’s ranking, it’s often guys who are a little closer to their prime as rookies who have the bigger immediate impact. A 20 year old on the verge of the Majors may have incredible potential, but a 25-year old with a balance of skills but a limitted ceiling is often the better bet for the immediate season.

    Comment by WilsonC — February 22, 2012 @ 10:19 pm

  23. The Baseball Prospectus Rankings are wrong. As in, that’s not the rankings on the BP site. Take Shelby Miller at #5 for example. Teheran is #5. Or am I missing something?

    Comment by drew — February 22, 2012 @ 11:00 pm

  24. umm, the project prospect rankings are wrong too

    Comment by drew — February 22, 2012 @ 11:14 pm

  25. ok, i think all the headings are just mislabeled

    Comment by drew — February 22, 2012 @ 11:37 pm

  26. Surprise, surprise…I was working on something like this earlier in the week, but now that you’ve done it I don’t need to do it anymore. Thanks! :)

    Comment by Randy — February 23, 2012 @ 12:12 am

  27. What’s the story with #46 Brandon Jacobs? He only has a rank from BP but blanks from everbody else. Shouldn’t those blanks all be 130?

    Comment by Wait Til Next Year — February 23, 2012 @ 1:45 am

  28. I just don’t see it this year. For it to happen he will need to tear of ST to get sent to AAA. Once in AAA he will have to be hitting great again and someone in the majors will need to be struggling.

    Comment by Jeff Zimmerman — February 23, 2012 @ 7:18 am

  29. I have done this already. It’s not a “difficult” thing to do, but it is very time consuming given that not every source spells player names the same way, or even writes them first and last name in the same order. Plus all the columns are lined up different from source to source, so it’s a lot of cutting and pasting, vlookups, averageif, etc, etc.

    Here’s the spreadsheet: https://docs.google.com/spreadsheet/ccc … VdCVjhMRFE

    Includes averages of Fangraphs fan projections, Zips, CBS, Sportsline, Davenport, a few others. Just a straight average of the projected stats.

    Comment by Jeff Akston — February 23, 2012 @ 8:46 am

  30. I would be very suprised. Even if he were to force the issue, I don’t see Myers as a ‘break the bank’ type prospect – more Nick Markakis than Michael Stanton probably.

    Comment by The Jean Genie — February 23, 2012 @ 8:51 am

  31. Thank, Jeff, but that link isn’t working. Repost?

    Comment by Ayuh — February 23, 2012 @ 9:19 am

  32. Don’t draft rookies in non-keeper leagues, they’re not priced logically. Happy ending.

    Comment by lester bangs — February 23, 2012 @ 9:30 am

  33. don’t know why the link didn’t work. Here it is again: https://docs.google.com/spreadsheet/ccc?key=0AjgBY_KJufpPdFlEdF9NUS1vS1JoUEFzWVdCVjhMRFE

    Comment by Jeff Akston — February 23, 2012 @ 10:13 am

  34. Great resource, Jeff, thanks! Looks like adding a projected $ amount would be as simple as multiplying the “value” columns by about 4 or 4.5, right?

    Also, I tried to send you a little something through the paypal link on the doc but it didn’t seem to work. That link just seems to take me to my paypal account but doesn’t give me a way to send directly to you.

    Comment by Aaron Murray — February 23, 2012 @ 10:35 am

  35. This is already done by Cory Schwartz at Fantasy 411. He uses up to 11 sources (paid and unpaid sources).

    http://fantasy411.mlblogs.com/

    Comment by yoda0 — February 23, 2012 @ 10:47 am

  36. He’s too busy winning Super Bowl rings….

    Sorry bad joke but had to plug them somewhere. Good catch though according to Jeff’s methodology.

    Comment by chri521 — February 23, 2012 @ 10:59 am

  37. The ones at fantasy411 are good except that there’s no ultimate valuation and players are listed alphabetically. I guess if you are either going to study each player carefully or you’re just looking for a couple guys here and there it’s pretty good but I’d rather have something ranking guys by their projected value.

    Comment by Aaron Murray — February 23, 2012 @ 11:02 am

  38. Aaron, I usually just sort by OPS and that gives me a quick/dirty look at how the players measure up against one another. This simply the best sheet to use if you want to look at the baseline valuation of a player.

    Comment by yoda0 — February 23, 2012 @ 11:14 am

  39. Hmmm, I don’t know why the paypal thing wasn’t working for you. It took me there. Not sure what’s up.

    I wouldn’t multiply the value by a dollar amount. That’s a whole different calculation that I never got around to doing.

    I am not in an auction league so I’ve never done a value for that.

    Now with ZIPS and Steamer projections out, I’ll update that spreadsheet one last time this offseason.

    I look forward to next year when Fangraphs is doing it so I don’t have to.

    Comment by Jeff Akston — February 23, 2012 @ 11:21 am

  40. This has been done: http://www.fantasyrundown.com/Prospect_Spreadsheet_12.html

    Its $4. I don’t use it myself, but just putting it out there for others

    Comment by tenags — February 23, 2012 @ 11:48 am

  41. Another important thing with prospecting in fantasy baseball is the type of league. A league where there is a large number of players kept makes prospects much more draftable. Possibly even more importantly is the conditions and penalties for keeping players. I play in a league where there is zero penalty and you may keep a player for as long as you wish. This, in my opinion, puts a huge emphasis on holding onto one or two high upside prospects. They’d have to be the type that get very high praise (the non MLB players I’ve kept have been Weiters, Jesus Montero, and Matt Moore at various times) and close to the majors in order to really make it a no brainer.

    Comment by Nick — February 23, 2012 @ 11:51 am

  42. To the guy who corrected me on Izzy Alcantara, you’re right, wasn’t really meaning to talk about just top-flight prospects… My bad… Sox fan here, so I just listed the first two failed prospects to pop into my head from growing up, not necessarily the biggest name failed prospects I could think of! To all those who did all this work, thanks!

    Comment by Paul M. — February 23, 2012 @ 1:23 pm

  43. Jeff,

    I have been doing the same thing as you for years and actually created a website to post my results. You can check it out at:

    http://mlbcpi.blogspot.com/

    So far this year, I have 13 different lists that I have combined into one composite list (over 200 players) and I expect to add 4 or 5 more (including Fangraph’s Top 100) when its all said and done.

    Mark

    Comment by Mark Sherrard — February 24, 2012 @ 9:25 am

  44. Sickles doesn’t do a top 100; he does top 50 hitters and to 50 pitchers.

    Comment by philosofool — February 24, 2012 @ 2:11 pm

  45. I think the comparison was more for illustrative purposes, not to say Izzy was on par with Strasburg.

    And also the fact that it’s not every day that you have the opportunity to make an Izzy Alcantara reference.

    Comment by BStu185 — February 24, 2012 @ 3:42 pm

  46. Great concept. I’ve seen it in a couple different ways on the net. I would suggest a column for MEDIAN ranking as that is less swayed by extreme rankings.

    Comment by Dean — March 5, 2012 @ 4:36 pm

  47. Hey Jeff,

    I do this a tonne, and I started out doing it the same way. You gotta have highest level -slash- ETA.

    The easiest way to do this is through a quick MYSQL database. At this point, if you’re into fantasy baseball or pfx analysis, there’s no excuse for not spending the 2 hours it takes to learn the basics of SQL.

    I’m not sure if Fangraphs has ever done a write-up on “Using DBs” but it’d be neat, methinks.

    Comment by Kris — March 5, 2012 @ 5:16 pm

Leave a comment

Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Close this window.

0.108 Powered by WordPress