XLQ 4.1

XLQ 4.1 offers you a powerful application which can help you to deliver live, intraday and historic worldwide stock market data for use in xlq, xlqCompanion, MS Excel or via other programs or programming languages through a COM interface.

XLQ allows you to maintain a portfolio or perform personalized in-depth stock analysis the way you want, in the format you want and with the tools you want.

XLQ manages all data retrieval, with no need to "cut and paste" or manually download data from the web, and the data remains available when offline.

A task bar indicator shows the status of the program and offers various viewing and configuration options.

xlq is available via 2 licenses with xlqPlus including xlqCompanion and additional formulae (including automatic trailing stop calculations and support for AAIIs Stock Investor Pro database.)

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

Major Features:

1. Has over 90 formulate for the latest trade and intraday data including all price details, name, exchange, average volume, 52 week high/low, trade time, P/E, Earnings per share, Yield, Market Cap, Shares Outstanding, Short Ratio, PEG Ratio, EBITDA, Earnings Estimates, Price / Sales and Price / Book.
2. Has around 200 formulae covering daily, weekly and monthly historical stock data including opening price, closing price, high, low, volume, change (and %), true range, SMAs, EMAs, MACD, DMI+/and ADX, RSI. All may be either retrieved for a specific date or -x days/weeks/months from today and may be calculated for multiple period ranges.
3. Multiple data sources may be selected simultaneously, covering US market data, as well as UK, European, and most international exchanges.
4. A task bar indicator shows program / data retrieval status and whether historical data is up to date, with the possibility to pause and resume.
5. A sample spreadsheet showing usage examples is provided, along with a help file and samples on how to use the COM interface from Visual Basic, C++ and C#.
6. May be used through VBA to create custom formulae and analysis routines as well as via excel charts.
7. LQ is digitally signed allowing it to work on computers with tightened security.
8. Detailed  fundamental data (xlq provides an excel and com interface to AAII's renowned Stock Investor Pro Database). 

Enhancements:

• Numerous changes and optimizations applied to historic data processing and handling.
• Support for 22 new fields in AAII Stock Investor Pro (update aaiiDemo, new fields are listed at end of Summary page).
• New historic formula xlqxhAveTrueRange2 (+w+m) return a weighted ATR (as per Wilder), xlqxhAveTrueRange is a SMA.
• New intraday formula xlqxiSMA, xlqxiEMA, xlqxiAveVolume, xlqxiAveVolumeEMA, xlqxiAveRange, xlqxiAveRangeEma, xlqxiAveTrueRange, xlqxiAveTrueRange2, xlqxiAveTrueRangeEMA, (also xlqxiSMATP, xlqxiSMATPMD, added before but was undocumented, i.e. simple moving average of typical price and Mean deviation of the smatp). 
• Xlq preferences completely revised, now property sheet based, includes descriptions when choice is selected. Simplified update settings and categorized by data source.
• Fix problem in xlqCompanion where historic source preference not always used.
• Supports IQFeed client 4.5.0.3
• Documentation and xlqDemo have been updated.

 WareSeeker Editor