Spreadsheet: 117176d1312484852-how-do-i-run-a-monte-carlo-on-stock-probabilities-txn-simulation
Sheet: Sheet1

Month | Starting Price | [NAME] | % Change | Closing Price |  | Trial Number | Year End Price | % Yearly Gain
1 | 32.01
2 |  |  |  |  |  | 1 |  | 258.9951073804082
3 |  |  |  |  |  | 2 | 22.11581122662503 | -30.90968064159629
4 |  |  |  |  |  | 3 | 27.99458060600217 | -12.54426552326718
5 |  |  |  |  |  | 4 | 30.0292230201967 | -6.187994313662289
6 |  |  |  |  |  | 5 | 56.93773950438645 | 77.87485006056373
7 |  |  |  |  |  | 6 | 23.1678966380034 | -27.62294083722774
8 |  |  |  |  |  | 7 | 37.88371833217224 | 18.3496355269361
9 |  |  |  |  |  | 8 | 34.95207256675999 | 9.191104550952796
10 |  |  |  |  |  | 9 | 33.00280643022371 | 3.101550859805402
11 |  |  |  |  |  | 10 | 11.42302810267589 | -64.31418899507688
12 |  |  |  |  |  | 11 | 40.80396581077619 | 27.47255798430551
 |  |  |  |  |  | 12 | 34.81899502282158 | 8.775367144084925
 |  |  |  |  |  | 13 | 73.84067831874141 | 130.6800322359932
 | % Chance for Positive Return |  |  |  |  | 14 | 24.21780336515312 | -24.34300729411708
 | % Chance for > 20% Return |  |  |  |  | 15 | 28.54880622653883 | -10.8128515259643
 |  |  |  |  |  | 16 | 28.08926325706873 | -12.24847467332479
 |  |  |  |  |  | 17 | 13.13882530363504 | -58.95399780182741
 |  |  |  |  |  | 18 | 31.68295131585876 | -1.021707854236935
 |  |  |  |  |  | 19 | 53.05438466597945 | 65.74315734451562
 |  |  |  |  |  | 20 | 38.33534483425088 | 19.7605274422083
 |  |  |  |  |  | 21 | 21.21761914729788 | -33.71565402281199
 |  |  |  |  |  | 22 | 21.22553424990361 | -33.69092705434672
 |  |  |  |  |  | 23 | 52.13617765330047 | 62.87465683630264
 |  |  |  |  |  | 24 | 33.73350770890605 | 5.384279003142919
 |  |  |  |  |  | 25 | 47.43230353902524 | 48.17964242119726
 |  |  |  |  |  | 26 | 18.18617828857549 | -43.18594723968918
 |  |  |  |  |  | 27 | 37.09919878003667 | 15.89877781954598
 |  |  |  |  |  | 28 | 44.02151114626345 | 37.52424600519667
 |  |  |  |  |  | 29 | 24.97387883215722 | -21.98100958401367
 |  |  |  |  |  | 30 | 48.75272521068263 | 52.30467107367271
 |  |  |  |  |  | 31 | 37.85206843918714 | 18.25076050980051
 |  |  |  |  |  | 32 | 21.64954221886394 | -32.36631609227135
 |  |  |  |  |  | 33 | 29.49609207803901 | -7.853508034867184
 |  |  |  |  |  | 34 | 31.02660138964699 | -3.072160607163418
 |  |  |  |  |  | 35 | 23.74817019057749 | -25.81015248179477
 |  |  |  |  |  | 36 | 26.72653127773832 | -16.50568173152664
 |  |  |  |  |  | 37 | 33.26591664090705 | 3.92351340489551
 |  |  |  |  |  | 38 | 46.50897444682546 | 45.29514041494988
 |  |  |  |  |  | 39 | 47.539182946216 | 48.51353622685412
 |  |  |  |  |  | 40 | 44.80413218615122 | 39.96917271524906
 |  |  |  |  |  | 41 | 36.61424038296042 | 14.38375627291603
 |  |  |  |  |  | 42 | 47.42718415741826 | 48.16364935150973
 |  |  |  |  |  | 43 | 34.31076863296743 | 7.187655835574611
 |  |  |  |  |  | 44 | 34.39100379440868 | 7.438312384906856
 |  |  |  |  |  | 45 | 22.13615978141109 | -30.84611127331742
 |  |  |  |  |  | 46 | 11.88254645282555 | -62.87864275905795
 |  |  |  |  |  | 47 | 10.93125783019108 | -65.8504910022147
 |  |  |  |  |  | 48 | 27.96131991999318 | -12.6481726960538
 |  |  |  |  |  | 49 | 14.32116766220739 | -55.26033220178883
 |  |  |  |  |  | 50 | 73.44369370206968 | 129.4398428680715
 |  |  |  |  |  | 51 | 35.06950575097132 | 9.557968606595809
 |  |  |  |  |  | 52 | 22.43600317280429 | -29.90939339954922
 |  |  |  |  |  | 53 | 31.41671006920503 | -1.853451830037374
 |  |  |  |  |  | 54 | 24.92523531377375 | -22.1329730903663
 |  |  |  |  |  | 55 | 54.24651907759324 | 69.46741355074428
 |  |  |  |  |  | 56 | 47.92510528453006 | 49.71916677453941
 |  |  |  |  |  | 57 | 60.25682718138813 | 88.24375876722317
 |  |  |  |  |  | 58 | 22.89494124787926 | -28.47565995664086
 |  |  |  |  |  | 59 | 35.09727039218058 | 9.644706004937765
 |  |  |  |  |  | 60 | 40.24880556628186 | 25.73822419956845
 |  |  |  |  |  | 61 | 29.60390446087319 | -7.516699591149046
 |  |  |  |  |  | 62 | 23.77887588438043 | -25.714227165322
 |  |  |  |  |  | 63 | 30.75307417029864 | -3.926666134649669
 |  |  |  |  |  | 64 | 24.92568589565596 | -22.13156546186829
 |  |  |  |  |  | 65 | 44.79147158379699 | 39.92962069289907
 |  |  |  |  |  | 66 | 10.87659809770861 | -66.02124930425302
 |  |  |  |  |  | 67 | 51.40014486056044 | 60.57527291646498
 |  |  |  |  |  | 68 | 11.20538343732421 | -64.99411609708149
 |  |  |  |  |  | 69 | 26.82468732100641 | -16.19903992187937
 |  |  |  |  |  | 70 | 32.73159317755768 | 2.254274219174278
 |  |  |  |  |  | 71 | 24.4432358752195 | -23.6387507803202
 |  |  |  |  |  | 72 | 37.43402351684554 | 16.94477824694014
 |  |  |  |  |  | 73 | 17.18982914860418 | -46.29856560885917
 |  |  |  |  |  | 74 | 20.45354478650827 | -36.1026404670157
 |  |  |  |  |  | 75 | 57.68240597727927 | 80.20120580218456
 |  |  |  |  |  | 76 | 20.88965453543745 | -34.74022325699016
 |  |  |  |  |  | 77 | 23.50295474569658 | -26.57621135365016
 |  |  |  |  |  | 78 | 31.00807468492319 | -3.130038472592349
 |  |  |  |  |  | 79 | 35.35278964773543 | 10.44295422597762
 |  |  |  |  |  | 80 | 30.90996090079211 | -3.436548263692254
 |  |  |  |  |  | 81 | 42.69873440696337 | 33.39186006549009
 |  |  |  |  |  | 82 | 52.72929327343375 | 64.72756411569434
 |  |  |  |  |  | 83 | 49.11408766054335 | 53.43357594671465
 |  |  |  |  |  | 84 | 13.83627594576197 | -56.77514543654492
 |  |  |  |  |  | 85 | 28.33966329231378 | -11.46621901807628
 |  |  |  |  |  | 86 | 56.47704847713396 | 76.43564035343319
 |  |  |  |  |  | 87 | 53.56407969284553 | 67.33545670992045
 |  |  |  |  |  | 88 | 14.24900748413869 | -55.4857623113443
 |  |  |  |  |  | 89 | 24.87377431666521 | -22.29373846715023
 |  |  |  |  |  | 90 | 48.66139467837964 | 52.01935232233566
 |  |  |  |  |  | 91 | 62.82854654941803 | 96.27787113220253
 |  |  |  |  |  | 92 | 36.55670898160822 | 14.20402680914783
 |  |  |  |  |  | 93 | 36.05434883273602 | 12.63464177674483
 |  |  |  |  |  | 94 | 20.6377295566795 | -35.52724287197908
 |  |  |  |  |  | 95 | 58.54298597249453 | 82.8896781396268
 |  |  |  |  |  | 96 | 26.05276568055954 | -18.61054145404705
 |  |  |  |  |  | 97 | 13.57881618292381 | -57.57945584841047
 |  |  |  |  |  | 98 | 31.66892050497582 | -1.065540440562883
 |  |  |  |  |  | 99 | 35.01062858700455 | 9.374034948467818
 |  |  |  |  |  | 100 | 43.5003653478339 | 35.89617415755671
 |  |  |  |  |  | 101 | 12.02838481966347 | -62.42304023847712
 |  |  |  |  |  | 102 | 25.67005968943448 | -19.80612405674952
 |  |  |  |  |  | 103 | 38.74251019659263 | 21.03252170132032
 |  |  |  |  |  | 104 | 25.40528220370088 | -20.63329520868204
 |  |  |  |  |  | 105 | 40.78379853859843 | 27.40955494719911
 |  |  |  |  |  | 106 | 44.35350036991269 | 38.56138822215775
 |  |  |  |  |  | 107 | 47.3188680498814 | 47.82526725986067
 |  |  |  |  |  | 108 | 40.07442911767687 | 25.19346803397961
 |  |  |  |  |  | 109 | 41.10281228106196 | 28.40616145286461
 |  |  |  |  |  | 110 | 23.96093023167423 | -25.14548506193616
 |  |  |  |  |  | 111 | 44.0183831036251 | 37.51447392572665
 |  |  |  |  |  | 112 | 19.08514949204244 | -40.37753985616232
 |  |  |  |  |  | 113 | 14.02774508826368 | -56.17699128939807
 |  |  |  |  |  | 114 | 36.98228483030434 | 15.53353586474335
 |  |  |  |  |  | 115 | 21.72391548416719 | -32.13397224565077
 |  |  |  |  |  | 116 | 85.654614074871 | 167.5870480314621
 |  |  |  |  |  | 117 | 35.76521073362415 | 11.73136749023478
 |  |  |  |  |  | 118 | 33.46427719413789 | 4.543196482780029
 |  |  |  |  |  | 119 | 13.79695555815032 | -56.89798326101119
 |  |  |  |  |  | 120 | 23.73979482646427 | -25.83631731813722
 |  |  |  |  |  | 121 | 32.53896288406902 | 1.652492608775458
 |  |  |  |  |  | 122 | 20.9894591236132 | -34.42843135391065
 |  |  |  |  |  | 123 | 11.41853525198114 | -64.32822476731914
 |  |  |  |  |  | 124 | 13.78188050596981 | -56.94507808194373
 |  |  |  |  |  | 125 | 46.60335534887047 | 45.58998859378466
 |  |  |  |  |  | 126 | 23.42484425452346 | -26.82023038261961
 |  |  |  |  |  | 127 | 44.38888838254761 | 38.67194121383198
 |  |  |  |  |  | 128 | 32.55765477748018 | 1.710886527585701
 |  |  |  |  |  | 129 | 96.98844829318874 | 202.9942152239573
 |  |  |  |  |  | 130 | 63.95696033981641 | 99.80306260486228
 |  |  |  |  |  | 131 | 18.86857101466276 | -41.05413616162838
 |  |  |  |  |  | 132 | 24.49777711070021 | -23.4683626657288
 |  |  |  |  |  | 133 | 43.65452015438287 | 36.37775743324859
 |  |  |  |  |  | 134 | 44.92587657924684 | 40.34950508980582
 |  |  |  |  |  | 135 | 38.24371909382479 | 19.47428645368571
 |  |  |  |  |  | 136 | 28.69906512643583 | -10.34343915515204
 |  |  |  |  |  | 137 | 13.94363764237691 | -56.43974494727612
 |  |  |  |  |  | 138 | 47.68556229964405 | 48.97082880238693
 |  |  |  |  |  | 139 | 46.75541628018679 | 46.06503055353576
 |  |  |  |  |  | 140 | 17.34484098308629 | -45.8143049575561
 |  |  |  |  |  | 141 | 43.61858578607375 | 36.26549761347627
 |  |  |  |  |  | 142 | 27.24846277079166 | -14.87515535522754
 |  |  |  |  |  | 143 | 30.80557972212063 | -3.762637544140471
 |  |  |  |  |  | 144 | 31.97295096295868 | -0.1157420713568174
 |  |  |  |  |  | 145 | 18.83746718320655 | -41.15130526958278
 |  |  |  |  |  | 146 | 40.5657318586195 | 26.72830946147923
 |  |  |  |  |  | 147 | 21.32073541145144 | -33.39351636535008
 |  |  |  |  |  | 148 | 74.52282397508782 | 132.8110714623175
 |  |  |  |  |  | 149 | 56.06483691496157 | 75.14788164624046
 |  |  |  |  |  | 150 | 49.11760104094868 | 53.44455183051761
 |  |  |  |  |  | 151 | 20.92396480984633 | -34.63303714512237
 |  |  |  |  |  | 152 | 26.80986610901506 | -16.24534174003417
 |  |  |  |  |  | 153 | 78.00239421553282 | 143.681331507444
 |  |  |  |  |  | 154 | 41.69236757595657 | 30.2479461916794
 |  |  |  |  |  | 155 | 85.84751086704641 | 168.1896621900856
 |  |  |  |  |  | 156 | 22.47537733011549 | -29.78638759726496
 |  |  |  |  |  | 157 | 15.94177949823901 | -50.19750234851917
 |  |  |  |  |  | 158 | 12.85672899670092 | -59.83527336238389
 |  |  |  |  |  | 159 | 36.73037919859863 | 14.74657669040496
 |  |  |  |  |  | 160 | 23.16408702940496 | -27.6348421449392
 |  |  |  |  |  | 161 | 31.03314502760949 | -3.051718126805714
 |  |  |  |  |  | 162 | 30.43906950921767 | -4.907624151147551
 |  |  |  |  |  | 163 | 17.19823667546581 | -46.27230029532705
 |  |  |  |  |  | 164 | 26.08389059968465 | -18.5133064677143
 |  |  |  |  |  | 165 | 36.01766613210693 | 12.5200441490376
 |  |  |  |  |  | 166 | 28.06962133684057 | -12.30983649846746
 |  |  |  |  |  | 167 | 55.43028525590837 | 73.16552719746447
 |  |  |  |  |  | 168 | 40.27901473440548 | 25.83259835803025
 |  |  |  |  |  | 169 | 77.25908113176341 | 141.3592037855777
 |  |  |  |  |  | 170 | 26.56014484222348 | -17.02547690651833
 |  |  |  |  |  | 171 | 32.33568023776542 | 1.017432795268433
 |  |  |  |  |  | 172 | 29.16287073535806 | -8.894499420937008
 |  |  |  |  |  | 173 | 51.41357132766329 | 60.61721751847328
 |  |  |  |  |  | 174 | 22.93872232144446 | -28.3388868433475
 |  |  |  |  |  | 175 | 21.52998965454839 | -32.73980114167949
 |  |  |  |  |  | 176 | 46.44588593905582 | 45.09805041879358
 |  |  |  |  |  | 177 | 28.93070350561591 | -9.619795358900632
 |  |  |  |  |  | 178 | 23.58487752377225 | -26.32028264988363
 |  |  |  |  |  | 179 | 19.32102733609871 | -39.64065187098186
 |  |  |  |  |  | 180 | 62.27439790497851 | 94.54669761005471
 |  |  |  |  |  | 181 | 28.0966098031443 | -12.22552388895876
 |  |  |  |  |  | 182 | 30.58519310159517 | -4.451130579209085
 |  |  |  |  |  | 183 | 31.79369337042108 | -0.6757470464820883
 |  |  |  |  |  | 184 | 24.31741806647813 | -24.0318086020677
 |  |  |  |  |  | 185 | 23.37752026355501 | -26.96807165399873
 |  |  |  |  |  | 186 | 31.50212050965813 | -1.58662758619766
 |  |  |  |  |  | 187 | 20.9588850230154 | -34.52394557008622
 |  |  |  |  |  | 188 | 36.72609331744668 | 14.73318749592841
 |  |  |  |  |  | 189 | 27.07159274470755 | -15.42770151606513
 |  |  |  |  |  | 190 | 28.45382319970681 | -11.10958075692966
 |  |  |  |  |  | 191 | 12.42859615572505 | -61.17277052257093
 |  |  |  |  |  | 192 | 7.730515539598081 | -75.84968591190852
 |  |  |  |  |  | 193 | 33.43476326383555 | 4.450994263778667
 |  |  |  |  |  | 194 | 13.47945083233711 | -57.88987556283313
 |  |  |  |  |  | 195 | 34.24693057820129 | 6.988224236805026
 |  |  |  |  |  | 196 | 22.47159614915017 | -29.7982000963756
 |  |  |  |  |  | 197 | 19.06651714638176 | -40.43574774638626
 |  |  |  |  |  | 198 | 59.8074018312592 | 86.83974330290285
 |  |  |  |  |  | 199 | 41.38853515900148 | 29.29876650734611
 |  |  |  |  |  | 200 | 55.02584374324392 | 71.90204230941556
 |  |  |  |  |  | 201 | 32.61987211720461 | 1.905254974085004
 |  |  |  |  |  | 202 | 29.89122121407129 | -6.619115232517061
 |  |  |  |  |  | 203 | 35.88437573180847 | 12.10364177384714
 |  |  |  |  |  | 204 | 32.17777142141894 | 0.5241219038392401
 |  |  |  |  |  | 205 | 27.21873007814689 | -14.96804099298064
 |  |  |  |  |  | 206 | 58.95269984582222 | 84.16963400756707
 |  |  |  |  |  | 207 | 47.54537589073353 | 48.53288313256337
 |  |  |  |  |  | 208 | 31.25609034797699 | -2.355231652680449
 |  |  |  |  |  | 209 | 14.86414426444251 | -53.56406040474065
 |  |  |  |  |  | 210 | 33.44400006614973 | 4.479850253513701
 |  |  |  |  |  | 211 | 11.8455230930908 | -62.9943046138994
 |  |  |  |  |  | 212 | 13.59510150917199 | -57.52858010255548
 |  |  |  |  |  | 213 | 35.34561293436751 | 10.42053400302253
 |  |  |  |  |  | 214 | 70.38896118648469 | 119.8967859621515
 |  |  |  |  |  | 215 | 38.0344684976783 | 18.82058262317494
 |  |  |  |  |  | 216 | 32.06547111069542 | 0.1732930668398049
 |  |  |  |  |  | 217 | 48.18824041398423 | 50.54120716646119
 |  |  |  |  |  | 218 | 49.36446401410044 | 54.2157576198077
 |  |  |  |  |  | 219 | 11.08178237645475 | -65.3802487458458
 |  |  |  |  |  | 220 | 26.91779454713781 | -15.90817073683907
 |  |  |  |  |  | 221 | 26.13922171127187 | -18.34045076141247
 |  |  |  |  |  | 222 | 22.14141945726787 | -30.82967992106258
 |  |  |  |  |  | 223 | 18.67398510669352 | -41.66202715809584
 |  |  |  |  |  | 224 | 20.49755871960486 | -35.96513989501763
 |  |  |  |  |  | 225 | 38.61075842235103 | 20.62092603046244
 |  |  |  |  |  | 226 | 36.87145755075932 | 15.18730881211909
 |  |  |  |  |  | 227 | 40.96753568282545 | 27.98355414815824
 |  |  |  |  |  | 228 | 20.49100843457785 | -35.98560314096266
 |  |  |  |  |  | 229 | 46.76480175261654 | 46.09435099224163
 |  |  |  |  |  | 230 | 22.25034484101276 | -30.48939443607384
 |  |  |  |  |  | 231 | 43.57661035253938 | 36.13436536250978
 |  |  |  |  |  | 232 | 23.89071387106564 | -25.364842639595
 |  |  |  |  |  | 233 | 26.46137369288268 | -17.33404032214095
 |  |  |  |  |  | 234 | 20.64730430812192 | -35.49733112114365
 |  |  |  |  |  | 235 | 21.80219904996883 | -31.88941252743258
 |  |  |  |  |  | 236 | 46.05724281498092 | 43.88392007179296
 |  |  |  |  |  | 237 | 21.31036126366399 | -33.42592544934711
 |  |  |  |  |  | 238 | 34.0727813571361 | 6.444177935445496
 |  |  |  |  |  | 239 | 22.67107229486498 | -29.17503188108408
 |  |  |  |  |  | 240 | 23.25560708497483 | -27.34893131841666
 |  |  |  |  |  | 241 | 22.10829355210444 | -30.9331660352876
 |  |  |  |  |  | 242 | 32.57540078624424 | 1.766325480300656
 |  |  |  |  |  | 243 | 41.78098850716114 | 30.52480008485206
 |  |  |  |  |  | 244 | 29.73838677270736 | -7.096573656021994
 |  |  |  |  |  | 245 | 15.93164213987096 | -50.229171696748
 |  |  |  |  |  | 246 | 30.87962230715687 | -3.531326750525241
 |  |  |  |  |  | 247 | 39.9270542612151 | 24.73306548333365
 |  |  |  |  |  | 248 | 7.270770177041018 | -77.28594134007804
 |  |  |  |  |  | 249 | 56.30488280353085 | 75.89779070143972
 |  |  |  |  |  | 250 | 19.15510094535175 | -40.15900985519603