Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is for financial maths questions. i dont know if it lies under computer science or finance or statistics. need help with coding. can be

this is for financial maths questions. i dont know if it lies under computer science or finance or statistics. need help with coding. can be in either r studio or matlab. help v appreciated! thank you!! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
thats the inly information ivegot
Below we provide some questions for the disciplinary project. You may want to make some adjustment for some parts of the questions, e.g., adjusting the numbers in red or consider more periods for the dynamic optimisation, in order to have more interesting results. In that case, please feel free to do so. Setup. In reality each asset class in the spreadsheet provided on canvas, e.g, Dev. Equities and Hedge Funds, may contain several different assets. For the simplicity of analysis and presentation, without loss of generality we assume each asset class behaves like a single asset and admits some price process. We will work on four reset classes, including Cash (Asset Class 1), Dev. Equities (DEQ, Asset Class 2), Hedge Funds (HF, Asset Class 3), and Dev. Gov. Bonds (DGB, Asset Class 4). Let S = (S)en be the price process for Asset Class i, i = 1,2,3,4. Here time t is in months and thus S is the price of Asset Class i at the end of the t-th month. For 1 = 1,2,3,4, assume the dynamics of the price of Asset Class i satisfies S-1 - Sex -0,1,2,.... (1) Denote X=(x,xx, x4). Assume X., X, X3.. are i.i.d., and each admits multivariate normal distribu- tion with mean a (a, a, a, a) R' and covariance matrix B - (b)=1.2.3.4. For i = 1,2,3,4, denote a the monthly return of Asset Class i in the t-th month. By (1), SH 1-1 = x= In(1+a;) Note that the realised monthly returns or for these asset classes since the year 2001 are provided in the spreadsheet 1 Parameter Estimation Q1. Estimate the parameters , and by for y=1,2,3.4 using market data for the two time intervals (A) from 1/1/2007 to 31/12/2010. (B) from 1/1/2011 to 31/12/2014 Q2. Form-1.2. by (1) the return for Assut Class i from the beginning of the t-th month to the beginning of the (+ n)-th month is given by A 1 exp 1 SH ATE Show that -1.-1.2.3.4 wliere (YYYY) admits multivarinte normal distribution with mean na and covariation matrix B JX B D E F G H Monthly returns (net oftaces and investment fees) from asset classes, all hedged @ @ DATE Cash 3 4 5 6 7 18 19 20 21 22 23 24 25 26 27 28 29 30 5 1 31/1/01 0.043198 0.02603 0.009438 0.015003 0.010966 0.005364 2 28/2/01 -0.00187 -0.07868 -0.00588 0.006675 0.01025 0.004695 3 30/3/01 0.04847 -0.04787 -0.00337 0.005939 0.007192 0.004821 4 30/4/01 0.058545 0.06975 0.006883 -0.00966 0.00638 0.00435 5 31/5/01 0.017158 -0.0071 0.008255 -0.00377 0.005613 0.00405 6 29/6/01 0.037769 -0.0254 0.005842 0.00068 0.006525 0.004009 7 31/7/01 -0.04744 0.02128 0.00021 0.004161 0.012291 0.004221 8 31/8/01 0.00958 -0.06226 0.009159 0.026625 0.009451 0.004432 9 28/9/01 0.0657 -0.089 0.00832 0.011419 0.008455 0.004287 10 31/10/01 0.067654 0.025293 0.004407 0.016335 0.019457 0.003786 11 30/11/01 0.033143 0.062491 0.0054 -0.0107 -0.00651 0.003571 12 31/12/01 0.026497 0.010931 0.011916 0.00879 -0.00549 0.003623 13 31/1/02 0.012901 -0.01952 0.00539 0.000473 0.004313 0.003565 14 28/2/02 0.01113 0.01004 0.00561 0.005765 0.005154 0.003293 15 29/3/02 0.006496 0.039896 0.007383 -0.00859 -0.00677 0.003483 16 30/4/02 -0.01802 0.04586 0.007946 0.014438 0.013874 0.003777 17 31/5/02 0.008467 0.01092 0.00674 -0.0027 0.00469 0.003704 18 28/6/02 0.04193 0.07735 0.00844 0.012693 0.015635 0.003896 19 317/02 -0.04023 0.08437 -0.01346 0.01032 0.014983 0.004384 20 30/8/02 0.01625 0.001642 0.008461 0.010429 0.016764 0.004132 21 30/9/02 0.04157 0.11047 0.000781 0.01687 0.017054 0.004132 22 31/10/02 0.026771 0.073984 0.00041 0.001893 0.00014 0.004172 29/11/02 0.011244 0.05349 0.010936 0.001247 0.002032 0.00399 24 31/12/02 0.01595 0.06424 0.010655 0.022359 0.01899 0.004134 25 31/1/03 0.01641 -0.03653 0.012756 0.00408 0.008446 0.004058 25 28/2/03 -0.04923 -0.01634 0.006755 0.009675 0.011494 0.003686 27 31/3/03 0.039236 0.0054 0.002605 0.00443 0.001504 0.003991 28 30/4/03 0.043103 0.082659 0.019564 0.005512 0.005857 0.003915 29 30/5/03 0.003713 0.042378 0.027142 0.016025 0.020745 0.004067 Sheett Ready J11 A ona TOUT TURUU 35 36 37 38 39 40 41 42 43 44 45 46 48 49 50 51 52 5a 54 55 56 57 58 59 GO 61 B C D E G ETTO 31 31/7/03 0.032662 0.028493 0.00082 -0.00875 0.0158 0.003921 32 29/8/03 0.02993 0.024352 0.007599 -0.0002 0.00162 0.004001 33 30/9/03 -0.0014 -0.01556 0.015157 0.006676 0.016878 0.003967 34 31/10/03 0.033544 0.054291 0.013765 -0.01103 0.00681 0.004081 35 28/11/03 -0.02022 0.006509 0.010776 0.00465 0.004429 0.003842 36 31/12/03 0.037631 0.044966 0.019546 0.017542 0.011475 0.00448 32 30/1/04 -0.00791 0.016904 0.017045 0.00188 0.008913 0.004574 38 27/2/04 0.031262 0.017778 0.013983 0.012793 0.01346 0.00441 39 31/3/04 0.023205 -0.009 0.002839 0.009273 0.007483 0.004773 40 30/4/04 -0.00392 -0.00387 -0.00583 0.00926 0.00992 0.004486 41 31/5/04 0.018696 0.001631 0.00231 0.00908 0.001935 0.004728 42 30/6/04 0.026881 0.021212 0.003432 0.003919 0.002974 0.004515 43 30/04 0.00272 -0.0289 0.00312 0.004292 0.008686 0.004629 44 31/8/04 0.011562 0.00168 0.001359 0.0141 0.018523 0.004623 45 30/9/04 0.038007 0.012853 0.010143 0.007409 0.007926 0.004455 46 29/10/04 0.0326 0.012323 0.012829 0.00717 0.009379 0.004568 47 30/11/04 0.045785 0.033342 0.026493 0.011012 0.006911 0.004459 48 31/12/04 0.031449 0.033498 0.016054 -0.00019 0.009186 0.004566 49 31/1/05 0.014358 0.00991 0.00337 0.000661 0.011025 0.004553 50 28/2/05 0.021621 0.024967 0.014323 0.00262 0.00217 0.003984 51 31/3/05 0.00974 0.01007 0.00154 0.001632 0.007423 0.004697 52 29/4/05 0.03148 -0.02288 0.01036 0.015723 0.015287 0.004963 53 31/5/05 0.032064 0.035535 0.001464 0.010401 0.011617 0.004847 54 30/6/05 0.047693 0.016818 0.013062 0.00584 0.011358 0.004634 55 29/7/05 0.026486 0.037586 0.01923 0.004569 0.00379 0.004797 56 31/8/0S 0.020132 0.000846 0.008833 0.008189 0.011108 0.004784 57 30/9/05 0.050922 0.03287 0.016261 0.00615 0.00209 0.004561 58 31/10/05 -0.03843 0.01916-001456 0.001779 -0.00446 0.004775 59 30/11/05 0.044381 0.042206 0.014806 0.007488 0.006345 0.004634 50 30/12/05 0.031033 0.021568 0.016121 0009227 0.009698 0.004727 61 31/1/06 0.035568 0.032141 0.032262 0.001653 0.0007 62 28/2/06 0.005802 0.003232 0.003377 0.005711 0.003366 0.004305 0.00479 63 31/3/06 0.047711 0.024454 0.018227 0.001138 64 0.00845 28/4/06 0.026024 0.009083 0.022159 0.00474 204726 0.00558 -0,00376 0.004422 4191 Sheett 1799 RS na 04236 + 54 66 67 68 65 Ready + 57 68 69 70 71 72 73 74 75 75 77 78 79 80 81 82 83 84 85 B6 87 US 89 90 91 92 90 G D TO re we 62 28/2/06 0.005802 0.003232 0.003377 0.005711 0.003366 0.004305 63 31/3/06 0.047711 0.024454 0.018227 0.001138 -0.0084 0.00474 64 28/4/06 0.026024 0.009083 0.022159 -0.00558 0.00376 0.004422 65 31/5/06 -0.04736 0.04391 -0.01299 0.003985 0.005354 0.004836 66 30/6/06 0.020404 0.005015 0.00106 0.001735 0.000246 0.004805 67 31/7/06 -0.01681 0.005522 0.002863 0.000813 0.01098 0.004823 68 31/8/06 0.033429 0.025589 0.008537 0.010564 0.016174 0.005226 69 29/9/06 0.013112 0.018081 0.001292 0.008402 0.00761 0.005109 70 31/10/06 0.047136 0.030845 0.017703 0.00185 0.005127 0.005065 71 30/11/06 0.023706 0.011272 0.020713 0.007567 0.008282 0.005157 72 29/12/06 0.036705 0.026465 0.018337 0.00304 -0.0036 0.005336 73 31/1/07 0.018866 0.017931 0.013285 0.004679 7.25E-05 0.005483 74 28/2/07 0.016204 0.01181 0.0074 0.011968 0.012174 0.00492 75 30/3/07 0.033025 0.01509 0.012353 -0.00266 0.000669 0.005235 76 30/4/07 0.029989 0.034975 0.020212 0.006918 0.00342 0.005475 77 31/5/07 0.026426 0.033718 0.023085 0.000487 0.00581 0.005402 78 29/6/07 -0.00113 0.00973 0.007794 -0.0045 0.00236 0.005184 79 31/7/07 -0.02042 0.03056 4.8E-05 0.00669 0.014519 0.005252 80 31/8/07 0.022217 -0.00051 0.0153 0.008581 0.014012 0.005307 81 28/9/07 0.055815 0.029983 0.027053 0.00048 0.004042 0.005726 82 31/10/07 0.029421 0.021433 0.031628 0.00039 0.009108 0.00573 83 30/11/07 -0.02892 0.0429 0.01206 0.004561 0.014963 0.005571 84 31/12/07 0.02635 -0.0081 0.004655 0.00161 0.00298 0.00603 85 31/1/08 0.10997 -0.08406 0.0148 0.012222 0.020025 0.005969 86 29/2/08 0.00666 -0.01722 0.016051 0.00616 0.009059 0.005414 87 31/3/08 -0.0342 0.02129 0.02109 0.016031 0.00449 0.006661 88 30/4/08 0.045121 0.061438 0.005216 0.000153 -0.00635 0.006532 89 30/5/08 0.017103 0.016 0.019975 0.00109 0.00696 0.006559 90 30/6/08 0.07566 0.08233 4.6EOS 0.002876 0.002889 0.006289 91 31/7/08 0.04695 0.01819 0,02607 0.017875 0.016539 0.006678 92 29/8/08 0.040381 0.011559 0.01472 0.021625 93 0.01607 0.006679 30/9/08 0.09939 0.10783 0,06551 0.01285 0.006228 0.005861 94 31/10/080.12884 0.16369 0.06299 0.02008 28/11/08 0.00898 0.007144 0.06295 0.06074 0.04146 0.029602 0.032207 0.005447 A0127 010721 AR Sheet1 0 AR0220 na757 + Ready 95 96 97 GE = ill Merge & Contra X Fox B D E F G H 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 28/11/08 0.06295 -0.06074 0.04146 0.029602 0.032207 0.005447 31/12/08 0.00137 0.010231 0.00034 0.01248 0.023904 0.004257 30/1/09 -0.0484 0.07093 0.010938 0.014067 -0.01265 0.004006 0.00291 2712/09 0.0456 0.08958 -0.00885 -0.01228 0.004608 31/3/09 0.080698 0.0636 0.006538 0.001153 0.011409 0.002629 30/4/09 0.057048 0.103324 0.016832 3.53E-OS 0.00073 0.002643 29/5/09 0.014571 0.056238 0.040607 -0.00719 0.00583 0.002514 30/6/09 0.039599 -0.00068 0.004297 0.00614 0.009527 0.002675 317/09 0.073392 0.074171 0.025381 0.003136 0.008788 0.002651 0.00253 31/8/09 0.066386 0.037225 0.015266 0.007165 0.010708 30/9/09 0.062647 0.030743 0.030405 0.007235 0.007367 0.002829 30/10/09 -0.02071 -0.02245 0.001264 0.00075 0.001328 0.002558 30/11/09 0.018017 0.030925 0.021058 0.014982 0.011982 0.003035 31/12/09 0.036888 0.036931 0.008821 0.00381 -0.00725 0.003226 2971/10 -0.06167 0.03617 0.001682 0.013467 0.009835 0.003469 26/2/10 0.020459 0.019455 0.006811 0.00496 0.008224 0.003453 31/3/10 0.057414 0.065227 0.0222 -0.00583 0.003871 0.003268 30/4/10 0.01346 0.002508 0.012397 0.00551 0.007193 0.003464 31/5/10 -0.0754 0.07575 -0.02764 0.016453 0.016498 0.003752 30/6/10 0.02647 0.04167 -0.00843 0.013651 0.011325 0.003951 3077/10 0.044761 0.057381 0.015875 0.002727 0.009335 0.004221 31/8/10 0.01081 -0.03364 0.00235 0.019206 0.02344 0.00406 30/9/10 0.047877 0.069511 0.034323 0.00902 0.000881 0.003715 29/10/10 0.018352 0.028494 0.019221 4.66E-06 -0.00052 0.004199 30/11/10 0.00968 0.00329 0.00185 0.0022 0.00965 0.003887 31/12/10 0.037732 0.056556 0.029031 0.000266 4.078-05 0.004242 31/1/11 0.001054 0.019388 0.006885 0.009202 -0.00099 0.004284 28/2/11 0.023319 0.029231 0.013827 0.004242 0.003273 0.00371 31/3/11 0.006681 -0.01275 0.00123 0.006828 0.002909 0.004188 29/4/11 0.00318 0.022676 0.018028 0.004789 0.010806 0.004026 31/5/11 0.02018 0.01273 -0.00957 0.012839 0.013641 0.004165 30/6/11 0.01976 0.01585 0.01361 0.005514 0.002902 0.004042 127 29/7/13 0.03831 -0.02725 0.00688 0.016736 0.012767 0.004182 128 31/8/11 -0.01979 0.06766 0.023 0.019913 0.023165 0.004262 179 aniss 106275 06067 00320009020 01576R 0.00RR + + 3 Sheet1 Ready J11 v ft C D E JUIZTE UTVUS808 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 156 G H B U.WUZITT VOU7UUZUTOZ OUNOJZ SZ 133 31/1/12 0.051319 0.043268 0.023366 0.001358 0.010722 0.003894 134 29/2/12 0.020355 0.047295 0.016104 -0.00212 0.004816 0.003325 135 30/3/12 0.012174 0.017629 0.000491 0.008615 0.000282 0.003905 0.00946 0.003783 136 30/4/12 0.013031 0.01533 0.00038 0.01594 0.00381 137 31/5/12 -0.06737 0.06765 -0.01331 0.030966 0.018363 138 29/6/12 0.005355 0.042831 -0.004 -0.00163 -0.00053 0.002838 139 317/12 0.041993 0.013469 0.014213 0.003716 0.013547 0.002925 140 31/8/12 0.021369 0.02003 0.0084 0.006276 0.003828 0.002991 141 28/9/12 0.021814 0.021496 0.010412 0.00973 0.005779 0.003132 142 31/10/12 0.029184 0.00461 -0.00179 0.000182 0.0038 0.002966 143 30/11/12 0.003918 0.014697 0.006426 7.77E-05 0.009265 0.002543 144 31/12/12 0.033331 0.019128 0.014821 0.001819 0.002185 0.002875 145 31/1/13 0.049797 0.05373 0.020669 -0.00226 0.00227 0.002684 146 28/2/13 0.052916 0.014745 0.002385 0.005942 0.007904 0.002246 147 29/3/13 -0.02254 0.026757 0.012117 0.00203 0.009553 0.002463 148 30/4/13 0.042964 0.027869 0.013865 0.015421 0.012513 0.002614 149 31/5/13 0.04538 0.01437 0.004185 -0.00075 0.01374 0.002569 150 28/6/13 -0.02403 0.02419 0.01655 0.01046 0.00879 0.002299 151 310/13 0.05297 0.047328 0.008814 0.008555 0.005496 0.002532 152 30/8/13 0.02513 0.02062 -0.00542 0.00321 0.00076 0.002314 153 30/9/13 0.021621 0.037327 0.012731 0.005007: 0.008683 0.00211 154 31/10/13 0.039346 0.0395791 0.015938 0.00056 0.010127 0.00218 155 29/11/13 0.01358 0.021712 0.013086 -0.00099 0.001067 0.002132 156 31/12/13 0.008235 0.020881 0.011947 0.005252 -0.00469 0.002148 157 31/1/14 -0.02996 -0.03242 0.00286 0.010875 0.016745 0.002243 158 28/2/14 0.049164 0.04212 0.017157 0.003413 0.005823 0.001993 159 31/3/14 0.002094 0.001861 0.00484 0.00019 0.003546 160 30/4/14 0.016836 0.007288 0.00218 0.00207 0.009067 0.007741 0.002214 161 30/5/14 0.006452 0.022491 0.01131 0.013728 0.010118 0.002249 162 30/6/14 0.01447 0.013812 0.009578 0.008045 163 31/7/14 0.044124 0.00584 0.002202 -0.00783 0.00309 0.002912 0.006364 0.002299 164 29/8/14 0.006424 0.026414 0.008783 0.010142 0.014793 0.002266 30/9/14 -0.05367 0.00995 0.00011 166 0.00333 31/10/14 0.042654 0.011377 0.0003 0.002074 SER 0.008 0.009567 0.009115 0.002311 AAAF Sheet1 ARROS AS + 167 168 109 170 165 Ready Pasta BIU a. Av Margo & C J11 * D E H 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 F G B 0.0003 0.002074 165 30/9/14 0.05367 0.00995 0.00011 -0.00333 166 31/10/14 0.042654 0.011377 0.008 0.009567 0.009115 0.002311 167 28/11/14 -0.03242 0.028885 0.014972 0.012676 0.013803 0.002249 168 31/12/14 0.020403 -0.00777 0.000126 0.016851 0.010542 0.002318 169 30/1/15 0.032236 -0.00547 0.00807 0.016104 0.02313 0.002514 170 27/2/15 0.069222 0.058939 0.010566 0.002798 -0.00636 0.00209 171 31/3/15 -0.00052 -0.00431 0.00599 0.007597 0.009723 0.002053 172 30/4/15 -0.01647 0.010413 0.000211 0.01108 -0.0051 0.001797 173 29/5/15 0.004287 0.012677 0.00826 0.000362 -0.00402 0.002003 174 30/6/15 0.05315 0.02942 -0.01314 -0.00926 -0.01041 0.001759 175 31/7/15 0.043134 0.024939 0.008726 0.013 0.014113 0.001804 176 31/8/15 -0.07698 0.06654 -0.01988 0.006371 0.00027 0.001809 177 30/9/15 -0.02858 -0.03549 0.01409 0.0025 0.010317 0.001762 178 30/10/15 0.044205 0.078741 0.005266 0.002992 0.004256 0.001891 179 30/11/15 -0,00682 0.006407 0.002041 0.00876 0.002024 0.001667 180 31/12/15 0.027281 0.02157 -0.00849 0.003328 0.000124 0.001916 181 29/1/16 0.0545 0.05415 -0.01411 0.012222 0 021495 0.00201 182 29/2/16 0.01725 -0.01534 0.01084 0.010343 0.014049 0.001779 183 31/3/16 0.047762 0.052655 0.002853 0.00213 0.006538 0.001981 184 29/4/16 0.033398 0.008588 0.003384 0.002587 0.000462 0.001989 185 31/5/16 0.031363 0.017612 0.003576 0.012561 0.007134 0.001935 186 30/6/16 -0.02442 0.01316 0.00102 0.013269 0.023441 0.001648 187 2977/16 0.063592 0.041198 0.011458 0.007354 0.004032 18 31/8/16 -0.01557 0.004207 0.004659 0.004218 0.00223 0.001689 0.00173 189 30/9/16 0.005143 0.001949 0.001237 0.00225 0.000491 0.001416 190 31/10/16 0.02175 0.00669 0,00178 191 30/11/16 0.02805 0.026341 0.003639 -0.01276 -0.01163 0.001461 0.0144 192 30/12/16 0.043404 0.027761 0.009627 0.00172 -0.01523 0.001445 193 31/1/17 -0.00775 0.012872 0.007004 0.0061190.00573 0.002821 0.001451 194 28/2/17 0.021831 0.030965 0.009665 0.00157 195 31/3/17 0.032753 0.009639 0.003939 0.004411 0.00172 0.008997 0.001344 196 28/4/17 0.009828 0.011525 2.6E-05 0.001502 0.00431 0.007514 0.006786 0.001485 197 31/5/17 0.02743 0.014821 0.008181 0.011653 0.005054 0.001487 198 30/5/17 0.002205 0.000227 0.00488 199 31/7/17 0.000141 0.014316 0.013654 0.002479 0.002547 0,001457 0.00898 -0.0028 0.001433 Sheet1 192 195 200 201 202 203 Ready Below we provide some questions for the disciplinary project. You may want to make some adjustment for some parts of the questions, e.g., adjusting the numbers in red or consider more periods for the dynamic optimisation, in order to have more interesting results. In that case, please feel free to do so. Setup. In reality each asset class in the spreadsheet provided on canvas, e.g, Dev. Equities and Hedge Funds, may contain several different assets. For the simplicity of analysis and presentation, without loss of generality we assume each asset class behaves like a single asset and admits some price process. We will work on four reset classes, including Cash (Asset Class 1), Dev. Equities (DEQ, Asset Class 2), Hedge Funds (HF, Asset Class 3), and Dev. Gov. Bonds (DGB, Asset Class 4). Let S = (S)en be the price process for Asset Class i, i = 1,2,3,4. Here time t is in months and thus S is the price of Asset Class i at the end of the t-th month. For 1 = 1,2,3,4, assume the dynamics of the price of Asset Class i satisfies S-1 - Sex -0,1,2,.... (1) Denote X=(x,xx, x4). Assume X., X, X3.. are i.i.d., and each admits multivariate normal distribu- tion with mean a (a, a, a, a) R' and covariance matrix B - (b)=1.2.3.4. For i = 1,2,3,4, denote a the monthly return of Asset Class i in the t-th month. By (1), SH 1-1 = x= In(1+a;) Note that the realised monthly returns or for these asset classes since the year 2001 are provided in the spreadsheet 1 Parameter Estimation Q1. Estimate the parameters , and by for y=1,2,3.4 using market data for the two time intervals (A) from 1/1/2007 to 31/12/2010. (B) from 1/1/2011 to 31/12/2014 Q2. Form-1.2. by (1) the return for Assut Class i from the beginning of the t-th month to the beginning of the (+ n)-th month is given by A 1 exp 1 SH ATE Show that -1.-1.2.3.4 wliere (YYYY) admits multivarinte normal distribution with mean na and covariation matrix B JX B D E F G H Monthly returns (net oftaces and investment fees) from asset classes, all hedged @ @ DATE Cash 3 4 5 6 7 18 19 20 21 22 23 24 25 26 27 28 29 30 5 1 31/1/01 0.043198 0.02603 0.009438 0.015003 0.010966 0.005364 2 28/2/01 -0.00187 -0.07868 -0.00588 0.006675 0.01025 0.004695 3 30/3/01 0.04847 -0.04787 -0.00337 0.005939 0.007192 0.004821 4 30/4/01 0.058545 0.06975 0.006883 -0.00966 0.00638 0.00435 5 31/5/01 0.017158 -0.0071 0.008255 -0.00377 0.005613 0.00405 6 29/6/01 0.037769 -0.0254 0.005842 0.00068 0.006525 0.004009 7 31/7/01 -0.04744 0.02128 0.00021 0.004161 0.012291 0.004221 8 31/8/01 0.00958 -0.06226 0.009159 0.026625 0.009451 0.004432 9 28/9/01 0.0657 -0.089 0.00832 0.011419 0.008455 0.004287 10 31/10/01 0.067654 0.025293 0.004407 0.016335 0.019457 0.003786 11 30/11/01 0.033143 0.062491 0.0054 -0.0107 -0.00651 0.003571 12 31/12/01 0.026497 0.010931 0.011916 0.00879 -0.00549 0.003623 13 31/1/02 0.012901 -0.01952 0.00539 0.000473 0.004313 0.003565 14 28/2/02 0.01113 0.01004 0.00561 0.005765 0.005154 0.003293 15 29/3/02 0.006496 0.039896 0.007383 -0.00859 -0.00677 0.003483 16 30/4/02 -0.01802 0.04586 0.007946 0.014438 0.013874 0.003777 17 31/5/02 0.008467 0.01092 0.00674 -0.0027 0.00469 0.003704 18 28/6/02 0.04193 0.07735 0.00844 0.012693 0.015635 0.003896 19 317/02 -0.04023 0.08437 -0.01346 0.01032 0.014983 0.004384 20 30/8/02 0.01625 0.001642 0.008461 0.010429 0.016764 0.004132 21 30/9/02 0.04157 0.11047 0.000781 0.01687 0.017054 0.004132 22 31/10/02 0.026771 0.073984 0.00041 0.001893 0.00014 0.004172 29/11/02 0.011244 0.05349 0.010936 0.001247 0.002032 0.00399 24 31/12/02 0.01595 0.06424 0.010655 0.022359 0.01899 0.004134 25 31/1/03 0.01641 -0.03653 0.012756 0.00408 0.008446 0.004058 25 28/2/03 -0.04923 -0.01634 0.006755 0.009675 0.011494 0.003686 27 31/3/03 0.039236 0.0054 0.002605 0.00443 0.001504 0.003991 28 30/4/03 0.043103 0.082659 0.019564 0.005512 0.005857 0.003915 29 30/5/03 0.003713 0.042378 0.027142 0.016025 0.020745 0.004067 Sheett Ready J11 A ona TOUT TURUU 35 36 37 38 39 40 41 42 43 44 45 46 48 49 50 51 52 5a 54 55 56 57 58 59 GO 61 B C D E G ETTO 31 31/7/03 0.032662 0.028493 0.00082 -0.00875 0.0158 0.003921 32 29/8/03 0.02993 0.024352 0.007599 -0.0002 0.00162 0.004001 33 30/9/03 -0.0014 -0.01556 0.015157 0.006676 0.016878 0.003967 34 31/10/03 0.033544 0.054291 0.013765 -0.01103 0.00681 0.004081 35 28/11/03 -0.02022 0.006509 0.010776 0.00465 0.004429 0.003842 36 31/12/03 0.037631 0.044966 0.019546 0.017542 0.011475 0.00448 32 30/1/04 -0.00791 0.016904 0.017045 0.00188 0.008913 0.004574 38 27/2/04 0.031262 0.017778 0.013983 0.012793 0.01346 0.00441 39 31/3/04 0.023205 -0.009 0.002839 0.009273 0.007483 0.004773 40 30/4/04 -0.00392 -0.00387 -0.00583 0.00926 0.00992 0.004486 41 31/5/04 0.018696 0.001631 0.00231 0.00908 0.001935 0.004728 42 30/6/04 0.026881 0.021212 0.003432 0.003919 0.002974 0.004515 43 30/04 0.00272 -0.0289 0.00312 0.004292 0.008686 0.004629 44 31/8/04 0.011562 0.00168 0.001359 0.0141 0.018523 0.004623 45 30/9/04 0.038007 0.012853 0.010143 0.007409 0.007926 0.004455 46 29/10/04 0.0326 0.012323 0.012829 0.00717 0.009379 0.004568 47 30/11/04 0.045785 0.033342 0.026493 0.011012 0.006911 0.004459 48 31/12/04 0.031449 0.033498 0.016054 -0.00019 0.009186 0.004566 49 31/1/05 0.014358 0.00991 0.00337 0.000661 0.011025 0.004553 50 28/2/05 0.021621 0.024967 0.014323 0.00262 0.00217 0.003984 51 31/3/05 0.00974 0.01007 0.00154 0.001632 0.007423 0.004697 52 29/4/05 0.03148 -0.02288 0.01036 0.015723 0.015287 0.004963 53 31/5/05 0.032064 0.035535 0.001464 0.010401 0.011617 0.004847 54 30/6/05 0.047693 0.016818 0.013062 0.00584 0.011358 0.004634 55 29/7/05 0.026486 0.037586 0.01923 0.004569 0.00379 0.004797 56 31/8/0S 0.020132 0.000846 0.008833 0.008189 0.011108 0.004784 57 30/9/05 0.050922 0.03287 0.016261 0.00615 0.00209 0.004561 58 31/10/05 -0.03843 0.01916-001456 0.001779 -0.00446 0.004775 59 30/11/05 0.044381 0.042206 0.014806 0.007488 0.006345 0.004634 50 30/12/05 0.031033 0.021568 0.016121 0009227 0.009698 0.004727 61 31/1/06 0.035568 0.032141 0.032262 0.001653 0.0007 62 28/2/06 0.005802 0.003232 0.003377 0.005711 0.003366 0.004305 0.00479 63 31/3/06 0.047711 0.024454 0.018227 0.001138 64 0.00845 28/4/06 0.026024 0.009083 0.022159 0.00474 204726 0.00558 -0,00376 0.004422 4191 Sheett 1799 RS na 04236 + 54 66 67 68 65 Ready + 57 68 69 70 71 72 73 74 75 75 77 78 79 80 81 82 83 84 85 B6 87 US 89 90 91 92 90 G D TO re we 62 28/2/06 0.005802 0.003232 0.003377 0.005711 0.003366 0.004305 63 31/3/06 0.047711 0.024454 0.018227 0.001138 -0.0084 0.00474 64 28/4/06 0.026024 0.009083 0.022159 -0.00558 0.00376 0.004422 65 31/5/06 -0.04736 0.04391 -0.01299 0.003985 0.005354 0.004836 66 30/6/06 0.020404 0.005015 0.00106 0.001735 0.000246 0.004805 67 31/7/06 -0.01681 0.005522 0.002863 0.000813 0.01098 0.004823 68 31/8/06 0.033429 0.025589 0.008537 0.010564 0.016174 0.005226 69 29/9/06 0.013112 0.018081 0.001292 0.008402 0.00761 0.005109 70 31/10/06 0.047136 0.030845 0.017703 0.00185 0.005127 0.005065 71 30/11/06 0.023706 0.011272 0.020713 0.007567 0.008282 0.005157 72 29/12/06 0.036705 0.026465 0.018337 0.00304 -0.0036 0.005336 73 31/1/07 0.018866 0.017931 0.013285 0.004679 7.25E-05 0.005483 74 28/2/07 0.016204 0.01181 0.0074 0.011968 0.012174 0.00492 75 30/3/07 0.033025 0.01509 0.012353 -0.00266 0.000669 0.005235 76 30/4/07 0.029989 0.034975 0.020212 0.006918 0.00342 0.005475 77 31/5/07 0.026426 0.033718 0.023085 0.000487 0.00581 0.005402 78 29/6/07 -0.00113 0.00973 0.007794 -0.0045 0.00236 0.005184 79 31/7/07 -0.02042 0.03056 4.8E-05 0.00669 0.014519 0.005252 80 31/8/07 0.022217 -0.00051 0.0153 0.008581 0.014012 0.005307 81 28/9/07 0.055815 0.029983 0.027053 0.00048 0.004042 0.005726 82 31/10/07 0.029421 0.021433 0.031628 0.00039 0.009108 0.00573 83 30/11/07 -0.02892 0.0429 0.01206 0.004561 0.014963 0.005571 84 31/12/07 0.02635 -0.0081 0.004655 0.00161 0.00298 0.00603 85 31/1/08 0.10997 -0.08406 0.0148 0.012222 0.020025 0.005969 86 29/2/08 0.00666 -0.01722 0.016051 0.00616 0.009059 0.005414 87 31/3/08 -0.0342 0.02129 0.02109 0.016031 0.00449 0.006661 88 30/4/08 0.045121 0.061438 0.005216 0.000153 -0.00635 0.006532 89 30/5/08 0.017103 0.016 0.019975 0.00109 0.00696 0.006559 90 30/6/08 0.07566 0.08233 4.6EOS 0.002876 0.002889 0.006289 91 31/7/08 0.04695 0.01819 0,02607 0.017875 0.016539 0.006678 92 29/8/08 0.040381 0.011559 0.01472 0.021625 93 0.01607 0.006679 30/9/08 0.09939 0.10783 0,06551 0.01285 0.006228 0.005861 94 31/10/080.12884 0.16369 0.06299 0.02008 28/11/08 0.00898 0.007144 0.06295 0.06074 0.04146 0.029602 0.032207 0.005447 A0127 010721 AR Sheet1 0 AR0220 na757 + Ready 95 96 97 GE = ill Merge & Contra X Fox B D E F G H 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 28/11/08 0.06295 -0.06074 0.04146 0.029602 0.032207 0.005447 31/12/08 0.00137 0.010231 0.00034 0.01248 0.023904 0.004257 30/1/09 -0.0484 0.07093 0.010938 0.014067 -0.01265 0.004006 0.00291 2712/09 0.0456 0.08958 -0.00885 -0.01228 0.004608 31/3/09 0.080698 0.0636 0.006538 0.001153 0.011409 0.002629 30/4/09 0.057048 0.103324 0.016832 3.53E-OS 0.00073 0.002643 29/5/09 0.014571 0.056238 0.040607 -0.00719 0.00583 0.002514 30/6/09 0.039599 -0.00068 0.004297 0.00614 0.009527 0.002675 317/09 0.073392 0.074171 0.025381 0.003136 0.008788 0.002651 0.00253 31/8/09 0.066386 0.037225 0.015266 0.007165 0.010708 30/9/09 0.062647 0.030743 0.030405 0.007235 0.007367 0.002829 30/10/09 -0.02071 -0.02245 0.001264 0.00075 0.001328 0.002558 30/11/09 0.018017 0.030925 0.021058 0.014982 0.011982 0.003035 31/12/09 0.036888 0.036931 0.008821 0.00381 -0.00725 0.003226 2971/10 -0.06167 0.03617 0.001682 0.013467 0.009835 0.003469 26/2/10 0.020459 0.019455 0.006811 0.00496 0.008224 0.003453 31/3/10 0.057414 0.065227 0.0222 -0.00583 0.003871 0.003268 30/4/10 0.01346 0.002508 0.012397 0.00551 0.007193 0.003464 31/5/10 -0.0754 0.07575 -0.02764 0.016453 0.016498 0.003752 30/6/10 0.02647 0.04167 -0.00843 0.013651 0.011325 0.003951 3077/10 0.044761 0.057381 0.015875 0.002727 0.009335 0.004221 31/8/10 0.01081 -0.03364 0.00235 0.019206 0.02344 0.00406 30/9/10 0.047877 0.069511 0.034323 0.00902 0.000881 0.003715 29/10/10 0.018352 0.028494 0.019221 4.66E-06 -0.00052 0.004199 30/11/10 0.00968 0.00329 0.00185 0.0022 0.00965 0.003887 31/12/10 0.037732 0.056556 0.029031 0.000266 4.078-05 0.004242 31/1/11 0.001054 0.019388 0.006885 0.009202 -0.00099 0.004284 28/2/11 0.023319 0.029231 0.013827 0.004242 0.003273 0.00371 31/3/11 0.006681 -0.01275 0.00123 0.006828 0.002909 0.004188 29/4/11 0.00318 0.022676 0.018028 0.004789 0.010806 0.004026 31/5/11 0.02018 0.01273 -0.00957 0.012839 0.013641 0.004165 30/6/11 0.01976 0.01585 0.01361 0.005514 0.002902 0.004042 127 29/7/13 0.03831 -0.02725 0.00688 0.016736 0.012767 0.004182 128 31/8/11 -0.01979 0.06766 0.023 0.019913 0.023165 0.004262 179 aniss 106275 06067 00320009020 01576R 0.00RR + + 3 Sheet1 Ready J11 v ft C D E JUIZTE UTVUS808 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 156 G H B U.WUZITT VOU7UUZUTOZ OUNOJZ SZ 133 31/1/12 0.051319 0.043268 0.023366 0.001358 0.010722 0.003894 134 29/2/12 0.020355 0.047295 0.016104 -0.00212 0.004816 0.003325 135 30/3/12 0.012174 0.017629 0.000491 0.008615 0.000282 0.003905 0.00946 0.003783 136 30/4/12 0.013031 0.01533 0.00038 0.01594 0.00381 137 31/5/12 -0.06737 0.06765 -0.01331 0.030966 0.018363 138 29/6/12 0.005355 0.042831 -0.004 -0.00163 -0.00053 0.002838 139 317/12 0.041993 0.013469 0.014213 0.003716 0.013547 0.002925 140 31/8/12 0.021369 0.02003 0.0084 0.006276 0.003828 0.002991 141 28/9/12 0.021814 0.021496 0.010412 0.00973 0.005779 0.003132 142 31/10/12 0.029184 0.00461 -0.00179 0.000182 0.0038 0.002966 143 30/11/12 0.003918 0.014697 0.006426 7.77E-05 0.009265 0.002543 144 31/12/12 0.033331 0.019128 0.014821 0.001819 0.002185 0.002875 145 31/1/13 0.049797 0.05373 0.020669 -0.00226 0.00227 0.002684 146 28/2/13 0.052916 0.014745 0.002385 0.005942 0.007904 0.002246 147 29/3/13 -0.02254 0.026757 0.012117 0.00203 0.009553 0.002463 148 30/4/13 0.042964 0.027869 0.013865 0.015421 0.012513 0.002614 149 31/5/13 0.04538 0.01437 0.004185 -0.00075 0.01374 0.002569 150 28/6/13 -0.02403 0.02419 0.01655 0.01046 0.00879 0.002299 151 310/13 0.05297 0.047328 0.008814 0.008555 0.005496 0.002532 152 30/8/13 0.02513 0.02062 -0.00542 0.00321 0.00076 0.002314 153 30/9/13 0.021621 0.037327 0.012731 0.005007: 0.008683 0.00211 154 31/10/13 0.039346 0.0395791 0.015938 0.00056 0.010127 0.00218 155 29/11/13 0.01358 0.021712 0.013086 -0.00099 0.001067 0.002132 156 31/12/13 0.008235 0.020881 0.011947 0.005252 -0.00469 0.002148 157 31/1/14 -0.02996 -0.03242 0.00286 0.010875 0.016745 0.002243 158 28/2/14 0.049164 0.04212 0.017157 0.003413 0.005823 0.001993 159 31/3/14 0.002094 0.001861 0.00484 0.00019 0.003546 160 30/4/14 0.016836 0.007288 0.00218 0.00207 0.009067 0.007741 0.002214 161 30/5/14 0.006452 0.022491 0.01131 0.013728 0.010118 0.002249 162 30/6/14 0.01447 0.013812 0.009578 0.008045 163 31/7/14 0.044124 0.00584 0.002202 -0.00783 0.00309 0.002912 0.006364 0.002299 164 29/8/14 0.006424 0.026414 0.008783 0.010142 0.014793 0.002266 30/9/14 -0.05367 0.00995 0.00011 166 0.00333 31/10/14 0.042654 0.011377 0.0003 0.002074 SER 0.008 0.009567 0.009115 0.002311 AAAF Sheet1 ARROS AS + 167 168 109 170 165 Ready Pasta BIU a. Av Margo & C J11 * D E H 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 F G B 0.0003 0.002074 165 30/9/14 0.05367 0.00995 0.00011 -0.00333 166 31/10/14 0.042654 0.011377 0.008 0.009567 0.009115 0.002311 167 28/11/14 -0.03242 0.028885 0.014972 0.012676 0.013803 0.002249 168 31/12/14 0.020403 -0.00777 0.000126 0.016851 0.010542 0.002318 169 30/1/15 0.032236 -0.00547 0.00807 0.016104 0.02313 0.002514 170 27/2/15 0.069222 0.058939 0.010566 0.002798 -0.00636 0.00209 171 31/3/15 -0.00052 -0.00431 0.00599 0.007597 0.009723 0.002053 172 30/4/15 -0.01647 0.010413 0.000211 0.01108 -0.0051 0.001797 173 29/5/15 0.004287 0.012677 0.00826 0.000362 -0.00402 0.002003 174 30/6/15 0.05315 0.02942 -0.01314 -0.00926 -0.01041 0.001759 175 31/7/15 0.043134 0.024939 0.008726 0.013 0.014113 0.001804 176 31/8/15 -0.07698 0.06654 -0.01988 0.006371 0.00027 0.001809 177 30/9/15 -0.02858 -0.03549 0.01409 0.0025 0.010317 0.001762 178 30/10/15 0.044205 0.078741 0.005266 0.002992 0.004256 0.001891 179 30/11/15 -0,00682 0.006407 0.002041 0.00876 0.002024 0.001667 180 31/12/15 0.027281 0.02157 -0.00849 0.003328 0.000124 0.001916 181 29/1/16 0.0545 0.05415 -0.01411 0.012222 0 021495 0.00201 182 29/2/16 0.01725 -0.01534 0.01084 0.010343 0.014049 0.001779 183 31/3/16 0.047762 0.052655 0.002853 0.00213 0.006538 0.001981 184 29/4/16 0.033398 0.008588 0.003384 0.002587 0.000462 0.001989 185 31/5/16 0.031363 0.017612 0.003576 0.012561 0.007134 0.001935 186 30/6/16 -0.02442 0.01316 0.00102 0.013269 0.023441 0.001648 187 2977/16 0.063592 0.041198 0.011458 0.007354 0.004032 18 31/8/16 -0.01557 0.004207 0.004659 0.004218 0.00223 0.001689 0.00173 189 30/9/16 0.005143 0.001949 0.001237 0.00225 0.000491 0.001416 190 31/10/16 0.02175 0.00669 0,00178 191 30/11/16 0.02805 0.026341 0.003639 -0.01276 -0.01163 0.001461 0.0144 192 30/12/16 0.043404 0.027761 0.009627 0.00172 -0.01523 0.001445 193 31/1/17 -0.00775 0.012872 0.007004 0.0061190.00573 0.002821 0.001451 194 28/2/17 0.021831 0.030965 0.009665 0.00157 195 31/3/17 0.032753 0.009639 0.003939 0.004411 0.00172 0.008997 0.001344 196 28/4/17 0.009828 0.011525 2.6E-05 0.001502 0.00431 0.007514 0.006786 0.001485 197 31/5/17 0.02743 0.014821 0.008181 0.011653 0.005054 0.001487 198 30/5/17 0.002205 0.000227 0.00488 199 31/7/17 0.000141 0.014316 0.013654 0.002479 0.002547 0,001457 0.00898 -0.0028 0.001433 Sheet1 192 195 200 201 202 203 Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions