|
|
|
Special
Offer |
|
xlqPlus = $129.00
xlqLite = $79.00
1 year of free upgrades included |
|
XLQ Users Forum

Click to join xlqusers
|
|
|
|
|
|
Users Comments
(Click to See More)
|
|
It is a
pleasure doing business with such a responsive person who
obviously understands the value of good customer service. I have
just registered and intend to make good use of this program. - E.D. |
Your
fast and thorough answer is more than what I expected. Your service
is awesome and your product is very stable.
Keep up with your good work.
Sincerely appreciated :) - V.P. |
|
Very
much enjoying the package so far. - P.C |
|
Just a
note to let you know that I really like you software. It's a
wonderful interface that has been of great utility to me. - J.B. |
|
Your
software is just what I have needed. It provides me with the capability to customize data and construct
charts which give me the views I like -
not just what someone thinks I would like. - D.E. |
|
Firstly, let me say that
the philosophy and idea behind XLQ is exactly what I am
looking for. - S.P. |
|
The more I use XLQ the more I appreciate what can
be done with it. - S.M. |
|
Just like
to say, excellent work. A potentially good bit of
software for me. - M.C. |
|
I love
your product so far. ... Thank you for making such product
available. - A.T. |
|
Thanks
for the Tip. You know, your program is really super.
- P.B. |
|
Regarding
to XLQ, which I think is truly fantastic!!, I have the
following ideas / suggestions / wishes ... - L.B. |
|
Your product is
wonderful! Keep up the good work . - N.F. |
|
Great software!
Simple, elegant, well-thought-out and fast. - R.M. |
|
I am always finding new
ways to use your program in my investment / speculative Market
endeavors. - S.S
|
|
Thanks for such a
wonderful product. It certainly does handle my most precious
need which is to monitor the market realtime.. - W.B
|
|
|
|
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
Key Features include:
- Over 300 different formulae.
- Work with multiple data sources
simultaneously (free and subscription).
- Historic, Streaming, Realtime,
Delayed
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.
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/2007")
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
Interactive Brokers, and around 60 additional day
formulae and
numerous additional historic formulae (including for ranges).

XLQ is a 32bit multithreaded C++ application which functions independent
of Microsoft Excel but integrates with Excel via COM (and
other) technology, allowing the fastest possible processing
speeds while not interfering with the Excel users work
experience. XLQ does not use DDE technology, nor is it a
VBA-Add-in and contains no Visual Basic, VBA code or OCX's.
|
|
|
| |
|
Streaming Real-time Data from
Interactive Brokers |

xlqPlus supports streaming real-time data as well as
intraday backfill and historic data from Interactive
Brokers
-
Interactive Brokers
provides direct access trade execution and
clearing services to individuals, advisors,
institutions, and brokers at deep discount
commissions.
-
Interactive Brokers premier
technology allows customers to trade stocks,
options, futures, forex, and bonds on over 50
markets worldwide from a single IB Universal
account at best execution prices.
-
Interactive Brokers and its
affiliates execute over 20% of US options
trades, and IB Group was ranked by Institutional
Investor as the 16th largest US securities firm
with $2.1 billion in capital.
To
find out more about their services, click here |
|
|
| |
|
|
| |
|
Streaming Real-time Data from
IQFeed |
xlqPlus supports streaming
real-time data from IQFeed.net
- Streaming real-time data for US and Canadian
Equities.
- Real-time or Delayed Options and
International Futures data.
- Intraday backfill
- Historic Day / Week and Month Data.
- xlqPlus includes almost 50 additional
formulae covering their detailed quote data.
To find out
more about their services, click here (Their $50
startup fee is waived for xlq users)
You will also need to download their client
software (version 4.3.0.3), which you can do from
here |
|
|
|
|
|
|
|
Supports
Windows Vista
and Excel 2007 |

| Support for AAII's Stock
Investor Pro |
 xlqPlus provides formulae allowing you to use all of AAII's Stock Investor pro data in excel and through xlq's
COM interface, allowing for new levels of custom analysis.
Over 2800 data points for around 8000 companies covering
quarterly and yearly historic P&L, balance sheet, and cash
flow.
As well as valuations, estimates, growth, multiples
and ratios of all sorts. (including for sector and
industry.)
- Create spreadsheets analyzing detailed financial
data (sample aaiiDemo.xls provided)
- Work with the data without knowing the symbol to
find the investment that matches your requirements
(sample aaiiMacro.xls provided)
- Can work with up to 5 different databases
simultaneously, allowing for numerous back testing
possibilities.
Click here to find out more about Stock
Investor Pro |
|
|
|
|
|
XLQlite
Features |
-
Numerous Excel formulae (see below for full list).
-
XLQ Data engine, including the stock manager and data views
available by right clicking the Q in the task bar.
-
All XLQ formulae may also be used via a COM interface from any
program or programming language supporting COM. Examples are
provided for C++, C#, Visual Basic and Word.
-
XLQ offers various configuration options including update times
and frequency, production of .csv files, proxy support and
status views.
-
Supports free data sources covering US market data as well as UK, European, and most
international exchanges. Multiple data sources may be used
simultaneously. (Also supports Yahoo's real-time subscription
data).
-
A
Sample spreadsheet and help file is provided showing
functionality and usage examples.
|
| Additional
XLQplus Features |
-
xlqCompanion,
an additional program allowing you to display data via multiple tabs,
each with a custom configuration of column settings. Covering
Market, fundamental and transaction data, xlqCompanion can be a portfolio
manager, a stock alert system (including for trailing stops and
highs and lows), a "what-if' analyzer, market classifying
system, or all at the same time
-
Support for
AAII's Stock Investor Pro database, providing
formulae for heaps of financial and fundamental data.
-
Support for IQFeed's
streaming realtime, intraday backfill and historic equity,
options and futures quotes.
-
Support for
Interactive Brokers streaming real-time data (and intraday
backfill), as well as daily and weekly historic data (including
for options).
-
Well over 100
Additional formulae providing detailed quote information as well
as the historical range data,
allowing you to find the highest close within a period range
etc.
|
|
| |
Excel Formulae (all
historic formulae have Weekly and Monthly
Equivalents)
Additional formulae available
with xlqPlus shown in blue (certain formulae are
only available from specific data sources) |
|
"Day" Formulae |
| Name |
Exchange |
Open |
Previous
Close |
Change |
| Price |
Bid |
Ask |
High |
Change
Percent |
| Last
Size |
Bid Size |
Ask Size |
Low |
Trade
Time |
| Volume |
Average
Volume |
52 Week
Low |
52 Week
High |
Shares
Outstanding |
| Price /
Earnings |
P / E (Mkt) |
Market
Cap |
Market
Cap (Mkt) |
Yield |
| Earnings
per Share |
EPS est.
Current Year |
EPS est.
Next Year |
EPS est.
Next Qtr. |
Short
Ratio |
| Dividend
per Share |
Price
per Sales |
Price
per Book |
Price
per Earnings Growth |
EBITDA |
|
Exchange of last trade |
Ext. Trading Change |
Ext. Trading Difference |
Ext. Trading Last |
Volatility |
|
No. of Trades today |
Previous Days Volume |
% off Ave. Volume |
Change From Open |
Range |
|
Spread |
Bid Change |
Ask Change |
52 week High Date |
52 week Low Date |
|
Calendar
Year High |
Calendar
Year Low |
Calendar
Year High Date |
Calendar
Year Low Date |
Security
Type |
|
Dividend
Amount |
Dividend
Rate |
Dividend
Pay Date |
Ex.
Dividend Date |
5 year
Growth % |
|
Beta |
Institutional % |
Current
Assets |
Current
Liabilities |
Balance
Sheet Date |
|
Fiscal
Year End |
Long
Term Debt |
Historic
Volatility |
SIC |
Root
Option Symbols |
|
Split
Ratio 1 |
Split
Ratio 1 Date |
Split
Ratio 2 |
Split
Ratio 2 Date |
Leap
Symbols |
|
Net
Asset Value |
Open
Interest |
Strike |
Settle |
Delay |
|
Average
Maturity |
7 Day
Yield |
Expiration Date |
Days to
Expiration |
VWAP |
|
13 Week
Low |
13 Week
High |
26 Week
Low |
26 Week
High |
Implied
Volatility |
|
Option
Call Open Interest |
Option
Put Open Interest |
Option
Call Volume |
Option
Put Volume |
|
|
"IntraDay" Formulae |
| Price |
Bid |
Ask |
Time |
Change |
| Size |
Bid Size |
Ask Size |
Volume |
Total
Volume |
| Period
Open |
Period
Close |
Period
High |
Period
Low |
|
Commodity Channel Index |
SMA
of Typical Price (SMATP) |
Mean
Deviation of SMATP |
|
|
"Historic" Formulae |
| Open |
Close |
High |
Low |
Volume |
| Change |
Change
Percent |
Range |
Average
Range |
True
Range |
| Custom
EMA 1 |
Custom
EMA 2 |
Custom
SMA 1 |
Custom
SMA 2 |
Average
True Range |
| 12 Day
EMA |
26 Day
EMA |
MACD |
MACD
Trigger |
MACD
Histogram |
|
Directional Movement + |
Directional Movement - |
Directional Indicator + |
Directional Indicator - |
Directional Index |
| Relative
Date Index |
Earliest
Date |
No of
Periods |
Time of Last Update |
Date |
| DMI+ |
DMI- |
Average
DX |
Average
Gain |
Average
Loss |
|
Relative
Strength |
RSI |
Typical
Price |
SMA
of Typical Price (SMATP) |
Mean
Deviation of SMATP |
|
Commodity Channel Index |
Least
Square Moving Average. (LSMA) also known as linear
regression value, moving linear regression and
regression oscillator |
|
Williams
%R |
Stochastics %k and %d fast, slow and full |
|
xlqxh "Historic"
Formulae - calculated on the fly for the period
range specified in the formula |
|
EMA |
SMA |
Average
Range (SMA) |
Average
Range (EMA) |
Ave.
True Range (SMA) |
|
Ave.
True Range (EMA) |
Average
Volume (SMA) |
Average
Volume (EMA) |
Average
Gain |
Average
Loss |
|
Relative
Strength |
RSI |
MACD |
MACD
Trigger |
MACD
Histogram |
|
SMA of
Typical Price (SMATP) |
Mean
Deviation of SMATP |
Commodity Channel Index |
Directional Movement Indicator + and - |
Directional Index |
|
Average
Directional Index (ADX) |
Least
Square Moving Average. |
Slope of
LSMA |
Max LSMA
(Least
Square Moving Average. ) |
|
Williams
%R |
Stochastics %k and %d fast, slow and full
|
|
"Historic Range"
Formulae (xlqPlus Only) |
|
Highest Close |
Lowest Close |
Highest High |
Lowest
Low |
|
Highest Close Date |
Lowest Close Date |
Highest High Date |
Lowest
Low Date |
|
Highest Volume |
Lowest Volume |
Highest Volume Date |
Lowest
Volume Date |
|
%
Drawdown from Highest |
Max
Drawdown from Highest |
% Drawup
from Lowset |
Max
Drawup from Lowest |
|
Other Formula (xlqPlus
Only) |
|
=xlqAAII / xlqAAIIDescrip |
retrieves over 2800 data points from AAII Stock
Investor Pro
e.g. =xlqAAII("msft", "GrossIncomeQ_X",1) will
display the quarterly gross income for the latest
available quarter. |
|
|
|