Introduction and Downloads
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)
