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
103.843694
10
101.9765283
11
103.9937279
12
101.8957347
13
101.8362735
14
98.49989111
15
100.7222575
16
100.3332493
17
100.9669643
18
101.9756994101.4068321
19
105.4737644101.604402
20
108.2251974101.767409
21
111.5718675102.392276
22
111.8470341103.1500899
23
115.9188575104.1452199
24
119.3552798105.5534783
25
122.0370796107.6390171
26
123.7285249109.7704993
27
126.2386925112.1100269
28
123.8011952114.6371997
29
126.9030905116.8197493
30
124.6798373118.9626819
31
127.9848487120.6081459
32
125.4325334122.249444
33
121.5401492123.6079939
34
123.5769504124.1701231
35
124.631901124.5922902
36
124.2495036124.8517723
37
128.7297315124.9038702
38
128.3379851125.1529741
39
128.349316125.6066531
40
127.9291347125.7512756
41
130.6068463126.0762054
42
125.5816278126.3384051
43
129.9662106126.3533146
44
132.0290983127.1959207
45
127.5305773128.0411355
46
125.1095978128.3310031
47
129.8596957128.4170125
48
125.0258159128.530009
49
120.2007772128.198792
50
119.6455276127.3839382
51
124.0534951126.5555775
52
121.6819065125.9002423
53
126.2856573125.5102702
54
124.5956434125.1422149
55
126.1398316124.3988694
56
131.0124694124.2597948
57
131.4448031124.850082
58
128.163777125.0085927
59
123.3638721125.3223888
60
119.0643113125.6386983
61
116.8176438125.5805767
62
120.4165102124.8569915
63
120.7200857124.7304519
64
116.6253281124.1738947
65
119.5663621123.3768632
66
121.5927492122.7195163
67
126.1392771121.7775442
68
130.3904657121.2469916
69
135.3891751121.4696605
70
137.5468684122.6721908
71
141.3358321124.5204465
72
139.9761567126.9722654
73
140.8249224128.92823
74
138.8023881130.9387137
75
143.5622835133.1564197
76
138.8329456135.5560118
77
143.9048342137.2800315
78
139.2565675139.0565872
79
144.478985139.9431974
80
147.8027255140.8521784
81
151.1194907141.8777641
82
154.3146745142.8561299
83
158.9266961144.2899817
84
162.8579013146.1001591
85
160.4067908148.5057104
86
154.6033302150.1901611
87
151.2481307151.7671996
88
146.2707027152.5015292
89
141.6157627153.2029427
90
137.315796152.9166205
91
137.9729573151.8679276
92
142.7357269150.5532742
93
147.2458521149.3953795
94
151.0237083148.2272951
95
153.2662392147.0438758
96
157.9709675146.3298206
97
157.7802899146.6665843
98
162.2547223147.3198003
99
162.1069631148.9182022
100
160.5583515150.9673223