Free Stock Quote Tracker

The Excel Stock Quotes program is a collection of custom Excel functions and macros that allow you to insert stock data in to any cell in any worksheet. For example, if you wanted a stock quote for IBM to appear in a particular cell, you would enter this: =GetQuote("IBM"). This function would then retrieve the latest quote for IBM. Alternatively, you can use =GetQuote("A1") where A1 is a reference to a cell.

Price isn't the only information you can retrieve. Here's a complete list of the functions that you can use to retrieve information:

• GetChange(symbol or cell) - Retrieves the price change for the current day.
• GetChartURL(symbol or cell) - Creates a link you can click on to load the stock's chart on bigcharts.com.
• GetHigh(symbol or cell) - Retrieves the high price for the current day.
• GetLow(symbol or cell) - Retrieves the low price for the current day.
• GetOpen(symbol or cell) - Retrieves the open price for the current day.
• GetPE(symbol or cell) - Retrieves the PE ratio.
• GetPercentChange200Day(symbol or cell) - Retrieves the percentage difference between the current price and the 200 day moving average.
• GetPercentChange50Day(symbol or cell) - Retrieves the percentage difference between the current price and the 50 day moving average.
• Get52wkHigh(symbol or cell) - Retrieves the 52 week high.
• Get52wkLow(symbol or cell) - Retrieves the 52 week low.
• GetPercentChange52wkHigh(symbol or cell) - Retrieves the percentage difference between the current price and the 52 week high.
• GetPercentChange52wkLow(symbol or cell) - Retrieves the percentage difference between the current price and the 52 week low.
• GetPrice(symbol or cell) - Retrieves the current price.
• GetTime(symbol or cell) - Retrieves the time of the last stock quote.
• GetVolume(symbol or cell) - Retrieves the trading volume for the stock for the day.

Also available is the ability to have stock quotes automatically retrieved at an interval that you specify. Alternatively, you can retrieve the quotes whenever you want at the click of a button.

System Requirements and Notes

To run the Excel Stock Quotes program successfully, make sure you have:

• Windows 2000 or Windows XP installed on your computer.
• Excel 2000 or greater installed on your computer.
• You should be familiar with how to use Excel functions and understand the concepts of relative and absolute cell values to get the most from this program.
• This is NOT an add-in. It is an Excel workbook with all the functionality built in to the workbook.
• Internet access is required to retrieve quotes.
• This workbook retrieves stock quote data from Yahoo. If Yahoo changes or discontinues the service (unlikely), this program will stop functioning.
• If you make too many quote requests in too short a period of time, Yahoo may block future requests. I can't do anything about that. In over a year's worth of use, I haven't had any problems.
• Up to a few hundred stock symbols can easily be handled by this program. More are possible, but not guaranteed, depending on your Internet connection and computer speed.

It's FREE!

You can download the stock quote tracker.

There is no charge. But if you run a web site, please consider spreading the word by linking to this page (i.e. http://www.etftopics.com/free-stock-quote-tracker/). If there's enough demand for this tool, I'll reconsider adding all of the features people have been requesting.

Instructions are included in the Excel workbook.