How to Stream a Fantasy Football Kicker (Part 2 of 3)
How to Stream a Fantasy Football Kicker is a three-part series, and you’re currently reading Part 2 of 3. If you haven’t read Part 1 yet, I highly recommend starting there. It covers the basics you’ll need to make sense of what’s coming next. Click the blue button below to catch up.
How to Stream a Fantasy Kicker (Part 1 of 3)Also, all three parts of this series are built on my 2013 post, Using the Science of Statistics to Select a Fantasy Kicker. Think of it as the ancient scroll that started it all – the foundation for everything we’re doing here. Click the blue button below to check out the original post and see where it all began.
Using Statistics to Select a Fantasy KickerQuick Recap of Part 1
In the first post, I explained how fantasy football owners can gain an edge by streaming kickers, rotating them weekly based on matchup potential and using Las Vegas odds instead of traditional rankings.
Instead of focusing on traits like leg strength or accuracy, which have little correlation with a kicker’s fantasy success, the key is to target kickers from teams that Vegas expects to score the most points, since those teams tend to produce the best fantasy kicker results.
While this whole process may look a bit heady and intimidating at first, it’s actually easier than assembling IKEA furniture without cussing. By applying simple math to point spreads and over/under totals, you can quickly estimate each team’s projected points and make smarter weekly kicker choices.
What You’ll Learn in Part 2
In this post, I’ll show you how to streamline the entire process using Excel, allowing you to quickly find the best kicker options each week without doing all the math manually.
You’ll be copying Vegas odds from a website and pasting them into an Excel spreadsheet that automatically calculates projected team points and ranks every team accordingly.
Once the spreadsheet is built, it can be reused every week during the season. The steps are explained in detail so that anyone, no matter how comfortable you are with computers, can follow along successfully.
A Note Before We Begin
Although this process is much easier than folding a fitted bed sheet, if it still feels overwhelming, you might want to wait for Part 3. That section explains how to use AI to automatically create your kicker spreadsheet and happens to be the same method I use each week.
If you’re ready to give it a whirl, though, let’s roll up our sleeves and dive into the Excel approach.
