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
97.12824478
10
96.30001834
11
99.88689859
12
101.4383706
13
98.21361652
14
96.17541738
15
95.64254532
16
93.47787822
17
93.86004913
18
94.3533133897.21230389
19
95.4452934396.64763523
20
91.8093523996.47934009
21
90.5411118596.0302735
22
91.8280037195.09569482
23
94.0901716794.13465813
24
91.2804390993.72231365
25
87.8204113393.23281582
26
84.7155697392.45060242
27
87.7091668691.57437157
28
89.9245516590.95928334
29
88.2267995590.51640717
30
88.6992450889.79455778
31
91.0583522389.48354705
32
94.1981711889.53527109
33
97.229696289.77228784
34
94.1875394590.08624029
35
94.2659025190.37695033
36
97.9522915291.02149945
37
96.1934196792.34517162
38
97.783502293.1935969
39
98.0062964993.97949196
40
98.6917306694.95744165
41
96.6061318595.95669021
42
94.9133038596.51146817
43
95.2294485296.58298144
44
92.8472881596.38295667
45
91.5707500696.24893154
46
94.1175146495.9794163
47
92.8170545995.59593861
48
91.7963737395.2583021
49
93.9449687394.65958925
50
92.4651247694.25345648
51
90.4205497293.63079589
52
87.1387671393.01223768
53
85.2422847592.234784
54
84.1939476391.23606763
55
81.9214885590.37073357
56
80.2502959689.40580742
57
83.2183468988.01908556
58
81.9467676687.05921479
59
79.5587275186.07425418
60
78.8438388384.63563006
61
79.1618121383.27350146
62
78.6416123382.1476277
63
80.3109004781.29791222
64
78.9616867580.8047738
65
81.8620773380.28154771
66
84.1999463480.27560659
67
86.3397422580.67057162
68
88.6545672680.98271116
69
87.2813799781.65349112
70
84.1118033282.42575637
71
80.9768930982.95255282
72
83.1640872483.13406091
73
80.2869181683.5863084
74
81.2409873483.58391017
75
83.2674806883.81184023
76
84.6233450283.95238057
77
82.6767841883.99472043
78
85.7428439683.62842463
79
87.6730069783.3372523
80
87.6074239283.376415
81
89.5767518683.72597706
82
92.3753845384.58596293
83
91.7818494385.50709266
84
92.8807492686.65658579
85
94.4662842287.82056198
86
91.6093753588.94044234
87
92.8879102389.63904537
88
95.5331800290.66015797
89
97.2287591191.63919158
90
98.5245511992.59476679
91
99.7590273793.68647952
92
100.948788794.70470707
93
97.2979970695.56204749
94
98.6636374696.11366225
95
94.8283003296.69195107
96
91.0910402196.72815268
97
88.2291721796.67631917
98
90.1429032596.21044536
99
91.6642446695.67141768
100
91.9616416695.11496624