1.Choose two stocks whose ticker starts with the first letter of your first name (example: “B”lake, BA, BYND, and B). Each company should be trading for at least two years.
2.Download two years’ worth of daily stock price data from yahoo finance or any other site you would like to use. Keep the adjusted close, and compute log returns.
Helpful Hints:
Yahoo finance is the easiest way to download historical stock price data. https://finance.yahoo.com/.
Yahoo is easy but can take some time. If you are interested in getting stock data into excel and you like exploring new things, try alpha vantage https://www.alphavantage.co/excel_installer/.
You could also use NASDAQ’s site, https://www.nasdaq.com/market-activity/quotes/historical.
Compute the average annual return, the average annual standard deviation.
Sample Solution
