|
#1
|
|||
|
|||
Random result grapher spreadsheet
I made this little spreadsheet to draw random results graphs based on finishing distribution. Perhaps it could be useful to help demonstrate variance to someone in a more visual manner than the ROI Simulator and a less soul crushing one than experience.
The results seem pretty much just like searching for winning players on sharkscope, but it's perhaps reassuring to see what swings can happen with no "tilt" or change in the players skill whatsoever. I don't have anywhere to upload it hopefully this is ok. http://www.megaupload.com/?d=6VVWLJ1Q |
#2
|
|||
|
|||
Re: Random result grapher spreadsheet
this is pretty cool. where is the calculate now button tho? i cant find it
|
#3
|
|||
|
|||
Re: Random result grapher spreadsheet
nevermind, thought u actually added a "button" on the sheet.
for anyone else: tools|options|calculations thanks again, this is very cool |
#4
|
|||
|
|||
Re: Random result grapher spreadsheet
F9
|
#5
|
|||
|
|||
Re: Random result grapher spreadsheet
This is fantastic, for real.
Thank you. |
#6
|
|||
|
|||
Re: Random result grapher spreadsheet
this is awesome, ty
|
#7
|
|||
|
|||
Re: Random result grapher spreadsheet
I expanded this excelsheet with a simulating part (assuming it was open source [img]/images/graemlins/smile.gif[/img] ). It simulates a predefined number of profit graphs based on the input given. The best and worst profit graph are shown in a graph.
For example, my 22+2 results(200 simulations, ROI 8%): Download links: Excel 97/2003 Excel 2007 These sheets contain VB code so you might need to enable macros. I deleted the initial graph because otherwise for each simulation the graph is updated which takes a lot of time. It's still kind of slow so I wouldn't recommend to enter a large amount of simulations (200 simulations takes about a minute on my dual core). The sheet may be expanded by showing for example largest downswing, upswing, break even strike etc. in the graph, but i guess this is rather difficult to implement. However, I'll try if there is enough interest. |
#8
|
|||
|
|||
Re: Random result grapher spreadsheet
there is interest. very cool what you did so far.
|
#9
|
|||
|
|||
Re: Random result grapher spreadsheet
Im interested in that aswell [img]/images/graemlins/smile.gif[/img]
|
#10
|
|||
|
|||
Re: Random result grapher spreadsheet
Please don't let Guthrie get a hold of this spreadsheet.
|
|
|