FanGraphs Members can obtain any of our stats over any timeframe. Certainly one of my favourite methods to make use of the obtain function is to check info over distinctive time frames. For at the moment’s instance, I’ll examine 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 normally use a number of time frames (e.g. earlier two seasons, first half, final month) for a whole bunch 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 deciding on distinctive time frames. Most individuals will examine first- and second-half stats, however I’ve discovered hidden gems through the use of 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 kind of evaluation. Once more, the secret’s to search out breakouts that others may not have recognized.
Right here is methods to examine the 2023 fastball stats of this season’s Cardinals starters. And bear in mind, this may be completed with any group of pitchers and stats.
Step 1. Go to the 2023 pitching leaderboard and choose “Customized Gamers.” Add the gamers.
Step 2. Choose the stats you need to use. I’m utilizing strikeout fee, fastball velocity, bot fastball stuff, and fastball Stuff+.
Step 3. Choose your required timeframe and export the data. On this instance, first- and second-half stats are used, however bear in mind, the customized date vary function lets you choose different time frames.
Observe: Some info could also be lacking for some gamers, particularly in the event that they missed time within the minors or due to damage. 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 data.
Step 5. Put the names and stats you need to examine 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 “exhausting” step, nevertheless it must be mastered. The best approach to pull the data 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 comprises 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 searching for the contents of C16 (543243) in column I of sheet 1H and returning the corresponding worth in column C.
Step 7. Herald all of the stats and discover the first-half to second-half variations for every of the pitchers.
Step 8. Examine all of the variations in a single desk. On this occasion, I simply linked the cells, but when the desk is giant, XLOOKUP may very well be used once more.
Step 9. Make the desk all fairly. Open Conditional Formatting …
… and set the constructive values to inexperienced and the unfavourable ones to pink.
Step 10. Cover the ID numbers.
Step 11. Benefit from the fruits of your labor.
