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
101.2065384
10
103.2689357
11
100.2625579
12
100.0739509
13
98.4103941
14
101.0391751
15
97.40574122
16
99.61213926
17
96.65192745
18
93.2145317999.79313601
19
94.2872176399.11458919
20
94.6668143598.42265711
21
96.373204697.56244497
22
97.7167617497.17350964
23
94.0011559496.93779072
24
93.9319315696.49686691
25
92.0287116695.78614255
26
94.0703859595.2484396
27
92.5587177294.69426427
28
95.0304380294.28494329
29
96.1813413494.46653392
30
95.2236951294.65594629
31
96.6525656494.71163436
32
99.2482828794.73957047
33
101.421106894.89272258
34
98.7253486195.63471766
35
97.7740592996.11405937
36
100.213291196.68859413
37
100.188623597.30288465
38
100.342870198.06587522
39
101.472003898.59711843
40
98.6127532299.12618467
41
102.27212399.46509048
42
100.1338336100.0270462
43
101.2725113100.1156013
44
97.28508533100.1007417
45
98.1874089699.95671542
46
101.671289999.99805039
47
102.3253876100.1438503
48
100.5320885100.3575267
49
103.7307559100.3764485
50
100.990703100.6023237
51
103.1882733100.8401187
52
99.32281694100.9317337
53
100.9758557100.8506321
54
98.54023738100.8209665
55
100.8105428100.9464817
56
97.84445221101.2087951
57
96.721394100.8261113
58
94.18408541100.265712
59
92.9009288699.63091166
60
93.7701391698.54792896
61
93.5308542597.82587258
62
90.6872709796.86013068
63
93.0382842595.99657608
64
93.0999643895.20281893
65
89.90953694.65879163
66
90.602740993.56869095
67
91.0718707392.84451982
68
89.4129161292.27956749
69
92.0188177391.80245056
70
93.1671617891.71423945
71
96.3230191591.65394171
72
97.8079700991.9331582
73
95.7256525392.64522811
74
99.0062806892.91396494
75
102.482745493.50459657
76
105.0519394.76191752
77
105.758250396.20683643
78
104.929528397.67547439
79
107.363933299.22713561
80
108.9595753100.7616472
81
111.5522723102.3408885
82
112.3122313103.8638138
83
114.5264385105.3142399
84
117.7588559107.1943185
85
116.9347775109.0695761
86
118.9166082110.5147793
87
119.3188978111.9012471
88
123.0601943113.2573118
89
123.9777803115.0703784
90
125.7909511116.7317631
91
129.8167606118.4149007
92
127.5844266120.2413496
93
124.6035415121.7685691
94
123.7970223122.7762794
95
123.2125339123.380096
96
122.33451124.0078717
97
124.0054927124.3496619
98
122.0401473124.8183213
99
124.8373884124.7163166
100
124.6910101124.8022774