Generate Stock Intraday Data for Excel

Not everyone knows that Microsoft Excel has the ability to draw stock chart. If you don’t have professional charting tool, Microsoft Excel stock chart is a simple but useful tool to conduct initial analysis. For example, if you are interested in plotting Coca-Cola (KO) daily chart with 1minute interval, following are the steps to generate stock intraday chart by using data output from Stock Intraday Quotes Download

Step 1: Generate Data Output With Appropriate Settings

Microsoft Excel stock chart requires the data format to be Time-Volume-Open-High-Low-Close, which is different from traditional format, Time-Open-High-Low-Close-Volume. But no problem, Stock Intraday Quotes Download gives you the flexibility to choose the order of data field. Follow is the sample screenshot for the setting in “Customize the data field” window:



Following is the sample screenshot for the setting window:



Make sure the file extension is “csv” so that when you double click the output, it will be automatically opened by Excel. Also make sure the Add Header box is checked. Because we are interested in generating daily chart with interval 1 minute, choose Range to be 1 day and Interval to be 1 min. As for data source, it can be either Google Finance or Yahoo Finance, depends on your preference.
After that, simply add the symbol KO in the table and hit update.

Step2: Load generated data into Excel

Following is a sample screenshot after you open the generated data by Excel



If you are using Microsoft Excel 2010, you can find stock chart type in “Insert”->”Other Charts”->”stock”

Step 3: Generate the Chart

Following is the KO daily chart generated after selecting the column B – G and choose the right most stock chart type



That’s it. You can also use Excel to calculate some indicators such as moving average, RSI, and MACD, and plot them. It’s a tool you can consider and it is free if you already have Excel