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

Mac OS X 10.10 Yosemite Available Today
posted 6 days ago by Wayne Thorp

Apple’s Third Quarter Tops Estimates
posted 6 days ago by Wayne Thorp

Nokia Hurts Microsoft’s Earnings
posted 6 days ago by Wayne Thorp

WSJ: Ukrainian Conflict Hurting Tech Sector
posted 7 days ago by Wayne Thorp

Report: Apple Readying Production of iPhone 6
posted 7 days ago by Wayne Thorp



Computerized Investing > Fourth Quarter 2009

XLQ: Excel Spreadsheet Add-In

PRINT | | | | COMMENTS (8) | A A   Reset

by Wayne A. Thorp, CFA

Without a doubt, the Internet has provided a tremendous boost to individual investors in terms of the amount of information we have at our disposal. Bring up almost any investment Web site and you have access to stock quotes, fundamental ratios and multiples, financial statement data, earnings estimates, and more.

For me, however, one of the biggest failures of the Internet has been the lack of this same data in a form where the end user can manipulate it in either a database or spreadsheet program for free. To be sure, many financial Web sites, such as Yahoo! Finance and MSN Money offer free historical price data going back many years. However, you are only able to pull up one ticker at a time and this lack of “batch processing” makes it time-prohibitive to rely on these sites for maintaining a database on many stocks.

...To continue reading this article you must be a Computerized Investing Subscriber.

Gain exclusive access to this article and all of the benefits and investment education a Computerized Investing subscription offers.

SUBSCRIBE TODAY for just $24.
Log in
Already a CI subscriber? Login to read the rest of this article.

Subscribe
A subscription to Computerized Investing includes a monthly email and access to the CI Website, all of which aim to benefit your investing skills with respect to computers and the Internet.

  


Discussion

Gary from TX posted over 3 years ago:

You might also want to look at "Stock Quotes for Excel" from Jabsoft (www.jabsoft.com) - have found it to be even better...


Randy from AZ posted over 3 years ago:

I have a free open-source add-in:

http://finance.groups.yahoo.com/group/smf_addin


William from AZ posted over 2 years ago:

I have been using msnsq from Microsoft for years with all editions of Excel. It is no longer available from Microsoft but you may be able to find it by doing a search on the internet or if you have a friend with the file. This was free and worked well. I do not know why MS no longer makes it available


Robert from CO posted over 2 years ago:

I would like to see Stock Investor Pro interoperate with Excel better, and/or a downloadable data base for Excel from AAII.


William from CA posted over 2 years ago:

Does XLQ allow me to download stock data and run Visual Basic programs? I get end of day data from HighGrowthStock.com. Then I convert it to metastock format automatically). Once I have it in metastock format, I use Metalib5.0 (from trading-tools.com) to run my VB programs. I have not found any program that does what I want, other than Metalib5.0


Patrick from PA posted over 2 years ago:

I have to agree with Randall from Arizona, why pay for a website when the links provided on free open-source add-in:
http://finance.groups.yahoo.com/group/smf_addin.
Once you sign up for free, this group is the home base for the Stock Market Functions add-in developed by Randy Harmelink. This add-in contains a number of user defined functions for EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges.
I have used many of the reports for over 2 years
, designed by users and myself which provide everything needed to make informed investment decisions. Wish Computerized Investing staff would look and comment.
Thanks
Pat McGinnis


Jake from CA posted about 1 year ago:

I definitely recommend trying Randy's add-in before you pay for anything. I bet they both use the same data sources and functionality if likely very similar.

http://finance.groups.yahoo.com/group/smf_addin


MarkP from CA posted 7 months ago:

I think the unique thing for XLQ is that it can interface to the AAII SIPro database. For me, that is a nice feature.


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

Log In