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
98.13921253
10
100.8491118
11
104.7890956
12
106.9771464
13
109.4452108
14
107.5174181
15
108.452652
16
105.9861817
17
102.8465456
18
106.133062104.5002575
19
105.9372194105.1135637
20
105.5702698105.8933643
21
109.665007106.3654801
22
106.0918782106.8530713
23
107.6259715106.7645445
24
103.6537307106.5826205
25
102.1406446106.1962518
26
103.4180991105.565051
27
102.9567032105.3082428
28
106.882886105.3192585
29
106.0589048105.3942409
30
109.8996111105.4064095
31
105.5336154105.8393436
32
102.5643504105.4262045
33
102.6409451105.0734517
34
103.5588317104.574949
35
107.6828194104.5654591
36
107.6020017105.1196766
37
110.4990769105.5380669
38
107.7638534106.2923042
39
109.0214777106.380401
40
106.4739207106.6766583
41
109.9317933106.3340892
42
107.0059353106.773907
43
109.0649118107.2180655
44
109.2262326107.8604622
45
112.9583669108.4272023
46
113.240627108.954757
47
113.1589119109.5186196
48
114.2880691109.7846031
49
112.6688253110.4370246
50
113.3256852110.8017594
51
112.7770661111.4869358
52
111.1483866111.7714631
53
110.0387485112.1857083
54
106.6184314112.2830919
55
109.9993153112.0223118
56
108.0360138111.7264066
57
107.6369548111.2059453
58
104.1091053110.6537496
59
102.6538374109.6358532
60
106.691029108.6343544
61
109.6494465107.9708888
62
106.4415838107.6581268
63
104.5991326107.1874466
64
106.57702106.643485
65
106.595702106.6393438
66
107.8466446106.2989825
67
108.5721437106.2800456
68
110.5265071106.3735645
69
108.9516089107.0153047
70
112.2184391107.6450818
71
108.096818108.1978228
72
111.6515076108.04256
73
110.9412702108.5635524
74
109.385951109.1977661
75
108.9614769109.4786592
76
105.9688108109.7152367
77
103.3257013109.5274533
78
100.5911078109.0028091
79
101.6874264108.0092692
80
105.044902107.2828509
81
108.8483583106.5654972
82
107.9104557106.6406512
83
111.0557863106.266546
84
106.7822981106.2779977
85
107.5494325106.0176324
86
109.3258321105.8764279
87
109.9597267106.2121301
88
107.9964114106.8755326
89
104.9112993107.616063
90
102.5212042107.9384502
91
99.66570478107.6860805
92
97.92268655106.7678151
93
98.8608427105.7690382
94
99.86746843104.5495438
95
97.93710845103.8580609
96
98.24286209102.8968285
97
101.4060407101.7885315
98
103.551634100.9331629
99
103.9000117100.4886851
100
104.2779933100.3875564