When I first started playing daily fantasy sports I would take my favorite players and guys I thought were in great matchups... and I got slaughtered. How the hell am I losing? I KNOW HOW TO WIN IN FANTASY! But what I didn’t realize is how much data can be used to pick a player. I always heard guys on ESPN and other sites saying how Player X had such a great matchup this week. How do they know that?!?! Then, I discovered that most fantasy experts had some form of spreadsheet showing stats for each player.
There are some successful fantasy players out there that don’t use a spreadsheet, but not many. The ability to tailor your spreadsheet to the stats you want, with days, weeks, months, or even years of data, will launch you into a completely different level of fantasy player.
So I started my spreadsheet. I literally would input data like crazy on my days off of work (did I mention I’m a bit obsessed with fantasy?). I would input targets, team projected points, attempts per game, and so much more. There has to be an easier way, I thought.
I watched YouTube videos, read articles, listened to podcasts… and there wasn’t much info out there. I became obsessed with creating the perfect spreadsheet! What are the most important stats? How the hell do I get those stats into my spreadsheet? How do I use those stats?
Then, I finally found how to import stats directly into my spreadsheet. It was freakin’ magic! I had stats updating automatically, for free!
I still tweak this thing every single week! Let’s take a look at what’s in my current sheet.
Basic Info From the Export
This everything from when you export players from DraftKings.
Projected Points and Values
I get these from a subscription with RotoWire. I export them and paste them in my spreadsheet. This helps me get a quick glance at who should see an increase in touches.
Per Game Averages
This shows how many opportunities a player is getting every game.
Defense vs Position
Vegas Projected Points
And that's it guys. You can also learn how I made my spreadsheet and get updated stats!