Compute the annualized volatility for each of your stocks

Reference no: EM131583074

Project Assignment: Stock Data Collected

1. Be sure your data is listed so that each column is a different stock and the rows contain the prices for each day of your collection.

	Stock 1	Stock 2	Stock 3...	Stock 10
1/1/17
1/2/17
1/32/174
	HPR1	HPR2	HPR3	HPR1
	Volatility1	Volatility2	Volatility3	Volatility10
Investment	$10,000	$10,000	$10,000	$10,000

2. Compute the holding period return for each. Here is a website that will help.

3. Compute the annualized volatility for each of your stocks:

4. Compute the return on an equally weighted portfolio of your ten stock.

5. Construct a correlation matrix for the ten stocks in your spreadsheet.

6. Using the correlation matrix, construct 6 portfolios of two stocks each. Find 2 portfolios of positively correlated stocks, 2 portfolios of negatively correlated stocks and 2 portfolios of stocks that have correlations that are as close to zero as you have.

7. Compare the portfolio returns you get to the individual returns of the stock that comprise them.

8. Lastly, create portfolio of 5 stocks of your own choosing and weight. Compute the daily value of that portfolio, then use this column to determine the holding period return and volatility of your self-constructed portfolio.

Attachment:- Attachments.rar

Reference no: EM131583074

Questions Cloud

Explain what benefit does two-step clustering approach have : Explain what benefit does this two-step clustering approach have over the approaches in parts (1) and (2)? What weakness does it have?

Write an essay about an event in your life : Using The Hunger Games as your starting point, write an essay about an event in your life that will engage readers and that will, at the same time

Provide your own definition of community-policing : Identify the skills and knowledge that are imparted to police trainees during their academy training and explain the importance of these skills in relation .

Find the effective interest rate charged to roscoe : Roscoe's credit card has an APR of 13.59%, and it just changed its compounding period from daily to monthly.

Compute the annualized volatility for each of your stocks : Compute the annualized volatility for each of your stocks. Compute the return on an equally weighted portfolio of your ten stock.

Find the number of dimes and the number of quarters : A collection of dimes and quarters is retrieved from a soft drink machine. There are five times as many dimes as quarters and the total value of the coins.

Explain how budget cuts affect the various programs : Analyze the pros and cons of privatizing prison services and programs to alleviate budgetary costs.

Find the amount invested at each rate : Yolanda invested $50,000. Part of the money was invested at 6% yearly interest rate and part at 9% yearly interest rate.

Compares classical and biological theories. : Prepare a report that compares classical, biological, and psychological theories. xplain which theory is most applicable to crimes committed today.

User Account

All Pages