Go Back   Sports Handicapping Forum > Welcome Forums > Main Street > Capping

Capping All handicapping, betting systems, spreadsheets, mathematics & quantitative technicapping.

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-15-2010, 11:22 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
Base/Win/Risk Simulator

I created a simulator to compare the variance in betting with base units, risk and win. Excel constrains the number of possible data points on a graph to a set maximum (255), so to get around that i have two loops, one nested inside another.

On the sheet you will see two input boxes for number of iterations, the top one is how many points in the simulation you want to graph (n,0<=255). Or namely, how many subiterations you want to run. The other box indicates the number of games simulated for each main iteration (i,0<=infinity).

Descriptive statistics are under the graph

It might give you a warning box the first time you run the sim, just click OK. After that you shouldn't see it again.
Attached Files
File Type: xlsm BWR_Simulator.xlsm (35.4 KB, 19 views)
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
Rewards Awarded to uva3021 for this Post
Date User Comment Amount
01-15-2011 Dr. Jack you sent 250 for contest instead of 225 225
  #2  
Old 12-17-2010, 02:24 PM
The G.O.A.T
 
Join Date: Jan 2006
Location: Stowww
Posts: 22,031
Rewards: 1,646
You have potential uva. Just need a little guidance is all.
__________________
2005-present ATS
NFL - 158 - 121 - 15 - 57%
CFB - 259 - 161 - 11 - 62%
CBB - 354 - 189 - 20 - 65%

12/20/2010
ML's > -150 - 3-0


GOY's 13-1

-Go with your gut, not the chatter
Reply With Quote
  #3  
Old 12-17-2010, 03:28 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
lol says the guy who borrows money from wci

i've been playing with house money for a good 3 years guy
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
  #4  
Old 12-17-2010, 03:49 PM
The G.O.A.T
 
Join Date: Jan 2006
Location: Stowww
Posts: 22,031
Rewards: 1,646
Borrowed money from wci ? haha let me guess I stiffed him too ? :eyesr


I was being sincere uva, you got potential just need a little help putting things together. Don't get grumpy. I am being nice <tup>
__________________
2005-present ATS
NFL - 158 - 121 - 15 - 57%
CFB - 259 - 161 - 11 - 62%
CBB - 354 - 189 - 20 - 65%

12/20/2010
ML's > -150 - 3-0


GOY's 13-1

-Go with your gut, not the chatter
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 04:26 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.