• Basic Membership Access to Journal, Shadow Stock portfolio & monthly updates for stock screens
  • A+ Investor Full access to AAII.com, Journal, and a power data suite for investment ideas
  • AAII Platinum Full access to all of AAII's model portfolios and premium services at a significant discount
  • Dividend Investing Newsletter and model portfolio that focuses on dividend growth
  • AAII Growth Investing Find secular growth stocks poised for outperformance regardless of macroeconomic conditions.
  • Retirement Investing Discover trusted strategies for every stage of retirement. Get actionable insights and resources for smart retirement planning.
  • Sentiment Investing A research-driven newsletter with 10+ signals decoding sentiment across retail and institutional behavior.
  • Stock Superstars Report Get stock ideas inspired by the market's leading professionals
  • VMQ Stocks For the value investor looking to harness academic research in an actively managed portfolio
  • Bits and Bips Newsletter delivering insights on linking traditional finance, macro trends and cryptocurrency opportunities to help investors build stronger, more diversified portfolios.
All premium products come with free basic membership.
Explore All Membership Options
Join Now
Computerized Investing

XLQ

XLQ delivers free live, intraday and historical worldwide stock market data. Data can be used in XLQ, xlqCompanion, MS Excel and other programs, or with programming languages through a COM interface from Yahoo! and MSN.

by CI Staff | December 2011

XLQ delivers free live, intraday and historical worldwide stock market data. Data can be used in XLQ, xlqCompanion, MS Excel and other programs, or with programming languages through a COM interface from Yahoo! and MSN. With more than 300 formulas available, XLQ can maintain a portfolio or perform personalized in-depth stock analysis. In addition to real-time market data updated from the Internet, XLQ also provides an Excel interface for all data from AAII’s Stock Investor Pro.

Computerized Investing Editor Wayne A. Thorp, CFA, wrote an in-depth article on XLQ and its many features that can be found here: https://www.aaii.com/journal/article/xlq-excel-spreadsheet-add-in.

For more information, you can visit the QMatix website: https://www.qmatix.com. You can get $25 off when purchasing XLQ through the QMatix website by entering the discount code “AAII-SIP” when checking out.

XLQ 4.51

https://www.aaii.com/download-library/download?DL_ID=676

System Requirements: Windows 95 or newer; Excel 97 or newer

Price: $84 initial fee, $31/year for XLQlite; $139 initial fee, $54/year for XLQplus; free 45-day trial

{{"object":1850,"classes":"object-type icon-img left"}}

 

Discussion

Bill Roberts from CA posted over 14 years ago:

I need a database that I can use to populate a spreadsheet using Visual Basic Macros. I can do this now using QuotesPlus database, but it very inacurate and probably going out of business. For example: For days = -maxdays To 0 Step 1 Rowno = Rowno + 1 If QP_Date(days, Symbol) = "N/A" Then Exit For Cells(Rowno, "A") = days Cells(Rowno, "B") = QP_Date(days, Symbol) Cells(Rowno, "C") = QP_Open(days, Symbol) Cells(Rowno, "D") = QP_High(days, Symbol) Cells(Rowno, "E") = QP_Low(days, Symbol) Cells(Rowno, "F") = QP_Close(days, Symbol) Next Can I do this with any version of XLQ (end of day data only)? TIA Bill Roberts


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

Log In

Get your free copy of our special report analyzing the tech stocks most likely to outperform the market.
Download the FREE Report Here: