Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Yahoo Finance, download daily prices for the SPDR S&P 500 ETF (ticker = SPY) during July 1 to December 31, 2016. More specically, on
Using Yahoo Finance, download daily prices for the SPDR S&P 500 ETF (ticker = SPY) during July 1 to December 31, 2016. More specically, on the Yahoo Finance page, type in the ticker, then click \"Historical Data\" underneath the current price, enter the appropriate time period, choose \"Daily\" as the data frequency, and click \"Apply.\" Finally, when the prices appear, click \"Download Data\" underneath the \"Apply\" button to download the data to a spreadsheet. 1) Use the \"Adj Close\" price to calculate daily returns. Then compute the mean daily return during these six months and the standard deviation, skewness, and kurtosis of the daily retums. Comment on whether the daily return data are close to a normal distribution. 2) The average daily sir-month Treasury-bill yield during these six months was 0.001395% (yes, nearly zero). Use it as the risk-ee rate to compute S&P 500's daily Sharpe ratio during these six months. 3) Assuming there is no correlation between daily retums (i.e., they are all independent), what is the estimated annual Sharpe ratio? There are 252 trading days during one year. 4) Using the actual daily retum data (not assuming a normal distribution), calculate the 5% Value at Risk (VaR) and the 5% Expected Shortfall (ES)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started