W9_RRR_Coca solution 2016.xlsm

W9_RRR_Coca solution 2016.xlsm - CCL Prices Graph Daily...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CCL Prices Page 1 Graph Daily History Download Code = CCL Date Open High Low Close Volume Adj Close 7/1/2013 12.55 12.58 12.32 12.4 2118400 10.24309 7/2/2013 12.6 12.83 12.58 12.81 2831700 10.58177 7/3/2013 12.84 12.84 12.43 12.43 1819400 10.26787 7/4/2013 12.56 12.79 12.51 12.56 1259500 10.37526 7/5/2013 12.73 12.75 12.54 12.57 1187700 10.38352 7/8/2013 12.61 12.62 12.4 12.45 1310300 10.28439 7/9/2013 12.62 12.64 12.5 12.61 1273200 10.41656 7/10/2013 12.7 12.84 12.67 12.83 4469700 10.59829 7/11/2013 12.77 12.8 12.25 12.5 4937300 10.3257 7/12/2013 12.75 12.96 12.54 12.9 3655200 10.65612 7/15/2013 12.96 13.09 12.65 12.73 2066300 10.51569 7/16/2013 12.84 12.88 12.67 12.74 2568900 10.52395 7/17/2013 12.82 12.86 12.74 12.81 1649300 10.58177 7/18/2013 12.95 13.09 12.85 13.05 2715300 10.78003 7/19/2013 13.2 13.26 13.06 13.26 5119300 10.9535 7/22/2013 13.26 13.31 13.05 13.07 2111300 10.79655 7/23/2013 13.22 13.29 13.12 13.25 2422200 10.94524 7/24/2013 13.29 13.4 13.19 13.19 1578800 10.89567 7/25/2013 13.25 13.25 12.975 13.04 1999700 10.77177 7/26/2013 13.07 13.12 12.97 13.04 1568700 10.77177 7/29/2013 12.91 13.03 12.82 12.85 1804200 10.61482 7/30/2013 12.95 12.95 12.67 12.67 2726100 10.46613 7/31/2013 12.84 12.95 12.785 12.85 3178400 10.61482 8/1/2013 12.9 13.03 12.83 12.9 2734200 10.65612 8/2/2013 13 13.04 12.69 12.79 3922500 10.56525 8/5/2013 12.8 12.87 12.75 12.77 1365100 10.54873 8/6/2013 12.92 12.94 12.72 12.92 2354400 10.67264 8/7/2013 12.97 12.98 12.78 12.85 2050400 10.61482 8/8/2013 12.97 13.03 12.86 12.88 2789400 10.6396 8/9/2013 12.95 12.99 12.64 12.64 2096400 10.44134 8/12/2013 12.64 12.75 12.64 12.68 1310500 10.47439 8/13/2013 12.78 12.81 12.7 12.76 1808600 10.54047 8/14/2013 12.9 12.9 12.78 12.81 1512900 10.58177 8/15/2013 12.9 12.9 12.735 12.83 2261300 10.59829 8/16/2013 12.83 12.88 12.69 12.78 1356900 10.55699 8/19/2013 12.89 12.95 12.7 12.74 1540400 10.52395 8/20/2013 12.2 12.4 11.91 12.04 6051700 9.94571 8/21/2013 12.06 12.43 12.04 12.38 4322000 10.22657 8/22/2013 12.33 12.435 12.27 12.34 3352200 10.19353 8/23/2013 12.13 12.32 12.095 12.14 2615000 10.32121 8/26/2013 12.16 12.27 12.13 12.16 1111900 10.33821 8/27/2013 12.21 12.28 12.16 12.28 2001400 10.44023 8/28/2013 12.14 12.2 12 12 2658900 10.20218 8/29/2013 12.02 12.225 12.02 12.21 1471200 10.38072 8/30/2013 12.21 12.28 12.195 12.28 2820600 10.44023 9/2/2013 12.47 12.5 12.37 12.4 1221600 10.54225 9/3/2013 12.41 12.49 12.35 12.42 1412800 10.55926 9/4/2013 12.4 12.4 12.18 12.2 2309100 10.37222 9/5/2013 12.25 12.3 12.12 12.17 1852200 10.34671 9/6/2013 12.27 12.28 12.075 12.17 2461800 10.34671 9/9/2013 12.19 12.24 12.1 12.18 1168700 10.35521
Image of page 1

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

View Full Document Right Arrow Icon
CCL Prices Page 2 9/10/2013 12.22 12.3 12.19 12.19 1293600 10.36372 9/11/2013 12.15 12.2 11.98 12 4391000 10.20218 9/12/2013 12 12.2 12 12.15 2040100 10.32971 9/13/2013 12.18 12.24 12.12 12.19 2302400 10.36372 9/16/2013 12.25 12.28 12.17 12.19 868400 10.36372 9/17/2013 12.17 12.35 12.15 12.33 2473400 10.48274 9/18/2013 12.33 12.38 12.26 12.36 1689400 10.50825 9/19/2013 12.41 12.55 12.24 12.25 2944200 10.41473 9/20/2013 12.24 12.34 12.17 12.34 2476700 10.49124 9/23/2013 12.23 12.28 12.12 12.12 1711800 10.3042 9/24/2013 12.01 12.18 12.01 12.18 1604900 10.35521 9/25/2013 12.25 12.38 12.23 12.35 2586500 10.49975 9/26/2013 12.37 12.44 12.25 12.44 2162700 10.57626 9/27/2013 12.46 12.49 12.405 12.48 1955200 10.61027 9/30/2013 12.43 12.465 12.26 12.26 1644900 10.42323 10/1/2013 12.15 12.32 12.15 12.2 1926800 10.37222 10/2/2013 12.23 12.33 12.15 12.33 2888900 10.48274 10/3/2013 12.3 12.4 12.24 12.4 2259000 10.54225 10/4/2013 12.38 12.4 12.28 12.3 1879800 10.45724 10/7/2013 12.39 12.48 12.31 12.33 1289800 10.48274 10/8/2013 12.39 12.43 12.26 12.38 2384500 10.52525 10/9/2013 12.36 12.385 12.3 12.33 1867900 10.48274 10/10/2013 12.28 12.33 12.25 12.32 1286800 10.47424 10/11/2013 12.35 12.46 12.35 12.41 1500900 10.55076 10/14/2013 12.43 12.48 12.33 12.4 785800 10.54225 10/15/2013 12.5 12.55 12.365 12.39 1807900 10.53375 10/16/2013 12.35 12.485 12.35 12.47 1615700 10.60177 10/17/2013 12.55 12.68 12.51 12.55 1811800 10.66978 10/18/2013 12.62 12.66 12.5 12.57 1181500 10.68679 10/21/2013 12.6 12.63 12.49 12.59 1304600 10.70379 10/22/2013 12.65 12.75 12.62 12.71 1690200 10.80581 10/23/2013 12.78 12.83 12.68 12.74 2526800 10.83132 10/24/2013 12.8 12.92 12.76 12.78 2024000 10.86532 10/25/2013 12.84 12.93 12.82 12.9 2383700 10.96735 10/28/2013 12.96 13.05 12.95 13.04 2713800 11.08637 10/29/2013 12.98 13 12.835 12.88 1340300 10.95034 10/30/2013 12.75 12.96 12.75 12.89 1610900 10.95884 10/31/2013 12.87 13.01 12.865 12.9 1604600 10.96735 11/1/2013 12.89 12.99 12.88 12.89 1086700 10.95884 11/4/2013 12.41 12.47 12.21 12.28 4029500 10.44023 11/5/2013 12.3 12.37 12.15 12.29 2493600 10.44873 11/6/2013 12.21 12.28 12.15 12.25 2590700 10.41473 11/7/2013 12.17 12.17 11.97 11.97 4182800 10.17668 11/8/2013 11.95 12.11 11.9 11.99 2835400 10.19368 11/11/2013 12.1 12.14 11.99 11.99 2285900 10.19368 11/12/2013 12.02 12.18 12.02 12.15 1875300 10.32971 11/13/2013 12.16 12.25 11.95 11.97 2283200 10.17668 11/14/2013 12.09 12.13 12.01 12.08 1305400 10.2702 11/15/2013 12.08 12.23 12.05 12.23 1508000 10.39772 11/18/2013 12.25 12.33 12.17 12.32 2185300 10.47424 11/19/2013 12.34 12.375 12.28 12.34 2089400 10.49124 11/20/2013 12.29 12.3 12.15 12.17 1877300 10.34671 11/21/2013 12.12 12.16 12.08 12.08 1433100 10.2702 11/22/2013 12.12 12.22 12.12 12.17 1477000 10.34671
Image of page 2
CCL Prices Page 3 11/25/2013 12.24 12.31 12.18 12.2 1638600 10.37222 11/26/2013 12.28 12.33 12.22 12.29 2176000 10.44873 11/27/2013 12.3 12.32 12.2 12.24 1025900 10.40623 11/28/2013 12.21 12.25 12.13 12.15 962200 10.32971 11/29/2013 12.2 12.24 12.09 12.09 1528500 10.2787 12/2/2013 12.2 12.34 12.08 12.11 1706700 10.2957 12/3/2013 12.08 12.35 12.08 12.27 1811100 10.43173 12/4/2013 12.14 12.22 12.12 12.14 1812900 10.32121 12/5/2013 12.1 12.14 11.95 11.95 1886700 10.15967 12/6/2013 11.93 11.98 11.84 11.84 1590500 10.06615 12/9/2013 11.93 12.03 11.925 12 1634700 10.20218 12/10/2013 11.9 11.93 11.77 11.77 2098100 10.00664 12/11/2013 11.75 11.78 11.46 11.46 4713100 9.74308 12/12/2013 11.47 11.79 11.47 11.65 2937500 9.90462 12/13/2013 11.53 11.7 11.5 11.64 1847900 9.89612 12/16/2013 11.78 11.78 11.46 11.52 1887600 9.79409 12/17/2013 11.55 11.65 11.52 11.59 1425200 9.85361 12/18/2013 11.6 11.63 11.515 11.55 1387300 9.8196 12/19/2013 11.62 11.77 11.525 11.77 2592900 10.00664 12/20/2013 11.73 11.85 11.65 11.79 4383400 10.02364 12/23/2013 11.86 12 11.83 12 1566600 10.20218 12/24/2013 12 12.225 11.97 12.17 995900 10.34671 12/27/2013 12.23 12.23 12.04 12.09 416800 10.2787 12/30/2013 12.18 12.18 12.04 12.12 644600 10.3042 12/31/2013 12 12.11 12 12.03 672200 10.22769 1/2/2014 12.04 12.15 12.04 12.1 481500 10.2872 1/3/2014 12.11 12.12 12.01 12.07 1189300 10.26169 1/6/2014 12.07 12.1 11.94 12 853000 10.20218 1/7/2014 11.95 12.04 11.92 11.98 1088800 10.18518 1/8/2014 12.06 12.12 11.99 12 1157400 10.20218 1/9/2014 12.01 12.075 11.975 12.07 890700 10.26169 1/10/2014 12.07 12.16 11.995 12.14 1013500 10.32121 1/13/2014 12.2 12.2 12.05 12.17 930600 10.34671 1/14/2014 12.03 12.11 12 12.01 1329200 10.21068 1/15/2014 12.1 12.13 11.95 11.98 2618300 10.18518 1/16/2014 12.1 12.3 12.07 12.3 2343400 10.45724 1/17/2014 12.29 12.35 12.22 12.33 1080600 10.48274 1/20/2014 12.33 12.33 12.155 12.2 1190900 10.37222 1/21/2014 12.2 12.3 12.12 12.25 719400 10.41473 1/22/2014 12.3 12.3 12.04 12.07 1882000 10.26169 1/23/2014 12.05 12.095 11.95 12.01 1767300 10.21068 1/24/2014 12 12.09 11.95 11.98 1699800 10.18518 1/28/2014 11.9 11.93 11.75 11.76 2751900 9.99814 1/29/2014 11.85 11.93 11.81 11.9 1173000 10.11716 1/30/2014 11.84 11.875 11.7 11.79 1739700 10.02364 1/31/2014 11.82 11.87 11.64 11.69 2758500 9.93863 2/3/2014 11.66 11.85 11.66 11.71 1556200 9.95563 2/4/2014 11.6 11.65 11.375 11.41 3870100 9.70057 2/5/2014 11.48 11.52 11.3 11.31 2172200 9.61556 2/6/2014 11.38 11.55 11.36 11.55 2145900 9.8196 2/7/2014 11.61 11.62 11.37 11.39 2876100 9.68357 2/10/2014 11.39 11.55 11.39 11.53 2312700 9.8026 2/11/2014 11.55 11.79 11.55 11.76 2792200 9.99814 2/12/2014 11.75 11.83 11.69 11.81 2603600 10.04065
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern