Cumulative list of software mentioned in a newsgroup thread called "Free Software 4 U."
|

Latest Posts


Free Software List

The following list contains only freeware programs that install into your computer and
that do not require paid subscriptions to a service or data feed to be useable.  None
are embedded in anybody's webpage.  Some of them are very good
programs, some of them do things that your broker's software already does, some of
them are mediocre-quality software that plot an unusual type of chart, some of
them are obsolete junk, but all of them are functional and you won't discover you
need to pay money to make them work after you've installed them.  There are many
more downloadable programs listed on places like CNET, SourceForge, etc.; you will
find that only about 15% are both freeware and worth anything.  I have already
sorted through them, this list is the result.
 

CHARTING/TECHNICAL ANALYSIS PROGRAMS

AptiStock
Here is a freeware program that charts EoD data.  It seems to be written by people
in India, but this isn't obvious on the website.  It has its own online community,
but nobody seems to answer postings except about Indian markets.  It is not
connected with any brokerage, and is freeware, except it has a 4-line wide window
that flashes Google's banner ads.
Notes:
1) It claims to chart data from US plus 23 different foreign markets, I think from
accessing historical data from other countries' Yahoo sites.  This works, but I
haven't tried many of them.  It will store the price data for the same stock
traded in different markets in separate directories, so you could plot both
without conflict if you wanted.  This operates only from downloaded stock lists
taken from their website.  These ticker lists seem complete for markets like NYSE
and NASDAQ, but not for OTC markets.
2) This one can plot a true equivolume chart, where candlesticks of varying widths
representing volume are plotted with volume instead of time as the x-axis.  See
attachment for example.  This feature gets a little buggy when you try to resize
things.
3) It has a "tower" chart that I don't understand.
4) It has a "fund distribution" plot that I don't understand.
5) The help function is incomplete; for example, it doesn't explain the things
noted above.
6) The y-axis of charts can be plotted with a logarithmic axis, which is a typical
feature, but the logarithmic scale can be based on a choice of log 10, log 2, or
log e.  Bizzare, don't you think?
7) Charts most of the common indicators, but none of the less common ones.
 
QuoteTracker
A charting and trading program that is itself free, but stunted without datafeeds
provided by certain brokerages:
Notes:
1) It accepts historical data from a wide variety of brokerages; and streaming
intraday data but it needs to pause and backfill data to hard drive for the
trading hours before you have run the program.  Some of the sources are free and
some are not; you can probably receive streaming data from your online broker
account; certainly you can find historical data for free from one or the other.
2) You can make trade stocks from inside QuoteTracker, but only through accounts
at a certain few of these brokerages.
3) It has a portfolio view that is good, that can link to accounts at a certain
few of these brokerages, but not so closely that you can't add positions held in
separate accounts or change the cost basis values that are held in the broker's
account.
4) Charts can be set to show after-hours data (this appears as the sparse
candlesticks of after-hours trades).
5) There's a five-line banner ad that you have to look at if you use it as
freeware.  This disappears if you send money to QT or have an account at certain
brokerages which provide QT to their customers gratis.
6) QT shows Level II data from some sources.
7) There are tabs to access a lot of stock research pages from Yahoo Finance and
Zack's.
8) Streaming market index values are shown in their own bar.
9) QT is maintained by T2 API Technologies (one programmer named Jerry Medved),
which was purchased by TD Ameritrade in 2008.  TD Ameritrade began to place more
restrictions on this program in late 2009; it seems you need to have some sort of
account with AMTD to have QT enabled at this time, but it still accepts feeds from
other brokers.
 
FCharts
Here is a charting program that works with downloaded historical data from Yahoo
Finance:
The programmer is a semipro science fiction writer in Australia, which explains a
few things when you see his website.  There is a freeware version, named
FreeCharts or FChartsSE, that has a few minor limitations; and a pay version,
named FCharts Pro.  I bought the pro version because I was acquainted with the guy
a little from newsgroups.  He charges about 120USD now, but it was 90 when I got
it.  He updates the program frequently.  Very stable, few bugs.
Notes:
1) You can write the formula for indicators yourself and experiment - that's the
biggest advantage.  The main difference between SE and Pro versions is the number
of indicators you can store has no limitations.
2) The charts produced are very high quality.  They can be output as pdf and bmp.
3) A few of the features are involved with the ASX market only or certain peculiar
trading techniques that are popular for some reason in Australia.  When program is
downloaded, some of the Yahoo urls are set to Australian Yahoo with .au in their
nodes, that need editing out from the Preferences by Americans.
4) The program will chart intraday data, but does it parasitically from
QuoteTracker, another freeware charting program.  QuoteTracker must be running on
your computer simultaneously with FCharts for FCharts' intraday window to get data
from QuoteTracker, and it can only get the data from stocks that have first been
added to QT's watchlist and then backfilled with intraday data in QT.  It can get
live data from QT, only while QT is receiving streaming data.  Maybe you would go
through this if you wanted to use some feature in FCharts on intraday data for
some reason.
5) It has a portfolio feature like many charting programs, but this feature is
awkward.
6) It doesn't read split data out of Yahoo files -- you have to enter all splits
manually.  This split correction operates by changing the daily prices stored in
the program's database, so record of pre-split prices are lost.
7) The program has screening capability for whatever stock data you have imported
into the program.
8) The program has a feature to create indexes by adding a set of stock prices
together, but there is not capability to make a weighted index.
9) This program has an online village, but if you go there, you'll be downunder.
 
Wall Street Analyzer
A charting program:
This is totally free, but maybe not as good as FreeCharts.  It plots an equivolume
chart by changing the widths of the candlesticks only, but leaves the x-axis in
terms of time, so it is not a true equivolume chart.
 
EclipseTrader
Another chart program that uses Yahoo EoD data, also data from OpenTick.  It has
some technical indicators in it that I've never heard of.  Eclipse is a script
like Java, but didn't catch on, even less than ruby or Python.
 
JStock
This is a program from China:
http://sourceforge.net/projects/jstock
Has a watchlist, a stock screener, a chatroom interface, and some charting ability.
 
CapitalReSources
An EoD data charting program posted on SourceForge of 2007 vintage, still updates
about once a year.
 
Chartastic Chart Viewer
A chart viewer that gets EoD data.  Plots one hi-quality chart at a time.  You
gotta join the website to get in.
 
Chartsy
A charting program provided free by a website called MrSwing.com:
Program downloads data from Yahoo Finance and draws a stock chart.  This is a program given free by a website that tries to sell you stuff, wants your e-mail address, send you stock pick letters.  A registration screen pops up on open that leads to this website, but program will still run if you click Remind Me Later.  Previous version required going to this website to download plugins that gave the indicators, but these install with the program now.
 
iTrade
Charting program:
Notes:
1) Can assemble a portfolio table on one screen of securities traded in any market
in any country using their ISIN numbers as the key field (ISIN numbers contain a
country code like "US" or "FR"); in principle, you could show the Vodaphone ADR
shares traded on NYSE and the Vodaphone shares traded on FTSE together.  Not many
stock chart programs can do this.
2) Has a chart function that is limited to only several indicators: RSI,
Stochastic, 20,50 and 100d SMA.  Bad bug: the plot of Stochastic seems to be
calculated with a wrong formula.
3) This program is written in Python (the current version of Python is 3.0) and
needs Python V2.5 plus four different Python add-on modules that were never
updated since Python V2.5, so versions of these Python programs written for Python
2.5 only must all be installed for iTrade to run.  You should be able to find the
most updated versions/releases which are still compatible with Python V2.5 from
various download sites by examining the names of the downloadable installer files
listed below:
Python                  http://www.python.org
python-2.5.4.msi
wxPython                http://www.wxpython.org
wxPython2.8-win32-unicode-2.8.9.1-py25.exe
matplotlib              http://matplotlib.sourceforge.net
mathplotlib-0.91.4.win32-py2.5.exe
Numerical Python        http://sourceforge.net/projects/numpy
numpy-1.2.1.win32-py2.5.exe
xlrd                    http://www.lexicon.net/sjmachin/xlrd.htm
xlrd-0.6.1.win32.exe
 
Evolutionary Elliot Wave Trading Program
This one was originally a unix program called EWaveTrade.  Unfortunately, what you
download is not an executable program, but files meant to be compiled into an
executable program with Microsoft Visual C++, Version 6.
If you have this version of Visual C++, you can compile everything; alternatively,
you can send me an e-mail and I'll send you the compiled program files.
Installation and Build Notes:
1) Extract the downloaded zipfile ElliotEngine_1_0_2.zip to c:\Program Files.
2) After you have extracted this zipfile into a directory called "ElliotEngine" on
your hard drive, you will discover that you need to download a zipfile of a stock
charting program module from someplace else:
Chart Director for C++   http://www.advsofteng.com/download.html
chartdir_cpp_win32.zip
There will already be a subdirectory of ElliotEngine called ChartDirector.
Extract the chartdir_cpp_win32.zip zipfile into ElliotEngine directory so that it
will overwrite the ChartDirector subdirectory.  ChartDirector should be filled
with files now.
3) In the ElliotEngine directory, change a line in file ElliotEngineDoc.cpp from
const char YahooDateTemplate2[]   = "%d/%m/%y";
to
const char YahooDateTemplate2[]   = "%Y-%m-%d";
which will read in the date format that is in Yahoo Finance historical quotes csv
files.
4) At this point, the program can be compiled with Microsoft Visual C++ V6.0.  The
project file for Visual C++ is ElliotEngine_w_Chart.dsp; open this file with MS
Visual C++, then build it.  After you close Visual C++, you will find that there
is a subdirectory "debug" left behind in directory ElliotEngine.  This will
contain ElliotEngine_w_Chart.exe and chartdir41.dll, and various other files left
behind during the compilation.
5) Move the two files from subdirectory debug, ElliotEngine_w_Chart.exe and
chartdir41.dll, to a new directory outside of ElliotEngine -- only these two are
needed to run the program.  After this, you may delete the entire ElliotEngine
directory and everything else in it, including two files with the same filenames
that extracted from the original zipfile into a subdirectory "Release".
6) ElliotEngine_w_Chart.exe in the Release subdirectory is now the executable file
for the program that will run, read data, and plot stock charts.  The dll file
must be in the same directory.  Create a shortcut to this exe file and move it
someplace useful.

AIOTrade
Another charting program.
AIO stands for All In One.  Used to be called blogtrader and Humai Trading Platform.  Needs Java JRE.
 
MAS
A charting program from around 2002.  The acronym is for Market Analysis System.
An update of a module is still posted on SourceForge, but the full program isn't
there anymore:
I have the installer for full version 1.6.5a, I can send it to you if you want.  I
could get it to chart data, but it was difficult to access quotes directly.  It's
not as good as FreeCharts.  I mention it because it's freeware.
 
RAPID
A chart program from around 1990 that was originally for MS DOS and sold
commercially, but is now given away at:
It has been reconfigured to respond to mouse clicks and run on Win 98 to XP.  It is listed under "Rapid Charting for Investment Decisions" now, which is what the acronym is for.  It has also been called by the name of a website it used to be posted on "www(dot)rapidcharting(dot)com".  On the SourceForge page, you need to go into their file archives to get the Windows version, because they have a Linux version under the Download link.
 

BACKTESTERS

Webotron Stocks
A freeware that gives you a selection of a lot of trading systems based on TA
crossovers and suchlike and backtests them.  It downloads EoD data from Yahoo
Finance.  It could be interesting to look through the selections of trading rules
for ideas to backtest on some professional software.  The GUI window is locked in
one size that is about 2/3 wide as a typical monitor.
 
Merchant of Venice
This is primarily a program for backtesting swing trading systems of a portfolio
of stocks on EoD data, using trendy scientific optimization algorithms -- genetic
algorithm and artificial neural network.
Notes:
1) It has some charting features with the standard indicators.  The charting
aspect is mediocre.
2) Historical quotes for individual stocks can be downloaded from Yahoo, which is
straightforward.  Getting large bodies of data in is awkward, because the program
wants XML files.  Documentation talks about linking the program to databases using
various freeware database managers, MySQL in particular, but this is a chore to
set up.
3) The program has one resident Artificial Neural Network installed.  If you want
to get into this, and change to ANNs of different structure, you need to create
them with joone, another freeware program, for which you need to install several
other programs to run, JDK and ANT Build Tool....
4) This software is not perfectly stable, but certainly useable, which is pretty
good for something out of SourceForge.
5) It comes with data for All Ordinaries components loaded into it, so it wreaks
of Australia.
 
Oropuro
A program from Italy with a high quality interface:
The menus and commands can be set to display in English, unfortunately, all program documentation is written in
Italian.  It appears to me to provide charting and backtesting.  The backtesting involves artificial intelligence
algorithms.  It is too complex to understand without reading the Italian manual.

Forex Strategy Builder
A forex backtester that is entirely freeware, not connected to an arbitrage
broker.
http://forexsb.com/
This program needs Microsoft .NET Framework 2.0 installed on your Windows operating system.
 

FUNDAMENTAL SCREENERS

Follow the Money
This is the explanation from the above page so you can see the concept:
Follow The Money is a Windows mash up program that allows a trader to quickly
screen for increased activity interest in stocks about to announce earnings for a
selected date. Heavy volume in advance of an earnings announcement can indicate
institutional interest in a stock. If the money is flowing in, institutions may be
buying, money flowing out, institutions may be selling. To make money just 'Follow
The Money!'.
 
Yummy Yields Super Stock Ticker Picker
Downloads entire database out of Yahoo Finance key statistics, and similar
websites, then sorts into table based on dividend yields:
Notes:
1) Obviously, this takes a lot of download time -- you better have ethernet or
FIOS.  It might be more straightforward to use the advanced stock screener on
Yahoo's website, or a similar one.
2) Sorts table of forward dividend yields, then gives other dividend and earnings
related fundamentals in another window pane when one of the tickers is clicked.
3) Has a chart tab with 1d, 5d, 3m, 6m, 1y, 2y, 5y selections that just downloads
a "Basic Charts" picture from Yahoo Finance.
4) Gotta love the name.
 

ALERTS

Piggy Market Squeak
A stock alert freeware that reads EoD data:
Notes:
1) Operates by downloading historical data for an entire market (6 to 20Gb) to
hard drive.  Initial download may consume several hours; updates will take up to
15min.
2) Almost no help or explanatory files.
3) Operates on data from only "one market" at a time.  For Americans, this means
you have to choose between storing data for NASDAQ or NYSE or AMEX.
4) Gives alarms based on price levels and indicator levels.
5) Sends cute messages you you through MS Outlook when you close the program.
 

OPTIONS

Options Oracle

Options analysis software
http://www.samoasky.com/download.html
Gets free data from CBOE, PHLX and some foreign exchanges, and data from some brokers' feeds.
This program requires Microsoft .NET Framework 2.0 installed on Windows.

Snowgold Option Calculator
An elaborate options price and parameter calculator:
Uses three mathematical models, and is capable of generating and printing a report.

Options Pricing Calculator
Desktop calcultor that gives options price and greeks.  Go to this link and click "Widgets & Gadgets":
An options evaluation program given to Interactive Brokers' customers and
students of their training courses with no restrictions.
 
Free Options Calculator
Desktop calculator with options greeks and profit/loss graph.
http://trader-soft.com/download.html

Historical Volatility Calculator
An excel spreadsheet:
http://www.optiontradingtips.com/options101/volatility.html
Calculates the historical (realized) volatility in percent from historical data taken from Yahoo Finance.  You would need to input this historical volatility into the various options calculators in this list.


SMALL PROGRAMS

Auge
A portfolio program that looks up stock prices from Yahoo Finance and calculates profit and loss after you enter
your holdings:

Take Stock
A portfolio program:
http://www.ravib.com/takestock/
Keeps a portfolio of stocks, calculates profit/loss, displays Key Statistics from Yahoo Finance, fetches intraday and historical charts from BigCharts.com.
 
Netstock
Small program that gets prices from Yahoo or PC Quote and displays them in a
little table.
 
Quoteboard
Similar to Netstock, but gets data from OpenTick.
 
TickerTape
Small program to fool with that has no fees.
 
StockMonkey
Here is a calculator for single trade profit/loss minus commissions to put on your
desktop:
It's okay for some things, but don't expect greatness.
 
Capitalor Pivot Calculator
This is a pivot point calculator for your desktop.
Calulates Floor Pivots (P is based on Yesterday's Close) only.  The download from
CNET is still good; the company "Capitalor" website seems to be dead.
 
Pivot Point Calculation Software 101
Another desktop Pivot Point calculator.
This promotional item from a Forex company has various names, including "Crown &
Glory Calculator."  It does four varieties of Pivot Points: Floor Pivots, Woodie's
Pivots, Camarilla Equation levels (Holy Crap!), and Tom DeMark's Pivots (predicts
LoD and HoD based on Yesterday's HLC).
This program needs Microsoft .NET Framework 2.0 installed into Windows to run.
 
Forex Pivot Points
Another desktop pivot points calculator:
Calculates Floor Pivots only.
Needs Microsoft .NET Framework 2.0.

Fibonacci Calculator
Calculator for Fib levels for your desktop.  A link in the middle of this page
downloads the desktop calculator directly:
Calculates Fib Levels and Fib Periods from a High & Low price.
 
Forex Fibonacci Levels
Another Fibonacci levels calculator:
http://forexsb.com/freeware/forex_fibonacci_levels.html
Needs Microsoft .NET Framework 2.0 installed to run.

Fibonacci Retracement Calculator
This calculator only calculates three Fib levels, but the interface is funny:
http://www.freewarefiles.com/Fibonacci-Retracement-Calculator-V_program_8333.html

There's no Exit button in this program -- use Esc key instead.  


MICROSOFT EXCEL

QuoteCat
Program runs in system tray and fetches current quotes from Yahoo Finance to cells
in Excel spreadsheets for your calculations:
This is good, but it was meant to run on Windows 2000, and ran correctly on
Windows XP until about a year ago when a Windows Update changed something.
 
Excel 2003/2002 Add-in: MSN Money Stock Quotes
Inserts live quotes from MSN Money into MS Excel cells:
This is for writing Excel spreadsheets involving stock prices.This is for writing Excel spreadsheets involving stock prices.  It provides an Excel function of the form
MSNStockQuote(Symbol,Property,CountryCode)
that fetches stock quotes from MSN Money website, which are 15 min delayed.  The add-in installer downloadable from the url above is the version for Excel 2002 and 2003, which are the versions involved with Windows XP and Office XP.  There should be other versions downloadable from Microsoft downloads for Windows Vistas and Windows 7.
It seems that you need to be connected to internet while you run this installer.  If you are not, the installer will still run to install something, and you will see the MSNStockQuote function listed in Excel, but it will fail to fetch quotes and say #VALUE in your spreadsheet cells.  You must have the MSNStockQuotes.Functions box in Tools;Add-Ins checked for the function to operate and fetch quotes.
No Help is installed into Excel to explain the the arguments to the function.  Lists of these were posted at one time on Microsoft's web pages, but is rather hard to find now.  Below is somebody else's explanation I found on Google:

If you select the Insert Stock Quotes button, that should bring up a dialog box
in which you enter those parameters.  The dialog box will enter a properly
formatted function in the target cell, and this should give you the info you
require.
For example, for the UK, the symbol is "GB".  For Canada, "CA"
So valid formulas might be:
=MSNStockQuote(609140,"Last Price","GB") --> 388.50
=MSNStockQuote(609140,"Company Name","GB") --> A & J Mucklow Group plc
The Property codes are listed in the above mentioned dialog box (they are
actually spelled out like "Last Price" or "52 Week High".
You should be able to access HELP for this from the Data/Stock Quotes from MSN
Money/MSN Money Stock Quotes HELP.
Syntax:
MSNStockQuote(Symbol,Property,CountryCode)
Symbol   is a stock symbol (for example: "MSFT", "AOL", "IBM", "AAPL").
Property   is a piece of information regarding the stock, such as Ask Price or
Close Price. This is an optional parameter. If omitted, the default is Last
Price. You can either type the indicated property as text, or use a value from
1 to 25 to represent the property you want to return.
Property argument Value returned:
1 or "Last" or "Last Price" or "Last Sale" Price of the last trade
2 or "Time" or "Time of Last Sale" or "Last Sale Time" or "Last Time" or "Date"
or "Date of Last Sale" or "Last Sale Date" Date/time of the last trade,
returned as a serial number, in local time for the New York Stock Exchange
3 or "Size" or "Size Of Last Sale" or "Last Sale Size" or "Last Size" Size of
the last trade
4 or "Ask" or "Asking Price" or "Ask Price" Last asking price
5 or "Ask Size" or "Asking Size" Last asking size
6 or "Bid" or "Bidding Price" or "Bid Price" Last bid price
7 or "Bid Size" or "Bidding Size" Last bid size
8 or "Open" or "Opening Price" or "Open Price" Opening price
9 or "Close" or "Closing Price" or "Previous Close" or "Close Price" Last
closing price
10 or "High" or "High Price" or "Day High" or "Day's High" High price for the
day
11 or "Low" or "Low Price" or "Day Low" or "Day's Low" Low price for the day
12 or "Volume" or "Vol" Volume traded for the day
13 or "Change" or "Chg" Change for the day
14 or "Percent Change" or "% Change" or "%Change" or "% Chg" or "%Chg" Percent
change for the day
15 or "Year High" or "52 Week High" or "52 Wk High" 52 week high
16 or "Year Low" or "52 Week Low" or "52 Wk Low" 52 week low
17 or "Market Cap" or "Market Capital" or "Market Cap." Market capital
18 or "Earnings Per Share" or "EPS" Earnings per share
19 or "PE" or "P/E Ratio" or "PE Ratio" PE ratio
20 or "Shares Outstanding" or "Shares Out" or "Shares Out." or "# Shares Out"
or "# Shares Out" Number of shares outstanding
21 or "Currency" Currency in which the stock is traded
22 or "Exchange" Exchange on which the stock is traded
23 or "Country" Country in which the stock is traded
24 or "Type" Type of stock traded
25 or "Company Name" Company's name
CountryCode is the two-letter code that represents the country in which the
stock is traded (for example: "CA", "GB", "US"). This is an optional parameter.
If omitted, the default value is "US". Alternatively, you can enter the country
code when you specify the stock symbol (such as, US:MSFT), in which case the
CountryCode property is ignored.
Country Code
Australia AU
Canada CA
Germany DE
France FR
Great Britain GB
Italy IT
United States US
Note  For quotes from Great Britain, Last Price, Ask Price, Bid Price, and
Previous Close are returned in British pence, while Currency, Earnings Per
Share, and Market Capital are returned in British pounds.
Examples
Formula Description (Result)
=MSNStockQuote("MSFT") Last price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT","Open") Opening price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT",9) Close price for U.S. symbol "MSFT"

Office 2003 Add-in: Stock Actions for the Research Task Pane
This add-in is similar to the above, except that it installs and works only with MS Word 2003 and MS Excel 2003, which are components of MS Office 2003, running under MS Windows XP SP3 and earlier.
http://www.microsoft.com/downloads/details.aspx?FamilyID=D20E2CA8-9F26-4EF6-8F07-F0EF37D3D35B&displaylang=en&displaylang=en
 
EXCEL Stock Market Functions Add-in
An MS Excel add-in that provides functions to read delayed stock quotes and also historical
price data for specific dates into cells, as well as most other stock info in the various
quotes pages of Yahoo Finance (including Key Statistics), into MS Excel files:
http://finance.groups.yahoo.com/group/smf_addin/files/Add-In%20Files/
This zip file for download is buried in Yahoo Groups, inside the uploaded files section of a
newsgroup dedicated to this piece of software.  The documentation is in a separate group
directory up one level from this location.  Other directories contain numerous excel templates
and examples.
Note that:
1) If you install this add-in, you will not need to download csv historical data files, then
import them into Excel, or paste individual figures of fundamentals data from Key Statistics
into Excel; the information will be fetched automatically into your spreadsheets. 
2) There is no interface or toolbar to select the functions and insert them into cells, you
need to type the individual functions into the command line.
3) By selecting a 10 rows by 7 columns box, typing =RCHGetYahooQuotes("IBM") into the command
line, and Cntrl + Shift + Return, I will fill the the box with a one line header of
Date,Open,High,Low,Close,Volume,AdjClose, with the last 9 days of EoD stock data in the rows
beneath.  The box can be as many rows as you like.
Following comes from the documentation and will give you the idea:
There are four primary user-defined functions that the SMF add-in provides:
1) =RCHGetElementNumber() is a UDF that returns a specific data element from a specified data
source (i.e. web page). For example, this formula would return the Market Capitalization
amount from Yahoo's Key Statistics page for ticker "IBM":
    =RCHGetElementNumber("IBM", 941)
2) =RCHGetYahooQuotes() is a UDF that returns delayed stock quotes and other data from the
Yahoo quotes interface. For example, this formula would return a range of data showing the
last trading price, the price/sales ratio, and the price/book ratio for "IBM" and "MMM":
    =RCHGetYahooQuotes("IBM,MMM", "l1p5p6")
3) =RCHGetYahooHistory() is a UDF that returns historical stock quotes from the Yahoo
historical quotes interface. For example, this formula would return a range of data containing
historical quotes data from 6/1/2006 thru 6/16/2006 for "IBM":
    =RCHGetYahooHistory("IBM", 2006, 6, 1, 2006, 6, 16)
4) =RCHGetHTMLTable() is a UDF that is used to extract an HTML table from a web page. For
example, this formula would return a range of data containing a table from Yahoo's Key
Statistics page:
    =RCHGetHTMLTable("http://finance.yahoo.com/q/ks?s=MMM","Market Cap (intraday)",-1,"",1)


HISTORICAL QUOTE DOWNLOADERS

Yahoo & Google Historical Quotes Downloader
This downloader will get EoD quotes from Yahoo Finance, Google Finance, MSN Money, and QuoteMedia.
This downloader can be set to process the downloaded files before they are saved by various means: 1) append letters to the saved filenames, 2) specify a different extension for the saved filenames, 2) dividend & split adjust prices, 3) replace characters in the downloaded files with a different character, e.g., change all the commas in csv files to spaces, 4) change the date format inside the saved files, 5) multiply the volume by a constant factor, 6) sort the data in the files by date, 7) put a header into the saved files, and 8) period can be set to daily, weekly, monthly, quarterly or yearly.

GimmeFreeData
A utility that bulk downloads historical data from Yahoo Finance or MSN websites
as csv files:
This is a separate support utility to a charting program called the Grafster.
GimmeFreeData is a free program given away to promote Grafster, which is not free.
 
downloader.exe
A similar download utility that gets historical data from Yahoo Finance as csv
files:
This Australian newsgroup now requires a password from the program's author.  If
you want downloader.exe, send me a personal e-mail, and I will send it to you.
This is a module that is part of FreeCharts.  It is a small program that you can
put on a datastick, carry to some computer, and download the files into a folder
on the datastick.  If connected to an ethernet line, it can download all price
data from Yahoo's archive in several hours.  This is actually faster with a
standalone utility, than with the backfiller that is incorporated into FCharts,
because it will not interrupt downloading to process the data.  A file
"Tickers.csv" containing a list of the ticker symbols for all stocks to be
downloaded must be prepared. This download is buried deep in among Simon Haynes'
webpages and you'll never find it without the above url.
 
Historical CSV
Download utility that gets historical data from OpenTick as csv files:
 
AI Quant ToyDownloader
Some kind of downloader you can fool with.  It has quotes organized into sectors,
which might be somewhat interesting.

 
Posted by WmVetter on May 9, 2010 5:00 PM CDT

Most Recent Comments

WmV, I saw you mentioned that you are using dial up. Can that be so? How in the world did you download all theses with di...
Thanks for the info... I am ashamed to say I graduated in 1984 with an Economics major and never bothered to play with w...
Don't forget www.FreeStockCharts.com A great web based charting program with lots of indicators. Tons of tools.I...
This is updated version, some new items, some changes from freeware to semifreeware...I'd have liked to replace th...
Thanks for all the work and information. This just shows how willing you are to contribute and is great information a...