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.79945601
10
97.87488705
11
101.5970172
12
99.1193851
13
95.17360605
14
98.22368024
15
95.76179965
16
98.07870069
17
98.63288118
18
96.837225998.22614132
19
93.8676244197.90986391
20
94.0094800797.51668075
21
92.6783800597.13014005
22
93.1891386996.23827633
23
93.6775031295.64525169
24
94.8773898495.4956414
25
91.258730195.16101236
26
89.8314213694.7107054
27
91.6937106493.88597747
28
94.4416575393.19206042
29
92.3398435492.95250358
30
95.8090671492.79972549
31
95.37963592.9796842
32
98.9599935993.2498097
33
101.457370593.82689519
34
97.502030994.60488192
35
94.6528066694.86734603
36
91.0253455895.20675369
37
91.7805957895.32614611
38
88.352314295.33483462
39
88.1920232394.72590029
40
87.0905245994.31111826
41
90.3470027393.439264
42
90.2722855292.93600077
43
90.5825831892.06722997
44
91.0630880290.97975124
45
87.695507790.33585695
46
84.2637782889.64012705
47
82.2539331988.96397032
48
81.5380395888.01130406
49
81.779300687.3298766
50
78.9505116886.68860434
51
78.7606430685.87460305
52
81.2664651684.71596708
53
78.633137383.81538505
54
76.0036626382.62044046
55
77.4046941981.11449792
56
76.9699663180.08541657
57
78.3397970779.35603537
58
77.7438806478.96462176
59
77.4545612478.58520586
60
76.1488711278.15273193
61
74.3685657477.87256787
62
73.8415378577.43336014
63
76.7702920776.69086741
64
78.0320735576.50458289
65
77.1510259176.70742398
66
78.1606858376.68205715
67
80.6458041276.8011291
68
77.6335382777.03172981
69
74.9041785177.02069557
70
73.9985022176.7656573
71
74.3205388876.55062041
72
73.7692089476.54581772
73
71.6466181776.53858483
74
70.141936976.02621744
75
72.0704683775.23720377
76
71.2147632574.72914802
77
71.7522905674.03455576
78
72.0042158873.14520441
79
69.1328322472.58227217
80
66.986008772.00513754
81
69.0193649571.30388819
82
70.9428014870.7737708
83
68.1613657170.49113005
84
70.0894521170.1426048
85
72.855045470.13735633
86
70.9474197770.21581403
87
71.191458870.18907968
88
68.8310082170.13299651
89
70.6315473269.81567574
90
70.2470903569.96554725
91
72.7265636370.29165541
92
70.1597488470.66237528
93
68.7687511570.58407001
94
69.4820322970.64480856
95
67.2083328470.58406658
96
64.9324476370.01939532
97
65.4495282569.41789811
98
67.3031203168.84370505
99
69.8590770568.69091626
100
67.2128112568.61366924