Improved SGP Calculation Formula – Part II

Welcome to Part II of a three-part series in which I’ll share an improved method of determining standings gain points factors.  In the first part of the series we looked at the difference between my old method of calculating standings gain points factors and the improved approach suggested by Art McGee in his book, How to Value Players for Rotisserie Baseball.  

In this part of the series I’ll explain how to implement the SLOPE function McGee suggests.

The SLOPE Function

The SLOPE function interprets a set of data points and returns the slope of the linear line-of-best-fit for the data. The function requires two inputs:

  1. The Y-values of all the data points
  2. The X-values of all the data points

Again, we’re back in high school math class (or earlier?).  The Y-values (vertical axis) will be the actual accumulated statistics for each team in the league for the category we’re measuring.

The X-values (horizontal axis) will be the rotisserie points earned for each team.

For example:

Rotisserie Points (x-values) Home Runs (y-values)
12 291
11 287
10 281
9 274
8 272
7 267
6 263
5 261
4 244
3 239
2 234
1 191

Let’s Put This Into Excel

You can see the data entered into Excel below.

Given this exact set of data, the formula used in Excel to calculate the slope is:

=SLOPE(B2:B13,A2:A13)

A More Comprehensive Example

This is only the home run data for one season for one league.  In order to calculate more accurate SGP factors we should be including multiple years and/or leagues and we also need to perform these calculations for many different statistics (not just home runs).

A more thorough example Excel file that contains several years of data and the SLOPE calculations for the different years can be found below.  It’s not my prettiest work, but this is a file you only need to be in once a year, when you’re updating your SGP calculations for an upcoming season.  You can download the file using the ExcelWebApp toolbar below the spreadsheet.

WHAT’S COMING?

In the final part of the series I’ll take a deep dive into how these changes in SGP calculations affect our end rankings.

Want More In-Depth Analysis Like This?


Thanks For Reading

Stay smart.

 

Improved SGP Calculation Formula – Part I

Welcome to Part I of a three-part series in which I’ll share an improved method of determining standings gain points factors.  In this first part I’ll show graphically demonstrate the old method I used in calculating SGP factors and compare it to the improved method.

I’m mostly self-taught when it comes to my knowledge of standings gain points.  It’s hard to say where I picked up the information.  I think it’s an accumulation of information gleaned from message boards and old web sites.  Nevertheless, I continue to learn and I recently came across an improved method of calculating SGP factors.

Enter Art McGee

Art McGee published his approach to using standings gain points in his book, How to Value Players for Rotisserie Baseball.  The book was originally published in 1997 and he put out an updated version in 2007.  So his theories have been around for quite some time and continue to live on.  The Excel implementation of SGPs that I use has been tweaked some, but is very consistent with McGee’s approach.

NOTE:  I have provided an affiliate link (what’s an affiliate link?) to the book on Amazon to the right, but at the time of writing, I don’t suggest you buy it from Amazon.  It seems like the book is difficult to come by and the prices are quite high.  The link is just so you can see the book and read the summary, or maybe the prices will come down in the future.  If you do want to purchase McGee’s book, Baseball HQ is selling them on a close out sale for $8.95 plus S&H.  That’s where I got my copy.

A Difference Is Found

Not too far into McGee’s explanation did I come across an important difference in the way he calculates his SGP factors.  To illustrate the difference, let’s take a look the following sets of Home Run standings:

Rotisserie Points HR Data Set #1 HR Data Set #2
12 291 300
11 287 273
10 281 260
9 274 249
8 272 249
7 267 248
6 263 243
5 261 241
4 244 231
3 239 231
2 234 229
1 191 203

I previously would have calculated my SGP factor for “HR Data Set #1” as the first place value (291) less the last place value (191), divided by the number of teams that could be passed (in a 12-team league you pass 11 teams by going from worst to first).  Specifically the SGP for Data Set #1 is 9.0909 ((291-191)/11) and for Data Set #2 is 8.8182 ((300-203)/11).

Let’s Plot It Out

The red line below plots out the approach I have been using to calculate my SGP factors.  If you think back to high school math class, we’re really calculating the slope of the line here.  Notice how the 9.0909 I calculated above matches the slope in the formula representing the red line, y = 9.0909x + 181.91.

And when you look at the red line next to the other plotted data points, you see that it doesn’t do a great job of fitting data as a whole.  This is the weakness in only using the highest and lowest data points to approximate the number of home runs necessary to move up one point in the standings.

Home_Run_Standings_Gain_Points Continue reading “Improved SGP Calculation Formula – Part I”

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.

Smart Elsewhere #8 – Fantasy Baseball Crackerjacks

You probably have gathered by now that I am not here offer much player analysis, sleeper talk, or draft breakdowns.  There is so much great information out there that I couldn’t possibly keep up (I have my nose too far buried in spreadsheets to write much).

Yet I do realize that spreadsheets and projections and conceptual talk I focus on can only take you so far.  At the end of the day, in-depth analysis, player profiles, rankings breakdowns, and draft prep information is extremely important to your success.

I can’t offer this myself.

But I do work with Fantasy Baseball Crackerjacks and they provide A TON of this high quality information.

My Role at Fantasy Baseball Crackerjacks

I used the methods documented here on SFBB to develop the projections used at Fantasy Baseball Crackerjacks.  I even write the occasional player profile, analysis, and strategy piece.  I’m very proud to be a part of the work they do at the site.  We just released the positional rankings and projections this week (see links below) and the other writers at the site pour out tons of interesting content.

Thanks For Reading

Stay smart!