SportsBet Tracker Excel Sheet Demo

SportsBetTracker · Jan 28, 2010

A few years ago, I designed a bet tracking excel sheet to follow up on the Daily Free Picks of several touts that offered them. I designed it to create the bet amounts automatically, depending on the initial bankroll amount.

If you only make one bet at a time, this sheet would work great. However, most people I know make more than one bet at a time, or make parlay bets, which this sheet cannot do. So I'm releasing this excel sheet as a DEMONSTRATION ONLY project.

In addition, one can NOT make a hard bet amounts. This sheet was designed with a systematic, rigid betting approach in mind that discounted fluctuations in the betting pattern. I've always maintained that in a 6 year period, if you make one bet a day on a daily basis and won at a 56% aggregate clip with less than 1.2% actual deviation (using established touts), then you can turn $1,000 into a million dollars. I had originally wanted to create something that would essentially automate the hard part: maintaining bet discipline.

For the purposes of the demo, though, I did add a "Unit bet" component. But I've abandoned further development on the Excel sheet. I've actually transferred the logic to a relational database environment, where I can actually create multiple bets, parlays, and cut and paste popular bet card formats to automatically enter data without typing. If you have seen WagerStation, think of something about 5 times more powerful as it can maintain separate bankrolls, touts, venues, even bookmaking operations. I'm actually working on a subscription model that will be fully web-based.

The file is located here: Sports Bet Tracker DEMO :modemman:

There is a read me file as well. If you would be interested in partnering with me in various aspects of marketing or developing this project for the web with me, go ahead and private message me or send an email to me at the one provided in the ReadMe file on the download.

AGAIN: This file is for demonstration purposes only, and won't help you much unless you only make one bet at a time. But it will show you how to discipline your betting habits over time.

SportsBetTracker · Feb 1, 2010

6-Year Bet Simulator Excel Sheet Released

The first sheet I showed you in this thread is the last excel sheet I created that shows a progression of bets according to a bankroll before I migrated everything to a relational database environment (Access, then SQL). Although it was descriptive enough for most people to understand, one must realize that the events must take place over a period of time, and frankly, most people new to sports betting cannot comprehend the actual winnings they can acquire if they are consistent in their methodology.

To that end, I've modified and released this sheet that actually predates the first sheet. This is a simulator that is used to show you the effects of betting once a day for 6 years, based on a consistent realistic winning percentage, and setting betting juice amounts.

Essentially, once you set the default settings, you can instantly calculate what you would win in six years. You can scroll down the excel sheet and look at the bet amounts for any day you wish, and review the yearly summary amounts at the top of the sheet.

I set the defaults to show a 56% winning percentage, which is what the best handicappers can usually achieve with a modicum of consistency, as well as a 3%, or 3-unit bet amount, along with a bookmaker percentage ("Juice" or vigorish) amount set at .9091, or -110. You can be amazed at what you can win if you are disciplined.

Read the ReadMe.txt file for specific explanations.

You can download the bet simulator HERE.:modemman:

IMPORTANT: It is an excel file with macros, so you must set your Security Level to "Low" on your excel sheet before it will work.

SportsBetTracker · Feb 7, 2010

Chase Sheet now Ready...Check it Out!

I note that a lot of sports bettors use modified Martingale systems, in which bettors make substantially higher bets after bet losses. While I don't endorse this strategy myself (mainly because of lack of personal handicapping knowledge), I have created an automated Microsoft Excel Sheet to create your betting chases, with up to 8 legs, and the ability to set up any unit configuration per leg.

As per normal chase operations, once a profit is made for a particular chase, that chase is considered "won" and a new chase is started.

The default amounts I have set are the same as those that Ace-Ace is using in his "Bet the Bankroll" thread he's done successfully for his "Win Money$$$ Or Lose The Bankroll Thread". Note that if a -110 line is used, using a Leg sequence progression of 10, 21, 43, 90, 189, 397, and 834 units will produce an overall Chase profit if any leg is won.

But you can set up any sequence of more than one bet, up to a total of 8 legs. It will calculate from an initial bankroll. I have also included instructions for importing sequences into the sheet, although those must be followed extremely closely, otherwise the sheet is compromised. In addition, the sheets are considered development sheets, and are not by any means polished. But they do give you an idea of how the betting regimen is done.

Good luck!