CI Market Dashboard

We have put together a collection of market indicators and track them to help you gauge the direction of the market.


CI Analysis Worksheets

Interactive analysis templates covering DuPont analysis (return on equity), valuing stocks the Warren Buffett way, and more to come.


CI Blog Feed

TipRanks Launches Website
posted 3 days ago by Jaclyn McClellan

CI Editor Speaking on East Coast
posted 8 days ago by Wayne Thorp

Market Dashboard: One New Neutral, Bearish Signal This Week
posted 8 days ago by Wayne Thorp

Bullish Sentiment Sees Biggest 2-Week Decline in Over a Year
posted 12 days ago by Wayne Thorp

Apple Unveils New Apple Watch and Two New iPhones
posted 14 days ago by Jaclyn McClellan



Computerized Investing > August 6, 2011

DownloaderXL and Analyzer XL

PRINT | | | | COMMENTS (2) | A A   Reset

by CI Staff

Recently, we have heard from several members who mentioned a need for historical stock quotes. Although quotes can be obtained on Yahoo! Finance, the website does not provide an easy way to sort the quotes if you were looking for, as an example, yearly highs and lows. DownloaderXL solves this problem by allowing users to download historical quotes directly into Microsoft Excel. To take it one step further, AnalyzerXL allows users to perform technical analysis on the figures, as well.

DownloaderXL and AnalyzerXL are installed using two separate downloads, both of which are available in AAII's Download Library. After installing the product, the additional functions will automatically appear in the “Add-Ins” section of Microsoft Excel. To use the data download feature, simply select DownloaderXL, and a separate window will pop up. Input your start and end dates, ticker, fields (date, open, high, low, close, volume, and adjusted closed), and beginning cell. If you would like the data to be plotted, there is a box you can check. DownloaderXL will download the historical quotes from Yahoo! Finance and populate Excel with the data.

After the cells are populated, you may manipulate the data in any way you want. This provides the ability to sort the data cells and write Excel formulas.

AnalyzerXL adds another dimension to the program’s abilities. This add-in is designed to offer technical analysis capabilities to Microsoft Excel. To use the function, click on AnalyzerXL, and a separate window will pop up, much like with DownloaderXL. In the pop-up window, choose the indicator to be run and hit “Next.” The next screen is where the input and output range are selected. If you would like a chart to be created, there is a box you can check.

A very useful area of the program is the demos that are linked in the AnalyzerXL pull-down tab. The links provide video tutorials highlighting technical indicators, including Bollinger Bands, commodity channel index, Fibonacci indicators, moving average, pivot points, and support and resistance lines. These tutorials will help you create and understand the indicators. Furthermore, these features are all added functions for Excel, so there is no need to learn a completely new program.

DownloaderXL and AnalyzerXL

Click here for DownloaderXL.

Click here for AnalyzerXL

System Requirements: Windows 98 or newer, Microsoft Excel 97 or newer (32-bit)

Price: 10-day free trial; $49.95 for DownloaderXL Package; $99.95 for AnalyzerXL Package; 30-day money-back guarantee


Discussion

Paul from NJ posted over 3 years ago:

Any time I try to download either the Downloader or Analyzer I get a different file size and an error message when trying to run that the setup files are corrupt. I must have tried 20 times on different PCs and on different days. I don't know of any other way to let you know of the issue. I made great use of the old Dow Jones Market Analyzer to update daily prices on my spreadsheets and to do basic technical analysis. I really missed it and these spreadsheets look like they would plug the gap (if I could get them and if they work!). HELP!


Joe from IL posted over 3 years ago:

Hi Paul,

I'm not sure what could be giving you the error. I uninstalled my DownloaderXL and reinstalled it using the link provided and it works fine for me again. I am using Windows 7 Ultimate with Excel 2007. What versions are you using?


You need to log in as a registered AAII user before commenting.
Create an account

Log In