Question

Create a line chart for the closing prices for all years, and a stock chart for the high/low/close prices for August 2013 in the Excel file S&P 500. (Show all steps in excel)

Answer 1

The data for all years is downloaded from yahoo finance. The data is available from 1950. Frequency selected is monthly data. This data is filtered using the "Filter" button in "Data" tab. Now, the date column is filtered for dates in December. This gives us the closing price in December for each year from 1950 to 2018

Now, the open, high,low, and close columns are hidden. Only date and adjusted close remaining. Now, go to "Insert" tab in Excel, click the "Line" button, and select "Line". The line chart is displayed

Stock chart :

First, the data for August 2013 is downloaded from yahoo finance

All the columns are hidden except High, Low and Close. Go to "Insert" tab in Excel, click on "other charts" --> "stock charts" --> high-low-close. Then right click on the chart, select data and in the horizontal axis label field, select the dates