Extras: 7-21 to 7-27 | Spreadsheet School

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)

Teach online with

Extras: 7-21 to 7-27

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock