ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hodorific Stock Market
11/23/2010
2
3
This uses the RAND function to generate a random gain or loss on each calculation. This is similar to the stock market.
4
5
Max % gain/loss4%
6
7
Price
Moving Average
8
100
9
96.80139136
10
98.27523866
11
97.22558055
12
93.97533014
13
94.41714272
14
93.13002784
15
93.03701174
16
90.6631119
17
93.89284381
18
96.5954461395.14176787
19
99.3999724894.80131248
20
99.4385266795.0611706
21
102.69338795.1774994
22
104.524655395.72428005
23
103.337981296.77921256
24
105.748768797.67129641
25
104.593895398.9331705
26
106.2453646100.0888589
27
107.5057311101.6470841
28
105.2345711103.0083729
29
103.7145919103.8722854
30
105.3804761104.3037473
31
101.7281317104.8979422
32
104.4360784104.8014167
33
102.3255111104.792559
34
103.3164182104.691312
35
100.3153479104.4480769
36
101.7727713104.0202222
37
104.5277091103.5729629
38
107.756852103.2751607
39
111.7325237103.5273888
40
109.3637742104.3291819
41
106.4912523104.7275118
42
103.6459542105.2038238
43
105.9735322105.1248114
44
107.1335295105.4896135
45
111.2243029105.8713246
46
113.2521411106.9622201
47
114.9339405108.1101571
48
114.7479965109.1507803
49
113.5341957109.8498947
50
110.0020062110.0300619
51
110.3667594110.0938851
52
109.033479110.4814358
53
111.5867319111.0201883
54
111.2312471111.5815083
55
107.2892792111.99128
56
107.7440675111.5977777
57
109.4154097111.0469703
58
108.6922055110.4951172
59
110.7001359109.8895381
60
110.4484218109.6061322
61
112.4451108109.6507737
62
113.8309006109.8586089
63
112.2453919110.338351
64
109.80481110.404217
65
110.9455772110.2615733
66
114.7690071110.6272031
67
111.8329897111.3296971
68
113.086201111.5714551
69
112.7828791112.0108546
70
115.3041375112.2191289
71
114.0283842112.7047005
72
111.8591176112.8630278
73
112.0230506112.6658495
74
116.256781112.6436154
75
118.2539278113.2888125
76
119.1996401114.0196476
77
119.4842001114.4627109
78
116.4728544115.2278319
79
119.8633595115.5664972
80
123.5183264116.2745453
81
124.2375167117.0959642
82
125.7764233118.1168774
83
124.0562232119.508608
84
124.8894843120.7119253
85
122.3500408121.5751956
86
118.7413236121.9848069
87
117.935221121.9389752
88
113.3601678121.7840773
89
116.6656658121.4728087
90
117.117595121.1530393
91
114.159286120.5129661
92
114.5358409119.5051431
93
111.6848591118.3810848
94
109.6239455117.1439484
95
113.2561045115.6173945
96
114.9455456114.7080009
97
111.7852843114.3284231
98
110.5189873113.7134294
99
110.8155395113.4293114
100
110.3875251112.8442988