In this assignment you will be analyzing real stock market data downloaded from YAHOO! FINANCE. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this assignment you will be analyzing real stock market data downloaded from YAHOO! FINANCE. The file DowPricing_2004_2010.csv which you can download from Ed, contains the daily closing prices of the 30 stocks which make up the Dow Jones Industrial Average Index. Prices are recorded on a (business)-daily basis between 31/12/2003 and 29/12/2010. This includes the Global Financial Crisis (GFC) which we locate here in time from very roughly from 03/01/2007 - 31/05/2010. We define the peak of the GFC as the period 02/09/08-01/06/09, and define a pre-GFC and post-GFC period from 03/01/07 - 29/08/2007 and from 01/06/09 - 31/12/10, respectively. Recall that Lehman Brothers filed bankrupt protection on September 15, 2008. There are two particularities with this time series: (1) Visa's share price starts at 19/3/2008 on YAHOO! FINANCE. (2) Dow and DuPont have recently merged and are now trading as a new entity (DWDP) with a short trading history. Therefore only consider the 28 stocks without Visa and Dow & DuPont. All prices are here in US dollars. CORRELATIONS AND THE COVARIANCE MATRIX 1. Export the data into Matlab using csvread and/or readtable. This question investigates the correlations of the return rates. When analyzing return rate data one has several choices. A commonly used variable is the logarithmic change of price or the so called log return rate: Let Y be the price at time i, then consider E = log Yi-log Yi-1 (wrt the natural base). An advantage of this variable to quantify the return rate is that it insensitive to (constant!) deflation factors (why?). (i) Calculate the maximal correlation between the Ei, and plot the two stock prices associated with the highest correlation as a function of time (excluding Visa and/or Dow & DuPont (see above)) (ii) Calculate the minimal correlation between the E, and plot the two stock prices associated with the smallest correlation as a function of time (excluding Visa and/or Dow & DuPont (see above)) (iii) Visualize the correlation matrices for the period before and during the GFC (separating into pre/peak/post periods). (You may use Matlab's command imagesc). Can you spot differences? (iv) Plot the histogram of the correlation coefficients pij for the four periods. Comment on your result. (v) Play with the data and try to identify interesting particularities. This sub-question will not be marked just an encouragement to have some fun. In this assignment you will be analyzing real stock market data downloaded from YAHOO! FINANCE. The file DowPricing_2004_2010.csv which you can download from Ed, contains the daily closing prices of the 30 stocks which make up the Dow Jones Industrial Average Index. Prices are recorded on a (business)-daily basis between 31/12/2003 and 29/12/2010. This includes the Global Financial Crisis (GFC) which we locate here in time from very roughly from 03/01/2007 - 31/05/2010. We define the peak of the GFC as the period 02/09/08-01/06/09, and define a pre-GFC and post-GFC period from 03/01/07 - 29/08/2007 and from 01/06/09 - 31/12/10, respectively. Recall that Lehman Brothers filed bankrupt protection on September 15, 2008. There are two particularities with this time series: (1) Visa's share price starts at 19/3/2008 on YAHOO! FINANCE. (2) Dow and DuPont have recently merged and are now trading as a new entity (DWDP) with a short trading history. Therefore only consider the 28 stocks without Visa and Dow & DuPont. All prices are here in US dollars. CORRELATIONS AND THE COVARIANCE MATRIX 1. Export the data into Matlab using csvread and/or readtable. This question investigates the correlations of the return rates. When analyzing return rate data one has several choices. A commonly used variable is the logarithmic change of price or the so called log return rate: Let Y be the price at time i, then consider E = log Yi-log Yi-1 (wrt the natural base). An advantage of this variable to quantify the return rate is that it insensitive to (constant!) deflation factors (why?). (i) Calculate the maximal correlation between the Ei, and plot the two stock prices associated with the highest correlation as a function of time (excluding Visa and/or Dow & DuPont (see above)) (ii) Calculate the minimal correlation between the E, and plot the two stock prices associated with the smallest correlation as a function of time (excluding Visa and/or Dow & DuPont (see above)) (iii) Visualize the correlation matrices for the period before and during the GFC (separating into pre/peak/post periods). (You may use Matlab's command imagesc). Can you spot differences? (iv) Plot the histogram of the correlation coefficients pij for the four periods. Comment on your result. (v) Play with the data and try to identify interesting particularities. This sub-question will not be marked just an encouragement to have some fun.
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these finance questions
-
Utilizing resoorces, complete a risk audit of Bank of Americas project to acquire Merrill Lynch. Ensure you address all 10 critical success factors. From the evidence of your audit, would you advise...
-
Gary Brandt, treasurer of WorldCom, Inc., could not remember a year quite like the last. WorldCom had stunned the financial community in November 1997 with a $37-billion bid for MCI Corp., besting...
-
A chemical processing plant has a network of pipes that are used to transfer liquid chemical products from one part of the plant to another. The following pipe network has pipe flow capacities in...
-
You may refer to the opening story of Tony and Suzie and their decision to start Great Adventures in AP 1-1. More of their story and the first set of transactions for the company in July are...
-
The annual rate of growth of real GDP in a developing nation is 0.3 percent. Initially, the country's population was stable from year to year. Recently, however, a significant increase in the...
-
During February, Peters Hardware made sales of \($38,600\) and ended the month with inventories totaling \($5,400.\) Cost of Goods Sold was \($23,200.\) Total operating expenses were \($8,700.\) How...
-
Flow between two tanks (Fig. 7B.4). Case I: A fluid flows between two tanks A and B because PA > PB. The tanks are at the same elevation and there is no pump in the line. The connecting line has a...
-
1. Every student enrolls in an online course; how do you manage your online course in terms of making ethical decisions making? Considering the situation right now and you saw your classmate sharing...
-
The time to make beds at a motel is supposed to fall into an agreed-on range of times. A sample of five maids was selected to evaluate their efficiency, and the time needed to make a bed was observed...
-
Interview three small-business owners about things they do (or have done) to bootstrap the financing of their business. How effective were these techniques? Be prepared to present this list to the...
-
Choose a type of business you would like to run. Then search the Internet for government grants that might be applicable for you and your business.
-
Go to a directory of venture capitalists and ascertain what percentage of funds for a typical venture-capital firm are invested in seed, start-up, expansion or development, and acquisitions or...
-
Should the government provide grants for entrepreneurs starting new businesses? Should the government guarantee loans for small businesses that are missing the necessary track record, assets, or...
-
The firm needs to make sales. What is the best way to motivate salespeople to make more sales and improve the performance of the firm? How would you effectively monitor their performance under the...
-
Annotate the following article. Reference: Adapted from Paul Bogard, Let There Be Dark. 2012 by Los Angeles Times. Originally published December 21, 2012. Article: At my familys cabin on a Minnesota...
-
When the Department of Homeland Security created a color-coded system to prepare government officials and the public against terrorist attacks, what did it do right and what did it do wrong?
-
The file P11.34.xlsx contains data on the top 40 golfers in 2008. This was the year when Tiger Woods won the U.S. Open in June and then had year-ending surgery directly afterward. Using all 40...
-
For 12 straight weeks you have observed the sales (in number of cases) of canned tomatoes at Mr. Ds supermarket. Each week you kept track of the following: Was a promotional notice placed in all...
-
Modify the Barney-Jones investment problem so that there is a minimum amount that must be put into any investment, although this minimum can vary by investment. For example, the minimum amount for...
-
Water at \(35^{\circ} \mathrm{C}\) is pumped through a horizontal, \(200-\mathrm{m}\)-long, \(30-\mathrm{mm}\)-diameter tube at \(0.25 \mathrm{~kg} / \mathrm{s}\). Over time, a 2-mm-thick layer of...
-
What is the pressure drop associated with water at \(27^{\circ} \mathrm{C}\) flowing with a mean velocity of \(0.1 \mathrm{~m} / \mathrm{s}\) through an \(800-\mathrm{m}-\) long cast iron pipe of...
-
Fully developed conditions are known to exist for water flowing through a \(50-\mathrm{mm}\)-diameter tube at \(0.02 \mathrm{~kg} / \mathrm{s}\) and \(27^{\circ} \mathrm{C}\). What is the maximum...
Study smarter with the SolutionInn App