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.7765832
10
102.5128957
11
106.2319256
12
106.8862242
13
107.0500198
14
106.8226938
15
106.7986585
16
110.0891184
17
109.9291625
18
108.3727116105.9097282
19
111.4093814106.7469993
20
114.1687033107.6102792
21
112.5647889108.7758599
22
108.8784248109.4091462
23
110.9791274109.6083663
24
110.750641110.0012771
25
108.7079537110.3940718
26
108.8658954110.5850013
27
108.5666516110.462679
28
107.4859328110.3264279
29
106.2274501110.23775
30
104.8788184109.7195569
31
108.458611108.7905684
32
108.482335108.3799506
33
108.401831108.3403416
34
108.0983418108.082612
35
106.5221624107.8173821
36
103.2107196107.598803
37
102.0893047107.0332854
38
98.48351823106.3855507
39
98.92560424105.4853092
40
100.6689048104.7551247
41
101.8028147104.3341333
42
98.20523437103.6685537
43
99.97985653102.6408436
44
101.7907085101.7986461
45
98.99661468101.1678828
46
99.72677465100.415328
47
101.0989803100.0669335
48
102.530161199.9679011
49
102.6215217100.3725654
50
100.6132517100.7421571
51
101.1776408100.7365918
52
97.92918979100.6740744
53
98.51401379100.64647
54
97.84511544100.4998857
55
94.82688134100.1053264
56
92.59729399.68835306
57
92.1871060498.97540489
58
90.7738853398.08421746
59
87.2574407796.90858988
60
86.1903788495.37218179
61
86.8313565693.92989451
62
86.6712549492.49526609
63
88.0512178591.36947261
64
85.7755649590.32319301
65
85.3060317389.11623796
66
87.7951355688.164153
67
90.7242436887.68393726
68
92.4554986187.53765102
69
89.1124694387.70581235
70
86.2822926787.89131521
71
88.8787102587.9005066
72
88.2712802788.10524197
73
89.1695818888.2652445
74
90.3454247588.3770809
75
86.8332130388.83406688
76
83.8391077488.98678501
77
83.3792635188.59118223
78
85.7717395887.85668421
79
86.5419077187.18830831
80
88.5460856986.93125214
81
91.1959746887.15763144
82
87.9919147587.38935788
83
90.7358247587.36142133
84
89.1369128187.51804562
85
87.1376299387.39719443
86
88.9795050487.42763612
87
90.7768228587.94167585
88
89.4726676988.68143178
89
86.5261188489.05152459
90
86.5165059989.0499457
91
89.9465637488.84698773
92
93.3343437888.72204664
93
92.2885053389.25628954
94
94.0162784689.4115576
95
91.6893168689.89949417
96
93.6297820490.35466286
97
93.1887156890.81969056
98
90.99599691.06087984
99
93.5359778891.21321267
100
91.4110113391.91419858