{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HW #1 - Sheet1 Date,Open,High,Low,Close,Volume,Adj...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Date,Open,High,Low,Close,Volume,Adj Close,Change,In Percent,Sorted,,Positive Rate of Return ratio, 12/1/2009,54.85,55.08,52.31,53.45,12474800,53.45,-0.015291083,-1.53%,-15.95%,,0.151515152, 11/2/2009,49.81,55.09,49.52,54.55,15896900,54.28,0.098118551,9.81%,-6.80%,,, 10/1/2009,49.07,52,48.73,49.68,17802400,49.43,0.012080262,1.21%,-4.57%,,W, 9/1/2009,50.81,52.1,48.73,49.09,18941100,48.84,-0.034973325,-3.50%,-4.49%,,A, 8/3/2009,50.22,52.56,48.75,50.87,17214000,50.61,0.025324149,2.53%,-3.50%,,L, 7/1/2009,48.55,50.43,47.35,49.88,17442300,49.36,0.029835176,2.98%,-3.26%,,M, 6/1/2009,50.18,51.75,48.02,48.44,19751700,47.93,-0.026208858,-2.62%,-2.66%,,A, 5/1/2009,50.5,51.38,48.12,49.74,19494400,49.22,-0.007861318,-0.79%,-2.62%,,R, 4/1/2009,51.38,54.57,47.64,50.4,22551300,49.61,-0.032566303,-3.26%,-2.35%,,T, 3/2/2009,48.81,53,47,52.1,25748800,51.28,0.064121187,6.41%,-2.27%,,, 2/2/2009,46.57,50.67,46.25,49.24,28273400,48.19,0.044882914,4.49%,-1.53%,,, 1/2/2009,55.98,57.51,46.92,47.12,26935900,46.12,-0.159467833,-15.95%,-0.79%,,Standard Dev., 12/1/2008,55.37,59.23,52.22,56.06,21967800,54.87,0.007528461,0.75%,-0.33%,,4.708844734, 11/3/2008,56.76,57.25,50.2,55.88,27572100,54.46,0.001287001,0.13%,-0.22%,,, 10/1/2008,59.51,60.3,47.4,55.81,33669200,54.39,-0.068026045,-6.80%,0.00%,,, 9/2/2008,59.9,63.85,57.74,59.89,27956100,58.36,0.013898541,1.39%,0.05%,,, 8/1/2008,58.75,61,56.81,59.07,19461500,57.56,0.011599297,1.16%,0.13%,,, 7/1/2008,56,59.56,55.34,58.62,23372300,56.9,0.043079743,4.31%,0.75%,,, 6/2/2008,57.41,59.95,55.85,56.2,22170900,54.55,-0.026588151,-2.66%,1.08%,,, 5/1/2008,58.2,59.09,55.05,57.74,19291100,56.04,0,0.00%,1.16%,,, 4/1/2008,53.19,59.04,52.81,57.98,20886300,56.04,0.100549882,10.05%,1.21%,,, 3/3/2008,49.43,54.15,48.64,52.68,25488700,50.92,0.067505241,6.75%,1.31%,,, 2/1/2008,50.9,51.57,47.84,49.59,24842400,47.7,-0.022741242,-2.27%,1.39%,,, 1/2/2008,47.41,51.3,43.11,50.74,30515500,48.81,0.067585302,6.76%,2.07%,,, 12/3/2007,47.71,50.05,46.87,47.53,15835100,45.72,-0.003270111,-0.33%,2.53%,,, 11/1/2007,44.7,48.23,42.5,47.9,21366000,45.87,0.05959806,5.96%,2.98%,,, 10/1/2007,43.83,47.7,43.27,45.21,19963000,43.29,0.035645933,3.56%,3.56%,,, 9/4/2007,43.51,45.05,42.09,43.65,20484700,41.8,0.000478698,0.05%,4.31%,,, 8/1/2007,46.05,48.42,42.92,43.63,25314000,41.78,-0.04568296,-4.57%,4.49%,,, 7/2/2007,48.2,49.26,45.73,45.95,17741300,43.78,-0.044938918,-4.49%,5.96%,,, 6/1/2007,47.9,51.44,47.69,48.11,21795000,45.84,0.010804851,1.08%,6.41%,,, 5/1/2007,47.92,48.88,46.32,47.6,14849200,45.35,-0.00220022,-0.22%,6.75%,,, 4/2/2007,47.06,49.95,46.83,47.92,13556600,45.45,0.020660229,2.07%,6.76%,,, 3/1/2007,47.78,48.32,45.06,46.95,16479800,44.53,-0.023464912,-2.35%,9.81%,,, 2/1/2007,47.51,50.42,47.44,48.31,15754400,45.6,0.013108198,1.31%,10.05%,,, 1/3/2007,47.09,48.78,46.51,47.69,15240700,45.01,,,,,, ,,,,,,,,,,,Positive Rate of Return Ratio, Date,Open,High,Low,Close,Volume,Adj Close,Change,In Percentage,,Sorted,, 12/1/2009,30.44,32.75,30.3,32.25,11705500,32.25,-0.079317269,-7.93%,,-7.93%,-0.117647059, 11/2/2009,27.38,30.93,27.01,30.22,12564600,29.88,-0.10421286,-10.42%,,-20.61%,, 10/1/2009,27.76,29.98,26.84,27.37,11404100,27.06,0.003314917,0.33%,,-10.58%,, 9/1/2009,25.89,28.68,25.25,27.46,14444500,27.15,-0.054778555,-5.48%,,-10.42%,,D 8/3/2009,25.52,27.3,24.89,26.04,12957500,25.74,-0.036649215,-3.66%,,-8.64%,,I 7/1/2009,23.5,26.84,22.05,25.12,13940600,24.83,-0.076756288,-7.68%,,-8.26%,,S 6/1/2009,24.83,25.64,22.55,23.33,10968900,23.06,0.036758563,3.68%,,-7.68%,,N 5/1/2009,21.76,26.29,21.12,24.22,17036900,23.94,-0.105773672,-10.58%,,-6.60%,,E 4/1/2009,17.92,22.57,17.84,21.9,18716700,21.65,-0.206128134,-20.61%,,-5.48%,,Y 3/2/2009,16.48,19.14,15.14,18.16,17290700,17.95,-0.082629674,-8.26%,,-3.66%,, 2/2/2009,20.08,20.79,16.42,16.77,22002400,16.58,0.188845401,18.88%,,-3.61%,,Standard Dev. 1/2/2009,22.76,24.83,19.95,20.68,14693100,20.44,0.088720464,8.87%,,-3.37%,,4.900780421 12/1/2008,22.04,26.1,20.27,22.69,15933400,22.43,-0.022799818,-2.28%,,-2.35%,,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Sheet1 Page 2 11/3/2008,25.85,26.24,18.6,22.52,20977500,21.93,0.131141046,13.11%,,-2.28%,, 10/1/2008,30.3,31.06,21.25,25.91,20856800,25.24,0.155570425,15.56%,,-1.82%,, 9/2/2008,32.74,34.85,29.25,30.69,16750600,29.89,0.05141225,5.14%,,-1.60%,,
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}