FanGraphs Members can obtain any of our stats over any timeframe. Considered one of my favourite methods to make use of the obtain characteristic is to match data over distinctive time frames. For at the moment’s instance, I’ll evaluate the first- and second-half fastball traits of some Cardinals beginning pitchers.
I’m going to point out an instance evaluating two time frames for only one group, however I often use a number of time frames (e.g. earlier two seasons, first half, final month) for lots of of pitchers. And whereas this comparability is particularly useful to fantasy gamers, anybody can use the process for his or her participant evaluation. One key in analyzing gamers, particularly pitchers, is choosing distinctive time frames. Most individuals will evaluate first- and second-half stats, however I’ve discovered hidden gems by utilizing three to eight week intervals. No web site gives odd intervals of their default time frames, like the primary 4 months to the final two, or the season divided into quarters. These knowledge downloads assist facilitate that form of evaluation. Once more, the secret is to seek out breakouts that others may not have recognized.
Right here is easy methods to evaluate the 2023 fastball stats of this season’s Cardinals starters. And keep in mind, this may be accomplished with any group of pitchers and stats.
Step 1. Go to the 2023 pitching leaderboard and choose “Customized Gamers.” Add the gamers.
Step 2. Decide the stats you need to use. I’m utilizing strikeout price, fastball velocity, bot fastball stuff, and fastball Stuff+.
Step 3. Decide your required timeframe and export the knowledge. On this instance, first- and second-half stats are used, however keep in mind, the customized date vary characteristic permits you to choose different time frames.
Be aware: Some data could also be lacking for some gamers, particularly in the event that they missed time within the minors or due to harm. On this occasion, Steven Matz doesn’t throw a four-seam fastball, only a sinker.
Step 4. Import the downloads right into a single spreadsheet. On this instance, I imported them into Google Sheets to share the knowledge.
Step 5. Put the names and stats you need to evaluate into separate sheets. For now, embody one of many IDs. They are often hidden in a future step.
Step 6. Hyperlink the varied gamers and time frames. That is the “arduous” step, but it surely must be mastered. The best option to pull the knowledge is with the XLOOKUP command. The command is intuitive and solely has three inputs. The primary enter is a worth to match, usually a participant ID (FG or MLBAMID) or title.
The second worth is from one other column that incorporates the identical ID/title in a sheet that features the specified stats. On this occasion, Column I in Sheet 1H has the MLBAMID. The third worth is the column, C on this occasion, with the specified corresponding stat.
The XLOOKUP command is in search of the contents of C16 (543243) in column I of sheet 1H and returning the corresponding worth in column C.
Step 7. Usher in all of the stats and discover the first-half to second-half variations for every of the pitchers.
Step 8. Evaluate all of the variations in a single desk. On this occasion, I simply linked the cells, but when the desk is massive, XLOOKUP could possibly be used once more.
Step 9. Make the desk all fairly. Open Conditional Formatting …
… and set the optimistic values to inexperienced and the destructive ones to purple.
Step 10. Conceal the ID numbers.
Step 11. Benefit from the fruits of your labor.
