||If you have a problem with xlq, verify
first that you are using the latest version. Only the latest
version of xlq can be supported, and prior versions cannot be guaranteed
to continue to work as expected due to changes in the market,
data sources, network and IP address changes etc. If you
encounter a problem or have found a bug, or would like to see a
feature in a new version please let me know.
MSN (24 December 2014)
MSN are no longer providing any download data
(day or historic). The existing download links are now being
redirected to their home page and no newer ones have been put in
place. After more than 10 years of supporting their data, I will
proceed with the removal of MSN as a source for the next version.
(If they do announce an updated interface I will support it). In
the meantime you may wish to replace any usage with them with
alternate data sources, and remove any symbols from the stock
Which version of xlq should I install?
Starting with version 4.8, there are now 3 different downloads
available for xlq:
- XP Version: This
version (32 bit only) should only be used if you are using
window XP. It has the same functionality as the other
versions, but is built without using features found in more
recent versions of windows and also uses older functions
no longer found in more recent windows versions.
- 32 bit version: This
version should be installed on 32 bit versions of windows
(Vista and later), or on 64 bit versions of windows that are
using a 32 bit version of excel.
- 64 bit version: This
version should be installed on 64 bit versions of windows if
you are running a 64 bit version of excel.
- For advanced users, it
is possible to install both the 32 bit and 64 bit versions of
xlq on a 64 bit version of windows, allowing you to run one or
the other, but not at the same time. It is best to choose
based upon the version of excel you are using. A 64 bit
version of excel will connect with the 64 bit data engine, and
32 bit excel with the 32 bit data engine. Only one version of
the engine can be running at the same time, i.e. if excel 64
bit tries to connect with xlq and the 32 bit engine is
running, it will wait until the 32 bit is closed and then
start the 64 bit. Some users have reported noticeable
improvements with excel 64 bit connecting with the 64 bit
engine, but there would be no gains made using for example a
32 bit excel with a 64 bit engine.
- If moving from a 32 bit
version to 64 bit (and vice verse), it is recommended to
uninstall first to avoid duplicate installations.
||XLQ cannot run
on Windows RT or a windows 8 phone. Excel available on these
platforms cannot work with addins or custom formulae.
||XLQ cannot run
natively on Apple OS X. To use xlq on a Mac, you would need to
install xlq on a windows platform, and run it via parallels
(etc.), If used with Excel, a windows version of excel would
also be needed.
||For data access TDAmeritrade clients need a standard TDA account. ThinkOrSwim
enabled accounts connect to a different platform for data and
trade routing, and do not provide access to the same TDA data
service. TDA has
confirmed that it is possible to convert a standard account to a ToS account, but it is not possible to convert a ToS account to a
standard account. Instead a new account would need to be created.
longer provide historic day or month data for download. On June 28
2013 MSN stopped their service concerning historic downloads and
no longer provide day or monthly data. Since then they have added
new downloads for weekly data, but cover a smaller time frame,
less symbols and do not include the last partial week. xlq 4.91
has been released to cover these changes. msn is no longer
available as an historic source in xlqCompanion, and only the new
weekly service is available via excel/com.
or later is required for compatibility with Windows 7 (32 and 64
bit) and Excel 2010 (32 bit).
4.32 or later is required for Excel 2010 64 bit.
- If you are using excel 2007 and can only see #xlq in the cells
you are using Norton Antivirus, you need to install Excel 2007
SP1 to solve the problem. Alternatively you could disable the
Norton Antivirus office plug-in (http://support.microsoft.com/kb/329820/en-us).
||XLQ 3.3 or
later is required for compatibility with Vista and Office 2007.
||XLQ will work with Microsoft Excel 97
and later. Earlier versions of Excel will not work.
98, ME, NT and Windows 2000 are no
longer supported. (xlq uses supporting libraries and windows functionality that is
not available in them)
||If you are using Microsoft Excel 97
and it crashes, you need to update your version of Excel to
Service Release 1. You may download this patch from Microsoft
for free. For further information please check the FAQ by