XLQ allows you to work with market data in the way you want. No interface or program design restrictions. Create your own layout or easily modify any existing spreadsheets to have them always updated and up to date, even in real-time.
XLQ is used by the individual investor for basic portfolio management or following of trailing stops. By financial advisors, journalists, newsletter editors, financial institutions and professional traders in many different markets around the world. It is used for investment tracking, financial analysis, decision making, risk assessment, back-testing, and as the core of trading systems.
v5.0 [Mar 19, 2014]
- reverse calculation formulae xlqxhReverseRSI and xlqxhReverseConnorsRSI returning the price needed to obtain the specified RSI/CRSI target (as well as xlqxi intraday versions).
- formula supporting Connors RSI, i.e. xlqhConnorsRSI, xlqxhConnorsRSI weekly, monthly and intraday versions.
- formula for Streak, i.e. returning the number of consecutive up or down periods, i.e. xlqhStreak, xlqxhStreak weekly, monthly and intraday versions.
- formula for PercentRank, i.e. returning the percentile rank for the period over the number of periods specified i.e. xlqhPercentRank, xlqxhPercentRank weekly, monthly and intraday versions.
- formula for Historic Volatility, i.e. xlqhHistoricVolatility, xlqxhHistoricVolatility weekly, monthly and intraday versions. May specify the number of periods (default 30, and the scale factor (default annual / 252 days).
- formula for Fractal Dimension Index, i.e. xlqhFractalDimension, xlqxhFractalDimension weekly, monthly and intraday versions.
- Now possible to set gridline intensity for xlq and xlqCompanion grids – choose xlq preferences / general settings / general / set grid line intensity. (for xlqCompanion choose view / preferences).
- Numerous internal design changes, and re-dimensioning of internal structures. As a result the historic databases will be deleted on first run. The new data files are not compatible with older versions.
- fixed crash in excel 2013 when closing an xlq workbook and having another non xlq workbook open.
- fixes a problem with storing of some xlqCompanion preference settings.
- Fixed a problem with re-retrieval of Yahoo data after a dividend adjustment has been detected.
- fixed a problem with generating csv files (if option enabled).
- Support IQFeed 5105.
- Change IB handling when tws is started after xlq.
- Can now request more (earlier dates) historic data from google.
- YAHOO-RT as a source has been removed. Yahoo have already stopped providing real-time downloads for their subscription service, making YAHOO-RT as a source obsolete. Any reference in xlqCompanion will revert to YAHOO, and any request via excel or COM will be processed as yahoo to maintain compatibility. This change does not affect Yahoo or Yahoo-Int.
- Various other changes, including updated libraries for windows 8.1.
- xlqDemo.xls and help have been updated.
