INITIAL PORTFOLIO
18 Nov 2020	Ticker	Nominal	Last_Price	Value (TRY)
Stock_1	GARAN	1.000	8,85	8.850
Stock_2	AKSA	1.502	10,02	15.050
Stock_3	AKBNK	1.600	6,27	10.032
Stock_4	MAVI	1.375	45,36	62.370
Stock_5	EKGYO	1.858	1,99	3.697
Cash	CASH			1
TOTAL				100.000

,

1. Calculate covariance and correlation coefficient of your stocks in pairs in excel and plot them as a table like the one given in the worksheet of the excel file (see below).

Covariance and Correlation Coefficient ?

2. Comment on the selection of your stocks in the first week, taking into account the new correlation coefficients information you have calculated in Part1. Would you prefer to select few or less stocks or different stocks in your first week selection process, taking into account the risk diversification concept?