Question

In: Finance

Collect recent data on the stock market index (for e.g., either S&P500 or DJIA or TASI)...

Collect recent data on the stock market index (for e.g., either S&P500 or DJIA or TASI) for a period covering a few months. Try to identify primary trends using the technical analysis stats discussed in the class. Can you tell whether the market currently is in an upward or downward trend?

Solutions

Expert Solution

S&P 500 Historical Data

  • Date Range:

    01/01/2020 - 06/30/2020

  • Monthly

Date

Price

Open

High

Low

Volume

Chg%

Jun 2020 3,053.24 3,035.80 3,233.13 2,964.40 0 0.29%
May 2020 3,044.31 2,856.70 3,068.88 2,766.46 0 4.53%
Apr 2020 2,912.43 2,488.12 2,955.10 2,447.49 0 12.68%
Mar 2020 2,584.59 2,982.50 3,137.80 2,189.88 0 -12.51%
Feb 2020 2,954.22 3,235.66 3,393.52 2,855.84 0 -8.41%
Jan 2020 3,225.52 3,244.67 3,337.77 3,214.64 0 -0.16%

Highest = 3,393.52

Lowest = 2,189.88

Difference = 1,203.64

Average = 2,962.39

Chg. % = -5.50

we can use several analysis tools to find out the trend of the given data. Here only taken 6 months data of s&p 500. with this data we can surely say that the trend of the given is downward . here we can identify by taking the changes of averages or the percentage of changes in prices . on jan 2020 the price of the stock were 3225.52 it were had a decrease in the price from 3230.68. which is of 0.16%. after that the price of the stock had changed to 2954.22 which is again got a fall in price of -8.41% , here we can see that the perecentage of change were increased. after that on march 2020 th price of the stock got changed to 2584.59 wich is agin got a fall in price of -12.51%. the trend of the stock price is downward now. and which is falling more. and after that the price got rised to 2912.43 on april 2020 which had an increase of 12.68%. the positive change in price doesn't make any change in trend pattern. on may 2020 it again got a rise in price to 3044.31 which is of 4.53%. after it changed to 3053.24 which had a small change 0.29%. by seeing these changes only we can say that its a situation of not to put money. because the patten of the stockprice can't be predicted. for the last 3 months it had positive changes but the percentage of changes is still negative. so even if it had positive changes, it is still in downward trend.


Related Solutions

Part 1 : Analyzing "stock market condition". (Note: Collect S&P500 index prices using Yahoo! Finance.) 1)...
Part 1 : Analyzing "stock market condition". (Note: Collect S&P500 index prices using Yahoo! Finance.) 1) Download S&P500 daily index prices from Dec 31, 2019 to Apr 30, 2020. 2) Calculate daily S&P500 index returns and daily cumulative returns over the sample period. 3) Plot the cumulative returns and analyze the plot.  
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Suppose that the next S&P500 return will be 7%. Use the CAPM model to calculate the expected return...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Assuming normal distribution, what is the probability that the next S&P500 return will be greater than 0? Please...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 What is the sample standard deviation of the stock A returns? Please write an answer in decimals. For...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Assuming normal distribution, what is the probability that the next stock A return will be less than 0?...
True or False 12. If you have the historical data of S&P500 index level in the...
True or False 12. If you have the historical data of S&P500 index level in the last 5 years, you can compute the returns of investment in 500 stocks in the S&P500. Assume you know the 500 constituents. 13. If you just watched bad news on the market on CNBC and if you believe the market risk premium is 0.5% for the next month and, you should short sell the market to maximize your Sharpe ratio. 14. A portfolio’s net...
Compute the total return on all of these in the respective market: 1. The S&P500 stock...
Compute the total return on all of these in the respective market: 1. The S&P500 stock index closes at 2250 at the end of March. At the end of June, the index closes at 2475. Assume the S&P500 has a divided yield of 3% annually. 2. The S&P500 stock index closes at 2500 at the end of December. The following June, the index closes at 2400. Assume the S&P500 has a divided yield of 2% annually. 3. A Treasury bond...
You are an options trader with an investment bank. It appears that the S&P500 index will...
You are an options trader with an investment bank. It appears that the S&P500 index will trade between 2700 and 2500 for the next few months. How can you use options to create a profitable investment opportunity? 1 )Please explain in detail. 2) Show the payoff and profit in a graph.
You are an options trader with an investment bank. It appears that the S&P500 index will...
You are an options trader with an investment bank. It appears that the S&P500 index will trade between 2700 and 2500 for the next few months. How can you use options to create a profitable investment opportunity? Show the payoff and profit in a graph.
The S&P 500, or simply the S&P, is a stock market index that measures the stock...
The S&P 500, or simply the S&P, is a stock market index that measures the stock performance of 500 large companies listed on stock exchanges in the United States. define an adequate investment strategy, and select the assets they would invest to start with. -the potential customer profile specifications (SAP 500), -the portfolio objectives -the investment policies (strategic allocation) -The choice and justification of a benchmark -a trial portfolio based on the team investment guidelines -a brief evaluation on each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT