I have a free open-source EXCEL add-in that has a number of functions to retrieve data from the Internet, including historical quotes from Yahoo. The add-in, documentation on its functions, and examples can be found in the files area of:

http://finance.groups.yahoo.com/group/smf_addin/
For example, if I array-enter the following formula over 7 columns and 20 rows:

=RCHGetYahooHistory("IBM")

...it would return 19 days (plus a header row) of EOD quotes for IBM. The seven columns would contain date, open, high, low, close, volume, and adjusted close.

The next release will have a few technical indicators that could use the first 6 columns of the Yahoo historical quotes as input. For example, in my testing workbook, I use the following array-entered formula to download my historical quotes:

=RCHGetYahooHistory(B4,,,,,,,,,,1,1)

Cell B4 contains the ticker symbol. The two later parameters of 1 are telling the function to return the data adjusted for splits and dividends and to sort the data in ascending date sequence (Yahoo's default is descending date sequence). Then, I use the following array-entered function to compute an exponential moving average:

=SMFTech($B$6:$G$65,"EMA",L3)

...where the $B$6:$G$65 range points to the D/O/H/L/C/V history retrieved above and cell L3 contains the period to compute the exponential moving average over.

I've been using the StockCharts education area to help develop the tech indicators. In a few cases, they have sample workbooks that can be downloaded to actually see how the indicators are being calculated:

http://stockcharts.com/education/Ind...sis/index.html