- 1). Get your raw data for the Dow or any other stock from yahoo. Below is the link for the DJIA:
http://finance.yahoo.com/q/hp?s=^DJI - 2). On the Yahoo page mentioned above:
Set the date range. Dow Jones prices are available since 1928 to present. Also set the sampling rate (Daily,Weekly,Monthly,Dividends Only) - 3). Click on 'Get Prices'. The page will update.
- 4). Scroll down and click on 'Download to Spreadsheet'
It will ask you whether to open the .csv file with Microsoft Office Excel (or your default spreadsheet program) or save the file. Click on 'Open'. - 5). Now you have the data in Excel with the date in the left column and various DJIA values in the other columns.
Create a chart using a data range with the columns you want. Make sure you include the date column . Also, the volume should be plotted separately since it's orders of magnitude greater than the rest of the values. Excel will know that the date is the x axis of your plot and will make a nice chart. - 6). Right click on any set of data points and click on 'Add Trendline' to start making some sense of this mess!
- Advertisement -
- Advertisement -