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
96.84446785
10
94.28607585
11
92.06387559
12
89.72280331
13
88.70705872
14
91.15686931
15
94.5977136
16
92.45441382
17
91.06881812
18
92.3551405993.09020962
19
89.7160703692.32572367
20
89.14624191.61288393
21
91.7170791491.09890044
22
93.521625191.0642208
23
93.9240340291.44410297
24
96.7550724291.9658005
25
99.6328502992.52562082
26
101.943421793.02913449
27
101.881142993.97803528
28
99.2747365195.05926775
29
98.6851060695.75122734
30
102.218525696.64813091
31
98.8035252997.95535937
32
99.8328328598.66400398
33
100.144799199.29512476
34
100.373071899.91720127
35
103.4596176100.2790012
36
100.7369692100.6616779
37
100.1333626100.5410327
38
99.18444128100.3662547
39
103.055868100.3572251
40
105.5027367100.7943013
41
101.770707101.1227224
42
104.2682173101.4194406
43
103.3688953101.8629791
44
103.5360534102.1853887
45
102.3811879102.5016868
46
106.0100006102.3938439
47
102.395183102.921147
48
106.4305559103.147329
49
108.6759724103.8719405
50
112.6489003104.4339509
51
111.0494781105.1485673
52
114.3085214106.0764444
53
113.6507022107.0804748
54
117.2756708108.1086555
55
114.1420356109.4826173
56
114.8690242110.658702
57
110.3197498111.5446044
58
106.0504147112.3370611
59
105.6841732112.299047
60
108.1671762111.999867
61
103.99425111.5516946
62
104.4111599110.8461718
63
102.2878985109.8564357
64
101.2379337108.7201553
65
99.80633025107.1163816
66
103.4872915105.682811
67
102.6610981104.5446378
68
104.9099198103.7787726
69
105.3358082103.6647231
70
106.2747179103.6298866
71
108.1614943103.4406408
72
106.3366856103.8573652
73
108.4678142104.0499178
74
105.677348104.6679094
75
108.6879409105.1118508
76
105.3805715106.0000118
77
105.129741106.1893398
78
105.3462081106.4362041
79
106.3053211106.479833
80
103.9731462106.5767843
81
101.7090915106.3466271
82
104.062786105.7013868
83
103.8360049105.4739968
84
103.4757686105.0108159
85
105.3875811104.790658
86
102.7539105104.460622
87
103.1335215104.1979559
88
105.9639212103.998334
89
107.9675973104.0601053
90
109.7266645104.2263329
91
107.0836758104.8016847
92
104.8425218105.3391432
93
102.7512585105.4171167
94
106.2990383105.3086421
95
106.9124784105.5909691
96
109.5050718105.7434588
97
107.2089321106.4185749
98
103.0289629106.826116
99
103.2638348106.5326201
100
103.1006331106.0622439