Spreadsheet: 71872d1272558030-random-numbers-copy-the-value-to-a-list-excel-forum
Sheet: Ark1

 |  |  |  |  |  | Initially stock price
Date | Adj Close | Ln avkastning | indeks | Randomize the future | Return | 36.2 | n
40282 | 36.2 | 0.009994530724995588 | 1 | 85 | 0.03082158004060018 | 37.3331136738056 | n+1
40281 | 35.84 | -0.001394117052786046 | 2 | 90 | -0.01522704031903348 | 36.76894704141563 | n+2
40280 | 35.89 | -0.0091527472957514 | 3 | 94 | -0.008629326698054525 | 36.45302086062355 | n+3
40277 | 36.22 | 0.01530145308446705 | 4 | 12 | -0.004257137123318945 | 36.29816520701002 | n+4
40276 | 35.67 | 0.009860623635041038 | 5 | 10 | -0.005427809354875628 | 36.10167941244216 | n+5
40275 | 35.32 | -0.004237893049771116 | 6 | 42 | -0.002988546139317636 | 35.9939489367419 | n+6
40274 | 35.47 | 0.007073165717470443 | 7 | 76 | 0.003707140482819584 | 36.1276311983454 | n+7
40273 | 35.22 | -0.009326053181189778 | 8 | 91 | 0.001973035825858392 | 36.19898267536649 | n+8
40269 | 35.55 | 0.01816683513230518 | 9 | 21 | 0.0008892841848842585 | 36.23118817596736 | n+9
40268 | 34.91 | -0.005427809354875628 | 10 | 79 | 0.0006261740968532476 | 36.25388231199992 | n+10
40267 | 35.1 | -0.001707942345156036 | 11 | 83 | 0.004092560410766458 | 36.40255753914692 | [NAME]
40266 | 35.16 | -0.004257137123318945 | 12 | 56 | -0.002003339568175062 | 36.32970385494583 | n+12
40263 | 35.31 | 0.006250020345171326 | 13 | 119 | 0.006896579059060459 | 36.58112049062019 | n+13
40262 | 35.09 | 0.02015036515094905 | 14 | 118 | -0.01873103670606324 | 35.9022955742994 | n+14
40261 | 34.39 | 0.01111122542507085 | 15 | 39 | 0.005171310813378004 | 36.0884383899795 | n+15
40260 | 34.01 | 0.001765745014398726 | 16 | 28 | 0.01976048489700672 | 36.80865592002208 | n+16
40259 | 33.95 | 0.009173018899957811 | 17 | 70 | -0.005597029536717908 | 36.60321225907312 | [NAME]
40256 | 33.64 | -0.004153076274906701 | 18 | 2 | -0.001394117052786046 | 36.55221865046477 | n+18
40255 | 33.78 | 0.0008884940611152349 | 19 | 113 | -0.02769856375265497 | 35.5536677455635 | n+19
40254 | 33.75 | 0 | 20 | 47 | -0.004391157199496796 | 35.39788827785459 | n+20
40253 | 33.75 | 0.0008892841848842585 | 21 | 48 | -0.03575355994979636 | 34.15464537248604 | n+21
40252 | 33.72 | 0.0008900757151933303 | 22 | 12 | -0.004257137123318945 | 34.00955342103113 | n+22
40249 | 33.69 | -0.003555559301333207 | 23 | 4 | 0.01530145308446705 | 34.53395079646054 | n+23
40248 | 33.81 | 0.01429872440014636 | 24 | 67 | 0.0003142183843605118 | 34.54480370368758 | n+24
40247 | 33.33 | 0.0006002401140599063 | 25 | 63 | 0.01513472778882105 | 35.07160635588528 | n+25
40246 | 33.31 | 0.003609026473705128 | 26 | 71 | -0.0009298001599666387 | 35.0390119261865 | n+26
40245 | 33.19 | -0.0009034784532656254 | 27 | 55 | -0.008727816396490548 | 34.73452853377979 | n+27
40242 | 33.22 | 0.01976048489700672 | 28 | 87 | -0.01049534068173071 | 34.3718841901971 | n+28
40241 | 32.57 | 0.02896947638868896 | 29 | 114 | 0.03251427967178925 | 35.50782837620807 | n+29
40240 | 31.64 | -0.007556711022561115 | 30 | 119 | 0.006896579059060459 | 35.7535572923064 | n+30
40239 | 31.88 | 0.01072227238712202 | 31 | 11 | -0.001707942345156036 | 35.69254439590315 | n+31
40238 | 31.54 | 0.009557256563407156 | 32 | 85 | 0.03082158004060018 | 36.80977395689517 | n+32
40235 | 31.24 | -0.003833870510721901 | 33 | 73 | 0.01462150795933696 | 37.35194236052227 | n+33
40234 | 31.36 | -0.0009561753716550845 | 34 | 31 | 0.01072227238712202 | 37.75459487804217 | [NAME]
40233 | 31.39 | 0.01508614713464095 | 35 | 6 | -0.004237893049771116 | 37.59493349569917 | n+35
40232 | 30.92 | -0.006447475590969648 | 36 | 46 | -0.002033209782097845 | 37.51857276415746 | n+36
40231 | 31.12 | -0.003528471984796366 | 37 | 60 | 0.01330972415402244 | 38.0212725953112 | n+37
40228 | 31.23 | 0.006747013546594428 | 38 | 114 | 0.03251427967178925 | 39.27782412185509 | n+38
40227 | 31.02 | 0.005171310813378004 | 39 | 75 | -0.004326335549042814 | 39.10826213057973 | n+39
40226 | 30.86 | 0.01271825393739717 | 40 | 10 | -0.005427809354875628 | 38.89656498514354 | n+40
40225 | 30.47 | 0.0132145959971799 | 41 | 85 | 0.03082158004060018 | 40.11408514118592 | n+41
40221 | 30.07 | -0.002988546139317636 | 42 | 73 | 0.01462150795933696 | 40.70492249675964 | n+42
40220 | 30.16 | 0.00431966114451638 | 43 | 124 | 0.01113442261666523 | 41.16068090120202 | [NAME]
40219 | 30.03 | 0.006347106659678894 | 44 | 61 | -0.01363214879005764 | 40.60337961240432 | n+44
40218 | 29.84 | 0.0121377080144243 | 45 | 59 | 0.005787797507354357 | 40.8390651438533 | n+45
40217 | 29.48 | -0.002033209782097845 | 46 | 113 | -0.02769856375265497 | 39.7234041262642 | n+46
40214 | 29.54 | -0.004391157199496796 | 47 | 78 | 0.01398624197473987 | 40.28288869142285 | n+47
40213 | 29.67 | -0.03575355994979636 | 48 | 107 | 0.01546603762988045 | 40.91074809716943 | n+48
40212 | 30.75 | 0.02535950157807527 | 49 | 33 | -0.003833870510721901 | 40.75420186720577 | n+49
40211 | 29.98 | 0.01546249294218001 | 50 | 90 | -0.01522704031903348 | 40.13833679299701 | n+50
40210 | 29.52 | -0.001015744119835528 | 51 | 98 | -0.006718197925287927 | 39.8695832824982 | n+51
40207 | 29.55 | 0.006791197578001756 | 52 | 3 | -0.0091527472957514 | 39.50633197153122 | n+52
40206 | 29.35 | 0.001022669255654795 | 53 | 103 | 0.04659914646193047 | 41.39086103841833 | n+53
40205 | 29.32 | -0.01152945969133527 | 54 | 55 | -0.008727816396490548 | 41.03118109623956 | n+54
40204 | 29.66 | -0.008727816396490548 | 55 | 23 | -0.003555559301333207 | 40.88555134966905 | n+55
40203 | 29.92 | -0.002003339568175062 | 56 | 40 | 0.01271825393739717 | 41.40886493766941 | n+56
40200 | 29.98 | -0.02079626028286941 | 57 | 119 | 0.006896579059060459 | 41.69543147703045 | [NAME]
40199 | 30.61 | -0.01877077766239079 | 58 | 108 | -0.01546603762988052 | 41.05552949412521 | n+58
40198 | 31.19 | 0.005787797507354357 | 59 | 82 | 0.01093590027023582 | 41.50697263967796 | n+59
40197 | 31.01 | 0.01330972415402244 | 60 | 51 | -0.001015744119835528 | 41.46483358116052 | n+60
40193 | 30.6 | -0.01363214879005764 | 61 | 82 | 0.01093590027023582 | 41.92077739999201 | n+61
40192 | 31.02 | -0.008666399932398025 | 62 | 86 | 0.0006591958050176015 | 41.94842051070747 | [NAME]
40191 | 31.29 | 0.01513472778882105 | 63 | 84 | 0.01269858333712734 | 42.48450256196251 | n+63
40190 | 30.82 | -0.01736936559023738 | 64 | 111 | 0.007719207599958431 | 42.81371826447219 | n+64
40189 | 31.36 | -0.01644565843980715 | 65 | 76 | 0.003707140482819584 | 42.97272928866706 | n+65
40186 | 31.88 | 0.001569612628012787 | 66 | 94 | -0.008629326698054525 | 42.60349896430971 | n+66
40185 | 31.83 | 0.0003142183843605118 | 67 | 45 | 0.0121377080144243 | 43.12375878883995 | n+67
40184 | 31.82 | -0.005328331051785778 | 68 | 92
40183 | 31.99 | -0.002497659743636989 | 69 | 47
40182 | 32.07 | -0.005597029536717908 | 70 | 112
40178 | 32.25 | -0.0009298001599666387 | 71 | 31