scorecard
  1. Home
  2. sports
  3. Use our Excel spreadsheet to bet on the Kentucky Derby

Use our Excel spreadsheet to bet on the Kentucky Derby

Jim Edwards   

Use our Excel spreadsheet to bet on the Kentucky Derby
Sports3 min read

The 141st Kentucky Derby will be run on May 2, 2015. Currently, American Pharoah is the favorite at 5-2.

The fun of the derby is that it brings out all the rank amateur bettors in the nation. I have a friend who places her bets at the last minute, after she's seen which horses have pooped before getting into the gate, for instance. Another acquaintance never bets on gray horses. "Gray don't pay!" is her motto.

This is no way to bet on horses.

I, however, have a horse-betting system that takes the guesswork out of it. Or at least, adds to the fun for those of who can't be bothered to read The Daily Racing Form.

The caveat here is that I know nothing about horses. But I do know that horse racing is really boring unless you have money riding on it. So I decided to approach the Kentucky Derby as if it were a probability problem that could be solved with Excel.

Here's how it works.

There are 20 horses in the running Saturday. So at the outset, you have a 1 in 20 chance of picking the winner.

Those are NOT good odds.

Some horses have better chances than others at winning - some might not like longer races, for instance - and the odds adjust on each horse as more bettors place their bets.

But the bottom line is that the derby is a crowded race, random things happen, and in theory any horse can win.

So a sensible investor approaching the derby as if it were a portfolio with different risk levels in it might want to ask, how many horses can I bet on and still come out ahead if any one horse wins? Put another way, can I spread my bets among as many horses as possible and still come out ahead?

The good thing about the derby is that there are a lot of horses running at very long odds. The formulas in my spreadsheet ask, for a $10 bet on each horse, how many horses can I bet on and still be able to win more than the total amount of money I've wagered?

This year, you can bet on 11 of the 20 horses at the current odds, and if any of them win you'll come out ahead. That reduces your overall odds to something slightly akin to a 50/50 coin flip. Much better than 20-1.

Of course, your portfolio will contain NONE of the favorites. In other words, you're betting on all the horses the other bettors think will most likely lose. But you're covering as much of the field as possible. Remember, you only need ONE horse to come in good and Business Insider just paid your mint julep bill for the weekend!

The horses you must bet on are these: Ocho Ocho Ocho, Tencendur, Danzig Moon, El Kabeir, Bolo, Itsaknockout, Keen Ice, War Story, Mr. Z, Far Right, and Frammento:

kentucky derby spreadsheet

Jim Edwards/BI

A $10 bet on each one to win will cost you $110. If any of them come first you will win at least $300 and as much as $500. (I've built-in a margin to give the betting a purpose - there's no fun in betting $100 to win $110, for instance.)

The other disclosure here is that I've used the current odds as of 4 p.m. eastern time on the day before the race. Odds change up to post time, so this is for fun only.

Personally, I use the spreadsheet as an advisor, not a decider. Remember the Edwards Quant Fallacy: There's a difference between good data and applying judgment to good data. So consider picking only three or four horses, some at good odds and some at long odds. That limits your losses but makes your gains interesting. The worst thing that can happen is that you'll add some genuine excitement to a race that is, otherwise, two minutes of chaos.

NOW WATCH: Here's what Rio looks like 500 days before the 2016 Olympics

READ MORE ARTICLES ON


Advertisement

Advertisement