View Image

XLQ is a smart way to work with all kinds of stock data in excel, an easy way to manage your portfolio and track trailing stops, gains etc. XLQ is a way to perform custom in-depth market analysis without being limited by the design of a program's interface, a way to work with stock data in your own program through a COM interface.

XLQ (XLQlite/ XLQplus) offers an all-in-one solution providing market data simultaneously to:
? Microsoft Excel
? xlqCompanion (xlqPlus)
? All programming languages (supporting COM)
? Any program with a COM interface
? Directly in the window's task bar

XLQ connects automatically to excel allowing you to work with data in a layout and format that you want, allowing for complex in-depth analysis to simple portfolio management. If you know how to use excel, you already know how to use xlq. (an example xlqDemo.xls is provided with the install)
Simply enter =xlqPrice("YHOO") into an Excel cell and you will begin receiving up to date data for Yahoo! automatically.

Enter =xlqhVolume("msft",-1) will automatically display yesterdays volume for Microsoft.
Enter =xlqhHighestHigh("IBM","1/1/2005") and xlq will return the highest price for IBM since the beginning of the year.

XLQ is offered in 2 licenses (1 download), allowing you to choose the functionality you need. XLQplus includes xlqCompanion, support for AAII's Stock Investor Pro, Streaming and historic equity, options and futures data from IQFeed, streaming data from InteractiveBrokers, 50 additional day formulae and 24 additional historic range formulae.

FEATURES:

· Over 250 different formulae.
· Work with multiple data sources simultaneously (free and subscription).
· Historic, Streaming, Realtime, Delayed, ECN and intraday quotes.
· Detailed fundamental data (xlq provides an excel and com interface to AAII's renowned Stock Investor Pro Database).
· Covers worldwide stock, index, fund, options, futures and currency data.
· Built in Trailing stop calculations and alerts via xlqCompanion.
· May be used through VBA to create custom formulae and analysis routines as well as via excel charts.
· XLQ is digitally signed allowing it to work on computers with tightened security.