X
Lost password?

Don't have an account?
Gain Access Now

X

Receive free daily analysis

NFL
NBA
NHL
NASCAR
CFB
MLB
MMA
PGA
ESPORTS
BETTING

Already have an account? Log In

X

Forgot Password


POPULAR FANTASY TOOLS

Expert Advice
Articles & Tools
Import Your Leagues
Daily Stats & Leaders
All Pitcher Matchups
Compare Any Players
Compare Any Players
Rookies & Call-Ups
24x7 News and Alerts

Spencer's PGA DFS Rankings Wizard - 'How To' Guide

DraftKings PGA DFS lineup picks daily fantasy golf

Spencer Aguiar breaks down his powerful PGA DFS interactive data spreadsheet, allowing user inputs to create custom rankings and DFS models for PGA DFS contests.

Here at RotoBaller, we are always searching for ways to give our readers the best fantasy sports content possible. With that goal in mind, I am very proud to launch the introduction to my weekly-updated PGA DFS Rankings Wizard - a powerful and interactive data spreadsheet, allowing user inputs to create custom rankings and DFS models for PGA DFS contests.

Unlike most sports, golf is a unique beast because of the constant moving pieces that we have thrown our way for a tournament. Not only do we see golfers rotate in and out between events, but the venue and skillset needed to find success is the core of what our weekly research process becomes. Using our insight and knowledge to gain an edge over all avenues of the gambling sector becomes achievable with added effort, which is why so many mathematical systems have been constructed with the hopes of solving the weekly puzzle.

My PGA DFS model currently has eight individual subsections included, which will help provide continuous research throughout the week. We will get into how to use all the unique features available for your consumption during this article, and I hope you consider making this a part of your weekly digestion of golf data. You can follow me on Twitter @Teeoffsports if you have any questions!

Featured Promo: Get any Props Premium Pass for 30% off using code NEW. Win more with our two new Props Optimizer tools -- one for PrizePicks Props, and one for Sportsbook Betting Props. Find optimal prop bets and get our recommended picks daily! Go Premium, Win More!

 

Spencer's PGA DFS Rankings Wizard - 2020 Memorial

This week's sheet is available right now. Just click the link to get started on your research!

Then be sure to read through my 'How To' guide below, to take advantage of all the features.

 

The Table of Contents

When you click on the link to my PGA DFS model for an event, you will initially get taken to the 'Table of Contents' section. Here is an idea of what you will see:

There are a handful of quality features about this region that I like from a user standpoint. Not only do we have the descriptions for all eight areas in one place for those that are trying to gain a better understanding of what to expect, but all sheet names contain a link to take you to the section you are looking to find.

Here is a list of the segments and their descriptions.

 

Breaking Down Each Spreadsheet Section

1. Rankings - Your go-to shop for that week's tournament. In this section, you will find statistical data, rankings and everything you need to get ready for the event.

Make Your Own Custom Version - All my information will be viewable if you just view the sheet, but you can also create a copy of your own if you click on "make a copy" under the file menu option. If you do choose to create a sheet, all open light grey cells in row four of the "Standings & Calculations" and "Final Calculations" sections can be weighted to include your very own personal "Calculated Standing." The cell box will turn light blue when the weight has been activated, and the sheet runs best when you use a total weight of 100% for each section.

2. Round 1 Results  - If you are looking for DFS Showdown strategy or potential outright additions to your card after round 1, you have come to the right place. Similar to the 'Rankings' tab, you will be able to make a copy of your own after I have updated the first round stats, or you can just stop by to see what I have concocted for the day. I include some advanced metrics that should pinpoint who underachieved or overachieved on Thursday and have added a great feature that allows you to weigh back in your pre-tourney research. The sheet will become active once the first round is officially in the books and updated.

3. Round 2 Results - Let's get back to our research after Friday is finished with another in-tournament breakdown. While the design will mimic the overall feel of round one, the enhanced information we have received should make our jobs easier for the day. The sheet is great for outright bets, in-tournament head-to-head wagers and anyone playing on the DraftKings 'Showdown' slate. All players who missed the cut will be highlighted with a bright red 'MC' so there is no confusion when it comes to any of the gambling sectors, and we will gain a handful of additional categories that become weighable - all of which can be done in the light grey section of row four.

4. Round 3 Results -We are almost to the finish line for the week, but we will get one last opportunity on Saturday night to use the vast array of statistical combinations at our disposal. I tend to make my 'Round 3 Results' sheet geared towards outright wagers, so if you are only viewing it and not making a copy, keep that in mind. Everything that has happened for the event will be in one place, and it should provide a complete picture of what has transpired.

5. Previous Winner After Each Round - This is a brand-new idea that I have created to help highlight where the eventual champion of the tournament has been located after each round. As the sample size grows, the goal is to be able to pinpoint any potential corollary trends between both specific tournaments and individual players. While the actual information in the sheet shouldn't be touched, you will be able to sort any specific column to see the most common trends and biggest comebacks. A feature has been added in the final three columns to signify the average position after each round, making it an interesting tool if you are hoping to find value.

6. Putting Regression - We all know that putting can be the most random statistical category when it comes to golf, so wouldn't it be nice to have previous trends at your disposal? Starting at the 2020 Travelers Championship, I have been tracking every player that has either gained or lost two-plus strokes in a given round. The goal is to see how a golfer follows up an aberrational result, and I have included a handful of ways to decipher the information. The number of strokes gained for the day will be included, as well as a baseline performance from each player, their deviation from the norm, what the round amounted to from a scoring standpoint and how did their driver or irons help or hurt in the performance. We will then go back the next day and include how they produced in the same categories. This will give us our putting differential, place differential and OTT+APP differential. Last but not least, we will take a look at the overall strokes gained or lost on average in the follow-up performance and how many places better or worse it resulted from a scoring standpoint. I do not include round four statistics because of the uncertain nature of nerves affecting the outcome.

7. 3x+ Scoring Average - This sheet is exactly what it sounds like it would be. We are looking at players who generated a score for the day that eclipsed the field scoring average by over three-times the total. There is always a stigma around golfers that they can't provide back-to-back pristine performances, and this should give us an idea of how big of an overall letdown is likely (if any). The follow-up score will compare the scoring to the field average for the day, and there will be additional columns to sort for a better gauge of things. Column "M" will give us our average follow-up score to the field. The bigger the sample size gets, the more useful the tool should become.

8. My Betting Card - While not directly included onto my spreadsheet, the link will take you to the personalized betting recommendations that I have included for RotoBaller. The card will get updated daily for any new additions once the tournament begins.

Now that we have gotten the introductions out of the way, let's get into some of the meat of what separates my sheets from others.

 

Rankings Section

The majority of your pre-tournament research is going to be spent here. However, before we get into all the intricacies of the product and what to expect, I want to stress one more time that the sheet is available to have a copy made for your own weekly research.

It is not a necessity that you go this route, and just viewing what I have constructed is perfectly okay, but a model can be made if you go to "file, make a copy." I'd recommend going that route regardless of your plans because it provides you the ability to search every column without crashing the sheet, and the capability to find something that might stick out on your end could be vital.

 

Golfer Details

When you enter this page, the first thing you will see is "Golfer Details."

'Overall Rank' is a segment that we will touch on later and how it is constructed, but your basic information of DraftKings price, projected ownership and opening betting odds can be found here. I have frozen this area so that you will always have it in your line of sight as you traverse the sheet, making it easier to know what golfer you are looking at and some of the essential data needed.

 

Betting

When we move a few slots over to the right, you will come across a heading called "Betting."

There are a few things that I enjoy about this section from the mentality of a gambler. First off, it is interesting to see where the movement has occurred between Monday to Wednesday, and we highlight that with our drift percentage feature. A negative number will show red, indicating that a golfer has dropped in price, and a positive figure will show blue - highlighting there has been an increase in odds over the two days.

If you read my 'Vegas Report,' you will notice I talk a ton about the hold percentage from a casino. Outright wagers can be a tricky platform to maneuver around because casinos take something that can never exceed an outcome higher than 100% and amplify their edge with the percentage of money they decide to hold. Technically, this is no different than a book placing your typical 10-cent vig (-110) on both sides of a wager to create a long-term edge in their favor of 2.4%, but the more significant difference comes down to the amount of an advantage casinos decide to take upfront on an outright bet.

To break this down into terms that may be easier to understand, when a sporting contest starts, a potential outcome ranges between 0.01% and 99.9% to occur. As the game goes through its stages from beginning to end, we eventually get to the point where one team/player is your winner (100% win equity), and the other ends the competition as the loser (0% win equity). This is important to note because if casinos were posting "true" odds on a contest, all the players in the field would total 100% win equity after being priced out.

For obvious reasons, most notably because sportsbooks would never turn a profit if they treated the market in that sense, we see them shift the odds to create a betting board that is weighted in their favor. Now, the answer of value surrounding individual wagers and things of that nature will take things a step further, but the "total hold percentage" should emphasize to you that numerous players in the field are extremely overvalued in terms of their odds when you get boards outrageously priced over 100%. Our goal is to pinpoint where the incongruities are located and try to exploit an edge of our own on the golfers that might be underpriced.

The win equity region of my spreadsheet derives from what the casinos have listed for the week. An implied win equity of 7.14% means the casino has priced that specific golfer at 14/1 to win the contest - an easier to understand math equation would be a 20/1 player equaling a five percent implied win. I don't want to overstate the significance of the red-boxed hold percentage feature that shows 148.97% in the image because each betting board is different, and it is possible that a 110% hold can be awful, while a 148% hold can be brilliant for the bettor, but it should give us a general idea of how large of an edge we are going to need to overcome in a particular week. I have color-coded that feature to show blue when priced under 140, gray between 140.1 to 146.9 and red when valued higher than 147.

 

Summary Rankings

Welcome to the kitchen of this bad boy. Here you will have an opportunity to construct your very own recipe. Using last week's tournament as an example, there will be a handful of different ways to weight your data. 'Statistical Analysis' is something that you will have a chance to reconstruct later in the sheet to alter the rankings away from mine, Muirfield Village (or the course of that week) is your course history data and the next few sections will be your current form from different durations of time. This quadrant has a few things that I need to point out, and a few features that I like from a visual perspective.

You can remodel your weight percentage in any fashion you deem fit if you make a copy of your own, but the sheet works best when calculated to include a total of 100% weight under 'Overall Rank.' If you recall from 'Golfers Detail,' this where your 'Overall Rank' comes from. I've noticed I have my best results when I don't include more than 50% of my total onto course and current form, but it is completely up to you with how you would like to attack with your weighted totals.

One of my favorite features I have built into the sheet is how the cell box changes color under 'Overall Rank.' Anything that isn't weighted to 100% will turn red, and you will get your green light of sorts when you total 100%.

 

Model Differential

I love everything about this idea, and it is something I find myself using more than practically anything else when trying to find cheap value on DFS sites. What this tool does is compare your model to both DraftKings and the betting market.

Once you have constructed your weights on all sections and get your calculated overall rank, that number is compared to the ranking value of those two avenues. The disparity between your sheet and those sectors will be highlighted with a numerical value of difference.

For example, if Matthew NeSmith was the 86th highest priced betting option and 72nd ranked DraftKings player when it came to price, yet your model had him ranked 12th, it would be showing him to be 74 spots lower than expected for betting and 60 spots below your expected value for him on DraftKings. It was one of the core things that pushed me onto a min-priced Seamus Power at the Rocket Mortgage, Corey Conners at an astronomical 250/1 price tag at the Valero Texas Open and is a brilliant tool to locate underpriced options.

Miscellaneous Stats

Most of the categories in this area are self-explanatory. Betting position and DK position would be your numerical ranking in price for the player. Odds versus DK is your difference between those two. I use it as a tool to highlight potential value. Average DK points and ranking of those come next. Consecutive cuts would be your players who are the safest options to make a cut. Par or better streak is viewed by the number of rounds in a row a golfer has been greater than or equal to par, and the % of available purses won does give some indication for potential OAD selections.

 

Course History

If available, this section will always give you your course history over a span of five years. I go through and change all missed cuts to an 80 to lessen some of the short-term blow for any players that kamikazed a previous performance, and I do give every golfer that hasn't played at the venue a core average of 55. You will have the ability to change those numbers if you choose to when you make a copy, but I tend to find it to be the least interfering range.

 

Recent Results

Another pretty straightforward domain once you are aware that all missed cuts are turned into an 80th place finish. The last 10 weeks on the PGA Tour will be listed for your viewing pleasure, and the names of the events will make information easier to find. Your choice of either the last five or 10 weeks becomes weighable under the 'Summary Rankings,' but even if you only want to view this from a mentality of trying to find players in form, it is an excellent tool to use for that thought-process.

 

Statistical Data

The range of additional statistical information will vary from event-to-event, but five main analytical areas will always be in play: Strokes Gained, Scoring, Par Save, Driving and Iron Play. The nearly 25 stats that incorporate the weekly template will come back into use one last time at the end of this sheet in the form of a ranking, but here you can find how a player performs numerically in different categories.

 

Recent Differential Over Historical Data (Last 24 Rounds)

Everything is in the form of a plus-minus, but the key SG measures are compared to the long-term history to get a differential in recent performances over the last 24 rounds. The higher the number, the more a player is overperforming as of late, and we flip that for totals that run into the negatives. This tool is best used to find outliers.

 

Standings & Calculations

We have finally reached the end of the "Rankings' sheet. All of our previous statistical categories have been turned into rankable totals compared to the field, and the option to place weights on what you want to highlight into your research comes back into play.

As you can tell by the example above, the cell box in 'DW' will remain red if not equal to 100% with all your weights, and the statistical total that the golfers earn is where the ranking for 'Statistical Analysis' comes into play.

 

Conclusion

We touched on one of the eight sheets in-depth today, and as you can tell, there is a ton of information available. The individual round sheets will run in a similar fashion of having a 'Summary Rankings' tool to recalculate your in-tournament research, and the putting regression, scoring average and previous winners tools will always be updated for the following week's worksheet. Thank you for taking the time to read this article, and I truly hope you consider trying out this model that I am extremely proud to be sharing with RotoBaller.

More PGA Analysis and DFS Lineup Picks

POPULAR FANTASY TOOLS

Expert Advice
Articles & Tools
Import Your Leagues
Daily Stats & Leaders
All Pitcher Matchups
Compare Any Players
Compare Any Players
Rookies & Call-Ups
24x7 News and Alerts
RANKINGS
C
1B
2B
3B
SS
OF
SP
RP

RANKINGS

QB
RB
WR
TE
K
DEF

REAL-TIME FANTASY NEWS

Kyle Connor

Records an Assist in Season-Ending Defeat
Mark Scheifele

Nets Lone Jets Goal During Emotional Night
Tyler Seguin

Returns to Score Sheet with a Power-Play Assist
Miro Heiskanen

Picks Up an Assist in Saturday's Win
Thomas Harley

Records Two Points in Series-Clincher
Josh Morrissey

Sustains Knee Injury in Game 6 Loss
Jaylen Brown

May Need Surgery
Logan Gilbert

Completes Second Bullpen Session
Hunter Tyson

May Miss Another Game Sunday
Russell Westbrook

Listed as Probable for Sunday
Jamal Murray

Probable for Sunday's Game 7
Aaron Gordon

Officially Listed as Questionable for Game 7
Clayton Kershaw

Activated Ahead of Season Debut
Claude Giroux

Senators Interested in Keeping Claude Giroux
Jalen Chatfield

Expected to Play in Conference Finals Opener
Kyle Connor

Boasts Impressive Numbers In Elimination Games
Jake Oettinger

Looks To Extend Home Winning Streak Saturday
Connor Hellebuyck

Makes 13th Postseason Start Saturday
Mark Scheifele

Will Play on Saturday
Cole Ragans

Hits 15-Day Injured List
Seth Lugo

Placed on 15-Day Injured List
Jalen Royals

"Can Make An Impact Immediately"
Baltimore Orioles

Orioles Fire Brandon Hyde
Nico Hischier

Ruled Out for Rest of World Championships
Matthew Tkachuk

Sees Point Streak End Friday
Corbin Burnes

Strikes Out 10 in Six Shutout Innings
Matthew Knies

Questionable for Game 7
Joseph Woll

Quiets Panthers with 22-Save Shutout
Max Pacioretty

Nets Third Playoff Goal
Wilmer Flores

Collects Eight RBI in Three-Homer Game
Auston Matthews

Ends Goal Drought Friday
Josh Hart

Has A Triple-Double On Friday Night
Karl-Anthony Towns

Picks Up A Double-Double In Game 6
Jalen Brunson

Leads New York To A Win On Friday Night
Greg Joseph

49ers Sign Kicker Greg Joseph
John Jenkins

Ravens Agree to One-Year Deal With John Jenkins
Cole Ragans

Exits his Start on Friday With Groin Tightness
Pete Crow-Armstrong

Knocks in Six Runs
Miguel Vargas

Homers Twice in Loss
Byron Buxton

Clears Concussion Protocol, Considered Day-To-Day
Ezequiel Tovar

Activated and Starting on Friday
Xavier Edwards

Scratched With Back Tightness
Carlos Correa

Goes on Seven-Day Concussion Injured List
Aaron Nola

Goes on Injured List
Alex Ovechkin

Capitals Expect Alex Ovechkin to Return for 2025-26 Season
Mattias Ekholm

Expected to Miss Two More Games
Calvin Pickard

to Miss Start of Conference Finals
Brock Purdy

Signs Five-Year Extension
Aidan Hutchinson

Looks Good in Practice
Greg Zuerlein

Jets Release Greg Zuerlein
Chris Olave

Steelers Showing Interest in Chris Olave
Carlos Correa

Byron Buxton Both Out on Friday
Michael Morales

Set For His First UFC Main Event
Gilbert Burns

In Dire Need Of Victory
Precious Achiuwa

Uncertain For Game 6
Derek Carr

More to Derek Carr's Retirement Than his Injury?
Rodolfo Bellato

Set For UFC Vegas 106 Co-Main Event
Paul Craig

Returns To Light Heavyweight
Shedeur Sanders

Browns Say Shedeur Sanders is Willing to Put in the Work
Mairon Santos

Looks To Remain Undefeated In The UFC
Harold Fannin Jr.

Browns, Harold Fannin Jr. Agree to Terms on Four-Year Rookie Deal
Sodiq Yusuff

Set For Lightweight Bout
Nursulton Ruziboev

Looks To Win Back-To-Back Fights
Dustin Stoltzfus

An Underdog At UFC Vegas 106
Melquizael Costa

A Favorite At UFC Vegas 106
Julian Erosa

Set To Open Up UFC Vegas 106 Main Card
Keaontay Ingram

Chiefs Waive Keaontay Ingram
D.J. Humphries

No Deal Yet Between 49ers, D.J. Humphries
Cleveland Browns

Browns Maximizing Reps For Rookies
Cleveland Browns

Browns To Utilize Fullback Position In 2025
MLB

Former MLB Shortstop Rafael Furcal Arrested
Shohei Ohtani

Smashes Two Homers, Drives In Six
Hunter Brown

Dominates Rangers, Takes Tough Loss
Jacob deGrom

Quiets Astros In Masterful Start
Jaxson Dart

2025 Could Be A Redshirt Year For Jaxson Dart
Eric Johnson II

Claimed By Indianapolis
Donovan Jackson

Signs Rookie Contract
Brandon Lowe

Smacks Two Homers On Thursday
Jordan Addison

Jury Trial Set For June In Connection To Jordan Addison's 2024 DUI Citation
Las Vegas Raiders

Raiders Hiring Brandon Hunt As Vice President Of Player Personnel
Patrick Murtagh

Let Go By Jaguars
Christian Barmore

 Expected To Play In Week 1 After Dealing With Blood Clots
Josh Hart

Leads Knicks In Scoring Wednesday Night
Derrick White

Erupts For 34 Points As Celtics Stay Alive
Luke Kornet

Big For Boston In Game 5
Jaylen Brown

Records Double-Double In Crucial Win
Anthony Edwards

Posts Double-Double In Series-Clinching Win
Julius Randle

Scores Game-High 29 Points In Series-Clincher
Brian Harman

Not A Great Option For PGA Championship
Nikola Vučević

Nikola Vucevic May Be Involved In Trade Talks Again This Offseason
Jared McCain

Moving In The Right Direction
Cameron Smith

May Not Be Worth The Risk At Quail Hollow
Joaquin Niemann

A Strong Play At Quail Hollow
Stephen Curry

Cleared For Light On-Court Work
Sam Hauser

Returns To Action Wednesday
PGA

Sungjae Im Could Be Someone To Watch At Quail Hollow
Max Homa

Still Not Trustworthy Ahead Of PGA Championship
Jason Day

Looking To Continue Success At Quail Hollow
Sam Burns

A Shaky Play At Quail Hollow
Daniel Berger

Looking To Capture First Major At Quail Hollow
Jordan Spieth

Looks To Complete Career Grand Slam At Quail Hollow
Rory McIlroy

All Eyes Are On Rory McIlroy At Quail Hollow
Jon Rahm

Fits Quail Hollow Well On Paper
Keegan Bradley

A Reliable Option At Quail Hollow
Will Zalatoris

Enters PGA Championship With Major Concerns
Justin Thomas

Peaking At The Right Time For PGA Championship
Akshay Bhatia

Not Quite The Same Since Players Championship
Donovan Mitchell

Scores Game-High 35 Points In Tuesday's Loss
Harris English

Playing Well Heading Into PGA Championship
Collin Morikawa

A Solid Contender At PGA Championship
Tyrese Haliburton

Returns To Form In Closeout Game
Gary Woodland

Not Expecting Much At PGA Championship
Si Woo Kim

A High-Risk, High-Reward Option At PGA Championship
Tom Hoge

A Risky Play At Quail Hollow
PGA

Tyrell Hatton A Volatile Pick At PGA Championship
Jack Della Maddalena

Becomes The New UFC Welterweight Champion
Belal Muhammad

Outclassed At UFC 315
Manon Fiorot

Drops Decision At UFC 315
Valentina Shevchenko

Defends Title
José Aldo

Jose Aldo Retires After UFC 315 Loss
Aiemann Zahabi

Extends His Win Streak
Alexa Grasso

Loses Back-To-Back Fights
Alexa Grasso

Natalia Silva Outclasses Alexa Grasso
Kyle Prepolec

Submitted In His UFC Return
MMA

Benoit Saint-Denis Gets Back In The Win Column
Ryan Blaney

Holds Strong For A Top-Five Finish At Kansas
William Byron

Struggles At Kansas With An Underwhelming Finish
Chase Briscoe

Scores A New Career-Best Cup Finish At Kansas
Denny Hamlin

Mechanical Issues Ruin Denny Hamlin's Promising Kansas Performance
Alex Bowman

Puts Together A Strong Top-Five Finish At Kansas
Ryan Preece

Earns His First Career Top-10 Finish At Kansas