Q2. Consider the shared spreadsheet containing Price series of five different stock and answer the following:

In your opinion, which strategy will be better as per One-year VaR (@99% confidence level) calculation for a risk averse investor "risk minimize portfolio" or "equal weight portfolio"? (Show the calculation for equal weight portfolio as well and state your opinion in in same excel file.)

Date	HUL	HCL Tech	PRAXIS	HDFC	IDBI
20-Sep-19	1812.75	1049.55	81.45	1974.6	27.2
23-Sep-19	1969.75	1049.1	81.3	2049.3	28.75
24-Sep-19	2039.75	1032.9	82.75	2162	30.95
25-Sep-19	2050.45	1047.4	80	2130	34.1
26-Sep-19	2051.5	1053.85	61	2069.95	36.9
27-Sep-19	2034.4	1045.15	60	2063.2	35.7
30-Sep-19	2010.9	1041.05	58.85	2035.9	33.6
01-Oct-19	1981.95	1080.6	59.6	1977.05	31.75
03-Oct-19	1990.3	1059.55	59.55	1995.65	30.55
04-Oct-19	1962.05	1076.8	58.85	1974.55	30.8
07-Oct-19	1944.2	1079.1	59.35	1978.3	30.65
09-Oct-19	1940.05	1074.4	59.95	1969.3	29.8
10-Oct-19	1948	1051.1	59.85	2002	29.9
11-Oct-19	1968.75	1063.5	58	1987.95	29.65
14-Oct-19	2004.65	1079.5	60.9	2010.15	29.5
15-Oct-19	2014.25	1086.8	63.9	2014.75	29.15
16-Oct-19	2064.4	1084.5	67.05	2013.3	28.95
17-Oct-19	2071	1100.9	64.15	2048.7	29.05
18-Oct-19	2103.85	1093.05	60.95	2089.75	29.9
22-Oct-19	2106.85	1095.5	61.3	2094.45	30.7
23-Oct-19	2127.35	1064.45	64.3	2114.9	30.85
24-Oct-19	2133.25	1095.15	61.85	2142.95	30.7
25-Oct-19	2133.35	1119.05	62.1	2144.95	30.45
27-Oct-19	2145.1	1134.05	61	2101.55	30.75
29-Oct-19	2139.75	1130.5	61.35	2105.35	30.9
30-Oct-19	2160.2	1139.75	60.9	2113.05	32.7
31-Oct-19	2169.4	1146.75	62.75	2107.45	33.25
01-Nov-19	2175.35	1162.75	63.05	2131.9	33.2
04-Nov-19	2179.35	1152	61.65	2128.6	33.9
05-Nov-19	2158.15	1155.9	62	2181.3	34.95
06-Nov-19	2172.15	1158.7	62.25	2181.3	33.8
07-Nov-19	2179.45	1148.35	65.35	2220.6	33.6
08-Nov-19	2138.25	1148.45	68.6	2251	33.6
11-Nov-19	2086.4	1150.1	72	2233.2	33.05
13-Nov-19	2081.35	1145.95	75.55	2234.55	33.4
14-Nov-19	2091	1138.6	79.2	2207.45	32.15
15-Nov-19	2069.05	1147.8	35.75	2226.8	31.85
18-Nov-19	2057.7	1142.3	34	2224.05	32.9
19-Nov-19	2056.2	1141.1	32.3	2236.3	32.85
20-Nov-19	2037.75	1134.65	33.9	2212.1	33.85
21-Nov-19	2026.5	1132.8	33.65	2200.95	33.9
22-Nov-19	2048.65	1136.6	32	2210.35	33.45
25-Nov-19	2028.35	1114.75	30.4	2237.3	38.7
26-Nov-19	2062.4	1124.75	28.95	2294.55	37.6
27-Nov-19	2058.35	1108.05	30.35	2304.65	36.3
28-Nov-19	2093.25	1128.25	31.5	2336.3	36.25
29-Nov-19	2087.15	1132.65	31.05	2309.75	38.05
02-Dec-19	2035.3	1127.65	29.75	2297.25	37.75
03-Dec-19	2043.2	1125.3	28.7	2306.6	37.1
04-Dec-19	2028.45	1124.55	29.25	2319.7	36
05-Dec-19	2048	1125.5	28.2	2322.4	36.15
06-Dec-19	2037.45	560.9	27.55	2327.55	35.85
09-Dec-19	2026.05	560.3	26.65	2264.65	34.65
10-Dec-19	2008.15	552.05	26.7	2311.4	34.1
11-Dec-19	2025.35	544.45	26.2	2295.15	33.55
12-Dec-19	2010.45	543.8	25.8	2321.65	33.85
13-Dec-19	2007.35	536.35	24.55	2318.45	36.9
16-Dec-19	2006.2	543.15	23.55	2354.5	38.45
17-Dec-19	1974.75	552.2	23.5	2375.25	38
18-Dec-19	1961.35	557.75	22.5	2430.1	37.4
19-Dec-19	1928.55	564.7	21.4	2445.15	37
20-Dec-19	1951.1	569.5	20.35	2411.9	37.25
23-Dec-19	1943.1	569.9	19.35	2404.1	37.4
24-Dec-19	1950.4	570.95	20.3	2422.65	37.75
26-Dec-19	1946.4	560.55	21.3	2412.75	37.3
27-Dec-19	1944.95	560.5	22.15	2414.1	37.15
30-Dec-19	1949.9	567.55	23.2	2444.15	37.35
31-Dec-19	1937.25	569.3	24.3	2438.25	37.15
01-Jan-20	1923	568.1	25.5	2412.55	37
02-Jan-20	1936.55	571.95	25.95	2433.95	37.1
03-Jan-20	1938.05	573.55	27.2	2466.4	37.5
06-Jan-20	1927.45	585.05	28.55	2454.45	37.2
07-Jan-20	1915.45	582	29.1	2384.1	35.65
08-Jan-20	1920.7	584.25	28.95	2415.05	35.75
09-Jan-20	1929.35	585.75	28.45	2406.15	35.25
10-Jan-20	1935.05	580.3	27.7	2457.4	35.7
13-Jan-20	1954	580.35	27.4	2457.55	36.35
14-Jan-20	1994.85	586.5	27.7	2462.55	36.2
15-Jan-20	2008.8	594.3	27.3	2492.3	35.95
16-Jan-20	2021.65	595.75	27.15	2488.6	35.8
17-Jan-20	2049.25	593.25	26.5	2482.1	36.05
20-Jan-20	2060.3	598.8	27.05	2453.95	35.8
21-Jan-20	2062.85	589.25	27.65	2454.35	35.45
22-Jan-20	2055.4	584.05	28.45	2465.45	35.7
23-Jan-20	2051.7	590.65	29.85	2416.6	35.5
24-Jan-20	2056.9	598.95	31.3	2428.4	35.4
27-Jan-20	2073.7	607.7	32.85	2450.75	35.45
28-Jan-20	2061.35	604.35	34.45	2395.8	34.9
29-Jan-20	2060.6	601.45	36.15	2431.6	34.7
30-Jan-20	2074.2	608.85	36.05	2404.25	34.55
31-Jan-20	2058.1	607.85	34.25	2415	34.05
01-Feb-20	2034.25	591.4	30.1	2414	33.8
03-Feb-20	2074.9	590.9	30	2268.25	37.25
04-Feb-20	2178.95	579.1	31.5	2259.75	35.2
05-Feb-20	2155.6	586.5	32.45	2345.95	34.55
06-Feb-20	2160.3	595.6	31.2	2391.65	34.25
07-Feb-20	2156.4	599.7	30.7	2436.45	34.75
10-Feb-20	2159.95	607.7	30.1	2405.65	36.25
11-Feb-20	2159.3	604.9	30.1	2414.3	36.3
12-Feb-20	2152.65	610.65	30.4	2435.15	37
13-Feb-20	2260.35	614.1	30.6	2437.6	34.75
14-Feb-20	2283.4	612.45	32.1	2403.65	35.7
17-Feb-20	2255.05	621.65	33.7	2401.75	35.45
18-Feb-20	2252.6	613.45	35.35	2350.25	34.55
19-Feb-20	2234.4	607.05	37.1	2318.8	34.1
20-Feb-20	2292.15	605.75	38.95	2377.25	34.55
24-Feb-20	2248.25	608.05	40.85	2369.5	34.55
25-Feb-20	2215.15	595.15	42.85	2292.3	34.2
26-Feb-20	2233.6	582.45	35.7	2302.6	34.2
27-Feb-20	2236.2	583.6	33.6	2281.45	33.45
28-Feb-20	2254.95	573.05	31.75	2272.2	33.15
02-Mar-20	2174.75	534.35	30.55	2175.75	30.6
03-Mar-20	2159.45	549.7	30.8	2179.65	29.8
04-Mar-20	2166.65	565.05	30.65	2191.4	29.45
05-Mar-20	2175.85	563.1	29.8	2206.05	28.55
06-Mar-20	2218	576.4	29.9	2195.05	29.9
09-Mar-20	2188.9	566.2	29.65	2109.45	27.15
11-Mar-20	2121.5	540.45	29.5	2027.9	25.2
12-Mar-20	2155	536.8	29.15	2036.25	25.7
13-Mar-20	2055.95	493.35	28.95	1875.7	21.2
16-Mar-20	2033.2	492.9	29.05	2066.8	23.3
17-Mar-20	1941.9	450.7	29.9	1841.75	22.4
18-Mar-20	2004.05	450.65	30.7	1755.8	21.6
19-Mar-20	1923.8	434.25	30.85	1622.55	20.75
20-Mar-20	1838.3	413.45	30.7	1617.6	20.35
23-Mar-20	2051.7	444.9	30.45	1753.95	22.1
24-Mar-20	1869.7	417.15	30.75	1520.7	19.5
25-Mar-20	2027.85	442.05	30.9	1505.1	18.45
26-Mar-20	2088.15	457.6	32.7	1646.05	17.8
27-Mar-20	2194.9	447.7	33.25	1733.25	19.3
30-Mar-20	2140.55	430.65	33.2	1754	19.7
31-Mar-20	2184.35	419	33.9	1558.75	19.1
01-Apr-20	2298.5	436.4	34.95	1633.1	19.3
03-Apr-20	2179.65	413.55	33.8	1583.5	19.3
07-Apr-20	2154.1	405.8	33.6	1499.55	19.4
08-Apr-20	2444.9	451.15	33.6	1555.15	19.95
09-Apr-20	2460.85	463.1	33.05	1558.8	19.7
13-Apr-20	2372.25	469.05	33.4	1703.1	21.3
15-Apr-20	2346.45	458.25	32.15	1655.2	20.7
16-Apr-20	2487.55	478.75	31.85	1596.3	20.55
17-Apr-20	2436.1	459.75	32.9	1625.75	20.75
20-Apr-20	2385	455.25	32.85	1680.6	21.15
21-Apr-20	2336.55	470	33.85	1727.7	22.45
22-Apr-20	2317.4	455.7	33.9	1669.7	21.2
23-Apr-20	2386.15	462.4	33.45	1664.15	21.35
24-Apr-20	2317.5	477.7	38.7	1663.45	21.45
27-Apr-20	2283.1	468.1	37.6	1580.3	21.05
28-Apr-20	2320.45	483.1	36.3	1591.45	21
29-Apr-20	2289.95	471.1	36.25	1715.8	21
30-Apr-20	2231.75	491.75	38.05	1836.75	21.2
04-May-20	2195	543.55	37.75	1916	21.45
05-May-20	2082.65	514.25	37.1	1724.35	20.75
06-May-20	2041.5	520.4	36	1689.9	20.6
07-May-20	2010.2	519.1	36.15	1732.15	20.4
08-May-20	1992.05	511.75	35.85	1703.9	20.35
11-May-20	2089.45	518.4	34.65	1689.7	20.05
12-May-20	2048	527.55	34.1	1658.45	19.95
13-May-20	2011.55	527.4	33.55	1674.1	20.15
14-May-20	1995.75	528.75	33.85	1712.75	20.8
15-May-20	2006.05	517.45	36.9	1632.4	20.5
18-May-20	2032.1	511.25	38.45	1633.8	20.25
19-May-20	2005.25	510.75	38	1512.05	19.35
20-May-20	1975.55	518.25	37.4	1539.85	19.4
21-May-20	1990.85	526.75	37	1627	19.45
22-May-20	1970.9	534.85	37.25	1597.3	19.55
26-May-20	1987.9	530.4	37.4	1516.15	19.65
27-May-20	1977.8	524	37.75	1502.15	19.65
28-May-20	1998.1	530.95	37.3	1570.4	19.85
29-May-20	2009.95	542.65	37.15	1623.7	20.1
01-Jun-20	2057.35	550.25	37.35	1658.9	20.4
02-Jun-20	2108.55	559.75	37.15	1737.7	24.45
03-Jun-20	2107.4	560.2	37	1813.55	29
04-Jun-20	2120.5	562.8	37.1	1835.65	31.9
05-Jun-20	2120.6	578.95	37.5	1764.3	35.05
08-Jun-20	2087.6	575.95	37.2	1766.6	38.55
09-Jun-20	2111.7	578.25	35.65	1760.8	37.3
10-Jun-20	2106.5	572.85	35.75	1772.1	35.45
11-Jun-20	2119.6	578.7	35.25	1809.3	33.7
12-Jun-20	2106.9	578.05	35.7	1787.45	32.05
15-Jun-20	2107.25	570.75	36.35	1792.2	31.75
16-Jun-20	2084.3	578.95	36.2	1751.65	33.3
17-Jun-20	2076.35	580.9	35.95	1821.9	32.05
18-Jun-20	2078.25	575.85	35.8	1794.65	31.9
19-Jun-20	2065.35	578.95	36.05	1855.95	31.9
22-Jun-20	2092.75	569.6	35.8	1835.1	31.75
23-Jun-20	2100.8	569.6	35.45	1819.4	33.05
24-Jun-20	2155.95	580.25	35.7	1838.1	34.6
25-Jun-20	2130.3	559.6	35.5	1797.75	36.3
26-Jun-20	2173.15	550.05	35.4	1777.8	38.1
29-Jun-20	2154.2	562.4	35.45	1769.35	40
30-Jun-20	2182.95	553.7	34.9	1741.15	42
01-Jul-20	2180	556.85	34.7	1754.65	44.1
02-Jul-20	2170.4	551.75	34.55	1835.15	46.3
03-Jul-20	2151.75	569.2	34.05	1889.45	48.6
06-Jul-20	2173.7	579.15	33.8	1885.2	51
07-Jul-20	2161.6	578.7	37.25	1868.7	53.55
08-Jul-20	2154.15	592.05	35.2	1886.75	50.9
09-Jul-20	2186.05	574.9	34.55	1886.05	48.4
10-Jul-20	2175.85	588.25	34.25	1941.85	46
13-Jul-20	2223.8	582.25	34.75	1886	43.7
14-Jul-20	2265.25	602.6	36.25	1845.55	41.55
15-Jul-20	2234.75	591.35	36.3	1791.6	39.5
16-Jul-20	2275.15	615.2	37	1789.9	40.05
17-Jul-20	2287.85	627.75	34.75	1787.8	38.3
20-Jul-20	2334.55	623.15	35.7	1805.85	38.05
21-Jul-20	2330.95	648.6	35.45	1806.05	39.95
22-Jul-20	2318	652.35	34.55	1883.65	39.45
23-Jul-20	2248.5	650.15	34.1	1881.05	38.8
24-Jul-20	2211.35	652.85	34.55	1875.8	39.1
27-Jul-20	2209.3	679.95	34.55	1841.3	38.45
28-Jul-20	2221.5	701.1	34.2	1850.75	36.85
29-Jul-20	2242.55	712.45	34.2	1897.35	38.1
30-Jul-20	2231.3	694.4	33.45	1877.3	40
31-Jul-20	2195.6	695.45	33.15	1810.65	40.55
03-Aug-20	2209.9	705.2	30.6	1781.95	38.7
04-Aug-20	2204.5	705.95	29.8	1739.8	39.35
05-Aug-20	2197.8	692.65	29.45	1781.1	38.55
06-Aug-20	2194.55	688.4	28.55	1776.7	38.95
07-Aug-20	2220.45	704.9	29.9	1783.75	39.3
10-Aug-20	2210.55	690.3	27.15	1777.7	40.3
11-Aug-20	2206.75	692.05	25.2	1798.95	39.85
12-Aug-20	2210.65	683.8	25.7	1826.75	39.8
13-Aug-20	2195.1	717.1	21.2	1814.2	40
14-Aug-20	2198.65	724.6	23.3	1804.85	39.65
17-Aug-20	2173.9	709.1	22.4	1791.7	38.95
18-Aug-20	2196.05	718.85	21.6	1800.55	38.6
19-Aug-20	2214.35	714.45	20.75	1820.7	39.6
20-Aug-20	2193.6	709.85	20.35	1827.95	39.85
21-Aug-20	2185.7	710.1	22.1	1785.15	39.4
24-Aug-20	2202.05	705.9	19.5	1804.05	43.3
25-Aug-20	2194.4	705.7	18.45	1829.85	42.2
26-Aug-20	2179.1	701.6	17.8	1829.6	41.95
27-Aug-20	2182.8	712.8	38.85	1816	41.7
28-Aug-20	2171.25	710.15	39.5	1864.1	41.15
31-Aug-20	2151.95	706.45	39.15	1883.25	41.55
01-Sep-20	2117.35	694.4	38.4	1832.6	39.25
02-Sep-20	2161.65	689.6	38.45	1851.2	38.85
03-Sep-20	2141.65	701.95	38.1	1827.2	39.5
04-Sep-20	2139.15	706.75	37.3	1808.75	39.15
07-Sep-20	2124.65	700.8	37.85	1769.7	38.4
08-Sep-20	2162.6	708.8	38	1791.1	38.45
09-Sep-20	2142.25	725.9	37.6	1777.3	38.1
10-Sep-20	2132.25	721.95	37.65	1760.75	37.3
11-Sep-20	2133.9	722.4	37.7	1777.45	37.85
14-Sep-20	2159.25	721.65	37.5	1768.15	38
15-Sep-20	2123.5	794.95	41.15	1738	37.6
16-Sep-20	2124.45	792.7	41.55	1758.75	37.65
17-Sep-20	2143.5	789.25	39.25	1768.15	37.7
18-Sep-20	2128.2	808.3	38.85	1744.35	37.5