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
99.98761442
10
96.08882564
11
94.28629199
12
95.42999619
13
95.18999743
14
98.6854227
15
101.419054
16
105.0745617
17
102.6665285
18
99.1908511998.88282926
19
99.8206452698.80191438
20
98.1123663798.78521746
21
100.808809498.98757153
22
97.1191818399.63982328
23
97.920368499.80874184
24
99.25267672100.0817789
25
100.40159100.1385043
26
99.19059525100.0367579
27
99.6473460499.4483613
28
100.924398499.14644305
29
101.867053299.31979776
30
102.929223799.52443856
31
103.4678299100.0061243
32
101.1184921100.2720263
33
98.46541181100.6719574
34
94.5875088100.7264617
35
92.7788617100.2599449
36
89.1920366899.49767208
37
89.1637133198.49781622
38
89.9684808997.44945295
39
92.2508264296.3538612
40
89.6104035395.39223853
41
87.099466394.06035651
42
90.1958866592.42352015
43
91.574509891.33125961
44
92.4822910190.64216941
45
94.3578111490.43164763
46
94.5475546990.58954257
47
92.992631491.12509437
48
91.040155891.50798618
49
91.4691983191.61515367
50
91.0650987291.53699086
51
89.2922944791.68246038
52
89.1600663591.9017432
53
90.9147002191.79816117
54
91.047860791.73218021
55
92.7131924391.58873718
56
93.0508470291.42427531
57
96.3998299391.27460454
58
99.8856068191.61532439
59
102.358560492.4998695
60
103.252619493.58880571
61
99.9439410694.80755778
62
100.708120495.87272244
63
99.876569597.02752784
64
96.7414714597.92371477
65
93.048379198.49307585
66
91.0485460898.52659451
67
90.9374412498.32636442
68
90.4492462397.78012555
69
89.0025490896.83648949
70
85.7333566995.50088835
71
83.9111530793.74896208
72
86.7605923592.14568328
73
87.4989174690.75093048
74
89.0679961489.51316527
75
91.8011422288.74581774
76
88.2861957488.62109405
77
88.885797688.34485902
78
87.9448372888.13969466
79
87.5663283487.88925376
80
88.1668324487.74563169
81
85.6115994587.98897926
82
84.9196128588.1590239
83
87.1339895887.97492595
84
85.4319521887.93843316
85
88.6287491887.57482877
86
87.8694059287.25758946
87
90.1212675187.21591048
88
92.7645089687.33945747
89
93.6608569787.82142464
90
96.4661322988.4308775
91
97.9377099989.26080749
92
94.4878654990.49341854
93
95.3566642891.45024381
94
93.3198756992.27251128
95
91.6153389693.06130363
96
92.4683393.35996261
97
95.3892256793.81985501
98
97.2303713494.34665083
99
98.1457838894.79323707
100
95.0492177695.24172976