Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!