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
102.5338613
10
105.4609205
11
105.450752
12
105.0679765
13
108.4241476
14
104.2537793
15
102.370315
16
99.16784654
17
98.18579756
18
97.85040107103.0915396
19
94.67123579102.8765797
20
91.97869912102.0903172
21
90.09640289100.7420951
22
89.8911581299.20666014
23
90.5182221697.68897831
24
87.1996614395.89838576
25
84.7385358294.19297397
26
87.9609370192.42979605
27
87.1668282891.3091051
28
89.7521116890.20720817
29
88.5156109689.39737923
30
90.9067781688.78181675
31
91.1169225888.67462465
32
88.8874328288.77667662
33
86.9559904988.67630409
34
88.3721115988.32008092
35
91.2703287188.43732594
36
88.0355857389.09050523
37
90.993999189.0979701
38
88.1727278689.48068718
39
88.4642246689.3227488
40
86.8636248289.31761017
41
86.4137643688.91329484
42
86.0690103488.44297902
43
85.9810612488.16113677
44
82.5556068388.06364384
45
84.0225055887.48199337
46
83.2326073386.75721105
47
85.9330094786.27691321
48
85.5333399985.77081425
49
87.5016514785.50687546
50
84.647201285.41061814
51
87.2177908485.18897578
52
89.7171107785.26937843
53
92.4686566685.63418847
54
88.9229604886.28294801
55
89.5804514486.91968338
56
90.8101984487.47547797
57
94.3491274288.23323708
58
91.6212809889.07484887
59
91.6670721889.68364297
60
90.1930497190.10018504
61
88.6549795790.65476989
62
85.5583392590.79848877
63
83.7429804590.38261161
64
85.158977589.51004399
65
83.5405040489.13364569
66
81.0185572788.52965095
67
78.107046387.55048684
68
75.5992640885.92627873
69
72.646317784.32407704
70
73.5859940182.42200159
71
72.786542980.76129602
72
74.8308617179.17445235
73
72.7756477678.1017046
74
70.9196885877.00497133
75
72.7767965875.58104244
76
72.8304053374.50467169
77
74.0359709873.6858565
78
75.0985078473.27874896
79
77.647488173.22867334
80
75.7411577273.72879038
81
72.9717771173.94430675
82
73.1573779673.96283017
83
73.4616780873.7954818
84
74.1195188773.86408483
85
71.8423034974.18406786
86
73.0404677174.09061855
87
74.0465660174.11162479
88
71.9094354774.11268429
89
74.0044025573.79377705
90
72.5000639473.4294685
91
72.2923300173.10535912
92
74.207737673.03741441
93
75.023056873.14245037
94
77.7241262673.29858825
95
76.7341261273.65904898
96
77.6165812574.14823125
97
76.4792658974.6058426
98
75.8925012974.84911259
99
76.6807787475.24741917
100
75.4245691375.51505679