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

Stock Intraday Quotes Download 1.0 Available Now

Stock Intraday Quotes Download 1.0 (SIQD) version 1.00 is released! It can download the stock intraday prices for you with no monthly subscription fee at all. With the support of various data format such as MetaStock, you are able to use SIQD to download the intraday stock data, convert it to MetaStock format, and load it into your charting tool. Tired of manually launching the software, opening the symbol list, hitting the update button every day? Don’t worry, Stock Intraday Quotes Download supports console mode that makes fully automation possible.

Main Features

· Only one time purchase fee, no monthly subscription fee
· Batch downloads the symbol lists defined by you. There is no limitation of the number of symbols
· Support data source from Yahoo Finance and Google Finance
· Asynchronous download
· GUI or console-only versions
· Define your own data format to download
· Support MetaStock ASCII 8 column format
· Support various data range (1 – 15 days) and interval (1 – 60 minutes)
· Customize the data file name with postfix option
· Fully automation through command mode

You can access the complete documentation here. Also we provide the trial version with absolutely no cost to you. Try it now and tell us what you think. We would be more than happy to get any feedback or suggestion from you!