This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Spreadsheet School for Daily Fantasy Sports
Introduction and Downloads
Introduction and Downloads (0:45)
Module 1 - Pulling in DFS Web Data
Module 1-1 - Pulling Web Data into your Spreadsheet (3:57)
Module 1-2 Pulling Salary Information (2:46)
Module 1-3 Combining Data into one Table (5:01)
Module 1-4 Using a Names tab to Eliminate Spelling Issues (5:39)
Module 1-5 Getting rid of error messages (1:54)
Module 1-6 - How to Manipulate/Change the Pulled data (5:56)
Module 1-7 Using Google Sheets to Pull Web Data (4:15)
Module 1-8 Using Power Query Editor when Pulling Web Data (5:56)
Module 2 - Finding & Backtesting Trends from Historical Data
Module 2-1 - Introduction to Finding Trends (1:29)
Module 2-2 - Sorting the Data Before Finding Trends (1:38)
Module 2-3 - Reviewing your data to Search for Possible Trends (1:49)
Module 2-4 How to Research Universal Trends (3:37)
Module 2-5 Calculating Running Average of Player points (4:36)
Module 2-6 -Checking the Type of Player to Narrow our Research (4:49)
Module 2-7 - Create a Summary Sheet (8:13)
Module 2-8 Creating New Columns of Stats to Test (6:23)
Module 2-9 - Options to Increase Excel's Speed (2:58)
Module 2-10 - Researching Individual Player Trends (9:38)
Module 2-11: Adding Running Average without Sorting First (2:45)
Module 3 - Making your own Projections
Module 3-1 Make your own projections (8:27)
Module 3-2 - How to Look at Defensive Rankings (5:06)
Module 3-3 How to Analyze Vegas Odds for Spreadsheet Projections (4:38)
Module 3-4 - Setting up a Nested IF to Condense your Projections (4:46)
Module 3-5 - Set up a Table for Projection Adjustments (4:38)
Module 3-6 How to make NBA Projections with Fantasy Pts per minute (6:39)
Module 4 - Using Solver for Optimal Lineups
Module 4-1 Overview on Using Solver for Optimal Lineups (15:03)
Module 4-2 - Adding the Solver Add in (0:53)
Module 4-3 Displaying Solver Results Easier (9:46)
Module 4-4 - How to Stack a Team in Solver (3:45)
Module 4-5 Apply Site Limits to Solver Constraints (5:38)
Module 4-6 - Using the Flex Spot in Solver (4:47)
Module 4-7 Getting Solver to Choose Multiple Positions (5:04)
Module 4-8 - How to Include or Exclude Players (4:39)
Module 4-9 - How to Choose your own Flex spot (2:18)
Module 4-10 - How to Run Multiple Lineups with Solver (7:10)
Module 5 - Using Advanced Excel Features for Greater Stat Analysis
Module 5-1 Pivot Tables for Determining Best Home Run Ballparks (9:01)
Module 5-2 - Determining the type of players by Standard Deviation (8:43)
Module 5-3 Conditionally Formatting cell based on Stat Values (2:45)
Module 5-4 - Removing Duplicates (2:23)
Module 5-5 How to Use Macros to Automate Tasks (5:54)
Module 5-6 How to pull out parts of a cell into a new cell with Formulas (8:38)
Module 5-07 How to pull in Twitter Feeds into your Spreadsheet for last minute Injuries (7:41)
Module 5-08 How to use Numberfire's projections (2:58)
Module 5-10 How to use IFERROR to get rid of errors on your spreadsheet (2:01)
Module 5-11 How to combine multiple cells into one cell (2:20)
Module 5-12 How to Determine if a player is Home or Away in your spreadsheet (3:57)
Module 5-13 How to Rank Def vs Position or any range of numbers (3:25)
Module 5-14 How to pull in Injury news and Adjust Projections based on it (7:02)
Module 5-15 How to pull in NBA Season Stats into Google Sheets (3:07)
Module 5-16 How to calculate how many times salary a player scores (2:52)
Module 5-17: Use XLOOKUP for DFS (6:16)
Module 5-18: Pull over List of Teams from Salary Export using Formulas (6:44)
Module 5-19: Conditionally Format DFS data to stand out (4:50)
Module 5-20: Build Interactive Dashboard in Excel for DFS Stats (22:31)
Module 6 - How to analyze a completed Draftkings Contest
Module 6-01 How to pull the Data you need to Analyze contest results (3:34)
Module 6-02 How to format the contest data before Analyzing (7:03)
Module 6-03 How to analyze team stacks and team usage in contests (12:05)
Module 6-04 How to Track the strategies of the Top Users (6:04)
Module 6-05 How to Analyze winnings and losses from Tournaments (15:32)
Module 7 - How to create Bulk Lineups withOUT Solver
Introduction - Running Bulk Lineups without Solver (2:20)
Module 7-1 Copying in the Fanduel Salary export (1:11)
Module 7-2 Add in Player info (1:50)
Module 7-3 Calculate Projected points per Dollar (2:22)
Module 7-4 Rank each position based on Pts/$ (4:09)
Module 7-5 Create a Player Pool of the top players (7:37)
Module 7-6 Randomly Choose Players (3:45)
Module 7-7 Add in Salary columns for each player (1:52)
Module 7-8 Add in Projected points for each position (1:49)
Module 7-9 Add in formula to check for Duplicate Lineups (3:49)
Module 7-10 Add in length of player names to a new column (2:34)
Module 7-11 Display only Valid Lineups (3:57)
Module 7-12 Copy down all the Lineups (2:24)
Module 7-13 Copy and Paste Special the Final Lineups (1:05)
Module 7-14 Sort the lineups (1:11)
Module 7-15 Remove Duplicate Lineups (1:17)
Module 7-16 Delete rows for lineups you don't want to keep (0:43)
Module 7-17 Delete all rows on Lineups tab except for top row (2:11)
Module 7-18 Make a csv lineup Tab (2:46)
Module 7-19 Find actual Player's used percentage (2:14)
Module 7-20 Editing the Macro and running it (3:20)
Extras: 7-21 to 7-27
Module 7-21: How to Exclude players from Lineups (0:59)
Module 7-22: Set Minimum Salary for your Lineups (3:20)
Module 7-23: What to do if you get Low Lineup Salaries (3:57)
Module 7-24: Team Player Limits (5:53)
Module 7-25: Stacking Teams (6:42)
Module 7-26: Dual Positions in Draftkings (6:14)
Module 7-27: Lock Players into Lineups (6:05)
Module 7-28 - How to account for flex spot (2:56)
Module 8 - Single Game Slate
Introduction (3:33)
Spreadsheet Downloads
How to use the Fanduel Spreadsheet Optimizer tool (6:18)
How to use the Draftkings Spreadsheet Lineup Optimizer (7:14)
Draftkings Showdown Basics (2:00)
Fanduel Showdown Basics (2:20)
NBA Research Report (10:19)
MLB Research Report (12:22)
NFL Research Report (7:56)
NHL Research Report (6:56)
How to Build a Single Game lineup Builder Spreadsheet (30:50)
How to Research Past Single Game Contests (38:46)
How to Research User Data in Past Contests (11:38)
Where to get Projections from to Use with this Tool (2:20)
How to use Rotogrinders Results DB to research Past Contests (9:10)
Module 9 - How to make DFS Model/Cheatsheet in Google Sheets (Baseball Example)
Introduction (2:19)
1 - Pull in Fanduel Salary Data (2:49)
2- Create the Cheatsheet tabs and link Fanduel Data (3:27)
3- Create naming convention tab (3:14)
4-Pull in Draftkings Salary data (3:51)
5 - Add in batter and pitcher's hand (4:07)
6 - Pull in opposing pitcher to the batter's cheatsheet (3:59)
7 - How to Pull in Fangraphs data (9:26)
8 - Manipulate Cheatsheet to create Custom Stats (5:28)
9 - How to Rank Columns of Data Easily (3:15)
10 - How to Conditionally Format Cell Data (2:48)
11 - How to pull in Team stats (4:36)
12 - How to pull in Weather data to the Cheatsheet (11:58)
13 = How to pull in Vegas lines to your Cheatsheet (6:10)
14 - Your finished Cheatsheet (1:05)
Module 10 - VBA for Daily Fantasy
Intro & File downloads (4:05)
Module 10-1: How to Start with VBA code (2:26)
Module 10-2: Using Macro Building to Write VBA Code (1:06)
Module 10-3: How to Edit & Run a Macro (3:54)
Module 10-4: Declaring Variables (3:39)
Module 10-5: Cell Reference (4:33)
Module 10-6: IF Statements (4:20)
Module 10-7: For Loops (4:46)
Module 10-8: Insert Comments into your Code (2:49)
Module 10-9: Code to Stop Screen Updating (2:12)
Module 10-10: How to Create a pop up Message Box (1:29)
Module 10-11: Call Another Macro in your code (3:15)
Module 10-12: Password Protect VBA Code (1:49)
Module 10-13: Shortcut keys and Buttons to trigger macros (2:17)
Module 10-14: Debugging Errors (2:39)
Module 10-15: Find Correct Code with Macro Builder (2:53)
Module 10-16: Example - Run Certain Code based on Value of Cell (5:20)
Module 10-17: Using Input Box to Get Data from User (3:33)
Module 10-18: Example - Refresh Web Data (4:19)
Module 10-19: Run Macro upon Opening Workbook (2:55)
Module 10-20 - Example - Copy Daily Game stats to Complete Game Log List (9:48)
Module 10-21 : Example - Save sheet as csv file (3:24)
Module 10-22: Example - Email a worksheet (4:08)
Module 10-23: Create User Defined Functions (13:33)
Module 10-8: Insert Comments into your Code
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock