How to Make a Fantasy Baseball Spreadsheet
3.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
56 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to Make a Fantasy Baseball Spreadsheet to your Wishlist.

Add to Wishlist

How to Make a Fantasy Baseball Spreadsheet

The Complete Guide to Advanced Research in Daily Fantasy Baseball
3.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
56 students enrolled
Created by Nick Marsh
Last updated 6/2016
English
Current price: $10 Original price: $55 Discount: 82% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to import stats automatically.
  • Color coding stats to instantly see great plays
  • Build a Lineups Page to easily compare different players.
View Curriculum
Requirements
  • A computer, any computer.
  • No need to buy any software, it's free!
Description

A step-by-step guide on how to build a Fantasy Baseball Spreadsheet.  Learn how to import stats automatically every day.  You will have batter's stats based on the pitcher they are facing, pitcher's strikeout percentage, projected runs, and more! You will learn how to color code stats to easily see great plays.  There is also a lineups page where you can easily compare lineups for the day!  The Fantasy Basketball course was taken by hundreds of students, in 48 different countries.  Daily Fantasy Baseball brings a millions stats to look at. This spreadsheet will immediately speed up your research.  Save time and take your Fantasy game to a professional level with this easy to follow guide!

Who is the target audience?
  • All Fantasy Baseball Players!
  • Players with limited time for research.
  • Players that want to take their game to a professional level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 26 Lectures Collapse All 26 Lectures 50:31
+
Introduction
2 Lectures 01:02

A quick look at what your finished spreadsheet will do.

Preview 00:19
+
Starting the Spreadsheet
4 Lectures 07:48

How to start your Google Spreadsheet.  Then exporting the players for the day from DraftKings.

Preview 03:21



What you came here for!  This is the equation needed to import stats automatically for you every single day!

How to Import Stats
01:32
+
Today's Starting Pitchers and Vegas Odds
3 Lectures 08:36

Get every Starting Pitcher for the day automatically imported into your spreadsheet.

How to Import Today's Starting Pitchers
01:45

Using player I.D. numbers is much more accurate than using a player's name.  It can be Jon one place and Jonathan another.

Using Player IDs
04:12

This will get you the day's schedule and the Vegas Projected Runs for each team.

Vegas Odds Page with Projected Runs
02:39
+
Batter Matchup
6 Lectures 08:54
Batter facing Left or Right Handed Pitcher
01:39

Each batter's wOBA vs left or right handed pitchers, depending on who they are facing that day.  wOBA is a great stat to use for Fantasy Baseball.  FanGraphs has a great explanation of it in the attached link.

wOBA Splits
02:14

The ISO for each batter vs left or right handed pitchers, depending on who they are facing that day.  ISO is a great stat to measure power and extra base hits (UPSIDE).  FanGraphs has a detailed explanation in the attached link.

ISO Splits
01:16

The projected runs for each batter's team.

Projected Runs
00:57


Review
00:14
+
Starting Pitchers
5 Lectures 13:34

Get today's Starting Pitchers to the SP page.

Getting the Starting Pitchers
03:43

Each Starting Pitcher's team and player I.D.

Starting Pitcher Team and Player ID
02:11

Automatically get the throwing hand for each starting pitcher and the projected runs.

SP Throwing Hand and Projected Runs
03:11

Another great stat for pitchers.  Strikeouts per 9 innings pitched.

K/9 to Starting Pitchers
02:46

+
Lineups Page and Making an Easy Template
3 Lectures 07:10

Bringing it all together to make dominant lineups!  Just copy and paste the lineups page from FantasyBlueprint.com and you will easily be able to compare different lineups during your research.

Lineups Page
02:31

After your Blueprint is complete, we make a copy of it to start from every day.  Saving a ton of time!

Making a Template
02:25

All the work is done!  This is how you will start your spreadsheet every day.  It sets up in just a couple of minutes, allowing you more time building the perfect lineup!

Starting From a Template
02:14
+
Bonus
3 Lectures 03:27

I've added a few stats and things to my Blueprint that will be helpful.  Check it out!

My Blueprint
02:54

If you have any questions, feel free to ask on here.  Or share you screenshots of your customized spreadsheet with me on Twitter! @NickMarshGuy

Preview 00:10

Finished Blueprint
00:23
About the Instructor
Nick Marsh
3.9 Average rating
21 Reviews
58 Students
2 Courses
Certified Google Educator, Fantasy Blueprint

I've been playing Fantasy sports for 15 years.  MLB is my absolute favorite and I count down the days to Spring Training. I've played Fantasy Baseball, Football, Basketball, Hockey, Golf, and Bass Fishing (really). I'm a Certified Google Educator and have been using Google Sheets for years. I will help you build an amazing fantasy spreadsheet!