v5.3 [Nov 3, 2015]
Major update with completely re-written excel add-in:
- Optimized processing.
- New Ribbon interface (Excel 2010 and later).
- Expanded excel insert Function / Fx information with more details for formula / parameters, version, supported sources and includes link to help on web page.
- New =xlxFx as alternative wrapper for working with formulae.
- New =xlxFxStatic, an alternative formulae wrapper were cell contents will remain static, only updating when alt-ctrl-f9 is pressed (or via VBA calling Application.CalculateFull). This is now also the recommended method if using xlq formulae within VBA and examples in macros and help file have been updated.
New xlqBridge program:
Working with the new addin, the xlqBridge runs in the background, being started and closed by excel as needed. It allows for a 3-way communication between excel and the xlq data engine allowing for a better workload distribution and avoids potential bottlenecks. Apart from the overall improvements and workbook load time (the workbook would need to be save with this version) it also virtually eliminates potential “server busy” errors or many reasons for #xlq being shown.
New XLQ Engine Preference Settings
- There are new preference settings for each source (right click the Q and choose preferences, select data source specific and choose the source).
Previous versions of xlq would maintain all symbols for ‘day data’ until deleted in the stock manager.
You may now choose per source whether you would like the data kept or not. By default, the data is no longer kept. (These settings are for day data / real-time symbols only and not for historic data)
In xlq preferences under general settings there are 2 new options
- Delete all data on exit – once and delete all data on exit – always.
- Previously if there was a data corruption or for housekeeping purposes you needed to manually delete the data files. You may now choose the ‘once’ option to delete the files on exit automatically whenever needed.
- The Always option is not recommended but if you require that every time you start xlq there is no existing data stored, it is now possible.
IQFeed:
The real-time data from IQFeed has included ‘odd lot’ or non-qualifying data, which other sources would exclude. For example, small quantities that would not alter the last price or be included in volume.
This data is now excluded from xlqPrice etc. by default, but you can include them via a new xlq preference setting for iqfeed.
Regardless of whether you include or exclude them it is now possible to see the information separately with 3 new formulae
xlqPriceNonQualifying, xlqSizeNonQualifying and xlqTimeNonQualifying
If you now include the non-qualifying trades, they will also be included in the intraday (not backfill) which was not the case previously.
There is now also a new preference setting for iqfeed intraday that allows you to only update the intraday on new trades only, rather than on bid / ask changes etc. which is the default.
InteractiveBrokers:
The following new formulae are supported:
xlqVolumeRate being volume per minute
xlqTradeRate being trades per minute
xlqNoOfTradesToday (also supported by IQFeed)
Google:
xlq can now request historic data for more than US equities.
Any historic request including an exchange as part of the symbol will use this interface, allowing you to request data for indexes and non US stocks,
e.g. for the dow DJI:INDEXDJX, Danske Bank Copenhagen DANSKE:CPH, Haseko Corporation Tokyo 1808:TYO
xlqCompanion:
New column and field ‘Days G/(L)’ showing the $ amount gained or lost for a held symbol for the current day. To add the column, select it from the field chooser and drag it to where you want.
New formula xlqhValidDateOrNext:
This formula allows you to test a date to see if there is market data for that date. If the same date is returned it is a valid date, if not the following trading date is returned. Xlqhdate would return the prior trading day e.g. =xlqhValidDateOrNext("msft","1/1/2015","yahoo") would return 2 January 2015 whereas =xlqhDate("msft","1/1/2015","yahoo") would return 31 December 2014.
New formula for Money Flow Index:
xlqhMoneyFlowRaw, xlqhMoneyFlowRatio and xlqhMoneyFlowIndex, along with xlqxh and intraday versions.
Full suport for Excel 2016, and windows 10
“insufficient memory” error using the com interface has been fixed.
YieldLowAve7Y was missing from the AAII field list and is now supported
Built with updated libraries and Visual C 2015.
All programs now signed with a new 256 bit digital certificate.
Help file and sample spreadhseets have been updated.
The installation process has changed.
Starting with Visual C++ 2015 Microsoft will combine the c++ runtime libraries with the operating system.
The install process will now check if they are present, and if not, will download them from Microsoft and install them first. In such a case the installation process will require an internet connection and a reboot.
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.
