2014 Player ID Map Update

Draft day has come and gone, but if you’re looking to keep up-to-date with the Player ID Map, I’ve run a significant number of changes through the file.  In addition to adding rookies that should have a fantasy impact this year, a number of edits to player teams were made, many missing IDs were filled in, and Davenport, Baseball Prospectus, and Yahoo IDs were added to the file.

You can download the updated map here.

A complete list of changes can be found in the “Change Log” tab of the spreadsheet.

ESPN_Player_ID

Some of the more notable additions to the Player ID Map are:

  • Masahiro Tanaka
  • Noah Syndergaard
  • Jameson Taillon
  • Archie Bradley
  • Alexander Guerrero
  • Miguel Sano
  • Maikel Franco

If you’re new to the site, consider checking out these past posts that illustrate some interesting things you can do with player IDs.

Please let me know if I’ve missed anyone.  Stay smart.

How Do I Calculate SGP For OPS?

We’ve now calculated SGP for three rate statistics:  batting average, on-base percentage, and slugging percentage.  So let’s go for the ultimate challenge and combine two ratio statistics together!

This is the most complicated calculation yet, because of the fact that we have two rate stats being combined together.  And to make matters more complicated, in this scenario, we don’t know the breakdown of OPS into OBP and SLG.  Despite that, I think we can calculate the SGP factors accurately.

Let’s take a look at how to perform an SGP calculation for on-base plus slugging (OPS).

A Warning About This Data

What follows is a step-by-step calculation for determining OPS SGP in an NL-only league.  I do not have standings data for a mixed-league using OPS as a category.

If you play in a mixed league, use these exact SGP factors at your own risk.  They’ll give you an approximation, but the OPS standings in a mixed league will surely be different than in an NL-only league.

The good news is that if you have standings history for your own OPS league, you can follow this exact methodology to calculate the SGP factors for your league.

The Standings Data

Thanks to reader Bob who filled out the “What It Takes To Win Your League Calculator” with six years of data from this NL-only league:

SGP_OPS_Standings

The decline in OPS over this time frame was eye-catching to me.  So much so, that I think we’d be doing ourselves a disservice to include all six years of data.  And the decline happens at all spots in the standings (1st place and 10th place).  It’s roughly a 40 to 60 point drop from 2008 to 2013 regardless of the position in the standings you look at.  The numbers from just 2011 to 2013 look much more consistent.

With this in mind, I decided to trim things down to only include the last three years of data.  This is worth keeping in mind for all statistical categories.  I’m sure HR are down in all formats too.  So including ten years of history in your HR calculations may not be appropriate.

Here are only the last three years:

SGP_OPS_Standings2

How Many OPS Percentage Points Move You Up One Spot In The Standings?

Over the last three years, an average of .774 won the category and an average of .720 finished 10th.

.774 – .720 = .054 total spread between 10 teams

We have the data for 10 teams, meaning there are 9 spots you can move up in the standings by moving from .720 to .774 in team OPS.

.054 / 9 = .006

On average, increasing your team OPS by .006 points (in this NL-only league) will result in you climbing one spot in the standings.

What Formula Do I Use To Calculate The SGP For a Given Player?

Continue reading “How Do I Calculate SGP For OPS?”

Projecting X Bundle Update – 2014 Expected Runs Per Game Information

For those that have purchased the SFBB Projecting X Bundle (click here to read about the Bundle or here if you’re interested in purchasing), I have compiled expected runs per game metrics from around the web and put them into a format that you can drop into your Projecting X spreadsheet.

In Projecting X, Mike Podhorzer refers to Baseball Prospectus, Clay Davenport, and Replacement Level Yankees as the resources he uses for his expected RPG metric (this is an input into estimating pitcher wins).  I was able to locate the BP and Davenport information, but from what I can tell, Replacement Level Yankees has not published the projection.  If you can locate it, please feel free to link to it in the comments below this post.

Fangraphs also provides projected standings, and so I included them as the third input.

You can download this file below through the buttons at the bottom of the web part, or possibly even copy and paste from here into your own spreadsheet.

You’ll notice that I removed the 2013 information that was the best guess for 2014 runs per game at the time the bundle was created and released.

Thanks For Reading

Stay smart.

You Need To Read This If You Play In a Two-Catcher League

In this post I’m going to demonstrate why you can’t simply rely upon the rankings information you find online.  Widely available rankings do not account for the intricacies of your league.  These differences can lead to large swings in the valuations of players.

You should be calculating your own rankings specific to your own league format, especially if you play in a two-catcher league.  There is a valuation problem waiting to be exploited in two-catcher leagues.  

Please make sure you read to the end.  I get a little carried away with examples below, but there are some important conclusions at the end.

This Is Not a Lie

When I run Steamer’s 2014 projections through my ranking system, Buster Posey and Wilin Rosario come out as top 10 players.

Let that sink in.  In all the draft preparation and rankings articles you’ve read so far, have you seen any catcher crack the top ten?

You’re a Moron.  Your Ranking System Must Be Wrong.

Before you dismiss this out of hand, let’s work through a little exercise.  As with most scenarios I outline at this site, let’s assume a 12-team mixed league using standard 5×5 rotisserie categories, 14 hitters (2 C, 1B, 2B, SS, 3B, CI, MI, 5 OF, UTIL), 9 pitchers, and no bench. This would mean 24 catchers would be drafted, 60 OF, and 168 total hitters.

So as not to pick on any one analyst, I’ll be referring to the consensus fantasy baseball hitter rankings that FantasyPros.com puts out (if you don’t use this tool, it’s pretty neat.  You can instantly average the rankings of your favorite analysts).

As of March 10th, Buster Posey comes in as the top catcher and 36th ranked hitter.  Matt Holliday comes in as the 35th ranked hitter.

Matt_Holliday_Buster_Posey

Let’s say Team A drafts Holliday and with the very next pick, Team B drafts Posey.

If a ranking system were really accurate, you would think the combined stats from Holliday (the 35th ranked player) and Team A’s final draft pick should be very similar to the combined stats of Posey (the 36th ranked player) and Team B’s final draft pick.

Let’s Take a Look

Because Team A passed on Posey, let’s assume they decide to wait until the last round of the draft to fill their second catcher slot by taking the 24th ranked catcher.  In those same consensus rankings, the 24th catcher is Welington Castillo.

Wellington_Castillo

And because Team B wasn’t able to take Holliday with their pick, they decide to wait until the last round to draft their fifth outfielder.  When the time comes, Team B selects the 60th ranked OF (12 teams * five OF per team).  The consensus rankings tell us Kole Calhoun is that guy.

Kole_Calhoun

So Team A ends up with Holliday and Castillo.  Team B ends up with Posey and Calhoun. Applying Steamer’s 2014 projections to these two teams we get:

Player AB H AVG HR R RBI SB
Holliday 530 152 .287 22 78 81 4
Castillo 365 92 .252 12 41 45 2
Total Team A 895 244 .273 34 119 126 6
Player AB H AVG HR R RBI SB
Posey 557 165 .296 20 78 84 2
Calhoun 529 141 .267 17 72 69 11
Total Team B 1,086 306 .282 37 150 153 13

Wow.

Team B wins every category.  The reason for this is the concept of the replacement level players.  The 60th (last picked) OF is still pretty productive, whereas the last catcher selected is a problem.

Maybe Posey should be ranked higher if he gives you that big of an advantage.

You Cherry Picked This Example.  No Way Does This Work Out Like This Every Time.

It is very possible Calhoun is also slanting the results.  When I run his Steamer projection through my ranking system he comes out as the 41st OF (so the consensus rankings are underrating him by ranking him the 60th OF).  I think he’s a terrific sleeper.  So let’s drop twenty three more spots down to Gerardo Parra.

Why Parra, you ask?  Well, he does come out as the 60th best OF when I run the 2014 Steamer projections through my ranking calculations.  He’s ranked the #83 OF in the FantasyPros consensus ranks.

Gerardo_Parra

It would seem that dropping 23 spots further should affect things significantly.  But let’s take a look:

Player AB H AVG HR R RBI SB
Holliday 530 152 .287 22 78 81 4
Castillo 365 92 .252 12 41 45 2
Total Team A 895 244 .273 34 119 126 6

Continue reading “You Need To Read This If You Play In a Two-Catcher League”

Locating Historic League Standings Information in Yahoo

One of the keys to using the Standings Gain Points method to valuing fantasy baseball players is having historic league standings from which to calculate your SGP factors.

I’ve learned that locating historic standings in Yahoo! can be difficult if you don’t use the option to continue your league and roll it forward from year-to-year.

If you do roll your leagues forward, you can easily access past years from the “Season” drop down menu on the league home page.

Yahoo_Baseball_Seasons

If you don’t see this option or want to access the standings from past seasons, check out these instructions below:

How To Access Old Yahoo League Standings

Step Procedures
1. Visit the league page for any current year Yahoo league.
2. Click on the “My Team” link on the main header of your league page.Yahoo_Fantasy_Baseball
3. Once on your team page, you will see your team name in larger font. Right below this team name you will see a hyperlink, in smaller font, to your Yahoo! fantasy sports profile.  Click this link (for example, see the “SFBB” link in the image below).Yahoo_User_Profile
4. Your Yahoo! fantasy sports profile lists information about your past performances, has a trophy case, and lists out each fantasy sports league you’ve played at Yahoo.Yahoo_Trophy_Case
5. It appears like Yahoo keeps your fantasy baseball league standings available indefinitely.  I can get back to final standings from leagues as far back as the early 2000’s.Yahoo_Fantasy
6. To access the standings for a specific league, click on the link for the league name.Yahoo_League
7. You’ll then see the summarized league standings.  To see the more detailed category totals and category standings, click on the “Full Standings” link in the header bar.Yahoo_Rotisserie
8. Wow, I had a good pitching staff that season.  The team-by-team point totals are presented at the top of the page.Yahoo_Final_StandingsAnd the accumulated team stat totals are at the bottom.

Yahoo_Team_Stats

9. These are the figures you can enter into the “What It Takes To Win Your League” calculator to get a summarized look at the stats it has taken over time to win your specific league and to calculate SGP factors from.What-It-Takes-To-Win-Your-League

I’m Looking For Historic League Data

If you have used the “What It Takes To Win Your League” calculator and would be willing to provide me with the information, I’m looking to accumulate this data.  I’m mostly interested in non-standard league sizes and/or leagues that use non-standard statistics like OBP, OPS, K/9, Holds, Quality Starts, etc.

If you have this information available and are interested in helping out, please use the “Contact Me” page of this site to get in touch with me.

Thanks For Reading

Make smart choices.

2014 Rankings and Dollar Values Download Now Available

As draft day quickly approaches, I realize that not everyone will have the opportunity to work through the rankings and dollar value generation process from start to finish.  In order to accommodate people in this situation, the "Using Standings Gain Points to Rank and Value Fantasy Baseball Players" guide will now include an Excel download with the full ranking and dollar value process applied.

The Excel file includes the free Steamer projections available at Fangraphs.com.  The file is fully editable, but will come ranked according to a 12-team mixed league, traditional rotisserie categories and lineups (14 hitters, 9 pitchers).  You can use the guide to tailor this Excel file for your specific league settings and lineup configuration (the biggest adjustment you need to make is to determine the replacement level factors for each position).

Please click here to read more or to get your own copy of the this step-by-step guide for ranking players and calculating dollar values (and inflation!).

smartfantassybb_3d-500x635Or use the buttons below if you'd like to purchase the guide now for $9.99.

Buy Now View Cart

How To Calculate Auction Dollar Values and Account For Inflation

smartfantassybb_3d-500x635I’m very happy to announce that I’ve just finished the “missing pieces” to the “Create Your Own Fantasy Baseball Rankings” guide.

Parts 1 – 6, that walk you through the process of developing a league-specific ranking for each hitter and pitcher, will continue to be freely available here.

A fully comprehensive guide that includes calculating dollar values and incorporates calculations for keeper and in-draft inflation is available here.

This guide now goes up to 10 Parts:

  • Part 1 – Download Free Projection Data
  • Part 2 – Understanding Player IDs
  • Part 3 – VLOOKUP, Excel Tables, Named Ranges
  • Part 4 – Pitcher Rankings
  • Part 5 – Understanding Standings Gain Points
  • Part 6 – Accounting for Replacement Level and Position Scarcity
  • Part 7 – Understanding The Hitter/Pitcher Dollar Allocation
  • Part 8 – Converting SGPs into Hitter Dollar Values
  • Part 9 – Converting SGPs into Pitcher Dollar Values
  • Part 10 – Incorporating In-Draft Price Inflation and Keeper League Inflation

I’m very proud of this guide and believe it to be the best step-by-step guide to ranking players and calculating dollar values available anywhere.

Please click here to read all about the additions to the guide and how to purchase your copy.

Thanks For Reading

Good luck, as we approach draft season!  Stay smart.