Find the average daily market return (return for Al-Quds index)

Find the average daily return for BoP

Find the average daily return for PALTEL

Find the expected daily return for PEC

Find the standard deviation for OOREDOO

Find the standard deviation for PADICO

Find the coefficient of variation for AIG (calculate it as r/sd)

Find the coefficient of variation for APIC (using the formula r/sd)

Based on the SD, rank the following stocks from the least risky to the highest risk

Highest Risk

The second rank in the highest risk

Lowest Risk

The second rank in the lowest risk

Find Beta for APIC

Find beta for PALTEL

Find beta for PALTEL

The second rank in the lowest beta

Highest Beta

Lowest Bet

The second rank in highest beta

Explain the differences in ranking stocks according to the standard deviation (SD) and beta. This should entail explaining the different aspects that SD and beta measure, and why a stock that has the highest standard deviation might not have the highest beta.

Based on CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PEC?

Using CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PALTEL?

What is the dividend per share that PALTEL distributed for 2019?

Based on the zero-growth model, what is the intrinsic value of PALTEL stock?

Based on the zero-growth model and taking into consideration the current market price of PALTEL shares, is PALTEL overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Based on the zero-growth model and taking into consideration the current market price of PEC, is PEC stock overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Find the book value per share for OOREDOO (you must look for the required information in OOREDOO annual report for 2019)?

Based on the Book Value Per Share, is OOREDOO overvalued or undervalued?

Select one:

a. Overvalued

b. Undervalued

Using a P/E multiple approach and assuming an average P/E ratio for the investment industry of 12.94, what is PADICO intrinsic value?

Based on the P/E multiple approach, is PADICO overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Select at least two stocks you would not invest in based on the above analysis and their current market price

Please provide a satisfactory analysis (around 300 words) of why the above exercises are not sufficient to make a sound investment decision. The discussion may refer to deficiencies in the models utilized, unrealistic assumptions, theoretical shortcomings, etc. The mark depends on the depth of your analysis and your ability to address new knowledge that was not covered in class.

plz answer all this question plz hurry up

Calculate the data on Excel and find all the following data In a fast and clear manner and all data are complete just Enlarge image for illustration

These pictures are complete for the excel file Please help me as soon as possible All data are complete I want to reprimand true And the questions of Aisai are deep and their solution is very good Especially the last question To slide photos, please open and enlarge them

X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = 20 . siffroad . i A Calbit = * a 1 * * K | | M N P [] R T 11 1 v w 02E12 4 0 1] , .2 1 1] ] 1] 2 ,1 E552 3. B ( 1] F 1 Last Update Index BOP.D PALTEL PEC 526.6 2. 1.6 1.32 3 2018/1/3 20.4 1.35 4 2018/1/4 1,25 5 2018/1/4 26.47 . 1.33 6 01/19 576.3 . 2. 1.34 7 2018/1/20 53. 2.51 1.5E 1.11 8 2018/1/11 5/8.1 4.6 1.34 | 2018/1/14 3. 28 1 2018/1/15 91.7 2.3 . 1.34 11 2018/1/26 53.24 . 4.69 1.33 12 2018/1/17 551.17 2. . 1.31 13 2018/1/18 52. E5 2.6 4.3 1.3 14 2018/1/11 1. 24, 4.18 15 2018/1/22 23.47 . 1.1 16 2018/1/24 539.91 4.GE 1.34 13 2018/1/25 523.15 2.51 1.65 1.31 28 2018/1/28 2. 4. 1.35 19 2018/1/21 0 2018/1/19 13.5 . 4.6 1.33 21 2018/1/31 574.51 2. 4. F 1.33 22 2018/21 525.23 2. . 1.31 23 2018/ 2/4 5/639 2. 4. 1.3 2 . { 1,33 25 2018 53,43 1.33 26 01E7 576.5 .51 1.65 1.34 2 2015/ 2/ 525.52 2.51 1.67 1.31 28 2018/2011 52.9 E 129 22. 32 , 3 452 1.3 2 01 / 1 29f1.5 1.5 31 201E14 559. .53 1.55 1.11 37 2nK7/15 son 1 153 1 21 Index and Prices 1 5. 13). F G E OOREDOG PADICO AIG APIC 1.09 1.1B 0.25 7 13 148 199 1,11 1.3 1, 1,14 1. 0.4 1.15 1.44 0.27 2.12 1.5 0.2 2.05 2.1 14 29 1,15 , 4.13 1.5 . 2.05 1.15 1.45 0.25 .03 4.13 1.5 0.2 2.05 213 1 . 1,11 , 1.1 1.4 . 1.11 1.44 0.25 2.1 1.09 1.1 0.2 2.11 2. 143 0 2H 2.1 1,47 1. 1 1.03 1. . 2.1 1.04 1.4 0.25 .07 1.09 1.1 0.2 2.08 2. 1.4 2.1 1,15 1.4 .1 1,03 1.30 0.31 3.1 1.08 1.4 0.25 2.1 1.05 1.1 0.25 2.1 2. 13 12 1. |(, 31 13 1.0 1.1 (, 32 . 1.0 1.42 1,5 . 17 17 1 32 7 ? . 5 . . 1 1] 0 1] /2 /20118 63 0 2018/2/19 ,,1 11 1 : ENG 0) wo 90.2 Ps T[ == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = 20 " : siffroad . i A Calbit * a 1 * 1. ,1 (. F K | | M N P [] R T 11 1 v w . [552 A 31 01/11 32 2015/2/15 33 2018/2/18 24 2011 % 2/11 15 2014 20 4.5 1.82 1.06 2.07 2.53 3 4.35 B 589.2 590.1 523. 21 1, 93.7 525.54 513.1 F 1.11 1.11 1.4 1 2 3 1. 1.42 1.12 , 2.63 .53 2.53 . 1 / 31 3 | | | 0.3 . 0.25 2.26 31 2.3 (1, 1 3 0.34 . 0.33 .23 0.31 2.27 3 2. . . 3 2016 2/22 28 2018/22 4 44. , 1,63 1,015 1.0 2. 2.2 1,15 1.5 1.01 .. 201182 (34 2.6 , 1. 1.3 138 1.4 1.43 1.45 1.5 144 1.44 1. 1.51 152 1.52 1 1.46 1.5 1.7 4 4_55 1.81 1.85 4.4 451 4_32 4.75 1.82 4.8 3 4.2 1.85 1.7E 4.4 44 1.4 1.34 1.3 1.11 1.41 . . 2.51 . 0.25 0.3 2.7 2 2. [22 3 / 2018 1 .1 ) (1, 21 0.31 6.3 . .23 2.61 .51 2.51 2. 1.4 1.41 1.12 1.2 1.03 1.01 1 1 .2 0.25 3 25 1 1 .32 .1 1 1] . 4 2012/2/22 0553 41 2018/3/20 584.61 12 2016/3/1 559.25 43 2018/3/4 532 33. 45 2118/3/5 8. R1 4 201E/3/? 537,55 1 2016/3/11 510 2,12 48 2018/3/12 53.12 4 2011/3/13 5 2012/3/14 91.41 51 2016/3/15 52 2015/3/18 533.81 3 2018/3/19 33 34 55 2018/3/21 85.1 56 01E/3/23 53,18 5 2015/3/25 577. 2.33 2. [ F 2018 66.4 61 2018/3/23 555,57 5571 Index and Prices . 6.3 58.4 1 1 1 2. 2. 2. 4.62 1.82 4.53 0.3 2.5 53 1 83 2011 , 2 1,18 1.0 . 1.41 1.41 1.1 1.39 1,39 1.4 1.3 1.1 1.4 1,31 1.35 1.25 1.4 1.44 1.1 1 1.43 1.43 1.43 1.1 1.4 1. 1.37 1.42 4. . . 4. 0.9 2. 2. 2. 0.5 0.2 0.25 2 1 0.96 .27 .29 2.26 2018 8 2018 5 1 1] 2 4.4 1 . 57 752 . . 4.4 . 0.27 1 32 1 2013 57 112 T, 11 7 ? " ENG SOM Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = * 20 " siffroad . i A Calbit a 1 * * B 1. | | 4.44 K | | M N P [] R T 11 1 V [552 A E 201E/3/20 1 02E/3/20 6 2018/1 F 1.35 W (. .57 2.5 2.8 H 0.25 0.27 . . 1.22 1.3 2.26 556.41 55.5 563.4 1, 1 5.4 551,5K 558. TH 1.3 1.2 1.4 1.4 1. ] 1] 2018 3 1,2 F 1 1 . 1,15 1. 1.0 1.03 23 1,147 4.3 438 4.3 4.3 1.5 . . 1.11 1.27 1.27 . 0.3 . 1. . 2.5 2.57 1 0.25 | 3 39 .1 .2 54 2012/4 65 2014 EE 2016 b 2018, 8 8 2018 ) 50 2018 ,16 7 2018/1/11 1 201E12 4 .4 ,1) 4 . . .55 755 .1 .1 1, 1.5 1.25 1.25 123 1,88 57.4 555.93 550. 551.5 1.1 151.7 592 55.1 1.03 1.01 1.01 29 0.25 0.25 . 2.5 22 2018/1/19 2.55 4.2 4. ] ) , 1 , 1 .1 . 3 2018 ,14 74 2018 ,17 5 2016/4/19 E 201E12 . .4 .4 14 1.4 1.4 1.4 1.3 138 1.8 1.3 1.3E 1.3B 13 1. ( 1.3 1.35 1.35 1 1 1 . . . 1.26 1.2 0.25 0.25 2.5 1.3 4.26 1 1 2018/22 2018 9 550 33. 3 1] .2 23. .3 4 .4 .1 . . 0.25 0.2 0 2H | 1.6 2.53 53 2018 E2 1,11 1. 1.22 1.22 1. 1,1, 1. 1.24 1.2E .4 4 13 1, 1 . 0.97 0.95 1.93 [1,513 . 2.9 0.9 26 .23 .27 25 2 .5 7 2018 24 43.5 2 2016/4/25 546.6 81 02E2E 515, 15 12 3 2018 ,363 18, 12 24 2018 42.4 B5 04E53 55.55 BE 2015/5/6 5:13.17 E 2015 4. Et 8 2018 / 8 2 2015 544. 1 2013 R S 17 35 Index and Prices 1) . . 4.3 0.5 0.25 0.27 . 2. 2.5 52 1.3 1.35 1.35 1.33 133 1.3 1.31 1.32 1.35 1.39 | 43 43 4.35 1.34 1 , ,1 1] (44. 44, . . 1, . 27 / 2018 1.5 1.25 . 0.25 13E . .07 11 351 112 21 ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 : siffroad . i A Calbit * a 1 * 1. [553 * A F K | | M N P [] R T 11 1 V w | 91 02E/5/13 93 02E 1 93 2018/14 B 543.05 513.J (. .51 2.51 51 | | | 1.34 137 1.27 1.27 131 1.3 13 .12 4.3 .1 1 17, 2018 | | | | 0.25 3.1 0.2 2.1 26 ,13 0.7 .11 0.27 .13 0.2 2.12 F .91 0.93 0.321 [1,511 ,41 .91 0.9 19 : 1] 5 2012/5/20 1, 1.3 . 42. 19 40.5 539. EE 5:10.17 40.18 1 / 5 / 21 2 1.5 1.25 1.25 .1 7 2016/5/22 98 2018/23 32 4.3 23 131 4.34 3 4.33 1.33 137 2.5 5 1. B 18 1.20) 12. .1 1 2018 {{ ] 1] ,41 , , | 2,9 . .1 .1 41,493 539.5 533.55 3.2 1. 1.26 1.2E . 5 2.5 2.5 2.5 0.25 0.2 1. B 100 2018/1/27 101 2018/5/28 102 203 E529 103 2018//2 14 2018 /31 105 2012/6/4 106 2018/6/4 10 2016 1 0.39 9 [1] 1 1 ] 1] 2.1 4.33 43 433 1.33 . 41.Fa3 543.23 510,14 .5 2.5 3.5 2.5 1.5 1.34 1.3 . . 0.2 0.2 .12 2.12 2,11 2.12 2.11 ,15 2,15 .16 2.15 2.15 15 2.1 .1 2. 2 ,23 2. 1.33 4.3 2018 108 .19 121 ] 1] 1 . 0.3 . 103) 201186/ 11 2012/6/10 111 2015/5/11 112 2018/6/12 13 2018 ,13 114 2018 ,15 115 2018/6/20 116 2015/5/21 11 2015/5/21 0.25 0.25 2.5 3,37 41,41 541.0 5.3.1 4.4 8.1 4. 6 54.3 3 4.3 1.3B 4. 4 1.5 1.3 1.3 1.32 1.34 1.3 1.34, 1.3 1.3 1,31 1.34 1.3 133 1.34 1.4 1.3 1.32 1.33 13 1,31 1.31 1.32 , .1 1] [1] . .23 0.25 25 [ 13 . 0.25 . 1.8 [1 . 2.7 . 1.41 . 1.5 1.33 . 0.25 0.2E 2.5 2.5 2.5 51559 43 1.35 13 .23 .27 2.23 2018 118 2018 (115 , ) 4.3 437 4.36 1.36 4 1,4565 12 2015/6/23 1.43 121 2015/6/28 540. 63 177 7n3K7/ 11 FH Index and Prices 1,34 1.33 1.34 2.5 2.5 0.7 0.27 13E . 35 11 | AR 727 IT IT ENG 0) wo9 02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit * * a 1 * 1. E553 3.7 * (. F F K | | M N P [] R T 11 1 V w .1 . B 55,57 510.57 41. 68 . 3.5 5 4.36 135 | | | | 0.27 0.2 2. 28 . . 1.31 1.3 4.3 120 01/27 121 2015/6/28 12 2018/1 123 2018 124 2018/7/? 125 2016/3/4 12E 2016/3/5 1] 11. 4 1 45.4 545.3 56. 10 451 . . . 2.5 5 0.87 1.3 [1] . . 0.26 [ 36 4.3 4.4 1.2 . 33 73 0.27 0.2 0 2 1.32 1.32 13 13 1.34 1.35 135 133 1.33 1.34 1.3 1.32 1.29 1.20) 8/ 2018 12 , 1,36) 1] 3 . . . 5 2.5 2.5 2.5 4.3 1.39 1.3B 4.38 1,35 1.35 1.15 1.3 1, 1.35 1.35 1.35 1.3 1, 1 1.33 1.33 . . . 0 22 0.27 0.25 | 3 18 2019 1225 2017/7/16 13- 2016/3/11 131 201E/7/12 13 2018/15 133 2011 134 2012/7/17 135 2018/7/21 13E 2016/3/19 13 2018/22 .31 2.3 , .4 .1 1] . 54.4 515.2 4.85 42. 42 43.07 543.0 513.5 42. Eg 42,33 41. 51.3 511.21 39. EH .1 .1 4.3 1.3B 1.3B 2.5 3.5 2.5 . . 0.87 [ 36 0.25 0.25 . .3 .31 23 1.3 .4 1 .1 ] 1] 2011 138 .1 . . . 4.3 4.3 4.37 1.36 4.36 1.33 1.33 1,31 1.34 1.31 1.33 1.33 1, . 0.25 0.2 130 2018/2/24 140 2017/25 111 2012/7/25 142 2018/29 143 2011% 365 144 2012/3/11 145 2018/a/ 11 02E 5/2 14, 2018, 2.9 . . . 0.25 0.25 1,31 . 1.3 1. B 1. B 1. 28 1, 1. 1] 3 .4 , 43. . . 36.5 537.3 5.1.1 5.9 .1 435 1.34 1.37 4.4 2.3 2.3 28 2 .31 2.3 2.3 3 3 1,14 1.37 1.39 124 0.5 0.25 0.2 2.9 2018 148 : 41. . . .1 0.26 2.9 . . 2.9 1.8 18 1,21) 1.33 1.33 1,31 1.5 1.3 140) 2017 546,7 437 4.3B 1 7E 1E3EB 150 E 15170K . 0.2 1 H 2.3 13 317 115 E3 E Index and Prices 131 ENG 0) wo9 02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 " : siffroad . i A Calbit = 1 a * * 1. 3.7 * ( K | | M N P [] R T 11 1 V w | . [553 A 15 01ESE 151 02E 3 15 2018/3/12 13 2018/13 154 2012/3/14 B 563 1355 42. B3 3, F . 0.9 0 22 | | | | 0.25 2.3 0.2 2.3 2.3 2.17 45 45 1] .1 2, .40 . 4.3 1.35 4.3 43 4.4 1.34 1.35 4.3 32 4.2 . 0.33 2.3 . E535 155 540.26 511.5 411 .4a 2.8 19 2. ,[ 15 2015/3/1E 15 2018/3/19 18 2018/3/20 150 2012/3/27 16 2015/5/21 161 2016/8/22 16 2018/ 3 . . .25 0.26 0.26 1,31 . . 0.25 23 [1] .4 38.53 537.93 533.EE 536 .47 2.1 2.4 4 1.7 4.3 1.33 1.33 1.32 1,31 1.2 1.3 1.3 1.3 1.5 1.31 1.3 1.32 1.3 1.3 1.3 1.3 1.3 13 13 1.31 1.32 132 13 0.11 3 (1, 2 0.15 0.35 0.17 3 (1, 2 0.1 0.43 2.3 .28 2.33 ,33 3 2018 13 4 3 [ .41 F 1.3 1.35 1.3 1, 1.5 1.3 1.39 1.3 1, 1 1.1 1.3 1.35 1.3 1, 1 1.1 1.37 1.37 1.3 1, 1.37 1.37 1.3 1.3 1,3 1.4 1.37 1.35 129 1.3 1.33 151 . 4.3 4.3 . 0.26 . .47 7.7 . 0.13 44 4.3 164 2018 165 2015/9/4 16 2015/9/5 16 2018/9/6 18 2018 / 1 / 169 2012/16 17- 2016/9/12 171 2015/9/11 540,79 511.01 41. Et 42.8 43.4 541.26 5:12. 25 2.3 23 ,31 .4 [1 .[] . .45 2.6 4.3 4.35 1.35 2.3 2.3 2018 / 01 / 1 1 .4 .41 . [ . . 0.25 0.26 1,31 .33 5.23 0.33 33 .1 4. 4 434 1.33 ,33 .33 . .45 2.5 1.31 1.34 1.3 13 . (1.43 0.42 0.11 0.2 (1.41 0.1 0.41 0.1 1.4 1,39 0.37 0.3 1 1H 13 2011/11/12 174 2012/18 33,51 175 2018/9/13 538.43 176 02E/20 53322 17, 2018, 3 3.0 19 2018 / 1 / 4 3, 3 174 2012/9/5 162 01 A/a/28 53.45 R1 2013 Ra77 E1715 Index and Prices 1.33 434 43 4.3 1.33 2.3 3 3 . . 2. 1,33 . 3 .34 1.3 1.3 1.3 . 2.3 13 1 17 117 H? 11 | ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " : siffroad . i A Calbit a 1 * 1. [553 * B F 1. | | 1.33 (7 K | | M N P [] R T 11 1 V 014/ 27 161 w (. 2. 2.38 F 1.33 | . 1.31 1.32 . 0 2 1.3 1.7 129 1.8 38 4.3 4 1,3 .1 53.15 523.1 531,89 32. 38 3.71 530.6 531.21 30.18 , .33 .35 2.38 .32 4.31 1.32 1.32 4.3 .1 .1 .1 128 1.8 8 [ 163 02E 930 183 2018/10/21 184 2018/1/3 185 2018/11/4 1BE 201E10/3 187 2015/10/E 188 2018/1/ 184) 2011/10/10 190 2018/1/11 191 01/10/14 193 2016/10/15 193 2018/10/16 14 2018/1/17 195 2013/11/18 196 2016/10/21 197 2016/10/22 198 2018/10/23 1.35 1.34 1.35 1.33 1,25 1.11 1.32 1.11 1.33 | | | | 0.3 2.3 0.J 2.3 | 4 24 1.41 (1.4 2.3 0.4 . 1, 2. 14 2 0 2 1.4 . 6.4 [.7 2. .4 . . . 0.25 23 [ 13 . 5.23 0.53 0.25 [13 . .1 .1 4.3 2. 57.5 527.3 23.9 . 1.7 12 .4 | [] 25 , 1,2 .1 1.7 . 1.4 0.35 4 5 3 4.32 1.7 . .1 17,71 537.6 5 28.19 2.13 . .35 2.38 .3, 3 2.33 .37 2.37 .3, ,3, .37 .36 2.36 33 1.34 1.34 1.33 1.33 . 2. 1. B 128 4.3 14 25 .4 .1 .1 /2011 / 10 (1134 2118/1/25 O0 01/10/28 01 1. (1, 2 0, 20 0.3 6.5 524.3 523.5 . .1 02 2016/10/29 203 204B/10/30 1.34 1.34 1.32 1.32 . 0.33 0.33 [131 .31 0.21 2.3 22 [131 . . . 35 4.32 1.32 4.3 4. 4 434 1.33 3 3 2 1.5 1.25 1. 28 32, 1,2 , .1 101/31 ,2018 01/11/1 201E11 / 4 06 2018/11/5 07 11 2018 2018 0.3 3 (1, 2 (1,41 0.4 0.1 3H . . 2.33 .33 2.33 35 ,33 .35 .35 1.33 4.33 227,19 523.5 529.03 23 [123 2018/11/ 10 2011 211,9 5.13 52a. B3 317 313K 11/13 | 73 7 Index and Prices 1,14 1.34 1.35 129 1.3 1,35 1.6 1.8 16 1.28 34 4 1,34 . 24 .1 (, 39 0.5 0.7 2018/11/11 11 . . . .1 1.35 1 7E 1.36 112 37: | 17 11 | 12 ENG (0) w09 'o Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 . siffroad . i A Calbit a 1 * 1. E553 3.7 * A K | | M N P [] R T 11 1 V w (. .35 3 F 1.35 | | | | 0.3 2017/11/11 11 .1 . 4.35 1.35 4.34 12 2018/11/12 213 2018/11/13 214 2118/11/14 1.37 B 52a. F5 5 23.2 23.3 201 23.11 57.1 5 25.2 F 0.23 0.33 0.33 [ 13 .33 13 3 , . 2.2 ,23 . 4 0.17 3 (1, 20 1, 1 0.3 13 / 11 / 18 15 01/11/19 16 2016/11/21 1.3 13 12 1.3 1.3 1.9 1.2 14 . 4.3 1.32 1.32 4.33 . 2.28 23 2018 2018/11/12 219) 20118/11/21 .34 .3 2.3 .33 3 .33 .33 2.3 4 2018/11/20 01/11/27 31 4.33 1.33 .1 .1 0.37 3 (1, 2 0, 20 0.4 0.3 0.39 3.19 523.21 527. 2.1 22 2016/11/2a 23 2018/11 31 1.7 1. 28 1.28 0.2 0 31 1, . . 0.53 0.2 [131 . 0.21 0.31 033 [ 13 .33 55 2.3 23 ,23 . 2011/12 4 012/12/5 5 01/13/4 36 3 , 1.3 4.33 433 433 4.32 . 3 3 . 2.3 25,1 52.75 1, 1.16 1.35 1.37 1.3 1, 1.35 1.34 1.35 1.3 1, 1.3 1.35 1.33 1.3 1, 1.3 1.35 1.35 1.35 1.3 1.35 1.35 1.37 1.3 .1 .1 .1 1.4 . 0.39 . 27 2015/12/5 .523 2.3 23 5253 | 4 1 12 /2018 28 ( 12 / 2017 (20 2017/12/10 30 2018/1/11 31 4.3 2 4.3 128 1.8 1.7 . .1 4.3 4. 28 1.7 1. 28 1.7 . 2.3 2.3 23 3 . 0 31 [131 .31 .21 (1, 2 0, 20 0.35 0.15 0.3 (1, 2 1, 3g 0.3 0.15 3.3 .1 .4 .1 33. . . 2. 3 52.46 2.3 32 2016/12/12 52.12 2.3 233 2018/12/13 1 3 24 2018/1/16 25 2018/1/17 23, 2XA 3 52.25 52.31 2.3 238 2018/12/20 52.8 3 3 .31 57.13 575 15 37? Index and Prices 1 == | 201E12 / 18 36 2016/12/19 3 . 1.E 4.2E 7 1.6 1.7 126 1.2 1. 1. B .33 33 ,32 .3 .1 41. 3 / 12 / 2017 (30 2018/1/4 40 01/12/25 41 17 30 307 1,31 .31 0.39 , 3 0.5 0.3 1 12 1.37 137 3. 4.3 . . 12R 117 H? 18 7 35. - : " ENG (0) w09 '02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 : siffroad . i A Calbit * a 1 * 1. 3.7 * [55 A K | | M N P [] R T 11 1 V w (. . 01/12/26 41 B 527.1 5 22.1 2. Et . F 1.37 117 4.3 1.E 4.3 .1 .1 12 2016/12/27 243 2018/12/20 2.3 2.32 12E 1.28 | | | | 0.3 0.39 .35 0.32 35 (1, 2 . 0.1 .35 0.43 3 , 4 31 / 12 / 2017 ?/2015 / 1 45 019/1/3 4E 2018/1/26 17 2.3 .31 F 0.4 . 033 [ 12 . 5.23 0.23 022 [ 12 .3 .1 .1 .1 3. 0.13 2.36 2.3 248 2018/1/28 9.1 530.5 530.05 9. E2 23, 5.71 523.5 531.2 228 1.3 1, 1.34 1.35 1.39 1.3 1, 2 1.34 1.3 1.3 1.39 128 1.8 2011/1/4 (40 2015/1/16 2015/1/13 51 .[] 2.31 2.32 3 3 . 2.35 3 4.3 4.3 1.32 4.3 2 431 1.32 1.33 4.3 3 4.35 4.34 .1 .1 0.4 0.42 0.12 33. 3. . 2.39 52 2015/1/11 53 2018/1/19 1.6 16 1.2 41 39 0.33 0.33 [ 13 . 1- .[] 2014/1/16 01/12 2011 5 3 (8 ,3 ,30 .1 32. . 0.43 . 56 2018/1/20 5 2018/1/21 258 2018/1/22 . . 2.27 2.26 , 2 1.3 1.4 1.11 1.4 11 0.13 .3a .33 2.3 3 .[] 28/1/4 2013 01/24 2011 60 . 4.3 431 431 4.32 1.32 2.37 523.73 5 28.12 222 3.12 13.4 527.5 5 28.25 30.33 30], ii 31.1 533.55 532.5 32. Et 61 2018/1/27 62 2015/1/2E 263 2019/1/29 3. . 2.21 0.32 1.21 [131 .31 0.21 0.31 1.21 [131 . 2 0.3 0.42 0.13 1.3 1.3 1.3 1,31 1.32 1.32 1.33 1.34 133 1.1 1.35 1.35 2. 21 3 .4 1. 1.43 1.13 1.43 1,43 1.43 1.42 1.12 143 .15 .1 .2 201148/1/363 4] 2014/1/11 5 2017 EE 2015/21 7 2 2019 68 2 / 2017 ] . 4.4 1.42 1.2 4.1 . .37 2.37 2. 2. 0.31 31 1 .1 [. 0.15 0.15 0.14 (. . 0.15 33 , .33 .1 1.3 4.5 4.45 1,32 0.31 2,51 n 31 01510 31 . 75 2011 27 35.73 537.5 777 2012/7/ | 575 ! Index and Prices 1.45 1.3 1.36 16F . 2. 2. ?? 1 E 1 1 n 15 : " ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 siffroad . i A Calbit 1 a * * * 1. [55 3.9 * B (. F K | | M N P [] R T 11 1 V w 2012/11 72 . F 1.44 1.13 1.45 1.5 .21 | | | | 0.45 2. 0.11 2. 3 2019/2/12 2/4 2012/2013 536.2 536. 3.1 41, 1 1.36 1.36 13 2. 222 13 2014 2011 4 13 .[] 43 76 2014/2/19 . 1. 1.11 3. . 2015/2/18 37 . . 2.3 3 0.3 0.15 0.1 1.4B 1-17 448 78 2015/2/19 9 2012/20 281) 2011 49 2 1 1.13 1.41 2. 2. 543.5 513.J 52.8 41,16 41.0 54.51 512.11 0.2 022 [ 12 .33 5.23 0.33 22 [131 .31 5.23 0.33 0 22 [1 . 1.35 1.39 1.37 13 1.3 1.37 1.37 1.37 . ,1 . . 4 / 02 2011 R1 B2 2016/3/25 E3 2012 284 2012/2/2 3 2.3 2.3 23 4.4 1.45 1-13 4.4 1.3 1.42 1.12 . 0.15 0.15 2. . .41 42 40 12 13 1. .[] 2017 23/5 201 RK 2015/3/4 B7 41,18 4.3 53.51 513.5 43. Eg 4.3 1.43 1. 1.4 1.12 2.3 .3 2.33 2.3 . . . (. 0.15 0.15 2. BB 2015/3/5 89 2012/3 1.5 4.44 12 43. 0.32 0 22 [ 12 . 43 2011 (30 4 1. . . 36. 43 . (1.4 . 0.15 0.15 . 41. 444 1.45 1-15 4. 2015/3/11 92 201531 1.3 1.43 1.13 1.43 1,43 1.43 1.43 45 . 2.11 2.2 1.3 1.37 1.37 1.37 13 13 1.37 1.37 1.37 13 13 1.37 1.37 137 13 1.3 1.37 1.37 137 . 0 22 [ 12 1,31 2017/3/14 2017/17 2015 / 3 / 1A 97 . 1 2017/1C 54. Bin .35 510.5 2.35 24 2012/313 35 3 4. . 550.3 2.5 98 2016/3/19 550. DE 2. 2,40 [10) 2011/3/21 301 301 3/4 5.4 302 2015/3/25 550.5 .45 | En E 313 Index and Prices - 1 == 1 | HD 43. (1.4 1.4? 0.1 0.1 . 1.43 1.5 4.4 1.12 12 2013 29 [ H 50 2.8 . 1,31 . .4 ,1 . 2. .42 43 .3 .43 313 1. (. 0. 0.47 . 1.42 17 1.4 . 11 178 377 H? 1 17 ENG (0) w09 '02 Ps T== | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 . siffroad . i A Calbit 1 a * * * 1. [55 .1 * A F F K | | M N P [] R T 11 1 V w (. .43 .13 0.4 4.4 1.09 4.03 1.4 1.1 . | | | | 0.47 ,43 0.12 2.3 H 243 . 4 303 26/03/2019 30 2015/3/27 2015 2019/3/28 [11, 2011/3/31 2017 2015 , 30E 01223 30 2013-1 .1 1. 1,4 1.4 3. 4.12 0.3 0.1 4 1.3 1.37 13 13 1.35 1.39 1.1 1.4 1.4 1.4 . . 2. 22 1, 1 1.1 . .96 0.98 099 1,101 0.15 .43 2.3 43 B 550,45 539. 39.43 3[].4 3.3 535.91 538.3 32 23 3.3 35.4 53, A 535.6 535 . 33. N 33,291 531.25 531.2 141 2019 30 / 2011 311 2011 31 ,1 . . 1. 1.33 4 1.3 .21 2.21 2 . .93 0.98 98 1,51 . 0.47 0.12 . 2. 2. 4 3.118 41 313 01210 31 2015 11 35 2012 ,11 31 2014/15 317 2011 ,16 318 2019 17 319 2015 ,18 320 2019 21 . 1.33 1.3 1, 1.5 1.35 1.33 1.3 . (1.4 0.3 0.47 0.15 41. . .96 0.96 2. 2 3. 1.98 16 3.18 2. 2.3 .31 4 2011 31 1,2 1, 1 1.39 1.4 1,31) 1.3 1.34 1.3B 138 1,38 1.35 1.36 1.37 13 1.3 1.38 1.3B . . . * . []. 30.3 533.55 523, E 3 01 225 31 2018 ,24 321 2012/25 3.B 1.98 1.5 1.32 1.32 . .95 0.95 1.95 0.7 0.47 0.17 .43 2.3 3 2019 3 2 2011 [ ,] 1, 1.5 1.31 . * .53 0.93 4.0 2.18 1 2,1, 2.17 .17 2.17 .1 12 .17 .17 (1.4 0.7 0.4 0.15 45 . 2.26 1.1 .1 0.9 2 327 2011 09/12 12.4 32B 2016/5/5 535.51 3 2015 52.14 33 2015 331 2017 / 9 / 5.1 530.41 371 372 /11 E7n 11 Index and Prices 1 4.13 4. [] 4.[ 31 332 1555 333 1,31 1.31 1.33 111 1,22 . 0.5 13 1.3 1.37 1.36 15 (. . 0.47 . . 1.09 17 A no T 17 1 = 3 - ENG CwO9002 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit 1 a * * * 1. 3.9 * K | | M N P [] R T 11 1 V w F 1.3 B 530.41 5 30.11 29.99 F 0.5 0.9 | | | 0.47 0.12 . [55 A 333 019/5/13 331 2015/5/13 335 2019/5/14 30 2011 201 337 2015/16 33 019/5/19 33 2012/5/20 340 2019 21 1.31 1.33 1,33 1.33 1.33 . 535.13 52.82 4 1 4.09 | 1.09 | 4.0 4 [14 4.IR 4.GE | 1.08 4. 4. [15 4.(18 1.09 1.07 1.33 [1,511 0.91 . 0.91 (1.4 0.3 0.47 0.12 1.33 1.33 4 /201143 41 . 24 3 2.3 2.3 2.3 2. 28 ,31 .31 2.3 2.3 23 ,31 1 1 1.36 1.36 136 13 1.35 1.34 1.32 131 13 1.31 1.32 1.32 131 1.3 1.32 1.32 1.32 1.32 34) 2011 01/24 343 2016/5/26 31 2015/5/21 34 2012/28 5. 74 55. 525.5] 92 1,12 .51 2.9 0.93 92 . . 1.1 1.37 1.37 1.3 4 49. (. .17 2.17 .1 2,1, 2,1? .17 2.17 2.1 ,16 .16 .16 2.16 2.1 1 .16 .16 2.16 16 .1 2.15 .15 2.15 15 .1 2.15 .15 2.13 2.1 1 ,(4) (1.4 . 0.15 0.15 . (1.4 . 0.15 0.12 2011 40 2 ,1 3. 47 2015/16 34 019/6/? 31 2015/6/ 51.43 526.7 53.5 1.3 1.37 1.37 1.3 0.21 1.9 610 2019 43 345 .3 .32 2.33 3 .31 2 ,1 .1 . 1 2014 (1i 35 2014/6/13 35] 2015/5/13 351 2015/6/1E 2. 55.93 525.1 242 4.11 1.11 1.11 4.14 4.13 4.14 4.14 | 1.11 1.16 4.18 4.1 4. 1.1B 4.15 33. . 0.9 | 2.9 1.93 [1] 1.3 1.3 1.3 0.7 0.15 0.1 .33 12 [ H 17' 2019 18) 4 2017 33 33 (1.49 1.3 1.3 .33 1.35 1.37 1.37 1.3 1,3 1.4 1.35 1.37 1.3 1,3 1.3 1.35 . 0.93 [. 0.15 .1 357 2015/6/10 35 2015/6/20 352 2015/5/21 360 2012/6/21 . 523.13 5 23.51 0.96 0.15 ) 42 1.9 2014 1 25 3 . 1.3 1.3 12 1.3 1.3 .[] .33 2.3 3 .34 .34 7 3 36 2016 3.14 360 01 56 57 351 300ER/T E12 R1 Index and Prices 1, 2, ,45 .95 27 . 03, 4.19 1.19 5.1 0.42 0.49 1:12 11 115 11 I - 7 - = ENG SOM Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 : siffroad . i A Calbit 1 a * * 1. [55 3.7 * (. K | | M N P [] R T 11 1 V w 09 / 6 / 27 63 F 1.35 . B 523. 15 519 B3 20.4 | | | 0.49 0.15 05 . .3 1.35 13 .2 3 ,[ .1 (11 . 1.3 361 2012/6/20 365 2012/1 [1 2014 , 367 2012/7/5 366 2016/3/4 365 2012/7/21 30 2019 2/8 .1 .1 ( .1 .1 .1 1.33 1.37 F G 0.95 1.3 0.93 17 09 [1] ,45 0.95 0.99 1.9 1 [1, 1 ,47 1.0 2,3 .3 .33 3.10 5.R] 526. 25 . . 0.5 0.5 3 1. 14 .1 .1 (20 2011 1 1.4 .1 3 (3.4 .3 2.03 2.3 (13 2.03 . 2.0 1.4 1, 2.5 .1 525.6 525.5 . 0.47 0.5 1.1 0.99 37 2015/2/16 373 2015/7/21 71 2015/3/11 3 2012/19 4, 2011/2/10 37 2015/3/12 37B 2015/7/18 37 2015/7/21 l 2. .3 3 .35 .35 .35 .35 ,33 .34 .3 2.3 2 1.9 1.29 1.20) 1. ) .2 ) 1 23.9 525.1 525.3 323 4.15 1.2 4. 410) 4.14 1.19 . 4.1 4.1, 4.17 1.17 1.16 4.1 4.18 4.1 4.1B 1.16 4.16 4.1 4.17 1.17 1.16 4.16 4.1 4.16 1.17 1.15 4.1 4.17 4.17 4.17 1 17 2. . 2.0 2.3 1.41 1.4 1.4 1.1 [1 0.3 0.47 0.15 .1 .1 128 3 33 2019 8 2017 281 83 , 1.4 1 0.93 1 093 1,01 1.01 1.0 2.05 2.5 .1 ,33 2.01 .01 2.03 2 1.4 1.4 1.1 33. . 14 .5 . 1.6 1.6 1.5 16 1. 1. 1.5 1.5 2.35 .32 3 , 1, ,1 2.1 387 2015/3/4 12. 383 2019/7/25 55. 381 2015/2/21 525.1 38 2019 20 201143/363 387 2011 0/3/11 .43 BB 2013/3/4 531.1 385 2015/1 531. DE 30. By 11 2017 92 01 27 30.18 397 2015/3/E 531.17 31/11 /1 H E 2 1 Index and Prices 37. (1, 2 0.34 0.35 0.15 0.3 (1, 2 0.3 0.37 0.15 2 1,39 0.37 0.3 1.4 1.42 1.11 1.14 1. . 1.05 2.05 2015 2.12 12 2. 2. 2. 2013 300 (44. [ 12, .1 1 .1 .1 1. 2.11 .11 3r 1,CJ2 1.( 1.04 T, . . 4. 1.44 .1 1 1 1 7E | 15 77 = ENG (0) w09 '0 Ps T[ =/= 1,15 X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 siffroad . i A Calbit 1 a * * 1. [55 .1 * A B K | | M N P [] R T 11 1 V w (. . | | | 0.35 .52a .1 394 015821 395 2012/3/19 39 2019/3/20 F 1.44 1.13 1.3 522.5 3.34 2.0 . F 1.0 1.03 1.2 1 1 1. ] 1 2 . 2. 2.4 11 / 2017 , ,[ , .1 1 0.11 33 (1, 1 0.34 0.34 . 41. 4. 09 / 3 / 25 399 04. 1.3 1.42 1.13 1.3 2.08 2. 1 0.99 1 . 2.4 3 ,[] , ,1 1 0.12 33 (1, 1 0.5 0.31 25. 1.3 1.43 2016 404 2.03 .05 2.08 . (15 2.03 1.12 1. 1. 1.1B 1.1 118 1. 1.1B 1.1B 118 1.18 1.1 1.17 1.17 11 0.311 33 .43 2. .4 142 1,013 1.0 2.0 2. 1,CJ2 1.01 1.01 23 ,1) 4.17 . 4.12 4.13 4.13 4.12 1.11 4.14 4.14 4.15 4.15 1.15 4.15 4.14 4.15 4.15 1.15 4.14 4.14 4.14 1.14 1.11 4.14 4.15 4.14 4.15 | 1.15 | 414 4.14 4.14 4.14 1, 1.26 1.4 . 0.34 0.33 05. 11 39 2016/3/27 0.g 521.3 00 2015/8/2E 5 20.3 [1 2012/8/22 520.8 [] 2011 498 3 01 32 23.5 521.0 05 2012 521.13 [b 2018, 4/3 1.6 [17 2017 / 11 /4 11.4 2018 2017 / 11 / 1,71 409 2015/9/8 520.5 10 2015/9/ 519.23 II 2012/9/21 21.1 41 2014/1/11 13 2011 01/12 1, 1 414 2013/9/15 513.69 225 2015/1E 513.11 25 2011 51545 17 2017 2018 16. H 18 2011 513.4 19 2013/9/22 513.21 0 2015/9/23 517.2 16.41 17, 27 2015/26 51321 4 015/9/23 517.45 7E_703E 1 517 F5 Index and Prices 12 2.08 . (13 2.03 .44 2. .43 43 3 ,[ .1 0.12 33 (1, 1 0.13 0.34 2.2 1,011 1.01 0.58 1.01 2. 1.1 1.4 . . 05. 1, 2. 2.26 . 0.13 0.32 42. , 1 .1 1 . . . 2.0 1.4 1, 1.4 1.4 1.1 12 1.17 1.17 1.15 113 1.1 1.16 1.15 1.11 114 1.14 1.14 1.14 1,33 0.32 1 41. 1 0.13 23 2. 41 09 2019 1 2 / 11 / 2017 .2 ), .1 1 . 0.93 . .04 1.47 1.11 2.5 J, 33 0.3 0.31 1 17 .43 313 11 1 - 20 117 = 1 - 1 - = ENG (0) w09 '0 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 . siffroad . i A Calbit * * a 1 * 1. [55 .1 * A B F F K | | M N P [] R T 11 1 V w 6199 / 26 3 4.14 (. . 2.0 . 0.93 24 | | | | 0.32 . 0.311 .13 32 .43 21 2015/9/22 25 2010/4/20 0.2 1,147 2014/10/1 , 1) 7 2015/10/ 1.42 1.11 1.41 1,41 1.1 1.11 1.11 1.1 1.14 1.11 113 1.12 1.12 1.12 1.12 1.12 . 41. . .99 0.33 0.33 517.21 517,19 17 65 17.4 51. 31 515.9 513.12 1. 13.1 51,3,501 515.5 510.75 1.48 015 / 10 / 3 . .05 2.05 2. 0.13 33 .41 2.3 2.43 43 , ,1 29 2018/10/6 30 2019/10/ 31 2017 29/10/g 37 2015/10/ 33 2015/10/10 31 2015/10/13 1) 0.15 4.13 4.12 4.12 4.12 1.12 4.12 4.12 4.12 4.12 1.15 4.25 4.1i 4.15 1.19 | 1.5 4. 2.03 . 2.05 2.5 . 43. 0.99 1.99 1, ,45 .93 0.9 093 1,15 1.45 1.44 1.12 1.2 2014/10/14 3 10/14 / 2017 2.13 2.43 41 ,16 , .1 0.32 0.13 33 (1, 1 0.5 0.32 0.31 3 37 2014/10/16 3 2019/10/17 41. 517,373 517.4 520,19 52.51 . . 2.05 2012/10/20 3 1. 1.47 1.1 1.4 19 . .9 0.9 093 1,15 .4 2. .43 ,43 4 2012/10/21 41 2011/10/22 n3 , , 4 2 ,1) 2014/10/23 0.34 0.34 44. . (1.4 523.2 5 20.3 19. EH 443 2012/10/22 11 2012/10/27 45 2014/10/28 1.11 1.13 1.12 1.23 1.12 1.12 1.14 1.11 124 1.13 1.12 1.14 1.12 112 1.12 1.13 1.12 1.16 115 1.1 1.14 1.2 . .05 2.05 . 1.4 1.45 1.1E 1.16 1. ,47 0.97 0.97 09 1, 1 0.11 3 . .43 . 10 / 2017 3 10 , . . 1,34 0.34 . 4.4 1.2 19 4.10 418 1.1B | 1.17 | 41 4.1 4.15 4.14 1 15 2.0 22 ( 47 2015/10/30 513.8 44 2012/10/21 519.51 2012 2013/11/3 52.13 20.46 1 2011/11/ 5 2015/11/ 453 012117 53.11 E1703E11/11 E 7 E7 Index and Prices 1. 1.45 1.1E 1.4 1,49 1.40 1.11 . 0.93 0.99 0.95 1,23 .95 2012/11/4 .43 .13 .43 ,43 15) , 0.11 3 1,34 0.33 3,71 1.8 .1 2.03 .03 in7 43. 4. 2.5 15 1 11 17 1 17 77 I - 7 - ENG (0) w09 '0 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit = 1 a * * * 1. 3.7 * [55 A 53 2018/11/? F K | | M N P [] R T 11 1 V w | | | 0.33 B 52.11 52.93 2383 F 1.1 1.15 .1 (. .03 2.0 1 0.96 1.01 1.9 1,17 . . 2012/11/10 0.33 32 118 2.2 55 2013/11/11 31 2017/11/12 57 01 9/11/13 3 1. 1) 15) , 03. 1 3.71 52.73 522.5 09 / 11 / 14 5 1. 1.5 1.19 0.3 0.34 1 . .43 2. . 1 .01 2.0 2.1 (11 .1 0.31 3 23 .1 1 1 59 2012/11/12 60 2019/11/19 (1 2011/11/19 6 2016/11/20 463 2013/11/21 61 2016/11/20 ,1) .23 1.98 0.11 0.34 . . 52.69 03. 0.5 1.4 1.5 1.5 1.3 E .523 2.1 2.01 2.1 0.11 3 2. .43 5. H 2. 2012 / 11 65 08/11/20 2011 ] 3 .1 1 2 ,1) . 1 532.4 521.5 52.73 523 0.15 0.33 4.14 1.15 4.14 4.13 4.14 4.14 1.11 4.1 4.12 4.11 4.11 1.13 4.13 4 125 4.12 4.12 1.11 4.15 415 4.1 1.16 1.16 1.16 4.1 4.1 4.14 1.15 4.15 4.16 4.14 4.14 1. 1.5 1.5 0.93 27 1.3 1. 1.18 1.1 1.1B 1.17 1.18 1.17 1.1 1.1B 1.16 1.16 1.16 1.16 1.16 1.16 1.16 1.1 1.17 1.1B 1.16 1.18 1.18 | 118 1.17 1.15 115 1.15 1.15 1.14 .41 2. 11 67 2011 0/11/27 BB 2013/11/22 69 2012/12/1 0 2012/12 1 2017 / 12 / 3 ?? 2015/12/4 473 2013/12/5 71 2012/12 45 2 .1 . .1 1,15 0.11 3 (1, 1 0.13 0.33 . .99 1.4 1.5 1.55 43. 43. 25.4 525.4 525.33 5.3 2 2012/12 (1) 1/12 .1 .1 0.99 09 1, 1 0.13 33 (1, 1 0.33 0.33 2. .43 43 1,5 23. 1.5 1.55 1 7 11/12/2014 14.4 478 012/12/12 525.5 279 2012/12/15 5 25.1 0 2012/12/16 593 2 81 2014/12/12 26.1 ? 2014/1/18 3.4 52.63 R17.E172 E3311 3 Index and Prices - 11 - T | | .97 0.93 0.93 (1.9 1,212 0.13 23 1, 1 1.5 1.55 2.5 2.5 .2 , 2.5 2.5 15 . , 33 0.33 5,53 1 17 15 / 12 / 19 B7 2.5 111 1 E5 111 - ENG COWO 902 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 2 - . siffroad . i A Calbit 1 a * * * 1. [55 3.9 * A . F K | | M N P [] R T 11 1 V w 4 2013/12/22 B5 2013/12/23 &E 2015/12/21 B 533.11 522.35 2. 39 4.14 117 F 0.96 0.96 1.2 / 12 / 2017 7 3.4 1, 1 88 01 01/29 1.13 1.11 113 1.13 1.12 1.12 1.2 1.12 12 4.1 4.12 4.12 1.2 4.13 1.55 1.55 1.3 1, 1.3 1.53 1.53 13 1, 1.3 1.7 531.5 55. EE 22. 38 019 / 12 / 10 . .9 7 | | | | 0.33 .5 0.33 2.5 33 5 (1, 1 0.33 3.5 0.32 2.5 0.12 2.55 33 2.5 (1, 2 0.15 .3 0.33 .53 0.12 2.53 3 25 90 2015/12/21 91 2012/1/2 1.21 [1] 2012/1/4 ,[ , 5.75 521.99 521.1 93 02 01/ 94 021/B 95 2020/1/9 96 2012/1/12 1.5 4.13 4.15 4.15 1.15 1.16 18 4.1 . . 0.93 0.9 2 2018/1/14 .2 3 19. 1) | 2,9 0.4 2025/1/15 .1 1.53 1.3 1, 1. 1.55 1.55 1. 1, 1. 1.55 1.55 1. 2.5 2.5 2.5 2.5 23 14. ... 1.5 4.2 4. 2 2 0.11 0.31 0.311 31 (1, 21 0.3 6.3 2.9 0.2 . . .25 0.59 , .4 .1 1,114) 1.16 1.0B 1.2 12 1.(10) 1.1 1.2 1.12 1.GIE 1.IR 1.16 1.09 1.09 1. 1.12 1.16 1.09 1.09 1.9 1.11 1.IR 1.07 . .5 2.5 2.5 0.3 98 2012/1/14 535.91 500 2025/1/16 525.5] 2011 2012/1/19 [] 2 [] 3/1/3 503 2012 20/1/21 504 2022/1/23 524.3 505 2020/1/21 52.50 5UE 2012/1/20 5.3 013 201243 1/2 3.75 509 02/1/29 523.3 510 2020/1/20 5.23 5ll 2012 2. 512 2012 03/23 1,32 514 02535 55. 531E 2017 E27 BE Index and Prices 2 1.5 4.2 4. ] | .1 2012 / 1 / 2 18] . .4 .1 . . 11, 201 . 0.25 0.25 22 1,51 1.55 1.5 1 0.25 0.25 2.57 1.2 4.23 2 0 .1 , 1 1,23) 1, 1 1,55 4 2012 513 4.31 1.33 . .as TH 1.55 . 0.25 - 22 . .53 7 1 31 1 E5 1 TE 3 54 T =- 1 - - ENG COWO 902 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 : siffroad . i A Calbit 1 a * 1. [55 3.9 * A F K | | M N P [] R T 11 1 V w 515 02E B 527.BE 52.E 1.33 . F 1.55 1.5 1.5 2020 526 | | | | 0.25 0.24 2. 29 51 2020/2/10 18 201243 2/11 519 2012 (1) 22 ,)2 0.27 . 28 [ 13 . 15 1.09 1. CB 1.GIF 1.17 1.IR 1.07 1. CB 1.09 4.33 433 4.3 4.4 1.3B 4.4 1] .1 02 / 15 50 1. 1.55 1.55 . 0.93 0.95 1.26 0.25 0.2E . 2. 2. 3. K3 531.5 532.87 3.49 31,45) 36.4 537.37 535.51 .1 .1 521 2020/2/16 522 2012 2/1, 3 2012 2013 54 2012 02/19 525 20220 525 202 223 1] ,1 . 2,03 2.73 7.2 4.3 1.3 44 1.5 1.E 1.55 1.35 0.9 . 0.25 0.2 .3 .65 .53 2.55 65 2012/2/19 516 15 1.1 1.1 1. 1.2 1. [ 1.01 1.IR 1.DE 1. CB 2.2 (1 ] 1] .4 1, 1 , . . 1, 1. 1.5 1.5 01. 0.25 0.2 28 2012 (2) 50 2012 03/26 53 2020/3/27 531 21231 532 2012/3/ 33 2012 3 574 2012 (3/4 535 02/3/5 535 0235 3, 3.12 53.29 515, 53 3.4 32.0 531.9 5.2 437 4.36 1.36 4.36 4.3 437 4.3B . 2.5 2. . 2 1 .1 1 ] 1] (11 .1 .01 13. .97 .93 0.99 099 1, . 0.9 0.95 093 [1,511 .37 . 0.9 1.33 . 0.25 0.2 2012/21 3 1. 1.5 1.18 2. 1, 1. 1.45 1.31 . 28 4. 28 23 . [] .64 2.53 2. 1.(10) 1.7 1.07 1_07 1.5 1.13 1. 1.01 | |-9B ,J , 55. .4 . . . 0.27 0.27 11 .55 2.58 . 38 2012 3 3/11 13 2012 2013 15. 63 542 2023/15 513.33 11 02231E 53. 2.26 54 2012/3/1, 0142 1.96 43 2012/3/18 4133 1,23 1.5 545 2025/1 140, SA 1.3 SAE 207 . 1 125 Index and Prices - 1 -- T = .4 14 3 | 1.4 1.4 1.4 1.33 1,2 , 3 / 19/ 2017 3.5 4 4.1 3.9 175 . . . 0.7 0.27 | 12 2. 11 12 11 * 75F ENG COWO 902 Ps T[ =/= 1,15 X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit * * a 1 * 1. 3.9 * F G K | | M N P [] R T 11 1 V w [55 A 546 2020/5/4 517 202055 F 13 (. 1.75 1.8 22 3.2 3.4 | | | | 0.22 .55 0.2 2.59 2.5 1.32 0.3 033 |.89 0.88 3 13 2012 548 2012 ] 1] .33 550 2012 (1) 551 0235/5/11 552 2020/5/12 3 2012/5/13 B 47.41 13. 69 4 / 29 4. 476.47 47.45 175.11 4/351 42, 3 475.49 473.18 173.75 4.93 . 3.7 3. 3. 1.1 1.43 1.42 1.13 . 0.5 2.87 . 0.25 0.2 14 24 14( 2012 .3 .3 . . [ 22 [ 12 . 0.25 7 1] . .53 2. 2. . 2.65 .55 2.55 2.65 3.7 3.2 1.4 1,4 1.44 1.1 2. 1.4 RI .57 555 2012 05/17 556 207051 557 02012 558 2012/5/20 . 0.25 0.2 . .| 1 / 2012 1] .4 , 45. 50 2012 09/22 561 2020/5/2g 562 2020/531 563 2021 427.14 475.35 125.51 1. 1.5 1.8 1. 1.5 1. 1. 1.8 1.5 1, 1. 1.5 1.3 2. i 1.26 1.5 2.33 2.33 , 1. 2. 2. 231 3.1 3. 3.1 5.2 3.5 3.5 3. | 3.3 . 0.8B (2.87 . 0.25 0.2 1.4 1.35, 1.3 1.34 1.41 1.4 1.41 .15 .15 . 46 4/3 ] 1] ) 2012 4] 565 2012 06/3 566 2020/6/4 567 202057 4,29 4?fi, 473.5 176.17 4/5 21 0.26 [13 . .25 . 0.2 [1 . . 0.2 1.33 [ 12 .33 0.23 0.31 31 5. ?? 3.7E 3.E 3.8 (11) . 0.5 2.89 . . . 0.25 0.25 1. .16 14 2012 568 (4) 2012 4 == 1,4 1.4 1.4 1.1 . (54 .85 2.86 [13 . 0.3 46. . . . 7.5 3.8 3. 3. 3.8 3 5. ? 5 2017 ,16 473.1 571 202 /611 47.55 572 2020/6/21 123.2 3 20 2015 4 2.14 4 22.4 575 2012 06/17 47 . 576 02/21 473.5 517 Index and Prices (1) 2012/6/10 4 1,31 1. 1. 1.4 1.4 1.39 1.4 1,31 .33 1.33 (. 55 BE 0.3 [3 (1,5 0.3 , 45 . . . IT IT = ENG 0) wo 90.2 Ps [ =/= 1,15 X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 : siffroad . i A Calbit * a 1 * 1. * 3.7 | | (. F K | | M N P [] R T 11 1 V w [55 A 54 20355 519 202057 F 1.32 .1 . . B 47. 35 173.5 4 6.9 BB 69 H 0.2 0.2 0 2H 2012/5/10 1.11 143 1. 3.2 3 3. 3.7 2.8 1.83 [132 . . 1.33 1. 1. 1. 1.3 1.8 1] 1 2012 /11 552 2013 2013 553 0235/11 55 2020/5/11 5 2012/5/1 .59 2. 2. . . 3.5 2. (1) 37 7 2.87 1.43 1.44 1.1 .3 . . 0.25 0.2 0 2H 3.g 3 14 19, 2018 , .3 .1 | 47 1] . 557 2012 08/14 55B 2020/5/20 552 2020/5/21 50 20205 1 1. 1.5 1.8 1.5 1, 1. 3.74 3.5 3.2 . 1.4 1.4 1.1 0.32 1.26 1,32 .37 . 0.26 0.25 1,31 . . 7.2 . 0.25 0.2 .65 .55 2.55 |.89 24 43 2012 lil 1 1] 45 25. 425.4 475.51 177.23 425 48 43.18 473.7 473.5 123.2 42.14 4 / 6, 3 475.51 473.6 175,0 46.3 4 3 2 476.17 475.21 17. 4321 4 , , 473.73 47.14 17.9 5 2012 03:41 563 02/1 61 2012/6/20 . 28 37 87 0.9 1.7 3. 5.75 3.75 3.7 3. - 24 3. . 0.25 0.2 . . . 46 1.1 1.3 1.11 1.4 1.41 1.4 1.4 . 2 /2012 565 4 2013 ] 1] 1.8 2. 1, 1.33 1.33 2. 2.22 [1] . 57 2012 06/? 56B 02, . (1) . .57 2.87 0.84 . 0.25 0.3 2012 569 . 1, . 7.5 . 46 3.E 14 13 50 2012/6/10 1 2012 03/11 57 2012 (561/14 573 02/5/15 571 2020/5/1E . 0.23 0.2 1.33 [ 13 .31 0.81 0.31 33 (1,5 13 . ... 3.8 3. 1,4 1.4 1.4 1.1 1.39 1. 1.1 2.21 1. 15 0.3 .4 2.85 .45 .16 3.E 0.3 3 4/2 .3 2012 59 09/18 2012 423. 18 3. .1 1,35 (1,3 , 577 578 57E Index and Prices ENG CwO902 Ps [ =/= 1,15 X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = 20 . siffroad . i A Calbit = * a 1 * * K | | M N P [] R T 11 1 v w 02E12 4 0 1] , .2 1 1] ] 1] 2 ,1 E552 3. B ( 1] F 1 Last Update Index BOP.D PALTEL PEC 526.6 2. 1.6 1.32 3 2018/1/3 20.4 1.35 4 2018/1/4 1,25 5 2018/1/4 26.47 . 1.33 6 01/19 576.3 . 2. 1.34 7 2018/1/20 53. 2.51 1.5E 1.11 8 2018/1/11 5/8.1 4.6 1.34 | 2018/1/14 3. 28 1 2018/1/15 91.7 2.3 . 1.34 11 2018/1/26 53.24 . 4.69 1.33 12 2018/1/17 551.17 2. . 1.31 13 2018/1/18 52. E5 2.6 4.3 1.3 14 2018/1/11 1. 24, 4.18 15 2018/1/22 23.47 . 1.1 16 2018/1/24 539.91 4.GE 1.34 13 2018/1/25 523.15 2.51 1.65 1.31 28 2018/1/28 2. 4. 1.35 19 2018/1/21 0 2018/1/19 13.5 . 4.6 1.33 21 2018/1/31 574.51 2. 4. F 1.33 22 2018/21 525.23 2. . 1.31 23 2018/ 2/4 5/639 2. 4. 1.3 2 . { 1,33 25 2018 53,43 1.33 26 01E7 576.5 .51 1.65 1.34 2 2015/ 2/ 525.52 2.51 1.67 1.31 28 2018/2011 52.9 E 129 22. 32 , 3 452 1.3 2 01 / 1 29f1.5 1.5 31 201E14 559. .53 1.55 1.11 37 2nK7/15 son 1 153 1 21 Index and Prices 1 5. 13). F G E OOREDOG PADICO AIG APIC 1.09 1.1B 0.25 7 13 148 199 1,11 1.3 1, 1,14 1. 0.4 1.15 1.44 0.27 2.12 1.5 0.2 2.05 2.1 14 29 1,15 , 4.13 1.5 . 2.05 1.15 1.45 0.25 .03 4.13 1.5 0.2 2.05 213 1 . 1,11 , 1.1 1.4 . 1.11 1.44 0.25 2.1 1.09 1.1 0.2 2.11 2. 143 0 2H 2.1 1,47 1. 1 1.03 1. . 2.1 1.04 1.4 0.25 .07 1.09 1.1 0.2 2.08 2. 1.4 2.1 1,15 1.4 .1 1,03 1.30 0.31 3.1 1.08 1.4 0.25 2.1 1.05 1.1 0.25 2.1 2. 13 12 1. |(, 31 13 1.0 1.1 (, 32 . 1.0 1.42 1,5 . 17 17 1 32 7 ? . 5 . . 1 1] 0 1] /2 /20118 63 0 2018/2/19 ,,1 11 1 : ENG 0) wo 90.2 Ps T[ == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = 20 " : siffroad . i A Calbit * a 1 * 1. ,1 (. F K | | M N P [] R T 11 1 v w . [552 A 31 01/11 32 2015/2/15 33 2018/2/18 24 2011 % 2/11 15 2014 20 4.5 1.82 1.06 2.07 2.53 3 4.35 B 589.2 590.1 523. 21 1, 93.7 525.54 513.1 F 1.11 1.11 1.4 1 2 3 1. 1.42 1.12 , 2.63 .53 2.53 . 1 / 31 3 | | | 0.3 . 0.25 2.26 31 2.3 (1, 1 3 0.34 . 0.33 .23 0.31 2.27 3 2. . . 3 2016 2/22 28 2018/22 4 44. , 1,63 1,015 1.0 2. 2.2 1,15 1.5 1.01 .. 201182 (34 2.6 , 1. 1.3 138 1.4 1.43 1.45 1.5 144 1.44 1. 1.51 152 1.52 1 1.46 1.5 1.7 4 4_55 1.81 1.85 4.4 451 4_32 4.75 1.82 4.8 3 4.2 1.85 1.7E 4.4 44 1.4 1.34 1.3 1.11 1.41 . . 2.51 . 0.25 0.3 2.7 2 2. [22 3 / 2018 1 .1 ) (1, 21 0.31 6.3 . .23 2.61 .51 2.51 2. 1.4 1.41 1.12 1.2 1.03 1.01 1 1 .2 0.25 3 25 1 1 .32 .1 1 1] . 4 2012/2/22 0553 41 2018/3/20 584.61 12 2016/3/1 559.25 43 2018/3/4 532 33. 45 2118/3/5 8. R1 4 201E/3/? 537,55 1 2016/3/11 510 2,12 48 2018/3/12 53.12 4 2011/3/13 5 2012/3/14 91.41 51 2016/3/15 52 2015/3/18 533.81 3 2018/3/19 33 34 55 2018/3/21 85.1 56 01E/3/23 53,18 5 2015/3/25 577. 2.33 2. [ F 2018 66.4 61 2018/3/23 555,57 5571 Index and Prices . 6.3 58.4 1 1 1 2. 2. 2. 4.62 1.82 4.53 0.3 2.5 53 1 83 2011 , 2 1,18 1.0 . 1.41 1.41 1.1 1.39 1,39 1.4 1.3 1.1 1.4 1,31 1.35 1.25 1.4 1.44 1.1 1 1.43 1.43 1.43 1.1 1.4 1. 1.37 1.42 4. . . 4. 0.9 2. 2. 2. 0.5 0.2 0.25 2 1 0.96 .27 .29 2.26 2018 8 2018 5 1 1] 2 4.4 1 . 57 752 . . 4.4 . 0.27 1 32 1 2013 57 112 T, 11 7 ? " ENG SOM Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx == . = * 20 " siffroad . i A Calbit a 1 * * B 1. | | 4.44 K | | M N P [] R T 11 1 V [552 A E 201E/3/20 1 02E/3/20 6 2018/1 F 1.35 W (. .57 2.5 2.8 H 0.25 0.27 . . 1.22 1.3 2.26 556.41 55.5 563.4 1, 1 5.4 551,5K 558. TH 1.3 1.2 1.4 1.4 1. ] 1] 2018 3 1,2 F 1 1 . 1,15 1. 1.0 1.03 23 1,147 4.3 438 4.3 4.3 1.5 . . 1.11 1.27 1.27 . 0.3 . 1. . 2.5 2.57 1 0.25 | 3 39 .1 .2 54 2012/4 65 2014 EE 2016 b 2018, 8 8 2018 ) 50 2018 ,16 7 2018/1/11 1 201E12 4 .4 ,1) 4 . . .55 755 .1 .1 1, 1.5 1.25 1.25 123 1,88 57.4 555.93 550. 551.5 1.1 151.7 592 55.1 1.03 1.01 1.01 29 0.25 0.25 . 2.5 22 2018/1/19 2.55 4.2 4. ] ) , 1 , 1 .1 . 3 2018 ,14 74 2018 ,17 5 2016/4/19 E 201E12 . .4 .4 14 1.4 1.4 1.4 1.3 138 1.8 1.3 1.3E 1.3B 13 1. ( 1.3 1.35 1.35 1 1 1 . . . 1.26 1.2 0.25 0.25 2.5 1.3 4.26 1 1 2018/22 2018 9 550 33. 3 1] .2 23. .3 4 .4 .1 . . 0.25 0.2 0 2H | 1.6 2.53 53 2018 E2 1,11 1. 1.22 1.22 1. 1,1, 1. 1.24 1.2E .4 4 13 1, 1 . 0.97 0.95 1.93 [1,513 . 2.9 0.9 26 .23 .27 25 2 .5 7 2018 24 43.5 2 2016/4/25 546.6 81 02E2E 515, 15 12 3 2018 ,363 18, 12 24 2018 42.4 B5 04E53 55.55 BE 2015/5/6 5:13.17 E 2015 4. Et 8 2018 / 8 2 2015 544. 1 2013 R S 17 35 Index and Prices 1) . . 4.3 0.5 0.25 0.27 . 2. 2.5 52 1.3 1.35 1.35 1.33 133 1.3 1.31 1.32 1.35 1.39 | 43 43 4.35 1.34 1 , ,1 1] (44. 44, . . 1, . 27 / 2018 1.5 1.25 . 0.25 13E . .07 11 351 112 21 ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 : siffroad . i A Calbit * a 1 * 1. [553 * A F K | | M N P [] R T 11 1 V w | 91 02E/5/13 93 02E 1 93 2018/14 B 543.05 513.J (. .51 2.51 51 | | | 1.34 137 1.27 1.27 131 1.3 13 .12 4.3 .1 1 17, 2018 | | | | 0.25 3.1 0.2 2.1 26 ,13 0.7 .11 0.27 .13 0.2 2.12 F .91 0.93 0.321 [1,511 ,41 .91 0.9 19 : 1] 5 2012/5/20 1, 1.3 . 42. 19 40.5 539. EE 5:10.17 40.18 1 / 5 / 21 2 1.5 1.25 1.25 .1 7 2016/5/22 98 2018/23 32 4.3 23 131 4.34 3 4.33 1.33 137 2.5 5 1. B 18 1.20) 12. .1 1 2018 {{ ] 1] ,41 , , | 2,9 . .1 .1 41,493 539.5 533.55 3.2 1. 1.26 1.2E . 5 2.5 2.5 2.5 0.25 0.2 1. B 100 2018/1/27 101 2018/5/28 102 203 E529 103 2018//2 14 2018 /31 105 2012/6/4 106 2018/6/4 10 2016 1 0.39 9 [1] 1 1 ] 1] 2.1 4.33 43 433 1.33 . 41.Fa3 543.23 510,14 .5 2.5 3.5 2.5 1.5 1.34 1.3 . . 0.2 0.2 .12 2.12 2,11 2.12 2.11 ,15 2,15 .16 2.15 2.15 15 2.1 .1 2. 2 ,23 2. 1.33 4.3 2018 108 .19 121 ] 1] 1 . 0.3 . 103) 201186/ 11 2012/6/10 111 2015/5/11 112 2018/6/12 13 2018 ,13 114 2018 ,15 115 2018/6/20 116 2015/5/21 11 2015/5/21 0.25 0.25 2.5 3,37 41,41 541.0 5.3.1 4.4 8.1 4. 6 54.3 3 4.3 1.3B 4. 4 1.5 1.3 1.3 1.32 1.34 1.3 1.34, 1.3 1.3 1,31 1.34 1.3 133 1.34 1.4 1.3 1.32 1.33 13 1,31 1.31 1.32 , .1 1] [1] . .23 0.25 25 [ 13 . 0.25 . 1.8 [1 . 2.7 . 1.41 . 1.5 1.33 . 0.25 0.2E 2.5 2.5 2.5 51559 43 1.35 13 .23 .27 2.23 2018 118 2018 (115 , ) 4.3 437 4.36 1.36 4 1,4565 12 2015/6/23 1.43 121 2015/6/28 540. 63 177 7n3K7/ 11 FH Index and Prices 1,34 1.33 1.34 2.5 2.5 0.7 0.27 13E . 35 11 | AR 727 IT IT ENG 0) wo9 02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit * * a 1 * 1. E553 3.7 * (. F F K | | M N P [] R T 11 1 V w .1 . B 55,57 510.57 41. 68 . 3.5 5 4.36 135 | | | | 0.27 0.2 2. 28 . . 1.31 1.3 4.3 120 01/27 121 2015/6/28 12 2018/1 123 2018 124 2018/7/? 125 2016/3/4 12E 2016/3/5 1] 11. 4 1 45.4 545.3 56. 10 451 . . . 2.5 5 0.87 1.3 [1] . . 0.26 [ 36 4.3 4.4 1.2 . 33 73 0.27 0.2 0 2 1.32 1.32 13 13 1.34 1.35 135 133 1.33 1.34 1.3 1.32 1.29 1.20) 8/ 2018 12 , 1,36) 1] 3 . . . 5 2.5 2.5 2.5 4.3 1.39 1.3B 4.38 1,35 1.35 1.15 1.3 1, 1.35 1.35 1.35 1.3 1, 1 1.33 1.33 . . . 0 22 0.27 0.25 | 3 18 2019 1225 2017/7/16 13- 2016/3/11 131 201E/7/12 13 2018/15 133 2011 134 2012/7/17 135 2018/7/21 13E 2016/3/19 13 2018/22 .31 2.3 , .4 .1 1] . 54.4 515.2 4.85 42. 42 43.07 543.0 513.5 42. Eg 42,33 41. 51.3 511.21 39. EH .1 .1 4.3 1.3B 1.3B 2.5 3.5 2.5 . . 0.87 [ 36 0.25 0.25 . .3 .31 23 1.3 .4 1 .1 ] 1] 2011 138 .1 . . . 4.3 4.3 4.37 1.36 4.36 1.33 1.33 1,31 1.34 1.31 1.33 1.33 1, . 0.25 0.2 130 2018/2/24 140 2017/25 111 2012/7/25 142 2018/29 143 2011% 365 144 2012/3/11 145 2018/a/ 11 02E 5/2 14, 2018, 2.9 . . . 0.25 0.25 1,31 . 1.3 1. B 1. B 1. 28 1, 1. 1] 3 .4 , 43. . . 36.5 537.3 5.1.1 5.9 .1 435 1.34 1.37 4.4 2.3 2.3 28 2 .31 2.3 2.3 3 3 1,14 1.37 1.39 124 0.5 0.25 0.2 2.9 2018 148 : 41. . . .1 0.26 2.9 . . 2.9 1.8 18 1,21) 1.33 1.33 1,31 1.5 1.3 140) 2017 546,7 437 4.3B 1 7E 1E3EB 150 E 15170K . 0.2 1 H 2.3 13 317 115 E3 E Index and Prices 131 ENG 0) wo9 02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 " : siffroad . i A Calbit = 1 a * * 1. 3.7 * ( K | | M N P [] R T 11 1 V w | . [553 A 15 01ESE 151 02E 3 15 2018/3/12 13 2018/13 154 2012/3/14 B 563 1355 42. B3 3, F . 0.9 0 22 | | | | 0.25 2.3 0.2 2.3 2.3 2.17 45 45 1] .1 2, .40 . 4.3 1.35 4.3 43 4.4 1.34 1.35 4.3 32 4.2 . 0.33 2.3 . E535 155 540.26 511.5 411 .4a 2.8 19 2. ,[ 15 2015/3/1E 15 2018/3/19 18 2018/3/20 150 2012/3/27 16 2015/5/21 161 2016/8/22 16 2018/ 3 . . .25 0.26 0.26 1,31 . . 0.25 23 [1] .4 38.53 537.93 533.EE 536 .47 2.1 2.4 4 1.7 4.3 1.33 1.33 1.32 1,31 1.2 1.3 1.3 1.3 1.5 1.31 1.3 1.32 1.3 1.3 1.3 1.3 1.3 13 13 1.31 1.32 132 13 0.11 3 (1, 2 0.15 0.35 0.17 3 (1, 2 0.1 0.43 2.3 .28 2.33 ,33 3 2018 13 4 3 [ .41 F 1.3 1.35 1.3 1, 1.5 1.3 1.39 1.3 1, 1 1.1 1.3 1.35 1.3 1, 1 1.1 1.37 1.37 1.3 1, 1.37 1.37 1.3 1.3 1,3 1.4 1.37 1.35 129 1.3 1.33 151 . 4.3 4.3 . 0.26 . .47 7.7 . 0.13 44 4.3 164 2018 165 2015/9/4 16 2015/9/5 16 2018/9/6 18 2018 / 1 / 169 2012/16 17- 2016/9/12 171 2015/9/11 540,79 511.01 41. Et 42.8 43.4 541.26 5:12. 25 2.3 23 ,31 .4 [1 .[] . .45 2.6 4.3 4.35 1.35 2.3 2.3 2018 / 01 / 1 1 .4 .41 . [ . . 0.25 0.26 1,31 .33 5.23 0.33 33 .1 4. 4 434 1.33 ,33 .33 . .45 2.5 1.31 1.34 1.3 13 . (1.43 0.42 0.11 0.2 (1.41 0.1 0.41 0.1 1.4 1,39 0.37 0.3 1 1H 13 2011/11/12 174 2012/18 33,51 175 2018/9/13 538.43 176 02E/20 53322 17, 2018, 3 3.0 19 2018 / 1 / 4 3, 3 174 2012/9/5 162 01 A/a/28 53.45 R1 2013 Ra77 E1715 Index and Prices 1.33 434 43 4.3 1.33 2.3 3 3 . . 2. 1,33 . 3 .34 1.3 1.3 1.3 . 2.3 13 1 17 117 H? 11 | ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " : siffroad . i A Calbit a 1 * 1. [553 * B F 1. | | 1.33 (7 K | | M N P [] R T 11 1 V 014/ 27 161 w (. 2. 2.38 F 1.33 | . 1.31 1.32 . 0 2 1.3 1.7 129 1.8 38 4.3 4 1,3 .1 53.15 523.1 531,89 32. 38 3.71 530.6 531.21 30.18 , .33 .35 2.38 .32 4.31 1.32 1.32 4.3 .1 .1 .1 128 1.8 8 [ 163 02E 930 183 2018/10/21 184 2018/1/3 185 2018/11/4 1BE 201E10/3 187 2015/10/E 188 2018/1/ 184) 2011/10/10 190 2018/1/11 191 01/10/14 193 2016/10/15 193 2018/10/16 14 2018/1/17 195 2013/11/18 196 2016/10/21 197 2016/10/22 198 2018/10/23 1.35 1.34 1.35 1.33 1,25 1.11 1.32 1.11 1.33 | | | | 0.3 2.3 0.J 2.3 | 4 24 1.41 (1.4 2.3 0.4 . 1, 2. 14 2 0 2 1.4 . 6.4 [.7 2. .4 . . . 0.25 23 [ 13 . 5.23 0.53 0.25 [13 . .1 .1 4.3 2. 57.5 527.3 23.9 . 1.7 12 .4 | [] 25 , 1,2 .1 1.7 . 1.4 0.35 4 5 3 4.32 1.7 . .1 17,71 537.6 5 28.19 2.13 . .35 2.38 .3, 3 2.33 .37 2.37 .3, ,3, .37 .36 2.36 33 1.34 1.34 1.33 1.33 . 2. 1. B 128 4.3 14 25 .4 .1 .1 /2011 / 10 (1134 2118/1/25 O0 01/10/28 01 1. (1, 2 0, 20 0.3 6.5 524.3 523.5 . .1 02 2016/10/29 203 204B/10/30 1.34 1.34 1.32 1.32 . 0.33 0.33 [131 .31 0.21 2.3 22 [131 . . . 35 4.32 1.32 4.3 4. 4 434 1.33 3 3 2 1.5 1.25 1. 28 32, 1,2 , .1 101/31 ,2018 01/11/1 201E11 / 4 06 2018/11/5 07 11 2018 2018 0.3 3 (1, 2 (1,41 0.4 0.1 3H . . 2.33 .33 2.33 35 ,33 .35 .35 1.33 4.33 227,19 523.5 529.03 23 [123 2018/11/ 10 2011 211,9 5.13 52a. B3 317 313K 11/13 | 73 7 Index and Prices 1,14 1.34 1.35 129 1.3 1,35 1.6 1.8 16 1.28 34 4 1,34 . 24 .1 (, 39 0.5 0.7 2018/11/11 11 . . . .1 1.35 1 7E 1.36 112 37: | 17 11 | 12 ENG (0) w09 'o Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 . siffroad . i A Calbit a 1 * 1. E553 3.7 * A K | | M N P [] R T 11 1 V w (. .35 3 F 1.35 | | | | 0.3 2017/11/11 11 .1 . 4.35 1.35 4.34 12 2018/11/12 213 2018/11/13 214 2118/11/14 1.37 B 52a. F5 5 23.2 23.3 201 23.11 57.1 5 25.2 F 0.23 0.33 0.33 [ 13 .33 13 3 , . 2.2 ,23 . 4 0.17 3 (1, 20 1, 1 0.3 13 / 11 / 18 15 01/11/19 16 2016/11/21 1.3 13 12 1.3 1.3 1.9 1.2 14 . 4.3 1.32 1.32 4.33 . 2.28 23 2018 2018/11/12 219) 20118/11/21 .34 .3 2.3 .33 3 .33 .33 2.3 4 2018/11/20 01/11/27 31 4.33 1.33 .1 .1 0.37 3 (1, 2 0, 20 0.4 0.3 0.39 3.19 523.21 527. 2.1 22 2016/11/2a 23 2018/11 31 1.7 1. 28 1.28 0.2 0 31 1, . . 0.53 0.2 [131 . 0.21 0.31 033 [ 13 .33 55 2.3 23 ,23 . 2011/12 4 012/12/5 5 01/13/4 36 3 , 1.3 4.33 433 433 4.32 . 3 3 . 2.3 25,1 52.75 1, 1.16 1.35 1.37 1.3 1, 1.35 1.34 1.35 1.3 1, 1.3 1.35 1.33 1.3 1, 1.3 1.35 1.35 1.35 1.3 1.35 1.35 1.37 1.3 .1 .1 .1 1.4 . 0.39 . 27 2015/12/5 .523 2.3 23 5253 | 4 1 12 /2018 28 ( 12 / 2017 (20 2017/12/10 30 2018/1/11 31 4.3 2 4.3 128 1.8 1.7 . .1 4.3 4. 28 1.7 1. 28 1.7 . 2.3 2.3 23 3 . 0 31 [131 .31 .21 (1, 2 0, 20 0.35 0.15 0.3 (1, 2 1, 3g 0.3 0.15 3.3 .1 .4 .1 33. . . 2. 3 52.46 2.3 32 2016/12/12 52.12 2.3 233 2018/12/13 1 3 24 2018/1/16 25 2018/1/17 23, 2XA 3 52.25 52.31 2.3 238 2018/12/20 52.8 3 3 .31 57.13 575 15 37? Index and Prices 1 == | 201E12 / 18 36 2016/12/19 3 . 1.E 4.2E 7 1.6 1.7 126 1.2 1. 1. B .33 33 ,32 .3 .1 41. 3 / 12 / 2017 (30 2018/1/4 40 01/12/25 41 17 30 307 1,31 .31 0.39 , 3 0.5 0.3 1 12 1.37 137 3. 4.3 . . 12R 117 H? 18 7 35. - : " ENG (0) w09 '02 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx = = = = * 20 : siffroad . i A Calbit * a 1 * 1. 3.7 * [55 A K | | M N P [] R T 11 1 V w (. . 01/12/26 41 B 527.1 5 22.1 2. Et . F 1.37 117 4.3 1.E 4.3 .1 .1 12 2016/12/27 243 2018/12/20 2.3 2.32 12E 1.28 | | | | 0.3 0.39 .35 0.32 35 (1, 2 . 0.1 .35 0.43 3 , 4 31 / 12 / 2017 ?/2015 / 1 45 019/1/3 4E 2018/1/26 17 2.3 .31 F 0.4 . 033 [ 12 . 5.23 0.23 022 [ 12 .3 .1 .1 .1 3. 0.13 2.36 2.3 248 2018/1/28 9.1 530.5 530.05 9. E2 23, 5.71 523.5 531.2 228 1.3 1, 1.34 1.35 1.39 1.3 1, 2 1.34 1.3 1.3 1.39 128 1.8 2011/1/4 (40 2015/1/16 2015/1/13 51 .[] 2.31 2.32 3 3 . 2.35 3 4.3 4.3 1.32 4.3 2 431 1.32 1.33 4.3 3 4.35 4.34 .1 .1 0.4 0.42 0.12 33. 3. . 2.39 52 2015/1/11 53 2018/1/19 1.6 16 1.2 41 39 0.33 0.33 [ 13 . 1- .[] 2014/1/16 01/12 2011 5 3 (8 ,3 ,30 .1 32. . 0.43 . 56 2018/1/20 5 2018/1/21 258 2018/1/22 . . 2.27 2.26 , 2 1.3 1.4 1.11 1.4 11 0.13 .3a .33 2.3 3 .[] 28/1/4 2013 01/24 2011 60 . 4.3 431 431 4.32 1.32 2.37 523.73 5 28.12 222 3.12 13.4 527.5 5 28.25 30.33 30], ii 31.1 533.55 532.5 32. Et 61 2018/1/27 62 2015/1/2E 263 2019/1/29 3. . 2.21 0.32 1.21 [131 .31 0.21 0.31 1.21 [131 . 2 0.3 0.42 0.13 1.3 1.3 1.3 1,31 1.32 1.32 1.33 1.34 133 1.1 1.35 1.35 2. 21 3 .4 1. 1.43 1.13 1.43 1,43 1.43 1.42 1.12 143 .15 .1 .2 201148/1/363 4] 2014/1/11 5 2017 EE 2015/21 7 2 2019 68 2 / 2017 ] . 4.4 1.42 1.2 4.1 . .37 2.37 2. 2. 0.31 31 1 .1 [. 0.15 0.15 0.14 (. . 0.15 33 , .33 .1 1.3 4.5 4.45 1,32 0.31 2,51 n 31 01510 31 . 75 2011 27 35.73 537.5 777 2012/7/ | 575 ! Index and Prices 1.45 1.3 1.36 16F . 2. 2. ?? 1 E 1 1 n 15 : " ENG CwO90.2 Ps T= == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 siffroad . i A Calbit 1 a * * * 1. [55 3.9 * B (. F K | | M N P [] R T 11 1 V w 2012/11 72 . F 1.44 1.13 1.45 1.5 .21 | | | | 0.45 2. 0.11 2. 3 2019/2/12 2/4 2012/2013 536.2 536. 3.1 41, 1 1.36 1.36 13 2. 222 13 2014 2011 4 13 .[] 43 76 2014/2/19 . 1. 1.11 3. . 2015/2/18 37 . . 2.3 3 0.3 0.15 0.1 1.4B 1-17 448 78 2015/2/19 9 2012/20 281) 2011 49 2 1 1.13 1.41 2. 2. 543.5 513.J 52.8 41,16 41.0 54.51 512.11 0.2 022 [ 12 .33 5.23 0.33 22 [131 .31 5.23 0.33 0 22 [1 . 1.35 1.39 1.37 13 1.3 1.37 1.37 1.37 . ,1 . . 4 / 02 2011 R1 B2 2016/3/25 E3 2012 284 2012/2/2 3 2.3 2.3 23 4.4 1.45 1-13 4.4 1.3 1.42 1.12 . 0.15 0.15 2. . .41 42 40 12 13 1. .[] 2017 23/5 201 RK 2015/3/4 B7 41,18 4.3 53.51 513.5 43. Eg 4.3 1.43 1. 1.4 1.12 2.3 .3 2.33 2.3 . . . (. 0.15 0.15 2. BB 2015/3/5 89 2012/3 1.5 4.44 12 43. 0.32 0 22 [ 12 . 43 2011 (30 4 1. . . 36. 43 . (1.4 . 0.15 0.15 . 41. 444 1.45 1-15 4. 2015/3/11 92 201531 1.3 1.43 1.13 1.43 1,43 1.43 1.43 45 . 2.11 2.2 1.3 1.37 1.37 1.37 13 13 1.37 1.37 1.37 13 13 1.37 1.37 137 13 1.3 1.37 1.37 137 . 0 22 [ 12 1,31 2017/3/14 2017/17 2015 / 3 / 1A 97 . 1 2017/1C 54. Bin .35 510.5 2.35 24 2012/313 35 3 4. . 550.3 2.5 98 2016/3/19 550. DE 2. 2,40 [10) 2011/3/21 301 301 3/4 5.4 302 2015/3/25 550.5 .45 | En E 313 Index and Prices - 1 == 1 | HD 43. (1.4 1.4? 0.1 0.1 . 1.43 1.5 4.4 1.12 12 2013 29 [ H 50 2.8 . 1,31 . .4 ,1 . 2. .42 43 .3 .43 313 1. (. 0. 0.47 . 1.42 17 1.4 . 11 178 377 H? 1 17 ENG (0) w09 '02 Ps T== | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 . siffroad . i A Calbit 1 a * * * 1. [55 .1 * A F F K | | M N P [] R T 11 1 V w (. .43 .13 0.4 4.4 1.09 4.03 1.4 1.1 . | | | | 0.47 ,43 0.12 2.3 H 243 . 4 303 26/03/2019 30 2015/3/27 2015 2019/3/28 [11, 2011/3/31 2017 2015 , 30E 01223 30 2013-1 .1 1. 1,4 1.4 3. 4.12 0.3 0.1 4 1.3 1.37 13 13 1.35 1.39 1.1 1.4 1.4 1.4 . . 2. 22 1, 1 1.1 . .96 0.98 099 1,101 0.15 .43 2.3 43 B 550,45 539. 39.43 3[].4 3.3 535.91 538.3 32 23 3.3 35.4 53, A 535.6 535 . 33. N 33,291 531.25 531.2 141 2019 30 / 2011 311 2011 31 ,1 . . 1. 1.33 4 1.3 .21 2.21 2 . .93 0.98 98 1,51 . 0.47 0.12 . 2. 2. 4 3.118 41 313 01210 31 2015 11 35 2012 ,11 31 2014/15 317 2011 ,16 318 2019 17 319 2015 ,18 320 2019 21 . 1.33 1.3 1, 1.5 1.35 1.33 1.3 . (1.4 0.3 0.47 0.15 41. . .96 0.96 2. 2 3. 1.98 16 3.18 2. 2.3 .31 4 2011 31 1,2 1, 1 1.39 1.4 1,31) 1.3 1.34 1.3B 138 1,38 1.35 1.36 1.37 13 1.3 1.38 1.3B . . . * . []. 30.3 533.55 523, E 3 01 225 31 2018 ,24 321 2012/25 3.B 1.98 1.5 1.32 1.32 . .95 0.95 1.95 0.7 0.47 0.17 .43 2.3 3 2019 3 2 2011 [ ,] 1, 1.5 1.31 . * .53 0.93 4.0 2.18 1 2,1, 2.17 .17 2.17 .1 12 .17 .17 (1.4 0.7 0.4 0.15 45 . 2.26 1.1 .1 0.9 2 327 2011 09/12 12.4 32B 2016/5/5 535.51 3 2015 52.14 33 2015 331 2017 / 9 / 5.1 530.41 371 372 /11 E7n 11 Index and Prices 1 4.13 4. [] 4.[ 31 332 1555 333 1,31 1.31 1.33 111 1,22 . 0.5 13 1.3 1.37 1.36 15 (. . 0.47 . . 1.09 17 A no T 17 1 = 3 - ENG CwO9002 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 " siffroad . i A Calbit 1 a * * * 1. 3.9 * K | | M N P [] R T 11 1 V w F 1.3 B 530.41 5 30.11 29.99 F 0.5 0.9 | | | 0.47 0.12 . [55 A 333 019/5/13 331 2015/5/13 335 2019/5/14 30 2011 201 337 2015/16 33 019/5/19 33 2012/5/20 340 2019 21 1.31 1.33 1,33 1.33 1.33 . 535.13 52.82 4 1 4.09 | 1.09 | 4.0 4 [14 4.IR 4.GE | 1.08 4. 4. [15 4.(18 1.09 1.07 1.33 [1,511 0.91 . 0.91 (1.4 0.3 0.47 0.12 1.33 1.33 4 /201143 41 . 24 3 2.3 2.3 2.3 2. 28 ,31 .31 2.3 2.3 23 ,31 1 1 1.36 1.36 136 13 1.35 1.34 1.32 131 13 1.31 1.32 1.32 131 1.3 1.32 1.32 1.32 1.32 34) 2011 01/24 343 2016/5/26 31 2015/5/21 34 2012/28 5. 74 55. 525.5] 92 1,12 .51 2.9 0.93 92 . . 1.1 1.37 1.37 1.3 4 49. (. .17 2.17 .1 2,1, 2,1? .17 2.17 2.1 ,16 .16 .16 2.16 2.1 1 .16 .16 2.16 16 .1 2.15 .15 2.15 15 .1 2.15 .15 2.13 2.1 1 ,(4) (1.4 . 0.15 0.15 . (1.4 . 0.15 0.12 2011 40 2 ,1 3. 47 2015/16 34 019/6/? 31 2015/6/ 51.43 526.7 53.5 1.3 1.37 1.37 1.3 0.21 1.9 610 2019 43 345 .3 .32 2.33 3 .31 2 ,1 .1 . 1 2014 (1i 35 2014/6/13 35] 2015/5/13 351 2015/6/1E 2. 55.93 525.1 242 4.11 1.11 1.11 4.14 4.13 4.14 4.14 | 1.11 1.16 4.18 4.1 4. 1.1B 4.15 33. . 0.9 | 2.9 1.93 [1] 1.3 1.3 1.3 0.7 0.15 0.1 .33 12 [ H 17' 2019 18) 4 2017 33 33 (1.49 1.3 1.3 .33 1.35 1.37 1.37 1.3 1,3 1.4 1.35 1.37 1.3 1,3 1.3 1.35 . 0.93 [. 0.15 .1 357 2015/6/10 35 2015/6/20 352 2015/5/21 360 2012/6/21 . 523.13 5 23.51 0.96 0.15 ) 42 1.9 2014 1 25 3 . 1.3 1.3 12 1.3 1.3 .[] .33 2.3 3 .34 .34 7 3 36 2016 3.14 360 01 56 57 351 300ER/T E12 R1 Index and Prices 1, 2, ,45 .95 27 . 03, 4.19 1.19 5.1 0.42 0.49 1:12 11 115 11 I - 7 - = ENG SOM Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 : siffroad . i A Calbit 1 a * * 1. [55 3.7 * (. K | | M N P [] R T 11 1 V w 09 / 6 / 27 63 F 1.35 . B 523. 15 519 B3 20.4 | | | 0.49 0.15 05 . .3 1.35 13 .2 3 ,[ .1 (11 . 1.3 361 2012/6/20 365 2012/1 [1 2014 , 367 2012/7/5 366 2016/3/4 365 2012/7/21 30 2019 2/8 .1 .1 ( .1 .1 .1 1.33 1.37 F G 0.95 1.3 0.93 17 09 [1] ,45 0.95 0.99 1.9 1 [1, 1 ,47 1.0 2,3 .3 .33 3.10 5.R] 526. 25 . . 0.5 0.5 3 1. 14 .1 .1 (20 2011 1 1.4 .1 3 (3.4 .3 2.03 2.3 (13 2.03 . 2.0 1.4 1, 2.5 .1 525.6 525.5 . 0.47 0.5 1.1 0.99 37 2015/2/16 373 2015/7/21 71 2015/3/11 3 2012/19 4, 2011/2/10 37 2015/3/12 37B 2015/7/18 37 2015/7/21 l 2. .3 3 .35 .35 .35 .35 ,33 .34 .3 2.3 2 1.9 1.29 1.20) 1. ) .2 ) 1 23.9 525.1 525.3 323 4.15 1.2 4. 410) 4.14 1.19 . 4.1 4.1, 4.17 1.17 1.16 4.1 4.18 4.1 4.1B 1.16 4.16 4.1 4.17 1.17 1.16 4.16 4.1 4.16 1.17 1.15 4.1 4.17 4.17 4.17 1 17 2. . 2.0 2.3 1.41 1.4 1.4 1.1 [1 0.3 0.47 0.15 .1 .1 128 3 33 2019 8 2017 281 83 , 1.4 1 0.93 1 093 1,01 1.01 1.0 2.05 2.5 .1 ,33 2.01 .01 2.03 2 1.4 1.4 1.1 33. . 14 .5 . 1.6 1.6 1.5 16 1. 1. 1.5 1.5 2.35 .32 3 , 1, ,1 2.1 387 2015/3/4 12. 383 2019/7/25 55. 381 2015/2/21 525.1 38 2019 20 201143/363 387 2011 0/3/11 .43 BB 2013/3/4 531.1 385 2015/1 531. DE 30. By 11 2017 92 01 27 30.18 397 2015/3/E 531.17 31/11 /1 H E 2 1 Index and Prices 37. (1, 2 0.34 0.35 0.15 0.3 (1, 2 0.3 0.37 0.15 2 1,39 0.37 0.3 1.4 1.42 1.11 1.14 1. . 1.05 2.05 2015 2.12 12 2. 2. 2. 2013 300 (44. [ 12, .1 1 .1 .1 1. 2.11 .11 3r 1,CJ2 1.( 1.04 T, . . 4. 1.44 .1 1 1 1 7E | 15 77 = ENG (0) w09 '0 Ps T[ =/= 1,15 X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 siffroad . i A Calbit 1 a * * 1. [55 .1 * A B K | | M N P [] R T 11 1 V w (. . | | | 0.35 .52a .1 394 015821 395 2012/3/19 39 2019/3/20 F 1.44 1.13 1.3 522.5 3.34 2.0 . F 1.0 1.03 1.2 1 1 1. ] 1 2 . 2. 2.4 11 / 2017 , ,[ , .1 1 0.11 33 (1, 1 0.34 0.34 . 41. 4. 09 / 3 / 25 399 04. 1.3 1.42 1.13 1.3 2.08 2. 1 0.99 1 . 2.4 3 ,[] , ,1 1 0.12 33 (1, 1 0.5 0.31 25. 1.3 1.43 2016 404 2.03 .05 2.08 . (15 2.03 1.12 1. 1. 1.1B 1.1 118 1. 1.1B 1.1B 118 1.18 1.1 1.17 1.17 11 0.311 33 .43 2. .4 142 1,013 1.0 2.0 2. 1,CJ2 1.01 1.01 23 ,1) 4.17 . 4.12 4.13 4.13 4.12 1.11 4.14 4.14 4.15 4.15 1.15 4.15 4.14 4.15 4.15 1.15 4.14 4.14 4.14 1.14 1.11 4.14 4.15 4.14 4.15 | 1.15 | 414 4.14 4.14 4.14 1, 1.26 1.4 . 0.34 0.33 05. 11 39 2016/3/27 0.g 521.3 00 2015/8/2E 5 20.3 [1 2012/8/22 520.8 [] 2011 498 3 01 32 23.5 521.0 05 2012 521.13 [b 2018, 4/3 1.6 [17 2017 / 11 /4 11.4 2018 2017 / 11 / 1,71 409 2015/9/8 520.5 10 2015/9/ 519.23 II 2012/9/21 21.1 41 2014/1/11 13 2011 01/12 1, 1 414 2013/9/15 513.69 225 2015/1E 513.11 25 2011 51545 17 2017 2018 16. H 18 2011 513.4 19 2013/9/22 513.21 0 2015/9/23 517.2 16.41 17, 27 2015/26 51321 4 015/9/23 517.45 7E_703E 1 517 F5 Index and Prices 12 2.08 . (13 2.03 .44 2. .43 43 3 ,[ .1 0.12 33 (1, 1 0.13 0.34 2.2 1,011 1.01 0.58 1.01 2. 1.1 1.4 . . 05. 1, 2. 2.26 . 0.13 0.32 42. , 1 .1 1 . . . 2.0 1.4 1, 1.4 1.4 1.1 12 1.17 1.17 1.15 113 1.1 1.16 1.15 1.11 114 1.14 1.14 1.14 1,33 0.32 1 41. 1 0.13 23 2. 41 09 2019 1 2 / 11 / 2017 .2 ), .1 1 . 0.93 . .04 1.47 1.11 2.5 J, 33 0.3 0.31 1 17 .43 313 11 1 - 20 117 = 1 - 1 - = ENG (0) w09 '0 Ps F-| == | X Microsoft Excel - Assignment 2- Trading Data-Cleaned (5).xlsx * 20 . siffroad . i A Calbit * * a 1 * 1. [55 .1 * A B F F K | | M N P [] R T 11 1 V w 6199 / 26 3 4.14 (. . 2.0 . 0.93 24 | | | | 0.32 . 0.311 .13 32 .43 21 2015/9/22 25 2010/4/20 0.2 1,147 2014/10/1 , 1) 7 2015/10/ 1.42 1.11 1.41 1,41 1.1 1.11 1.11 1.1 1.14 1.11 113 1.12 1.12 1.12 1.12 1.12 . 41. . .99 0.33 0.33 517.21 517,19 17 65 17.4 51. 31 515.9 513.12 1. 13.1 51,3,501 515.5 510.75 1.48 015 / 10 / 3 . .05 2.05 2. 0.13 33 .41 2.3 2.43 43 , ,1 29 2018/10/6 30 2019/10/ 31 2017 29/10/g 37 2015/10/ 33 2015/10/10 31 2015/10/13 1) 0.15 4.13 4.12 4.12 4.12 1.12 4.12 4.12 4.12 4.12 1.15 4.25 4.1i 4.15 1.19 | 1.5 4. 2.03 . 2.05 2.5 . 43. 0.99 1.99 1, ,45 .93 0.9 093 1,15 1.45 1.44 1.12 1.2 2014/10/14 3 10/14 / 2017 2.13 2.43 41 ,16 , .1 0.32 0.13 33 (1, 1 0.5 0.32 0.31 3 37 2014/10/16 3 2019/10/17 41. 517,373 517.4 520,19 52.51 . . 2.05 2012/10/20 3 1. 1.47 1.1 1.4 19 . .9 0.9 093 1,15 .4 2. .43 ,43 4 2012/10/21 41 2011/10/22 n3 , , 4 2 ,1) 2014/10/23 0.34 0.34 44. . (1.4 523.2 5 20.3 19. EH 443 2012/10/22 11 2012/10/27 45 2014/10/28 1.11 1.13 1.12 1.23 1.12 1.12 1.14 1.11 124 1.13 1.12 1.14 1.12 112 1.12 1.13 1.12 1.16 115 1.1 1.14 1.2 . .05 2.05 . 1.4 1.45 1.1E 1.16 1. ,47 0.97 0.97 09 1, 1 0.11 3 . .43 . 10 / 2017 3 10