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
101.5316623
10
100.7587299
11
100.9524942
12
98.47968545
13
96.66555141
14
96.30588669
15
98.07522544
16
96.72351817
17
99.76138784
18
96.5393875198.92541414
19
96.4437391198.57935289
20
99.1430450898.07056057
21
96.6662092597.90899209
22
99.9509741597.48036359
23
103.014199497.62749246
24
103.495601398.26235727
25
103.735228598.98132873
26
106.918978599.54732903
27
106.0872968100.5668751
28
107.1351351101.199466
29
102.999908102.2590407
30
104.7535694102.9146576
31
105.7855031103.47571
32
108.0103063104.3876394
33
111.9468384105.1935726
34
114.7844102106.0868365
35
110.653215107.2157174
36
106.6543031107.9075161
37
106.4094695107.8810485
38
107.7102167107.9132658
39
104.5928752107.970774
40
104.7902762108.1300707
41
102.8033003108.1337414
42
100.3489752107.8355211
43
96.88636389107.069388
44
99.14771942105.5633405
45
101.0810941103.9996715
46
103.9391771103.0424594
47
104.8352472102.7709468
48
105.6609221102.6135245
49
101.6941542102.4085951
50
100.515413102.118723
51
103.7559558101.6912366
52
101.0564147101.7865022
53
99.11092878101.8572461
54
101.7446404102.0797026
55
99.2874958102.3393947
56
99.10651864102.1600349
57
97.91160839101.6767691
58
98.94902506100.9844052
59
97.76986181100.3132155
60
101.23799799.92078624
61
97.6615217799.99304465
62
97.5664750899.38360124
63
100.598325499.03460728
64
97.5061334399.18334694
65
100.249533498.75949624
66
102.778860898.8557
67
101.46845299.22293422
68
98.4283322199.57861858
69
94.563005299.52654929
70
97.7746429999.20586363
71
94.8555832598.85952823
72
97.6268860598.57893437
73
94.2436568798.58497547
74
92.9278886197.94950862
75
92.7403141197.49168414
76
94.2523588896.74076221
77
96.827699195.88811202
78
99.6593053795.42403672
79
100.596271295.54713404
80
98.1576940596.15046064
81
98.6604856196.18876574
82
101.389359296.56925598
83
102.967203796.9455033
84
103.264864497.81785798
85
101.068185498.85155556
86
103.16186799.68434268
87
104.1438616100.5752935
88
104.2896914101.3069097
89
106.6856108101.7699484
90
105.1612407102.3788823
91
108.0189674103.079237
92
108.4615249104.0150852
93
108.8074197104.7223017
94
112.9277991105.3063233
95
112.6733559106.2726168
96
111.2648891107.4331339
97
107.8411085108.2434361
98
111.076568108.6131608
99
110.3094539109.2918484
100
112.0860312109.6542327