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
102.1061764
10
98.07951563
11
101.1177839
12
99.48637135
13
98.217555
14
95.67331593
15
97.08707814
16
100.8926772
17
100.5982765
18
104.427647899.325875
19
107.516179499.76863978
20
109.7151804100.3096401
21
107.0429376101.4732066
22
104.6049335102.0657219
23
102.7972489102.5775781
24
100.1473422103.0355475
25
98.75460708103.4829502
26
96.50991803103.6497031
27
95.40453084103.2114271
28
93.07439347102.6920526
29
94.56587711101.5567271
30
97.59091144100.2616969
31
100.833127799.04927001
32
98.1690909698.42828902
33
99.9306259497.78470477
34
100.211571397.49804247
35
99.8245506197.50446539
36
101.58404997.61145974
37
102.506739998.11887284
38
98.5132905298.82909374
39
95.391665799.37298345
40
96.5908406699.45556231
41
99.2322014899.35555523
42
97.1867197399.19546261
43
97.2766652499.09722549
44
100.705987798.83182942
45
101.207112498.88127105
46
104.859854199.01952723
47
104.837038299.34710774
48
105.679991199.58013756
49
109.5501368100.2968076
50
110.150419101.7126547
51
112.1781393103.0686126
52
114.2914509104.3632064
53
111.7469968106.0736795
54
113.0170932107.5207126
55
115.8743122108.7518232
56
116.6483178110.2185432
57
117.5426778111.3973895
58
114.9772497112.6679535
59
115.5394337113.5976793
60
119.6855336114.196609
61
123.8764487115.1501205
62
121.2991706116.3199514
63
126.0478878117.0207234
64
128.4381502118.4508125
65
129.256433119.9929182
66
130.6874196121.3311303
67
126.8532035122.7350405
68
131.7241351123.666093
69
136.0220663125.3407816
70
136.6848216127.3890448
71
138.4856585129.0889736
72
134.6801992130.5498946
73
130.556176131.8879975
74
131.532969132.3388263
75
132.2045202132.6483082
76
134.8928584132.9431169
77
132.0568717133.3636608
78
133.213865133.8840276
79
130.8841329134.0330006
80
134.9840711133.5192073
81
130.9723656133.3491322
82
132.0093555132.5978029
83
130.648486132.3307185
84
135.0835567132.3399495
85
138.4982013132.6950083
86
134.8144379133.3243764
87
135.7697762133.3165344
88
130.4191894133.6878248
89
128.4357671133.4083573
90
123.8782277133.1635207
91
120.8263459132.0529363
92
120.2175954131.0383344
93
124.2617309129.8591584
94
125.4480293129.2204828
95
129.755232128.2569301
96
125.5174216127.3826332
97
125.9052979126.4529316
98
123.7526683125.4664837
99
126.5429557124.7998316
100
125.6410392124.6105505