Computer Science Assignment work
Ravi12
Week4-HSBC_Expected_Returns_Risk_Analysis.xlsx
HSBC_StockandMarket_Risk_Return
| date |
close.HSBC |
close.MK |
ExpectedReturn.HSBC |
ExpectedReturn.MK |
| 3/4/14 |
631.700012 |
6823.799805 |
| 3/5/14 |
622.599976 |
6775.399902 |
| 3/6/14 |
625.700012 |
6788.5 |
| 3/7/14 |
619.599976 |
6712.700195 |
| 3/10/14 |
615.700012 |
6689.5 |
| 3/11/14 |
616.599976 |
6685.5 |
| 3/12/14 |
599.200012 |
6620.899902 |
| 3/13/14 |
597.200012 |
6553.799805 |
| 3/14/14 |
598.099976 |
6527.899902 |
| 3/17/14 |
597 |
6568.399902 |
| 3/18/14 |
597.900024 |
6605.299805 |
| 3/19/14 |
591.799988 |
6573.100098 |
| 3/20/14 |
594.200012 |
6542.399902 |
| 3/21/14 |
605.700012 |
6557.200195 |
| 3/24/14 |
606.200012 |
6520.399902 |
| 3/25/14 |
611.700012 |
6604.899902 |
| 3/26/14 |
611.200012 |
6605.299805 |
| 3/27/14 |
608.299988 |
6588.299805 |
| 3/28/14 |
611 |
6615.600098 |
| 3/31/14 |
607.5 |
6598.399902 |
| 4/1/14 |
613 |
6652.600098 |
| 4/2/14 |
611.200012 |
6659 |
| 4/3/14 |
610.5 |
6649.100098 |
| 4/4/14 |
612.5 |
6695.600098 |
| 4/7/14 |
606.200012 |
6622.799805 |
| 4/8/14 |
605 |
6590.700195 |
| 4/9/14 |
612.700012 |
6635.600098 |
| 4/10/14 |
618.700012 |
6642 |
| 4/11/14 |
617.599976 |
6561.700195 |
| 4/14/14 |
621.400024 |
6583.799805 |
| 4/15/14 |
617.900024 |
6541.600098 |
| 4/16/14 |
616.299988 |
6584.200195 |
| 4/17/14 |
617.400024 |
6625.299805 |
| 4/22/14 |
614.900024 |
6681.799805 |
| 4/23/14 |
612.200012 |
6674.700195 |
| 4/24/14 |
613 |
6703 |
| 4/25/14 |
602.5 |
6685.700195 |
| 4/28/14 |
600.900024 |
6700.200195 |
| 4/29/14 |
611.099976 |
6769.899902 |
| 4/30/14 |
604.099976 |
6780 |
| 5/1/14 |
607.400024 |
6808.899902 |
| 5/2/14 |
605.700012 |
6822.399902 |
| 5/6/14 |
604.099976 |
6798.600098 |
| 5/7/14 |
596.5 |
6796.399902 |
| 5/8/14 |
593.799988 |
6839.299805 |
| 5/9/14 |
596 |
6814.600098 |
| 5/12/14 |
606.299988 |
6851.799805 |
| 5/13/14 |
611 |
6873.100098 |
| 5/14/14 |
617.5 |
6878.5 |
| 5/15/14 |
625 |
6840.899902 |
| 5/16/14 |
632.5 |
6855.799805 |
| 5/19/14 |
632.900024 |
6844.600098 |
| 5/20/14 |
627.099976 |
6802 |
| 5/21/14 |
618.5 |
6821 |
| 5/22/14 |
616.099976 |
6820.600098 |
| 5/23/14 |
614.799988 |
6815.799805 |
| 5/27/14 |
621.200012 |
6844.899902 |
| 5/28/14 |
629.200012 |
6851.200195 |
| 5/29/14 |
627.900024 |
6871.299805 |
| 5/30/14 |
629.200012 |
6844.5 |
| 6/2/14 |
626.799988 |
6864.100098 |
| 6/3/14 |
624 |
6836.299805 |
| 6/4/14 |
623 |
6818.600098 |
| 6/5/14 |
620.900024 |
6813.5 |
| 6/6/14 |
624 |
6858.200195 |
| 6/9/14 |
628.299988 |
6875 |
| 6/10/14 |
624.900024 |
6873.600098 |
| 6/11/14 |
620.900024 |
6838.899902 |
| 6/12/14 |
621 |
6843.100098 |
| 6/13/14 |
616.400024 |
6777.899902 |
| 6/16/14 |
612 |
6754.600098 |
| 6/17/14 |
612.099976 |
6766.799805 |
| 6/18/14 |
610.099976 |
6778.600098 |
| 6/19/14 |
610.299988 |
6808.100098 |
| 6/20/14 |
609.400024 |
6825.200195 |
| 6/23/14 |
606.400024 |
6800.600098 |
| 6/24/14 |
605.400024 |
6787.100098 |
| 6/25/14 |
601.599976 |
6733.600098 |
| 6/26/14 |
594.599976 |
6735.100098 |
| 6/27/14 |
597 |
6757.799805 |
| 6/30/14 |
592.900024 |
6743.899902 |
| 7/1/14 |
598.200012 |
6802.899902 |
| 7/2/14 |
601.299988 |
6816.399902 |
| 7/3/14 |
607.099976 |
6865.200195 |
| 7/4/14 |
607.299988 |
6866.100098 |
| 7/7/14 |
603.299988 |
6823.5 |
| 7/8/14 |
594.5 |
6738.5 |
| 7/9/14 |
596.5 |
6718 |
| 7/10/14 |
589 |
6672.399902 |
| 7/11/14 |
592.299988 |
6690.200195 |
| 7/14/14 |
599.400024 |
6746.100098 |
| 7/15/14 |
596.599976 |
6710.5 |
| 7/16/14 |
605.099976 |
6784.700195 |
| 7/17/14 |
599.200012 |
6738.299805 |
| 7/18/14 |
599.200012 |
6749.5 |
| 7/21/14 |
597.099976 |
6728.399902 |
| 7/22/14 |
604.900024 |
6795.299805 |
| 7/23/14 |
607.299988 |
6798.200195 |
| 7/24/14 |
621 |
6821.5 |
| 7/25/14 |
621.700012 |
6791.600098 |
| 7/28/14 |
630.900024 |
6788.100098 |
| 7/29/14 |
637.5 |
6807.799805 |
| 7/30/14 |
641.5 |
6773.399902 |
| 7/31/14 |
636.400024 |
6730.100098 |
| 8/1/14 |
629.299988 |
6679.200195 |
| 8/4/14 |
635 |
6677.5 |
| 8/5/14 |
634 |
6682.5 |
| 8/6/14 |
632.099976 |
6636.200195 |
| 8/7/14 |
628.700012 |
6597.399902 |
| 8/8/14 |
627.5 |
6567.399902 |
| 8/11/14 |
625.900024 |
6632.799805 |
| 8/12/14 |
630.099976 |
6632.399902 |
| 8/13/14 |
638.299988 |
6656.700195 |
| 8/14/14 |
651.400024 |
6685.299805 |
| 8/15/14 |
643.5 |
6689.100098 |
| 8/18/14 |
646 |
6741.299805 |
| 8/19/14 |
648.400024 |
6779.299805 |
| 8/20/14 |
640.799988 |
6755.5 |
| 8/21/14 |
640.900024 |
6777.700195 |
| 8/22/14 |
644.200012 |
6775.299805 |
| 8/26/14 |
648.700012 |
6822.799805 |
| 8/27/14 |
649.299988 |
6830.700195 |
| 8/28/14 |
647 |
6805.799805 |
| 8/29/14 |
652 |
6819.799805 |
| 9/1/14 |
647.5 |
6825.299805 |
| 9/2/14 |
647.099976 |
6829.200195 |
| 9/3/14 |
657.900024 |
6873.600098 |
| 9/4/14 |
660.200012 |
6878 |
| 9/5/14 |
660.400024 |
6855.100098 |
| 9/8/14 |
662.099976 |
6834.799805 |
| 9/9/14 |
660.5 |
6829 |
| 9/10/14 |
661 |
6830.100098 |
| 9/11/14 |
654.400024 |
6799.600098 |
| 9/12/14 |
657.400024 |
6807 |
| 9/15/14 |
658.200012 |
6804.200195 |
| 9/16/14 |
659.200012 |
6792.200195 |
| 9/17/14 |
656.599976 |
6780.899902 |
| 9/18/14 |
661.900024 |
6819.299805 |
| 9/19/14 |
663.599976 |
6837.899902 |
| 9/22/14 |
657.700012 |
6773.600098 |
| 9/23/14 |
651.700012 |
6676.100098 |
| 9/24/14 |
653 |
6706.299805 |
| 9/25/14 |
646.5 |
6639.700195 |
| 9/26/14 |
650.200012 |
6649.399902 |
| 9/29/14 |
635 |
6646.600098 |
| 9/30/14 |
626.099976 |
6622.700195 |
| 10/1/14 |
620.5 |
6557.5 |
| 10/2/14 |
613.900024 |
6446.399902 |
| 10/3/14 |
632.200012 |
6527.899902 |
| 10/6/14 |
634 |
6563.700195 |
| 10/7/14 |
630.799988 |
6495.600098 |
| 10/8/14 |
634.400024 |
6482.200195 |
| 10/9/14 |
625.799988 |
6431.899902 |
| 10/10/14 |
620.299988 |
6340 |
| 10/13/14 |
632.799988 |
6366.200195 |
| 10/14/14 |
634.599976 |
6392.700195 |
| 10/15/14 |
617 |
6211.600098 |
| 10/16/14 |
617.099976 |
6195.899902 |
| 10/17/14 |
623.799988 |
6310.299805 |
| 10/20/14 |
617.299988 |
6267.100098 |
| 10/21/14 |
625.200012 |
6372.299805 |
| 10/22/14 |
631.099976 |
6399.700195 |
| 10/23/14 |
632.099976 |
6419.200195 |
| 10/24/14 |
629.799988 |
6388.700195 |
| 10/27/14 |
622 |
6363.5 |
| 10/28/14 |
625.599976 |
6402.200195 |
| 10/29/14 |
628 |
6453.899902 |
| 10/30/14 |
629.099976 |
6463.600098 |
| 10/31/14 |
639.5 |
6546.5 |
| 11/3/14 |
627.900024 |
6488 |
| 11/4/14 |
624.299988 |
6454 |
| 11/5/14 |
633.400024 |
6539.100098 |
| 11/6/14 |
635.700012 |
6551.200195 |
| 11/7/14 |
630 |
6567.200195 |
| 11/10/14 |
635.700012 |
6611.299805 |
| 11/11/14 |
637.5 |
6627.399902 |
| 11/12/14 |
635.599976 |
6611 |
| 11/13/14 |
637.900024 |
6635.5 |
| 11/14/14 |
642.700012 |
6654.399902 |
| 11/17/14 |
640 |
6672 |
| 11/18/14 |
640 |
6709.100098 |
| 11/19/14 |
633.5 |
6696.600098 |
| 11/20/14 |
625.299988 |
6678.899902 |
| 11/21/14 |
631.5 |
6750.799805 |
| 11/24/14 |
628.599976 |
6729.799805 |
| 11/25/14 |
636.5 |
6731.100098 |
| 11/26/14 |
634 |
6729.200195 |
| 11/27/14 |
631.799988 |
6723.399902 |
| 11/28/14 |
637 |
6722.600098 |
| 12/1/14 |
625 |
6656.399902 |
| 12/2/14 |
635.700012 |
6742.100098 |
| 12/3/14 |
633 |
6716.600098 |
| 12/4/14 |
628 |
6679.399902 |
| 12/5/14 |
643.099976 |
6742.799805 |
| 12/8/14 |
639.299988 |
6672.200195 |
| 12/9/14 |
622.700012 |
6529.5 |
| 12/10/14 |
620.900024 |
6500 |
| 12/11/14 |
615.299988 |
6461.700195 |
| 12/12/14 |
603.400024 |
6300.600098 |
| 12/15/14 |
592.200012 |
6182.700195 |
| 12/16/14 |
603.5 |
6331.799805 |
| 12/17/14 |
592.900024 |
6336.5 |
| 12/18/14 |
596.799988 |
6466 |
| 12/19/14 |
607.5 |
6545.299805 |
| 12/22/14 |
612 |
6576.700195 |
| 12/23/14 |
612.599976 |
6598.200195 |
| 12/24/14 |
614.200012 |
6609.899902 |
| 12/29/14 |
619.900024 |
6633.5 |
| 12/30/14 |
609.200012 |
6547 |
| 12/31/14 |
608.599976 |
6566.100098 |
| 1/2/15 |
612 |
6547.799805 |
| 1/5/15 |
603.900024 |
6417.200195 |
| 1/6/15 |
593.700012 |
6366.5 |
| 1/7/15 |
601 |
6419.799805 |
| 1/8/15 |
606.200012 |
6570 |
| 1/9/15 |
602 |
6501.100098 |
| 1/12/15 |
602.700012 |
6501.399902 |
| 1/13/15 |
604.200012 |
6542.200195 |
| 1/14/15 |
590.099976 |
6388.5 |
| 1/15/15 |
596.900024 |
6498.799805 |
| 1/16/15 |
594 |
6550.299805 |
| 1/19/15 |
596.299988 |
6585.5 |
| 1/20/15 |
595.700012 |
6620.100098 |
| 1/21/15 |
605.599976 |
6728 |
| 1/22/15 |
620.299988 |
6796.600098 |
| 1/23/15 |
624.799988 |
6832.799805 |
| 1/26/15 |
627.099976 |
6852.399902 |
| 1/27/15 |
618 |
6811.600098 |
| 1/28/15 |
618.200012 |
6825.899902 |
| 1/29/15 |
618.099976 |
6810.600098 |
| 1/30/15 |
609.599976 |
6749.399902 |
| 2/2/15 |
612.400024 |
6782.600098 |
| 2/3/15 |
617.5 |
6871.799805 |
| 2/4/15 |
615.599976 |
6860 |
| 2/5/15 |
613.400024 |
6865.899902 |
| 2/6/15 |
620.799988 |
6853.399902 |
| 2/9/15 |
610.599976 |
6837.200195 |
| 2/10/15 |
597.799988 |
6829.100098 |
| 2/11/15 |
592.099976 |
6818.200195 |
| 2/12/15 |
596.400024 |
6828.100098 |
| 2/13/15 |
598.200012 |
6873.5 |
| 2/16/15 |
601.099976 |
6857.100098 |
| 2/17/15 |
602.799988 |
6898.100098 |
| 2/18/15 |
605.5 |
6898.100098 |
| 2/19/15 |
601.900024 |
6888.899902 |
| 2/20/15 |
605.200012 |
6915.200195 |
| 2/23/15 |
577.200012 |
6912.200195 |
| 2/24/15 |
581.599976 |
6949.600098 |
| 2/25/15 |
577.400024 |
6935.399902 |
| 2/26/15 |
581.599976 |
6949.700195 |
| 2/27/15 |
577.299988 |
6946.700195 |
| 3/2/15 |
582.900024 |
6940.600098 |
| 3/3/15 |
580.900024 |
6889.100098 |
| 3/4/15 |
586.099976 |
6919.200195 |
| 3/5/15 |
570.599976 |
6961.100098 |
