To complete the first assignment, you will need to find and obtain the set of daily closing prices for the stock of any company of your choice for the last 10 years (approx. 2400 observations), then perform the following:
1. Export the data to an excel sheet, and sort them by date (older first). Make sure that prices values are entered as numbers and consistent with Excel!
2. convert the daily price into daily returns.
3. Calculate the average daily return, variance, and standard deviation for the data set.
4. Perform statistics tests on the daily returns to assess the level conformity to the normal distribution. (skewness, Kurtosis)
5. Comment on the results.