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.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.
