Assignment task: Download the daily closing share price of Alphabet and S&P500 index (Ticker GOOG and SPY) from Yahoo Finance for the period 10-Feb-2022 to 10-Feb-2023.
Using historical data,
a) Calculate the expected daily and annual return for both the company and the index.
b) Calculate the daily and annual standard deviation of the company and the index.
c) Calculate the beta of the company.
d) Over the past year, which one is a better investment? If you have a choice, would you use 24 or 12-month of returns to proxy for expected return? Explain your own reasons.