Kens Stock Market.xlsx

	A	B	C	I
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/loss	4	%
6
7		Price	Moving Average
8		100
9		96.93595532
10		94.1732709
11		91.07143129
12		89.73790256
13		86.19471869
14		85.73384234
15		86.86408695
16		89.17459163
17		90.49951146
18		87.61880002	91.03853111
19		87.43748889	89.80041112
20		90.85744102	88.85056447
21		90.35244062	88.51898149
22		92.59186762	88.44708242
23		94.17073601	88.73247892
24		90.90682518	89.53008066
25		90.02040492	90.04737894
26		91.10700126	90.36301074
27		88.23025556	90.5562517
28		87.21662925	90.32932611
29		85.35846195	90.28910903
30		85.9603122	90.08120634
31		87.59579527	89.59149346
32		89.11126586	89.31582892
33		90.43390972	88.96776875
34		93.19859678	88.59408612
35		92.86301638	88.82326328
36		95.63765175	89.10752442
37		96.44140292	89.56058947
38		96.26359871	90.38170421
39		98.3813858	91.28640115
40		99.47137448	92.58869354
41		96.22425355	93.93979977
42		93.37150579	94.80264559
43		90.58451135	95.22866959
44		87.81321825	95.24372975
45		87.33427038	94.7051919
46		86.8757877	94.1523173
47		90.06867664	93.27613089
48		89.53880975	92.63885826
49		89.6221256	91.96637937
50		88.86390711	91.09045335
51		88.51764804	90.02970661
52		87.21691926	89.25904606
53		88.22681442	88.64358741
54		88.95101692	88.40781772
55		88.23134488	88.52159758
56		85.88762805	88.61130503
57		83.08107705	88.51248907
58		85.49626944	87.81372911
59		87.73362335	87.40947508
60		85.12727647	87.22062485
61		82.77023891	86.84696179
62		83.19539477	86.27222088
63		85.1629991	85.87006843
64		86.84273198	85.56368689
65		88.89610291	85.3528584
66		85.99500624	85.4193342
67		86.12955581	85.43007202
68		86.6882988	85.7349199
69		89.75656357	85.85412283
70		87.71825451	86.05641686
71		85.49443435	86.31551466
72		85.01019341	86.5879342
73		85.65861082	86.76941407
74		85.16455418	86.81897524
75		82.6316878	86.65115746
76		85.21319249	86.02471595
77		86.37082652	85.94653457
78		83.88364128	85.97066164
79		83.58899929	85.69019589
80		86.55483635	85.07343946
81		89.96107734	84.95709765
82		86.62749874	85.40376195
83		85.92972612	85.56549248
84		88.74028937	85.59260401
85		87.61721137	85.95017753
86		85.72850175	86.44872989
87		84.56123132	86.50026081
88		83.43430645	86.31930129
89		85.52374499	86.27436781
90		85.20489505	86.46784238
91		87.51908719	86.33284825
92		89.66261627	86.08864924
93		92.02906038	86.39216099
94		95.58909561	87.00209441
95		99.00512615	87.68697504
96		98.62694925	88.82576652
97		98.56561994	90.11561127
98		101.3732416	91.51605013
99		99.42073435	93.30994364
100		99.16646884	94.69964258