Question no 1)

Choose any five securities at random and determine the average returns for each company for the 120 months along with the variance and standard deviation of these returns. Next construct an equally weighted portfolio made up of the five securities, and determine the series of monthly returns. On this basis determine the average return for the portfolio and the associated variance and standard deviation. The averages, variances, and standard deviations can be derived using the relevant Excel functions. Utilise the Excel specification for population variance and standard deviation STDEVP and VARP in the calculations. Explain the discuss the relationship between the average returns, average variance, and average standard deviation for the five securities and the average returns, variance, and standard deviation for the portfolio.

Monthly Return Data for a sample of companies drawn from the FTSE ALL SHARE that have traded continuously from January 2009 to December 2018. 0.2885 Name 1 30/01/2009 2 27/02/2009 3 31/03/2009 4 30/04/2009 5 29/05/2009 6 30/06/2009 7 31/07/2009 8 31/08/2009 9 30/09/2009 10 30/10/2009 11 30/11/2009 12 31/12/2009 13 29/01/2010 14 26/02/2010 15 31/03/2010 16 30/01/2010 17 31/05/2010 18 30/06/2010 19 30/07/2010 20 31/08/2010 21 30/09/2010 22 29/10/2010 30/11/2010 24 31/12/2010 25 31/01/2011 26 26/02/2011 27 31/03/2011 28 29/01/2011 29 31/08/2011 30 30/06/2011 31 29/07/2011 32 31/08/2011 33 30/09/2011 34 31/10/2011 35 30/12/2011 36 30/12/2011 37 31/01/2012 36 38 20/02/2012 39 30/03/2012 10 30/01/2012 31/05/2012 12 29/06/2012 43 31/07/2012 44 31/08/2012 15 28/09/2012 16 31/10/2012 47 30/11/2012 48 31/12/2012 19 31/01/2013 50 28/02/2013 51 29/03/2015 52 30/01/2013 53 31/05/2013 34 28/06/2013 55 31/07/2013 56 30/08/2013 57 30/09/2013 58 31/10/2013 59 29/11/2013 60 31/12/2013 61 31/01/2011 62 28/02/2014 $3 31/03/2011 61 30/01/2011 05 30/05/2011 66 30/06/2011 67 31/07/2014 de 29/08/2014 59 30/09/2014 70 31/10/2014 71 28/11/2011 72 31/12/2011 73 30/01/2015 74 27/02/2015 75 31/03/2015 76 30/01/2015 77 29/05/2015 78 30/06/2015 79 31/07/2015 30 31/08/2015 81 30/09/2015 82 30/10/2015 03 30/11/2015 84 31/12/2015 25 29/01/2015 86 29/02/2016 87 31/03/2016 88 29/01/2018 89 31/05/2016 90 30/06/2016 91 29/07/2016 92 31/08/2016 93 30/09/2016 94 31/10/2016 95 30/11/2016 96 30/12/2016 97 31/01/2017 98 28/02/2017 99 31/03/2017 100 20/01/2017 101 31/05/2017 102 30/06/2017 102 31/07/2017 104 31/08/2017 105 29/09/2017 106 31/10/2017 107 30/11/2017 100 29/12/2017 100 11/01/2018 110 28/02/2018 111 30/09/2010 112 30/04/2018 112 31/05/2018 114 30/06/2018 115 31/07/2018 116 31/08/2018 117 28/09/2018 118 31/10/2018 119 30/11/2018 120 31/12/2018 FTSE ALL SHARE IMPRINT GROUP 68 HOLDINGS AGGREKO ANGLO AMERICAN ANGLO-EASTERN PLTNS ANTOFAGASTA APTITUDE SOFTWARE GROUP ASHTEAD GROUP ASSOCIATED BRIT, FOODS ASSURA Name FTSE ALL SHARE -0.05901 -0.12067 -0.00579-0.12282 - 18111 -0.05665 -0.01293 -0.04540 -0.00433 -0.09178 0.05308 30/01/2009 -0.00901 0,07173 0.16031 020845 0 09504 - 20532 0.01235 0.05298 0.00000 -0.14375 001810 033972 27/02/2000 -0.07175 0.02820 0.03182 -0.04429 0.37456 018482 0.15979 0.14076 0.09512 0.15328 -0.01613 -0.10489 31/03/2009 0.02820 0.09520 0.26872 -0.01390 0.1753 25126 0.24014 0.18917 0.20673 0.59194 012100 0.40435 30/01/2009 0.09520 0.03662 0.01910 0.06122 0.01298 0.19744 0.05278 005610 -0.00913 -0.17857 0.01811 0.06827 29/05/2000 0.03662 -0.03576 -0.24361 -0.00481 -0.11442 -0.00269 -0,03117 -0.05598 0.26371 0.09862 0.04309 -0.09231 30/06/2009 -0.03576 0.08351 -0.05405 -0.20531 0.05495 0.0941 0.01895 -0.02074 0.09692 0.04393 0.03878 31/07/2009 0.08351 0,07104 -0.02381 0.03951 0.21389 0 04715 0.02794 0.01255 012592 10924 0.00565 -0.17091 31/08/2009 0.07104 0.04528 0.07317 0.07485 0.00724 -001385 0.00858 -0.00913 -0.02628 0.05521 0.05809 0 33333 30/09/2009 0.04528 -0.01905 0.36091 0.0293 0.08262 01113 0.05674 0.01580 0.06749 -0.06370 -0.023OZ0.09539 30/10/2009 0.01905 0.02470 - 16049 0.10994 -0.03092 0.17517 0.03356 0.16721 0.13289 -0.15495 -0.02659 0.03220 30/11/2009 0.02470 0,0424 0.02041 0.05714 0.26272 0.04149 0.01039 0.10161 -0.01116 0.19588 0.02018 0.00788 31/12/2009 0.04243 -0.03633 0.00800 -0.01532 -0.02712 -0.143815 0.01028 011391 0.00564 0.05296 0.07421 040646 29/01/2010 00363) 0.02868 0.15873 -0.07411 0.07795 0.02929 0.10390 0.00512 -0.02806 -0.00760 0.07588 0.00000 26/02/2010 0.02868 0.00930 0.07534 -0.01970 0.22257 20251 0.11705 0.17714 -0.05774 012493 0.03000 0.01112 31/03/2010 0.08336 -0.01610 0.41401 -0.21371 0.02684 -0.02387 0.15709 003912 0.06127 0.24673 0.02810 -0.05501 30/01/2010 0.01610 -0.06642 -0.04955 -0.31731 0.03269 -0.05151 -0.06091 -0 11311 -0.04619 -0.11008 -0.04871 -0.02329 31/05/2010 -0.06642 -0.04052 0.04028 -0.33333 0.119:15 -0 11509 0.01355 -0 11230 -0.00005 -0.15156 0.01829 0.02980 30/06/2010 -0.01852 0.06758 0.02459 0.36620 0.09263 0.07403 001585 0 25620 0.06090 0.07958 0.05387 0.07524 30/07/2010 0.05758 -0.00686 0.01205 -0.23711 -0.07370 -0.07300 0.03927 0.01453 -0.02296 - 20670 0.03019 0.02091 31/08/2010 -0.00686 0.06336 0.01190 0.17568 0.10611 0.07927 0.02516 0.1977 0.25288 0.42620 -0.00851 -0.04193 30/09/2010 0.06336 0.92391 0.20941 0.05172 0.00319 015146 0.02999 0 05958 0.02354 0.14377 -0.00191 -0.03830 29/10/2010 0.02391 -0.02539 -0.0311) -0.07650 -0.06984 -0.03003 -0.00408 -0.00530 -0.00158 0.04137 0.01.307 0.10240 30/11/2010 -002539 0.07032 0.08134 0.29586 0.01161 0.18255 0.27968 0.22566 -0.01381 0.32086 0 11310 -0.05160 31/12/2010 0.07032 -0.00607 -0.04444 -0.24612 -0.00172 -0.08185 -0.01856 0127279 021955 -0.03991 -0.10075 0.01098 31/01/2011 -0.00607 0.02047 0.00194 -0.30100 0.00836 0.0869 -0.01120 0.0001 0.07062 0.03253 -0.08992 0.00257 28/02/2011 0.02017 -0.01251 -0.02321 0.02976 0.08916 -0.03795 0.00850 -0.03269 -0.01066 0.15753 was 0.01251 0.02638 -0.05089 31/03/2011 we 0.02846 0.0297 -0.22139 0.13388 -002697 0.10607 0.00441 0.00059 0.01915 0.01512 0.05222 29/01/2011 0.02816 -0.02075 0.04423 -0.09211 0.01477 -0.02900 -0.01711 -0.02700 0.00019 -0.09891 0.00951 -0.07455 31/05/2011 -0.01076 -0.00780 -0.01105 0.00000 0.00321 0 01091 -0.00417 001891 0.08330 -0.07002 0.00557 -0.00575 30/06/2011 -0.00780 -0.02283 0.02421 0.02174 -0.00186 -0.0607) -0.01490 0.01118 0.06602 -0.05647 -0.01108 -0.00579 29/07/2011 -0.02283 -0.07152 -0.16064 -0.13475 0.00311 -0.11456 0.01832 -0.01326 -0.07967 -2.26350 0.00000 0.00000 31/06/2011 -0.07452 -0.05216 -0.07600 0.00279 0.15907 -0.13181 -0.05713 -0.31319 -0.05140 0.12903 0.03611 -0.05796 30/09/2011 005218 0.07779 0.20000 0.04762 0.05095 0.02091 -0.00898 0.25958 0.02377 016617 -0.00360 -0,03708 31/10/2011 0.07779 -0.00875 0.10196 0.00030 0.10398 0.05516 0.00156 0.01457 -0.01306 0.18956 0.00271 -0.11217 30/11/2011 -0.00875 0.00777 0.01092 0.26471 0.05720 -0.01691 0.07001 002618 - 10555 0.2293 -0.00180 -0.13262 30/12/2011 0.00777 0.02625 0.12311 0.22093 0.03867 0.10291 0.00889 00M20 0.13346 0.01071 0.01155 0.02138 31/01/2012 0.02625 0.03785 -0.08162 0.07113 0.05633 0.00972 0.02711 0.02862 -0.01098 0.05017 0.01903 0.00107 29/02/2012 0.03785 -0.01351 0.24370 0.32809 0.01672 -0 11795 0.01788 -0.13383 0.03562 0.01615 0.01836 -0.01617 10/03/2012 -0.01351 -0.00003 -0.07095 0.30315 0.00014 0.01320 0.01504 0.02517 -0.07550 -0.03831 -0.00062 -0.01201 30/01/2012 -0.00003 -0.07290 0.00000 -0.36616 -0.02350 - 16765 0.00106 -0.15157 -0.01111 -0.07324 -0.02513 -0.03717 31/05/2012 -0.07290 0.04194 0.0527) -0.07971 -0.05733 0.05961 0.015-18 0.068583 0.05257 0.12852 0.07912 -0.02501 29/06/2012 0.01494 0.01239 -0.07599 0.25591 -0.01418 -0.09026 -0.00750 -0.01471 -0.11060 -0.02770 -0.02106 0.11403 31/07/2012 0.01239 0.01550 0.13150 0.05956 0.15573 -0.07095 -0.01.00 0.00265 0.06017 012149 0.05/98 0.01562 31/08/2012 0.01550 0.00882 0.07002 0.08876 -0.01991 003829 0.01570 0.14002 0.00143 0.11255 -0.02614 0.00000 28/09/2012 0.00682 0.00852 0.07507 0.33859 -0.07017 0.01733 -0.00315 -0.00396 0.02019 0.15195 0.078 0.03501 31/10/2012 0.00252 0.01352 -0.02329 0.05 0.0081 -0.08059 -0.02996 0.02466 -0.06569 0.02735 0.05715 0.01486 30/11/2012 001352 0.00917 0.04106 0.06951 -0.22013 0.09922 -0.01471 0.02795 -0.05080 0.11247 0.05819 -0.01090 31/12/2012 0.00917 0.06270 0.01972 -0.00903 0.00219 -0.00296 0.07463 -0.13716 0.01530 0.06190 0.15829 0.00721 31/01/2013 0.06270 0.01886 0.01519 0.5405 0.06109 0.01682 -0.02679 -0.0129 -0.07086 0.13136 0.05889 0.02595 28/02/2013 0.01686 0.00933 0.23810 0.09901 0.00071 - 11967 0.02990 -0.0597 0.000 0.13883 0.02610 0.02530 29/03/2013 0.00933 0.00202 0.10989 0.01190 0.00000 -0.07505 -0.01593 -0.08791 -0.02510 0.00171 0.01789 -0.03508 30/01/2013 0.00202 0.0267 0.00000 -0.08588 0.00200 -0.02450 0.02011 0.05318 0.20251 0.07101 -0.05357 0.0582) 31/05/201) 002167 -0.05300 0.00000 -0.05019 -0.0031 -0.17063 -0.00310 -0.15918 0.03229 0.02290 -0.01219 -0.02116 28/08/2013 -0.05300 0.06695 0.09109 0.15706 0.000 0 11216 -0.03563 0 10913 -0.04342 0.09373 0.12016 -0.0217 31/07/2013 0.06605 -0.02835 -0.01996 -0.15915 -0.08596 0.05007 -0.02568 -0.07081 -3.05251 -0.08510 -0.05093 0.00000 30/08/2013 -0.02835 0.00980 0.01574 0.15866 -0.0113 0.02072 0.00310 -0.01209 -0.03062 -0.01571 0.01680 0.00371 30/09/2013 0.00900 0.04100 0.1109 -0.011 0.00374 -0.02171 0.01328 0.01159 -0.04546 0.06110 0 20812 0.00000 31/10/2013 0.01100 -0.03026 -0.01955 0.01965 -0.00310 -0.09156 0.00223 -0.07135 0.03521 0.0618) 0.01117 0.07972 29/11/2013 -0.01026 0.01724 0.07997 0.00293 0.00479 -0.02152 -0.00591 0.00778 0.02797 0.09271 0.06629 -0.02253 31/12/2013 0.01721 -0.03131 0.06227 -0.37159 -0.09538 0.08781 -0.01004 0.00216 0.03117 0.039a2 0 11013 0.0391) 31/01/2011 -0.03134 0.01866 -0.03386 0.09307 0.00900 0.06616 0.01164 0.05879 0.02201 0.10956 0.10424 0.01111 28/02/2014 0.01866 -0.03029 -0.0200) -0.00521 -0.00702 -0.00291 0.02450 -0.07218 -0.02211 0.08362 -0.07238 0.03952 31/03/2014 -0.03029 0.01007 -0.01533 -0.00721 0.05063 003636 002809 -005805 -0.05281 -0.08011 0.05892 0.02938 30/01/2031 0.01807 0.00972 0.00741 -0.11325 0.05313 -0.67670 0.00725 0.00191 0.00000 0.00886 0.01582 -0.01703 30/05/2011 0.00972 -0.01500 -0.04930 -0.01857 -0.01020 -0.01007 0.00013 0.00203 -0.01191 -0.00625 0.01027 -0.03471 30/06/2014 -0.01500 -0.00105 0.09907 -0.00837 0.012-12 11618 -0.01853 0.05225 0.00103 0.02111 -0.0002 0.02978 31/07/2014 -0.00405 0.01501 0.05634 0.07173 -0.01017 -0.00313 -0.00739 -0.03005 -0.00010 0.09625 0.03060 0.00811 29/06/2014 0.01501 -0.02902 -0.01067 0.02362 0.0001 -0.09512 -0.02538 -0.00211 -0.00101 0.06183 -0.05427 0.00337 10/09/2011 -0.02902 -0.00862 0.06096 -0.01598 -0.01600 -0.04672 0.01500 -0.02566 -0.00106 0.00096 0.02800 0.06981 11/10/2011 -0.00852 0.02565 0.0530) 0.05273 0.00723 0.00382 0.01555 0.01911 0.00000 0.00950 0.16301 0.03511 28/11/2014 0.02565 -0.01686 -0.02095 0.02703 0.01892 -0.09156 -0.15000 0.02103 -0.03262 0.09290 -0.01561 -0.00070 31/12/2014 -0.01686 0.02521 0.09111 0.01906 0.00324 -0.07289 0.02803 -0.13621 0.00072 -0.05556 -0.01586 0.06876 30/01/2015 0.02521 0.03081 0.05110 0.33803 0.09910 0.08715 0.005 0.18000 0.01639 0.09375 0.00709 -0.02291 27/02/2015 0.03381 -0.07155 0.10072 -0.05413 0.10507 - 16251 -0.00107 -0.01498 -0.01539 -0.00000 -0.00824 016882 31/01/2015 -0.02155 0.02633 0.00019 0.05628 0.08120 0.09190 0.00750 0.06609 -0.03061 0.03075 0.01384 -0.05617 30/01/2015 0.02633 0.00986 0.00092 0.02652 -0.02604 -0.07149 0.00616 -0.01513 -0.00533 0.05ses -0.00125 29/05/2015 0.006 -0.05966 -0.01921 -0.07295 -0.10510 -0.10178 -0.00953 -0.07574 -0.06.194 -0.0175 -0.05185 -0.06103 10/06/2015 -0.05966 0.02302 0.14179 0.11 75 -0.10609 -0.11682 -0.03551 -0.17700 0.03201 -0.10092 0.12295 -0.00156 31/07/2015 0.02302 -0.05972 -0.10040 -0.01265 -0.11003 -0.0865 0.05611 -0.08969 -0.03666 -0.00662 -0.0613 31/08/2015 -0.05972 -0.02875 0.12625 0.01596 -0.10872 - 25655 0.01255 -0 17917 0.00985 -0.01639 0.00 0.1124) 10/09/2015 -0.02875 0.04457 0.04435 -0.02269 -0.00733 -0.00781 0.05398 0.05.363 0.00188 0.07327 0.03443 0.02733 30/10/2015 0.04457 0.00216 -0.02394 -0.00155 0.00726 -0.25238 -0.07611 -0.03609 0.05025 0.00500 0.02634 -0.03107 30/11/2015 0.00216 -0.00371 0.00175 0.13178 -0.09055 -0.26722 -0.00455 -0.07527 -0.00917 0.02192 -0.0575) 0.01474 31/12/2015 -0.01771 -0.03146 -0.07087 -0.01110 -0.06674 -0.0717 -0.00202 -0.18906 0.01167 -0.19660 -0.05745 -0.01153 29/01/2016 -0.03146 0.00290 -0.01864 0.01429 0.00603 0.7300 0.08971 0.29993 0.01233 0.02781 0.00127 -0.0816) 20/02/2016 0.00298 0.01475 0.06005 0.19577 0.21764 0.14961 0.14730 -0.01900 0.26754 -0.06194 -0.01674 0.06100 31/03/2016 0.01025 0.00781 0.00401 0.01767 0.00929 0.38272 0.02590 0.029 10 0.02076 0.05035 -0.08510 0.06675 29/01/2016 0.00791 0.00236 0.03569 0,07755 0.00006 -021301 -0.00012 -0.11217 0.01017 0.07540 -0.01946 -0.00975 31/05/2016 0.00236 0.02499 -0.04692 -0.12030 0.2701 0.21130 -0.14899 0.08531 -3.06711 0.09016 -0.07643 -0.02399 30/06/2016 0.02498 0.03936 0.09615 0.10012 0.00626 0.14252 0.00535 0.07496 0.42146 0.1.2106 -0.01030 0.07183 29/07/2016 0.03936 0.01187 0.12281 -0.00219 -0.20762 - 06105 0.117 -9.08033 0.05760 017006 -0.00597 31/08/2016 0.01187 0.01573 0.09500 0.01606 -0.06428 0.20083 0.05981 0.05923 0.03581 0.00174 -0-14502 -0.00326 30/09/2016 0.01573 0.00041 -0.05879 0.018060.15911 0.16387 0. 120 19 0.00626 -0.00266 0.00551 -0.05308 0.00B44 31/10/2016 0.00341 -0.02010 0.00182 -0.00793 0.01996 0.01775 0.06907 026888 -0.01900 0.22612 0.02574 -0.02630 30/11/2016 -0.02010 0.04897 0.07446 0.09704 0.12294 -0.02110 0.11619 -0.02032 0.03361 0.00830 0.07647 -0.00439 30/12/2016 0.04897 -0.00386 -0.06020 0.00667 0.09605 0.17069 0.05856 0.22704 0.13652 0.01646 0.13078 -0.08774 11/01/2017 -0.00396 0.02466 -0.01079 0.09111 0.01667 -0.06113 -0.01062 -0.02754 013350 0.03113 0.09765012195 28/02/2017 0.02466 0.00925 0.08242 0.15086 -0.10126 -0.04014 0.00438 0.02771 0.25910 -0.00181 -0.00196 -0.01099 31/03/2017 0.00925 -0,00689 -0.0020 0.01682 0.00453 -0.09266 0.07122 0.019 0.0001 -0.01111 0.07828 0.05267 26/01/2017 0.00600 0.03876 -0.03650 0.01025 -0.02592 -0.00778 0.05156 -0.01415 -0.00168 -0.03985 0.06619 0.03673 31/05/2017 0.03876 -0.02767 -0.0192) -0.12210 0.00428 -0.00727 0.0032 -0.00187 -0.00784 0.01469 0.02003 0.00174 30/06/2017 -0.02757 0.01100 -0.05766 0.00801 -0.07822 0.22710 0.09870 0.10024 0.28072 0.02517 0.00954 0.00172 31/07/2017 0.01100 0.00062 0.27049 0.02135 0.06127 0.11976 -0.01833 QU09408 0.13272 0.02082 0.12078 0.01802 31/08/2017 0.00662 -0.00567 -0.09132 -0.02357 0.04218 -0.04492 0.01157 -0.08 309 0.08178 0.03883 0.03909 29/09/2017 -0.00567 0.01674 0.05025 -0.09375 -0.00213 0.06010 -0.01511 0.00500 -0.08205 0.0738 0.01352 -0.0166 31/10/2017 0.01674 -0.02036 -0.05096 0.03510 -0.0933 -0.04296 -0.06723 -0.01215 0.03341 -0.02113 -0.11525 -0.01746 30/11/2017 -0.02036 0.04660 0.04110 0.005550.05945 0.14018 0.00130 0.10500 0.03007 0.04897 -0.01342 0.02122 29/12/2017 0.01660 -0.01992 0.05262 0.00025 0.00951 0.10268 -0.01120 -0.07363 -0.09626 0.0567 -0.01085 -0.03590 11/01/2018 -0.01992 -0.03771 -0.05500 0.01348 -0.02339 0.04214 0.01 310 -0.06552 0.13372 0.00428 -0.03732 -0.06169 28/02/2018 -0.0377: -0.02196 -0.16667 -0.05522 0.01766 0.06717 0.00000 0.05832 -0.07098 -0.08231 0.05321 0.02595 30/01/2018 0.02196 0.05996 0.09206 0.0143 0.00245 0.02914 -0.01558 0.05581 0.00225 0.04794 0408551 0.00506 30/04/2018 0.05996 0.02290 0.01744 0.09423 0.01069 0.05135 0.01847 0.0844 0.00679 0.14658 -0.01997 0.05034 31/05/2018 0.02290 -0.00472 0.01714 0.10013 0.01796 -0.0569 -0.07258 005117 -0.02004 -0.028 403201 0.01767 29/06/2018 0.00473 0.01215 0.17412 -0.07567 0.09941 0.02.12 0.05797 0.01313 -0.08864 0.02992 -0.10326 -0.01736 31/07/2018 0.01215 -0.03460 0.06436 0.06501 0.12836 -0.11034 -0.10959 0.1960: 0.04239 0.00897 0.05762 0.03180 11/01/2018 0.03460 0.005 -0.07002 -0.34666 0.01007 0.11762 -0.1230 00512 -0.00716 0.02175 0.00014 0.01277 29/09/2018 0.00530 -3.05419 -0.09045 -0.07025 -0.01582 -0.02774 0.00827 -0.00211 -2.04819 -0.20579 0.04192 -0.03142 31/10/2018 -0.00419 -0.02072 0.12207 -0.11333 0.12117 -0.06507 -0.02304 0.01988 0.03165 -0.09119 0.01593 0.01908 10/11/2016 -0.02072 -0.02878 -0.09554 0,06512 0.01770 0.11595 0.00158 -0.02149 - 16196 -0.06936 -0.15718 -0.01124 31/12/2018 -0.02878 00135 0.0107 - -0.01159 Monthly Return Data for a sample of companies drawn from the FTSE ALL SHARE that have traded continuously from January 2009 to December 2018. 0.2885 Name 1 30/01/2009 2 27/02/2009 3 31/03/2009 4 30/04/2009 5 29/05/2009 6 30/06/2009 7 31/07/2009 8 31/08/2009 9 30/09/2009 10 30/10/2009 11 30/11/2009 12 31/12/2009 13 29/01/2010 14 26/02/2010 15 31/03/2010 16 30/01/2010 17 31/05/2010 18 30/06/2010 19 30/07/2010 20 31/08/2010 21 30/09/2010 22 29/10/2010 30/11/2010 24 31/12/2010 25 31/01/2011 26 26/02/2011 27 31/03/2011 28 29/01/2011 29 31/08/2011 30 30/06/2011 31 29/07/2011 32 31/08/2011 33 30/09/2011 34 31/10/2011 35 30/12/2011 36 30/12/2011 37 31/01/2012 36 38 20/02/2012 39 30/03/2012 10 30/01/2012 31/05/2012 12 29/06/2012 43 31/07/2012 44 31/08/2012 15 28/09/2012 16 31/10/2012 47 30/11/2012 48 31/12/2012 19 31/01/2013 50 28/02/2013 51 29/03/2015 52 30/01/2013 53 31/05/2013 34 28/06/2013 55 31/07/2013 56 30/08/2013 57 30/09/2013 58 31/10/2013 59 29/11/2013 60 31/12/2013 61 31/01/2011 62 28/02/2014 $3 31/03/2011 61 30/01/2011 05 30/05/2011 66 30/06/2011 67 31/07/2014 de 29/08/2014 59 30/09/2014 70 31/10/2014 71 28/11/2011 72 31/12/2011 73 30/01/2015 74 27/02/2015 75 31/03/2015 76 30/01/2015 77 29/05/2015 78 30/06/2015 79 31/07/2015 30 31/08/2015 81 30/09/2015 82 30/10/2015 03 30/11/2015 84 31/12/2015 25 29/01/2015 86 29/02/2016 87 31/03/2016 88 29/01/2018 89 31/05/2016 90 30/06/2016 91 29/07/2016 92 31/08/2016 93 30/09/2016 94 31/10/2016 95 30/11/2016 96 30/12/2016 97 31/01/2017 98 28/02/2017 99 31/03/2017 100 20/01/2017 101 31/05/2017 102 30/06/2017 102 31/07/2017 104 31/08/2017 105 29/09/2017 106 31/10/2017 107 30/11/2017 100 29/12/2017 100 11/01/2018 110 28/02/2018 111 30/09/2010 112 30/04/2018 112 31/05/2018 114 30/06/2018 115 31/07/2018 116 31/08/2018 117 28/09/2018 118 31/10/2018 119 30/11/2018 120 31/12/2018 FTSE ALL SHARE IMPRINT GROUP 68 HOLDINGS AGGREKO ANGLO AMERICAN ANGLO-EASTERN PLTNS ANTOFAGASTA APTITUDE SOFTWARE GROUP ASHTEAD GROUP ASSOCIATED BRIT, FOODS ASSURA Name FTSE ALL SHARE -0.05901 -0.12067 -0.00579-0.12282 - 18111 -0.05665 -0.01293 -0.04540 -0.00433 -0.09178 0.05308 30/01/2009 -0.00901 0,07173 0.16031 020845 0 09504 - 20532 0.01235 0.05298 0.00000 -0.14375 001810 033972 27/02/2000 -0.07175 0.02820 0.03182 -0.04429 0.37456 018482 0.15979 0.14076 0.09512 0.15328 -0.01613 -0.10489 31/03/2009 0.02820 0.09520 0.26872 -0.01390 0.1753 25126 0.24014 0.18917 0.20673 0.59194 012100 0.40435 30/01/2009 0.09520 0.03662 0.01910 0.06122 0.01298 0.19744 0.05278 005610 -0.00913 -0.17857 0.01811 0.06827 29/05/2000 0.03662 -0.03576 -0.24361 -0.00481 -0.11442 -0.00269 -0,03117 -0.05598 0.26371 0.09862 0.04309 -0.09231 30/06/2009 -0.03576 0.08351 -0.05405 -0.20531 0.05495 0.0941 0.01895 -0.02074 0.09692 0.04393 0.03878 31/07/2009 0.08351 0,07104 -0.02381 0.03951 0.21389 0 04715 0.02794 0.01255 012592 10924 0.00565 -0.17091 31/08/2009 0.07104 0.04528 0.07317 0.07485 0.00724 -001385 0.00858 -0.00913 -0.02628 0.05521 0.05809 0 33333 30/09/2009 0.04528 -0.01905 0.36091 0.0293 0.08262 01113 0.05674 0.01580 0.06749 -0.06370 -0.023OZ0.09539 30/10/2009 0.01905 0.02470 - 16049 0.10994 -0.03092 0.17517 0.03356 0.16721 0.13289 -0.15495 -0.02659 0.03220 30/11/2009 0.02470 0,0424 0.02041 0.05714 0.26272 0.04149 0.01039 0.10161 -0.01116 0.19588 0.02018 0.00788 31/12/2009 0.04243 -0.03633 0.00800 -0.01532 -0.02712 -0.143815 0.01028 011391 0.00564 0.05296 0.07421 040646 29/01/2010 00363) 0.02868 0.15873 -0.07411 0.07795 0.02929 0.10390 0.00512 -0.02806 -0.00760 0.07588 0.00000 26/02/2010 0.02868 0.00930 0.07534 -0.01970 0.22257 20251 0.11705 0.17714 -0.05774 012493 0.03000 0.01112 31/03/2010 0.08336 -0.01610 0.41401 -0.21371 0.02684 -0.02387 0.15709 003912 0.06127 0.24673 0.02810 -0.05501 30/01/2010 0.01610 -0.06642 -0.04955 -0.31731 0.03269 -0.05151 -0.06091 -0 11311 -0.04619 -0.11008 -0.04871 -0.02329 31/05/2010 -0.06642 -0.04052 0.04028 -0.33333 0.119:15 -0 11509 0.01355 -0 11230 -0.00005 -0.15156 0.01829 0.02980 30/06/2010 -0.01852 0.06758 0.02459 0.36620 0.09263 0.07403 001585 0 25620 0.06090 0.07958 0.05387 0.07524 30/07/2010 0.05758 -0.00686 0.01205 -0.23711 -0.07370 -0.07300 0.03927 0.01453 -0.02296 - 20670 0.03019 0.02091 31/08/2010 -0.00686 0.06336 0.01190 0.17568 0.10611 0.07927 0.02516 0.1977 0.25288 0.42620 -0.00851 -0.04193 30/09/2010 0.06336 0.92391 0.20941 0.05172 0.00319 015146 0.02999 0 05958 0.02354 0.14377 -0.00191 -0.03830 29/10/2010 0.02391 -0.02539 -0.0311) -0.07650 -0.06984 -0.03003 -0.00408 -0.00530 -0.00158 0.04137 0.01.307 0.10240 30/11/2010 -002539 0.07032 0.08134 0.29586 0.01161 0.18255 0.27968 0.22566 -0.01381 0.32086 0 11310 -0.05160 31/12/2010 0.07032 -0.00607 -0.04444 -0.24612 -0.00172 -0.08185 -0.01856 0127279 021955 -0.03991 -0.10075 0.01098 31/01/2011 -0.00607 0.02047 0.00194 -0.30100 0.00836 0.0869 -0.01120 0.0001 0.07062 0.03253 -0.08992 0.00257 28/02/2011 0.02017 -0.01251 -0.02321 0.02976 0.08916 -0.03795 0.00850 -0.03269 -0.01066 0.15753 was 0.01251 0.02638 -0.05089 31/03/2011 we 0.02846 0.0297 -0.22139 0.13388 -002697 0.10607 0.00441 0.00059 0.01915 0.01512 0.05222 29/01/2011 0.02816 -0.02075 0.04423 -0.09211 0.01477 -0.02900 -0.01711 -0.02700 0.00019 -0.09891 0.00951 -0.07455 31/05/2011 -0.01076 -0.00780 -0.01105 0.00000 0.00321 0 01091 -0.00417 001891 0.08330 -0.07002 0.00557 -0.00575 30/06/2011 -0.00780 -0.02283 0.02421 0.02174 -0.00186 -0.0607) -0.01490 0.01118 0.06602 -0.05647 -0.01108 -0.00579 29/07/2011 -0.02283 -0.07152 -0.16064 -0.13475 0.00311 -0.11456 0.01832 -0.01326 -0.07967 -2.26350 0.00000 0.00000 31/06/2011 -0.07452 -0.05216 -0.07600 0.00279 0.15907 -0.13181 -0.05713 -0.31319 -0.05140 0.12903 0.03611 -0.05796 30/09/2011 005218 0.07779 0.20000 0.04762 0.05095 0.02091 -0.00898 0.25958 0.02377 016617 -0.00360 -0,03708 31/10/2011 0.07779 -0.00875 0.10196 0.00030 0.10398 0.05516 0.00156 0.01457 -0.01306 0.18956 0.00271 -0.11217 30/11/2011 -0.00875 0.00777 0.01092 0.26471 0.05720 -0.01691 0.07001 002618 - 10555 0.2293 -0.00180 -0.13262 30/12/2011 0.00777 0.02625 0.12311 0.22093 0.03867 0.10291 0.00889 00M20 0.13346 0.01071 0.01155 0.02138 31/01/2012 0.02625 0.03785 -0.08162 0.07113 0.05633 0.00972 0.02711 0.02862 -0.01098 0.05017 0.01903 0.00107 29/02/2012 0.03785 -0.01351 0.24370 0.32809 0.01672 -0 11795 0.01788 -0.13383 0.03562 0.01615 0.01836 -0.01617 10/03/2012 -0.01351 -0.00003 -0.07095 0.30315 0.00014 0.01320 0.01504 0.02517 -0.07550 -0.03831 -0.00062 -0.01201 30/01/2012 -0.00003 -0.07290 0.00000 -0.36616 -0.02350 - 16765 0.00106 -0.15157 -0.01111 -0.07324 -0.02513 -0.03717 31/05/2012 -0.07290 0.04194 0.0527) -0.07971 -0.05733 0.05961 0.015-18 0.068583 0.05257 0.12852 0.07912 -0.02501 29/06/2012 0.01494 0.01239 -0.07599 0.25591 -0.01418 -0.09026 -0.00750 -0.01471 -0.11060 -0.02770 -0.02106 0.11403 31/07/2012 0.01239 0.01550 0.13150 0.05956 0.15573 -0.07095 -0.01.00 0.00265 0.06017 012149 0.05/98 0.01562 31/08/2012 0.01550 0.00882 0.07002 0.08876 -0.01991 003829 0.01570 0.14002 0.00143 0.11255 -0.02614 0.00000 28/09/2012 0.00682 0.00852 0.07507 0.33859 -0.07017 0.01733 -0.00315 -0.00396 0.02019 0.15195 0.078 0.03501 31/10/2012 0.00252 0.01352 -0.02329 0.05 0.0081 -0.08059 -0.02996 0.02466 -0.06569 0.02735 0.05715 0.01486 30/11/2012 001352 0.00917 0.04106 0.06951 -0.22013 0.09922 -0.01471 0.02795 -0.05080 0.11247 0.05819 -0.01090 31/12/2012 0.00917 0.06270 0.01972 -0.00903 0.00219 -0.00296 0.07463 -0.13716 0.01530 0.06190 0.15829 0.00721 31/01/2013 0.06270 0.01886 0.01519 0.5405 0.06109 0.01682 -0.02679 -0.0129 -0.07086 0.13136 0.05889 0.02595 28/02/2013 0.01686 0.00933 0.23810 0.09901 0.00071 - 11967 0.02990 -0.0597 0.000 0.13883 0.02610 0.02530 29/03/2013 0.00933 0.00202 0.10989 0.01190 0.00000 -0.07505 -0.01593 -0.08791 -0.02510 0.00171 0.01789 -0.03508 30/01/2013 0.00202 0.0267 0.00000 -0.08588 0.00200 -0.02450 0.02011 0.05318 0.20251 0.07101 -0.05357 0.0582) 31/05/201) 002167 -0.05300 0.00000 -0.05019 -0.0031 -0.17063 -0.00310 -0.15918 0.03229 0.02290 -0.01219 -0.02116 28/08/2013 -0.05300 0.06695 0.09109 0.15706 0.000 0 11216 -0.03563 0 10913 -0.04342 0.09373 0.12016 -0.0217 31/07/2013 0.06605 -0.02835 -0.01996 -0.15915 -0.08596 0.05007 -0.02568 -0.07081 -3.05251 -0.08510 -0.05093 0.00000 30/08/2013 -0.02835 0.00980 0.01574 0.15866 -0.0113 0.02072 0.00310 -0.01209 -0.03062 -0.01571 0.01680 0.00371 30/09/2013 0.00900 0.04100 0.1109 -0.011 0.00374 -0.02171 0.01328 0.01159 -0.04546 0.06110 0 20812 0.00000 31/10/2013 0.01100 -0.03026 -0.01955 0.01965 -0.00310 -0.09156 0.00223 -0.07135 0.03521 0.0618) 0.01117 0.07972 29/11/2013 -0.01026 0.01724 0.07997 0.00293 0.00479 -0.02152 -0.00591 0.00778 0.02797 0.09271 0.06629 -0.02253 31/12/2013 0.01721 -0.03131 0.06227 -0.37159 -0.09538 0.08781 -0.01004 0.00216 0.03117 0.039a2 0 11013 0.0391) 31/01/2011 -0.03134 0.01866 -0.03386 0.09307 0.00900 0.06616 0.01164 0.05879 0.02201 0.10956 0.10424 0.01111 28/02/2014 0.01866 -0.03029 -0.0200) -0.00521 -0.00702 -0.00291 0.02450 -0.07218 -0.02211 0.08362 -0.07238 0.03952 31/03/2014 -0.03029 0.01007 -0.01533 -0.00721 0.05063 003636 002809 -005805 -0.05281 -0.08011 0.05892 0.02938 30/01/2031 0.01807 0.00972 0.00741 -0.11325 0.05313 -0.67670 0.00725 0.00191 0.00000 0.00886 0.01582 -0.01703 30/05/2011 0.00972 -0.01500 -0.04930 -0.01857 -0.01020 -0.01007 0.00013 0.00203 -0.01191 -0.00625 0.01027 -0.03471 30/06/2014 -0.01500 -0.00105 0.09907 -0.00837 0.012-12 11618 -0.01853 0.05225 0.00103 0.02111 -0.0002 0.02978 31/07/2014 -0.00405 0.01501 0.05634 0.07173 -0.01017 -0.00313 -0.00739 -0.03005 -0.00010 0.09625 0.03060 0.00811 29/06/2014 0.01501 -0.02902 -0.01067 0.02362 0.0001 -0.09512 -0.02538 -0.00211 -0.00101 0.06183 -0.05427 0.00337 10/09/2011 -0.02902 -0.00862 0.06096 -0.01598 -0.01600 -0.04672 0.01500 -0.02566 -0.00106 0.00096 0.02800 0.06981 11/10/2011 -0.00852 0.02565 0.0530) 0.05273 0.00723 0.00382 0.01555 0.01911 0.00000 0.00950 0.16301 0.03511 28/11/2014 0.02565 -0.01686 -0.02095 0.02703 0.01892 -0.09156 -0.15000 0.02103 -0.03262 0.09290 -0.01561 -0.00070 31/12/2014 -0.01686 0.02521 0.09111 0.01906 0.00324 -0.07289 0.02803 -0.13621 0.00072 -0.05556 -0.01586 0.06876 30/01/2015 0.02521 0.03081 0.05110 0.33803 0.09910 0.08715 0.005 0.18000 0.01639 0.09375 0.00709 -0.02291 27/02/2015 0.03381 -0.07155 0.10072 -0.05413 0.10507 - 16251 -0.00107 -0.01498 -0.01539 -0.00000 -0.00824 016882 31/01/2015 -0.02155 0.02633 0.00019 0.05628 0.08120 0.09190 0.00750 0.06609 -0.03061 0.03075 0.01384 -0.05617 30/01/2015 0.02633 0.00986 0.00092 0.02652 -0.02604 -0.07149 0.00616 -0.01513 -0.00533 0.05ses -0.00125 29/05/2015 0.006 -0.05966 -0.01921 -0.07295 -0.10510 -0.10178 -0.00953 -0.07574 -0.06.194 -0.0175 -0.05185 -0.06103 10/06/2015 -0.05966 0.02302 0.14179 0.11 75 -0.10609 -0.11682 -0.03551 -0.17700 0.03201 -0.10092 0.12295 -0.00156 31/07/2015 0.02302 -0.05972 -0.10040 -0.01265 -0.11003 -0.0865 0.05611 -0.08969 -0.03666 -0.00662 -0.0613 31/08/2015 -0.05972 -0.02875 0.12625 0.01596 -0.10872 - 25655 0.01255 -0 17917 0.00985 -0.01639 0.00 0.1124) 10/09/2015 -0.02875 0.04457 0.04435 -0.02269 -0.00733 -0.00781 0.05398 0.05.363 0.00188 0.07327 0.03443 0.02733 30/10/2015 0.04457 0.00216 -0.02394 -0.00155 0.00726 -0.25238 -0.07611 -0.03609 0.05025 0.00500 0.02634 -0.03107 30/11/2015 0.00216 -0.00371 0.00175 0.13178 -0.09055 -0.26722 -0.00455 -0.07527 -0.00917 0.02192 -0.0575) 0.01474 31/12/2015 -0.01771 -0.03146 -0.07087 -0.01110 -0.06674 -0.0717 -0.00202 -0.18906 0.01167 -0.19660 -0.05745 -0.01153 29/01/2016 -0.03146 0.00290 -0.01864 0.01429 0.00603 0.7300 0.08971 0.29993 0.01233 0.02781 0.00127 -0.0816) 20/02/2016 0.00298 0.01475 0.06005 0.19577 0.21764 0.14961 0.14730 -0.01900 0.26754 -0.06194 -0.01674 0.06100 31/03/2016 0.01025 0.00781 0.00401 0.01767 0.00929 0.38272 0.02590 0.029 10 0.02076 0.05035 -0.08510 0.06675 29/01/2016 0.00791 0.00236 0.03569 0,07755 0.00006 -021301 -0.00012 -0.11217 0.01017 0.07540 -0.01946 -0.00975 31/05/2016 0.00236 0.02499 -0.04692 -0.12030 0.2701 0.21130 -0.14899 0.08531 -3.06711 0.09016 -0.07643 -0.02399 30/06/2016 0.02498 0.03936 0.09615 0.10012 0.00626 0.14252 0.00535 0.07496 0.42146 0.1.2106 -0.01030 0.07183 29/07/2016 0.03936 0.01187 0.12281 -0.00219 -0.20762 - 06105 0.117 -9.08033 0.05760 017006 -0.00597 31/08/2016 0.01187 0.01573 0.09500 0.01606 -0.06428 0.20083 0.05981 0.05923 0.03581 0.00174 -0-14502 -0.00326 30/09/2016 0.01573 0.00041 -0.05879 0.018060.15911 0.16387 0. 120 19 0.00626 -0.00266 0.00551 -0.05308 0.00B44 31/10/2016 0.00341 -0.02010 0.00182 -0.00793 0.01996 0.01775 0.06907 026888 -0.01900 0.22612 0.02574 -0.02630 30/11/2016 -0.02010 0.04897 0.07446 0.09704 0.12294 -0.02110 0.11619 -0.02032 0.03361 0.00830 0.07647 -0.00439 30/12/2016 0.04897 -0.00386 -0.06020 0.00667 0.09605 0.17069 0.05856 0.22704 0.13652 0.01646 0.13078 -0.08774 11/01/2017 -0.00396 0.02466 -0.01079 0.09111 0.01667 -0.06113 -0.01062 -0.02754 013350 0.03113 0.09765012195 28/02/2017 0.02466 0.00925 0.08242 0.15086 -0.10126 -0.04014 0.00438 0.02771 0.25910 -0.00181 -0.00196 -0.01099 31/03/2017 0.00925 -0,00689 -0.0020 0.01682 0.00453 -0.09266 0.07122 0.019 0.0001 -0.01111 0.07828 0.05267 26/01/2017 0.00600 0.03876 -0.03650 0.01025 -0.02592 -0.00778 0.05156 -0.01415 -0.00168 -0.03985 0.06619 0.03673 31/05/2017 0.03876 -0.02767 -0.0192) -0.12210 0.00428 -0.00727 0.0032 -0.00187 -0.00784 0.01469 0.02003 0.00174 30/06/2017 -0.02757 0.01100 -0.05766 0.00801 -0.07822 0.22710 0.09870 0.10024 0.28072 0.02517 0.00954 0.00172 31/07/2017 0.01100 0.00062 0.27049 0.02135 0.06127 0.11976 -0.01833 QU09408 0.13272 0.02082 0.12078 0.01802 31/08/2017 0.00662 -0.00567 -0.09132 -0.02357 0.04218 -0.04492 0.01157 -0.08 309 0.08178 0.03883 0.03909 29/09/2017 -0.00567 0.01674 0.05025 -0.09375 -0.00213 0.06010 -0.01511 0.00500 -0.08205 0.0738 0.01352 -0.0166 31/10/2017 0.01674 -0.02036 -0.05096 0.03510 -0.0933 -0.04296 -0.06723 -0.01215 0.03341 -0.02113 -0.11525 -0.01746 30/11/2017 -0.02036 0.04660 0.04110 0.005550.05945 0.14018 0.00130 0.10500 0.03007 0.04897 -0.01342 0.02122 29/12/2017 0.01660 -0.01992 0.05262 0.00025 0.00951 0.10268 -0.01120 -0.07363 -0.09626 0.0567 -0.01085 -0.03590 11/01/2018 -0.01992 -0.03771 -0.05500 0.01348 -0.02339 0.04214 0.01 310 -0.06552 0.13372 0.00428 -0.03732 -0.06169 28/02/2018 -0.0377: -0.02196 -0.16667 -0.05522 0.01766 0.06717 0.00000 0.05832 -0.07098 -0.08231 0.05321 0.02595 30/01/2018 0.02196 0.05996 0.09206 0.0143 0.00245 0.02914 -0.01558 0.05581 0.00225 0.04794 0408551 0.00506 30/04/2018 0.05996 0.02290 0.01744 0.09423 0.01069 0.05135 0.01847 0.0844 0.00679 0.14658 -0.01997 0.05034 31/05/2018 0.02290 -0.00472 0.01714 0.10013 0.01796 -0.0569 -0.07258 005117 -0.02004 -0.028 403201 0.01767 29/06/2018 0.00473 0.01215 0.17412 -0.07567 0.09941 0.02.12 0.05797 0.01313 -0.08864 0.02992 -0.10326 -0.01736 31/07/2018 0.01215 -0.03460 0.06436 0.06501 0.12836 -0.11034 -0.10959 0.1960: 0.04239 0.00897 0.05762 0.03180 11/01/2018 0.03460 0.005 -0.07002 -0.34666 0.01007 0.11762 -0.1230 00512 -0.00716 0.02175 0.00014 0.01277 29/09/2018 0.00530 -3.05419 -0.09045 -0.07025 -0.01582 -0.02774 0.00827 -0.00211 -2.04819 -0.20579 0.04192 -0.03142 31/10/2018 -0.00419 -0.02072 0.12207 -0.11333 0.12117 -0.06507 -0.02304 0.01988 0.03165 -0.09119 0.01593 0.01908 10/11/2016 -0.02072 -0.02878 -0.09554 0,06512 0.01770 0.11595 0.00158 -0.02149 - 16196 -0.06936 -0.15718 -0.01124 31/12/2018 -0.02878 00135 0.0107 - -0.01159