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
100.9444813
10
99.41675014
11
99.22803472
12
95.99966346
13
98.21799235
14
95.40614609
15
94.87093259
16
95.22798816
17
97.29125419
18
98.6633508197.6603243
19
97.2072559697.52665938
20
96.9376711497.15293685
21
96.5178665796.90502895
22
96.228321696.63401213
23
98.173952596.65687794
24
99.9748145296.65247396
25
103.435315197.1093408
26
100.361018897.96577906
27
99.6449518298.47908212
28
97.679973198.71445189
29
97.4339496298.61611412
30
97.6057518298.63878348
31
95.5928511698.70559155
32
92.2421599198.61309001
33
90.8679291898.21447384
34
92.2957602897.48387151
35
91.5416620996.71596609
36
89.6678794895.52660078
37
89.352040794.45728685
38
91.2429425893.42799573
39
90.0331959492.78429268
40
90.6478199692.04421731
41
93.4022856991.34842413
42
91.1099567691.12936758
43
88.8562976791.01614727
44
86.9772635790.81498412
45
88.6982951390.28313444
46
91.7967552489.99879775
47
95.1454543790.21168532
48
96.077509990.79102669
49
97.6820841691.27448342
50
98.0591804992.03937225
51
98.2430688692.7805083
52
98.2844299293.26458662
53
98.3821680793.98203393
54
100.461290994.93462097
55
98.6890096596.2830237
56
101.618038297.28209515
57
99.890546398.26422345
58
103.758878498.73873264
59
103.599563899.50686949
60
102.1703613100.0986175
61
105.0294348100.5097355
62
104.5294163101.1883721
63
102.5987625101.8128708
64
99.62636216102.2345302
65
103.1174276102.1510373
66
105.1394815102.5938791
67
107.1971686102.9460235
68
111.3440285103.6766857
69
112.4523952104.4352007
70
110.6369201105.3204838
71
111.6004812106.1671397
72
115.4960611106.8242444
73
115.319643107.9209088
74
111.147433109.1929969
75
108.8094052110.345104
76
109.926674110.9143017
77
112.6697697111.393021
78
115.5001766111.9402811
79
118.7401698112.3558959
80
115.3908085112.9846734
81
111.4989458113.4600622
82
115.6098357113.4499087
83
114.0201176113.4612861
84
110.8127584113.3313336
85
111.2160889113.2978661
86
107.7690453113.5385345
87
103.8516272113.3227716
88
105.1612526112.4409574
89
104.279223111.407065
90
105.7624369109.9609703
91
107.894607108.9981331
92
104.2613964108.6376993
93
105.9638789107.5028553
94
106.8401713106.6972315
95
103.4097023106.2999728
96
102.8745213105.5193341
97
100.0027962105.0298817
98
101.6056604104.6449986
99
102.3636306104.2894394
100
100.4878223104.0978801