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!

ASCII to MetaStock Conversion Utility

 
Free end of day ASCII to MetaStock conversion utility is available now! It allows you to easily convert data generated from Stock Historical Data Download to MetaStock/Computrac format without any charges. Following is a simple instruction:

Step 1: Download the software

You can download the software from eoddata website here. You have to be a registered member to be able to download it. It is free to become a registered member

Step2: Generate stock end-of-day data

You can easily generate stock end-of-day data by using Stock Historical Data Download with appropriate setting:
1. For File Name Setup, the file extension has to be set as “txt” and the postfix has be set as “_date”. For example, if your end-of-day data is generated in 2012 March 24, type “_20120324” here
2. For Format Setup, the Date Format has to be set as “YYYYMMDD” and the Separator has to be set to none
Following is a sample screenshot of the necessary settings.



Following is the sample screenshot for MetaStock column 8 setting nn the “Customize the Data Field”

Step 3: Convert EOD data into MetaStock Format

After generating EOD data, we are ready to convert it into MetaStock format. First, launch the conversion utility. Following is a sample screenshot that you will see after launching the conversion utility:



The setting is very straightforward. Simply choose your source directory and destination directory, and then hit the “Convert” button.

Stock Market Browser Available Now

 
Stock Market Browser (SMB) version 1.00 is released! ! This tool provides you a unique way to find investment opportunity. We believe that the sector and industry the company you are interested in investing is important as well. That’s the reason why Stock Market Browser is useful. Based on your investment goal, you might be interested in owning companies in a particular sector and industry. With Stock Market Browser, you can not only browse the list of companies that are within a particular sector and industry, but also you can setup the screen criteria based on P/E, ROE %, market cap, dividend yield, debt to equity ratio, P/B, Net profit margin, and price to free cash flow to get the specific company within that industry.  The screened result can be exported to .csv format for further post processing you like.  If you want to know more about the particular company, simply double clicking the symbol to bring out detailed information to make your investment decision easier.
 

Main Features

· Only one time purchase fee, no further subscription fee

· Free upgrade for future release

· provide the price up number and the percentage to measure the overall market, sector, and industry performance

· Instantly monitor 9 sectors, 215 industries, more than 6000 publicly traded stock

· Screen the companies based on P/E, ROE %, dividend yield, debt to equity ratio, P/B, Net profit margin, and price to free cash flow within an industry

· In-software edit capability allows you to rearrange the data before exporting it .csv format

· In-software symbol query capability

· Detailed information such as profile, news, and chart is provided for selected symbol


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!