Football games

# Analysis Of The Results Of SPORTS.XLS, The Sports Betting Spreadsheet

### Written by Ion Saliu on September 5, 2003 (3 WE) — and later.

The success (correctness) rate of SPORTS.XLS, the Excel spreadsheet for sports betting, is around 2 out of 3. Actually, it is higher at picking straight winners or pick 'em. It can still hit at least 60% when applied to point spread betting, as in the American football.
A 60% success rate translates equivalently that a player can pick one game at a time and be successful in 60% of the cases.
If picking 2 games, the probability goes down to: .6 x .6 = .36 or 36%.
Picking three games: .6 ^ 3 = 21.6%. A 5-team parlay can expect a success rate of .6 ^ 5 = 7.7%.
The most favorable case is for straight-up betting: one game only. The house advantage (edge) is also the most favorable: 10%. That is, a 1-unit bet returns a .9-unit payout.
A five-team parlay offers, at best, a 25% house advantage.

If betting straight-up 10 times (or weeks, as in NFL), the player should expect 6 wins and 4 losses. The four losses result in –4 units. The 6 wins amount to +(6 x .9) = +5.4 units. The net win is 1.4 units. If betting \$100 at a time, the net profit should be \$140 over a period of 10 weeks.

A probability of over 50% yields also longer winning streaks and shorter losing streaks. The mathematical player can draw a big advantage from that probability feature. The non-mathematical bettor should keep in mind that an over-50% probability tends to repeat in the very next trial; a bet increase is favorable. Conversely, a 60% probability event will not lose very often more than three consecutive trials; again, a bet increase after three consecutive losses is good money management.

The SPORTS.XLS spreadsheet can be further fine-tuned to cover more variables. For example: inter-division results; inter-conference results; keep track of losses against the point spread, etc.

Here is a very interesting aspect: Repeat-winning teams from previous weeks. I have a 244-week result file in NFL (National Football League, USA). The results are against the point spread (ATS). The last result is week 5, the 2008 NFL season.

Given my previous type of software, I recorded 15 results in every NFL week. If the week has only 14 games (due to bye-week scheduling), I write 'open' at the end of the result line. If there are 16 games in the week, I discard the result of the Monday Night Football game.

The software counts how many teams from one week were also winners in: 'one week back', 'two weeks back', and 'three weeks back'. The results are very similar, as far as the average number of repeat-winners is concerned. I analyzed 20 weeks, 100 weeks, and 244 weeks. Here are the averages:

1-. Repeat-winning NFL teams from one week back:
Average number of repeats: 6.36.

2-. Repeat-winning NFL teams from two weeks back:
Average number of repeats: 6.45.

3-. Repeat-winning NFL teams from three weeks back:
Average number of repeats: 6.48.

Usually, there are fewer winning teams in the first week of the season in rapport to the last week of the previous season. Things change from one season to the next! Betting against the winning NFL teams in the previous week(s) offers a positive balance.

How about random play, like the quick-picks in lottery? It could help the biased player. Many bettors have a bias towards favorite teams. Reality is that only a tiny minority of teams are dominant. Therefore, most biased players are losers. They would be better off choosing the winners randomly. I offer free software to pick sports results in a random manner, like the lottery. This page lists the most important free programs that generate random sports picks—as numbers and also team names.

A program I wrote in August 2003 has become a big success: PermuteCombine.EXE. The freeware generates permutations, arrangements (some say permutations of N, M; like exactas and trifectas at horse racing), combinations (like in lotto), exponents (like in the pick-3 lottery and soccer pools 1,x,2). The program generates numbers OR words (such as sports teams names). There is a sample text file—TEAMS.NFL—with all 32 NFL teams.
The option applicable to the American football is 'Arrangements; Words; Random'.
The option applicable to soccer pools (1,x,2) is 'Exponents; Words; Random' (use the sample file 1X2.TXT).
It's best to run a random option several times in a row. Common sense tells you that hitting in a first try is a very rare event in gambling. The program is presented on this page: Calculate, generate exponents, permutations (factorial), combinations for any numbers and words.

• SPORTS.XLS - an Excel 95 spreadsheet. This is a template to use with the sports betting system presented on the message board: Sports Prognosticating or Betting - Best System.
• BellCurveGenerator.exe generates combinations within the bell (Gauss) curve, around the probability (FFG) median. The Fundamental Formula of Gambling calculates the median automatically. The application handles just about any game: pick-3, pick-4, lotto-5, lotto-6, lotto-7, PowerBall-6, PowerBall-7, horse racing, roulette and sports betting (including the famous European soccer pools and American sports teams).
It is not a simple observation or following the guts: It is a formula, therefore a law. The results tend to cluster in the FFG median area, with no exception. I have analyzed extensively 5-team parlays in the NFL. The games have been randomly selected. The results come predominantly from the FFG median area. I am yet to see results such as combination #1, or combination #2, or #31, or #32! Roulette is different because the numbers are not laid out sequentially. A special conversion is necessary!
• PermuteCombine.EXE: generate random or sequential sets (combinations) of team names and soccer pools 1x2. No other program in the world can do what PermuteCombine.EXE does!
• BETUS32.EXE is an intelligent random combination generator for sports betting, the American way. The player selects a number of games to bet on. The player bets on either the favorite team to win by more than the point spread, or the underdog to lose by less than the point spread.
• AMBET.EXE is much like BETUS32.EXE—but with a twist! You can add W or L at the end of a team name. Add W if the team was a winner in the previous game (week). Add L if the team lost the last game (week). For example:
COLTS-L, CHIEFS-L
BRONCOS-L, PATRIOTS-W

These are the main pages dealing with winning sports betting systems, strategies and software.

The excitement is higher when it's hard to predict the results. The NFL 2002 season offered great excitement. Valid for college football, too. There are no favorites! Or, every team has a good shot at winning any game, against anybody! Looks like the stats play a minor role. That's not exactly true! The results still follow the stats, within statistical limits, of course. What the fans and especially the bettors see is the discrepancy between the betting lines and the actual results. The betting lines try hard to ignore the randomness.
I use in-house sports betting software. It is founded on the same principles as LotWon. Therefore, randomness plays a very important rule in generating combinations. The programs are applicable to parlays. The 5-team parlay software is clearly more successful than the statistical spreadsheet! The programs eliminate certain patterns from previous results and generate lottery-like combinations. The numbers are replaced with team names. The hit rate is better than 2 out of 3 weeks. I haven't encountered two or more consecutive losses. The playing field amounts from 6 to 16 parlays per week. The payout can be as high as 24 to 1 (25% house edge or vigourish). Thus, the worst winning case comes to +8.
Here are some useful sports links. They offer schedules, betting lines, odds, results, and useful information.