submit it using 1 Excel file (.xls or .xlsx). Retrieve monthly data for the period of 01/01/2012 – 12/31/2017 from Yahoo Finance for Samp;P 500…

submit it using 1 Excel file (.xls or .xlsx).

1. Retrieve monthly data for the period of 01/01/2012 – 12/31/2017 from Yahoo Finance for

  1. S&P 500 Index (ticker: ^GSPC)
  2. Apple Inc. (ticker: AAPL)
  3. Procter & Gamble
  4. Disney (ticker: DIS)
  5. Ford (ticker: F)

 Instructions

  1. Yahoo Finance address: https://finance.yahoo.com
  2. To obtain the monthly data for each company, on Yahoo! Finance website, enter the ticker symbol in the companies search bar. Then, click on “Historical Data”. Enter “Time Period” as given above. For “Frequency”, make sure “Monthly” is selected and then click on “Apply”. Click on “Download Data”. Your computer will download a .csv file with 7 columns

Order the answer to view it

Assignment Solutions
Assignment Solutions