Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1 : Analyzing stock market condition. ( Note: Collect S&P 5 0 0 index prices using Yahoo! Finance. Ticker: SPX ) 1 ) From

Part 1: Analyzing "stock market condition." (Note: Collect S&P500 index prices using Yahoo! Finance. Ticker: SPX)
1) From MarketWatch (download S&P500 daily index prices over the period from Jan. 2,2019, to Dec 29,2023.(If unavailable, use the attached file including the SP500 index price over the period.)
2) Calculate daily S&P500 index returns and daily cumulative returns over the sample period (Jan.2,2019, to Dec 28,2023):
3) Compute daily cumulative returns:
4) Calculate the mean and standard deviation of daily returns.
5) Plot the cumulative returns over the sample period (X-axis: Date, Y-axis: Cumulative Return).
6) Explain the plot by identifying trends, significant events, or periods of high volatility.
Part 2: Analyzing "TED Spread."
1) Use the 3-month LIBOR as attached
2) Download daily "3-month Treasury Constant Maturity Rate" from Jan. 2,2019, to Dec 29,2023
3) Compute the daily average rate of return and standard deviation with a 3-month T-bill rate over the sample period,
4) Plot the cumulative rate of return (X-axis: Date, Y-axis: Cumulative Return) from 3). Explain the plot thoroughly.
5) Compare the daily average return and standard deviation from Part 1 and Part 2. Explain any similarities or differences.
6) Calculate daily TED spreads over the sample period. (TED Spread =3-month LIBOR -3-month Treasury Constant Maturity Rate.)
7) Plot the TED spreads (X-axis: Date, Y-axis: TED Spread) over the sample period. Explain the plot by identifying periods of stress or relaxation in the financial markets.

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_2

Step: 3

blur-text-image_3

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

Better Than Alpha Three Steps To Capturing Excess Returns In A Changing World

Authors: Christopher M. Schelling

1st Edition

1264257651,126425766X

More Books

Students also viewed these Finance questions