Question
Microsoft Stock From the Yahoo Finance Website, collect weekly price and weekly volume information for the period: October 12, 2015 (Mon.) October 14, 2016 (Fri.).
Microsoft Stock
From the Yahoo Finance Website, collect weekly price and weekly volume information for the period: October 12, 2015 (Mon.) October 14, 2016 (Fri.). This should be about 52 weeks of information with the week beginning October 12, 2015 (Mon.) being the 1st week and the week beginning October 10, 2016 (Mon.) being the last week. This data can be provided using the historical price function at the Yahoo Finance Website. Prepare a table of this price and volume information. Using the Interactive Charting function at the Yahoo Finance Website, in which you can set the range for the price series at the bottom of the graph, graph the weekly price and volume data for your stock for this period. Present this table and the graph in your project report.
2. Based upon the data gathered in question #1, establish support and resistance levels for your stock. Discuss the justification of why you feel these are support and resistance levels.
3. Prepare a similar weekly stock price and weekly volume chart for the period: October 17, 2016 (Mon.) October 20, 2017 (Fri.). You can also gather this same data at the Yahoo Finance Website and graph the data using the same functions as in question #1 above. Present this table and the graph in your project report.
4. Given your answers to #2 and your graph in #3, has the stock penetrated the support and resistance levels during the 10/17/2016 10/20/2017 period? If so, discuss what action you would take and why?
5. For the period October 12, 2015 October 14, 2016, using the same functions at the Yahoo Finance Website, plot the weekly price (close) movement in your company's stock against: (a) 50 day moving average price line, and (b) 200 day moving average price line. Include in your plots the weekly volume for your company. Present this graph in your project report as well. Given the weekly price movements relative to each of these moving average lines and the weekly volume, what would you do and why? Perform the same analysis for the period 10/17/2016 10/20/2017 for the two moving average price lines and present this graph, too, in your project report. What actions would you take and why?
6. Implement a filter rule for your stock for the 10/12/2015 10/14/2016 period. Prepare a table which compares the dollar profits (losses) on the trading strategy with the profits (losses) on a naive buy and hold strategy. Assume trading in lots of 100 shares and a 1% (one-way) commission. Does your filter rule hold? Perform the same analysis for the 10/17/2016 10/20/2017 period. Does the filter rule work here?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started