March Madness Forum

View the Forum Registry


0 Subject: Contest Scoring Simulator

Posted by: Guru
- [330592710] Fri, Mar 24, 16:33

I wish I'd have done this a couple weeks ago. It would have been a VERY helpful tool in making contest selections. Unfortunately, I didn't think of it until a few days ago.

I built a contest scoring simulator. You can fill out a bracket, simply picking the winners in each game. Then, the simulator figures out the contest scores for each team, and sorts them from best to worst.

I've done some limited testing, and it seems to work. It does reproduce the actual results to date if you plug in the results of the first 52 games. Let me know if you encounter any anomalous results.

Oh well, it will be available in advance of next year's contest. I figured I'd better do it now before I forget.

Pretty cool, huh?
1Sludge
      ID: 59228918
      Fri, Mar 24, 19:35
Guru, I wrote a program to simulate the tournament itself. I.e., based on some kind of rating system (I used Massey's computer ratings, but any could be used, really), you simulate the tournament play and pick the winners and losers randomly. Based on that, you compute what each team/basket scores. Simulate 1 million tournaments, and you can estimate the average score of each team/basket.

Using these averages, what I did was look at billions of combinations of teams and baskets and tried to find those combinations which gave high (or low - for my tanker team) scores.

Basically, I ran out of time (and wife's patience), and had to go with what I had. The above procedure would find a nearly optimal combination under the assumption that your units are independent. Since there were seed and conference baskets, the units are not independent. I.e., it's not a good idea to short the #1 seed and then long all 4 #1 seeds individually. The procedure never gave me anything that absurd, but it did give some results with some overlapping. I wish I would have had more time to modify the procedure to account for/minimize this overlapping.

Of course, I kept this under wraps. :) But now that the tourney is nearly done, it can be shared now. Anyone familiar with C?
2Sludge
      ID: 59228918
      Fri, Mar 24, 19:57
NOTE: "Avg Winnings" is the average winnings if you long the team and DOES NOT include the cost of each team.
 
Team Avg Winnings Seed Conference
Arizona 1.35034700 1 Pac 10
Jackson St 1.04788800 16 XXX
Wisconsin 9.87828600 8 Big 10
Fresno St 8.10879500 9 XXX
Texas 13.60867400 5 Big 12
Indiana St 7.45080200 12 XXX
LSU 10.26491900 4 SEC
SE MO St 5.00708700 13 XXX
Purdue 10.47174700 6 Big 10
Dayton 8.83834500 11 Atlantic 10
Oklahoma 10.85045200 3 Big 12
Winthrop 2.38424000 14 XXX
Louisville 3.63130900 7 C-USA
Gonzaga 13.82235700 10 XXX
St. Johns 1.85234900 2 Big East
Northern Arizona 5.26483000 15 XXX
Michigan St. 7.90018600 1 Big 10
Valpo 1.92227200 16 XXX
Utah 3.02731600 8 XXX
St. Louis 8.30895400 9 C-USA
Kentucky 10.71518300 5 SEC
St. Bonaventure 9.06632300 12 Atlantic 10
Syracuse 10.23273300 4 Big East
Samford 2.33505400 13 XXX
UCLA 3.55030300 6 Pac 10
Ball State 11.62756000 11 XXX
Maryland 7.11379000 3 ACC
Iona 4.14902400 14 XXX
Auburn 5.95759300 7 SEC
Creighton 8.51017400 10 XXX
Iowa St 11.41171700 2 Big 12
Central Conn St 3.55127900 15 XXX
Duke 10.30261200 1 ACC
Lamar 0.77964800 16 XXX
Kansas 8.18128800 8 Big 12
DePaul 7.11920100 9 C-USA
Florida 8.29886800 5 SEC
Butler 8.42976700 12 XXX
Illinois 4.06139000 4 Big 10
Pennsylvania 6.88940600 13 XXX
Indiana 9.70765900 6 Big 10
Pepperdine 8.41095700 11 XXX
Oklahoma St 1.66077400 3 Big 12
Hofstra 7.73293500 14 XXX
Oregon 7.92326400 7 Pac 10
Seton Hall 7.52373400 10 Big East
Temple 10.40430200 2 Atlantic 10
Lafayette 3.59872600 15 XXX
Stanford 9.41355500 1 Pac 10
SC State 1.14745600 16 XXX
UNC 4.82083300 8 ACC
Missouri 7.10568900 9 Big 12
UConn 6.42524700 5 Big East
Utah St 11.29511500 12 XXX
Tennessee 4.02569800 4 SEC
LA-Lafayette 6.27549200 13 XXX
Miami-FL 2.76951200 6 Big East
Arkansas 8.53141900 11 SEC
Ohio St 10.41771000 3 Big 10
Appalachian St 4.24529000 14 XXX
Tulsa 14.68261400 7 XXX
UNLV 6.93733600 10 XXX
Cincinnati 8.69285200 2 C-USA
UNC-Wilmington 2.80064300 15 XXX
3Guru
      ID: 330592710
      Fri, Mar 24, 21:11
I also built a monte carlo tournament simulator. I used it extensively last year (in advance of the tourney) as a means to test out alternative scoring formats, and as a guide for pricing. Mine was just a simple Excel macro.

One key assumption is assigning winning probabilities to the games. I used different assumptions - historical seed-based probabilities (smoothed), RPI and/or Sagarin ratings-based, and I even tried some dynamic assumptions where I changed a team's rating as it progressed through the tourney. (If a #10 seed wins in round 1, it probably is stronger than a normal #10 seed; if it wins again, it is probably even stronger; etc.)

This year, I didn't even bother to dust off that model. I just priced by gut feel. For this type of contest, as long as the prices are reasonable, they tend not to determine the final standings. To win, you need to pick the correct teams, almost regardless of price.

March Madness Forum

View the Forum Registry




Post a reply to this message: (But first, how about checking out this sponsor?)

Name:
Email:
Message:


Viewing statistics for this thread
Period# Views# Users
Last hour11
Last 24 hours11
Last 7 days11
Last 30 days33
Since Mar 1, 2007750418