Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Geometry Using The Geometer's Sketchpad

Authors: Barbara E Reynolds, William E Fenton

1st Edition

1118213408, 9781118213407

More Books

Students also viewed these Mathematics questions

Question

Prove the identity. 2 csc 2t = sec t csc t

Answered: 1 week ago