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
99.54776114
10
99.48001585
11
97.59852892
12
95.31210114
13
94.75620151
14
97.27960319
15
98.4493842
16
98.91332978
17
97.15463017
18
96.306234997.84915559
19
94.4941675397.47977908
20
93.5788086896.97441972
21
95.3741644196.384299
22
96.3510363696.16186255
23
97.0398587696.26575607
24
96.7992147396.4941218
25
96.5537187896.44608295
26
96.6943529696.25651641
27
96.5013808296.03461873
28
100.155948895.96929379
29
102.922171896.35426518
30
105.786878697.1970656
31
103.165689298.4178726
32
101.748249399.19702508
33
103.439208999.73674637
34
100.6008934100.3766814
35
103.1673394100.7568492
36
102.6086384101.4182113
37
104.2339201102.0096398
38
106.8776087102.7828938
39
104.9650368103.4550598
40
108.5945481103.6593463
41
106.5089263103.9401132
42
106.214241104.2744369
43
102.2297036104.7210361
44
100.6585651104.6000856
45
98.7762226104.6058527
46
101.5639516104.1667411
47
98.18161199104.0622724
48
95.20028178103.4570416
49
98.71274711102.2893089
50
97.82501779101.6640799
51
96.60926225100.5871269
52
98.4529266999.59716048
53
101.084598498.82102904
54
104.108155198.70651852
55
103.196908799.05147752
56
104.399349199.49354613
57
102.96974899.77708588
58
104.7735844100.2558995
59
103.1988507101.2132297
60
104.2641658101.6618401
61
101.5982078102.3057549
62
105.368787102.8046494
63
102.3147883103.4962355
64
99.09430169103.6192545
65
99.57958735103.1178691
66
97.55120833102.756137
67
98.86246117102.0713229
68
95.8207818101.6605942
69
98.6291573100.765314
70
99.73209100.3083447
71
101.79276299.85513707
72
102.207777499.8745925
73
100.685810699.55849154
74
97.9279407899.39559377
75
99.9868209699.27895768
76
99.2940132899.31968104
77
100.0624199.49396153
78
100.666747499.61395641
79
103.3073599100.098553
80
103.8250479100.5663732
81
105.7817974100.975669
82
102.6255191101.3745726
83
99.83606267101.4163467
84
95.99455539101.3313719
85
95.274409101.1380334
86
95.03971523100.6667922
87
98.52460066100.2413624
88
95.30498606100.0875815
89
98.0050094499.55140532
90
95.027851299.02117028
91
93.4063122398.14145062
92
96.9525267796.9039021
93
97.6461016496.33660287
94
99.4817642596.11760676
95
99.1692311196.46632765
96
100.285094596.85580986
97
98.1976336297.38034779
98
94.3189558297.34765109
99
96.2232793597.24904806
100
98.3362273697.07087505