• All licenses
  • requires xlq2 license

24.4

5 September 2024
12 September 2024 (24.41)
 
  • 24.41 Yahoo
    With data no longer being returned from Yahoo since 7 September due to the interface being disabled, this version requests the data using another interface which remains available.
    If this interface is also disabled, Yahoo will be removed as a source in xlq.
    If you are not already using one of the other historic sources supported please explore the alternatives here
  • xlqPrice2x, xlqBid2x and xlqAsk2x
    Similar to xlqPrice2 / Bid2 and Ask2 for xlq2 users.

    But take an additional parameter to only record movement based on change of price (smallest being 0.001) allowing you to set triggers, build a trend and view movement for price changes of 5 cents (for example).

    xlqPrice2 and xlqPrice2x etc. now also allow you to return the date / time of associated values.

    Example sheet in xlqdemo.xlsx has been updated.

    new utility formulae xlq2ReverseString which may be used if you wish to work with the trend showing most recent first.
  • Schwab
    The historic options formulae (chains) are now supported via Schwab

    A Schwab view has been added to work with the data directly in xlq2.
  • Schwab
    Includes all updates and improvements to the Schwab feed to date.
  • New Option Date Formulae (eodhd, tradier, schwab)
    Return calculated trend and target price based on volume and open interest for all options for a given expiry date, as well as totals for convenience
    • xlqhOptionDatePriceTrend - based on volume
    • xlqhOptionDatePriceTarget- based on open interest
    • xlqhOptionDateTotalVolume - total bid and ask volume
    • xlqhOptionDateTotalOpenInterest - total bid and ask open interest
    • xlqhOptionDateTotalVolumeStrike - total volume * strike
    • xlqhOptionDateTotalOpenInterestStrike - total open interest * strike
  • #Source
    New option for advanced users. Similar to xlqfxStatic wrapper but may be used with any formula by adding a # before the source.

    May be used to optimize updating if the data is already available and the request keeps changing due to a volatile parameter.

    e.g. =xlqhOptionContractName("aapl",TODAY()+30,xlqPrice("aapl","schwab")*100,1,"#schwab") will return the closest option put symbol based on current price (equal or less) for an expiry date around 30 days (or less) from the current day.
    As xlqprice will force the results to be updated for both formulae using # for xlqhOptionContractName in this case will be more efficient. (if you are not sure, do not use the #).

    Excel cell refreshing has also been updated.
  • xlq2 source / iex cloud
    As iex cloud have now shutdown, the xlq2 source covering their data has been removed as a source in this version.
  • Historic Dividend Examples
    xlq2demo.xlsx (Dvidends and Splits) has been updated to provide more examples of using the formulae for rate / dividends per year, trailing twelve month, as well as last and next dividend.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.40.33810)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.40.33810
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.40.33810

24.3

17 June 2024
 
  • xlqPrice2, xlqBid2 and xlqAsk2
    These are new specialized versions of xlqPrice / Bid and Ask for xlq2 users.

    They take an additional parameter that will either show prior values, the trend or return the value as positive or negative depending on movement.

    Up to 20 prior values are supported allowing with a streaming source, the last 20 price, bid or ask values or movement and with a snapshot source the last 20 minute values, same for trend, returning for example +--++---+.

    With the values returned as positive and negative it is possible to couple that with cell formatting and conditional formatting to highlight movement, or use an if() to trigger an event.

    A new sheet in xlqdemo.xlsx has been added to explain and show examples of use.
  • Tradier
    xlq2 now has permission to renew authentication automatically, i.e. you now need to only sign in once and no longer daily.
  • Schwab
    This version includes all updates and improvements for the Schwab interface to date.
  • TDAmeritrade
    As TDAmeritrade have now shutdown, it has been removed as a source in this version.
  • xlq2 source / iex cloud
    IEX have given notice that they are leaving the market data business and will be terminating their iex cloud service on 31 August 2024. As a result the xlq2 source, supporting their data will no longer update after that date and will be removed from the following version.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.40.33810)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.40.33810
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.40.33810

24.2

10 May 2024
16 May 2024 (24.21)
23 May 2024 (24.22)
 
  • 24.22 - Additional Schwab improvements.
  • 24.21 - Extra exception handling, corrects a problem where valid symbols could be marked as Not Available.
  • Schwab
    Schwab has been added as a data source. Schwab account holders may now use their account to work with data via xlq2 (data is free).
    For full details click the link below.
    • Historic day, week, month (split adjusted).
    • Snapshot data via schwab days source.
    • Historic intraday is supported (but not for current day or realtime updates).
    • The following additional formulae are supported.
      - xlqSecurityType
      - xlqBidTime
      - xlqAskTime
      - xlqMarketHoursLast
      - xlqMarketHoursChange
      - xlqMarketHoursChangePercent
      - xlqMarketHoursLastSize
      - xlqMarketHoursTradeTime
      - xlqMark
      - xlqMarkChange
      - xlqMarkChangePercent
      - xlqDividendDeclaredDate
      - xlqDividendFrequency
      - xlqDividendNextExDate
      - xlqDividendNextPayDate
      - xlqLastEarningsDate
      - xlqMoneyIntrinsicValue
      - xlqMultiplier
      - xlqTheoreticalOptionValue
      - xlqImpliedYield
      - xlqUnderlying
      - xlqOptionType
      - xlqNetAssetValue

      - xlqhName / xlqhExchange
  • The Schwab day and historic data sources are also available to xlq2lite users with an up to date license (limited to 500 simultaneous symbols (2000 for historic), includes options but excludes currencies, futures, futures options and xlq2 specific formulae.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.36.32532)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532

24.1

28 April 2024
 
  • Tradier
    Tradier has been added as a data source. Tradier account holders may now use their account to work with data via xlq2 (data is free).
    For full details click the link below.
    • Historic day, week, month including for options, dividends and splits.
    • Snapshot data via tradier days source.
    • Streaming data via tradier2 day source.
    • Historic intraday is supported for current day and streaming updates will use tradier2 automatically.
    • The historic options formulae (chains) are supported. (Used along with the tradier and tradier2 day sources is possible to get latest greeks and streaming realtime bid / ask, as well as historic data for options).
    • A new Tradier view is available via xlq2 to allow for viewing and filtering, including for the option data.
    • The following new formulae have been added
      - xlqBidExchange
      - xlqAskExchange
      - xlqUnderlying
      - xlqPhi
      - xlqBidImpliedVolatility
      - xlqAskImpliedVolatility
      - xlqMidImpliedVolatility
      - xlqORATSFinalImpliedVolatility (smv volume)
      - xlqGreeksUpdateTime
      - xlqContractSize
      - xlqOptionExpirationType
      - xlqOptionType
      - With other formulae such as bid / ask time or xlqhName also being supported
  • The Tradier day and historic data sources are also available to xlq2lite users with an up to date license (limited to 500 simultaneous symbols (2000 for historic), excludes options, tradier2 source, xlq2 specific formulae and the tradier view).
  • Chaikin Money Flow
    xlqChaikin Money Flow is now supported (historic day, week, month intraday etc. with the xlqx versions also providing , ChaikinMoneyFlowMultiplier and ChaikinMoneyFlowVolume.
  • Historic Intraday Formulae
    Now possible to work with the latest partial bar (multiple time frames) of historic intraday base value providing 0 for the date and time reference. Base values being high, low, close, open etc, xlqxhi calculations are not available for the incomplete bar but on the last completed.
  • New support formulae for options
    New support formulae have been added (example on option chain sheet in xlq2demo)
    • xlq2OptionSymbolConvert - Convert an option symbols form one source to another, taking 3 parameters, symbol, from source and to source.
    • xlq2OptionSymbolBuildCall - Allows you to construct an option symbol for a specific source by providing the parameters for root, date, price and source.
    • xlq2OptionSymbolBuildPut - Same for put symbols.
  • Other
    • Excel cell updating has been improved.
    • New excel refresh possibilities. From the stock manager, Refresh data calls (force xlq to update related cells) and Clear Requests (force xlq to re-request the data values for the cells) have been improved and are now also available for day sources. This allows for targeted refreshing per symbol or range of symbols. It is now also possible to press alt-ctrl-shift-X (no matter which program has focus) to force a total refresh of all xlq data in excel.
    • Authentication windows have been improved. Standard layout per source, retry button, auto-close. Pressing ctrl-Q to force focus to the browser content will now also work for tradier (useful if using a screen reader or working without a mouse).
    • Many other changes.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.36.32532)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532

23.7

5 December 2023
 
  • FMP added as a data source (with special pricing for xlq2 users)
    FinancialModelingPrep has been added as a new data source providing vast amounts of data (realtime, historic, financials etc.)for wordwide markets.
    for full details click the link below or view the examples in xlq2demo.xlsx.
    • Over 50 different worldwide exchanges are covered.
    • As well as forex, commodities, cryptos, indexes etc.
    • Realtime snapshot data
    • Historic day / week / month data is available as splits adjusted or dividend and split adjusted
    • Historic dividends, splits, earnings, financials available for many markets going back over 30 years
    • Upcoming dividends, splits, earnings and targets for many markets
    • Growth, key metrics and other historic ratios
    • Bulk data requests including all data for a market day etc.
    • Historic intraday data.
    • and more.
  • Yahoo
    xlqhName and xlqhExchange are now supported for Yahoo historic data.
  • Tiingo
    xlqName and xlqExchange are now supported via Tiingo.
  • xlq2 data source
    xlqName now returns a more detailed name (for etf’s etc)
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.36.32532)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532

23.6

16 October 2023
 
  • Excel
    Updated to work with the latest beta of Excel (version 2310) which could fail to start. xlq2 remains compatible with prior versions of Excel.
  • InteractiveBrokers
    Updated handling of FUNDs and CFDs
  • Norgate Data
    New preference setting allowing you to choose the update time for their historic data.
  • Yahoo
    Yahoo has been removed as a day source.

    There are new preference settings in yahoo allowing you to choose an alternative day source to be used if using their historic data and calculating into the current trading day (i.e. xlqxh 0 date formulae).

    It is also now possible to set the refresh time for their historic data, which previously occurred at midnight ET. If the data is available at that time it will be added.

    For certain sources (yahoo / TDA) that had historic data limits set to 1970, this has been extended and is now possible to get data back to the 1920’s for certain symbols.
  • Handling of xlqFx / xlqFXstatic has been updated.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.36.32532)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532

23.5a

21 July 2023
31 July 2023 (23.5b)
 
  • 23.5b - Update fixing reported crash.
  • Yahoo
    As Yahoo continues to disable any remaining interfaces for day data, Yahoo as a day source has now been disabled in xlq. You should replace it with their historic data, which remains unaffected and / or any of the other sources supported through xlq

    Only if they announce a new service, subscription or otherwise could it again be supported.
  • TDAmeritrade
    xlq now uses the latest embedded chromium browser and will eliminate the ‘unsupported browser’ warning when authenticating with TDAmeritrade.
    A new TDAmeritrade preference setting ‘show login screen x days before expiry’ can now be set to have the authentication screen be shown as a reminder for renewal.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.36.32532)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.36.32532

23.4

26 May 2023
1 June 2023 (23.4a)
 
  • 23.4a - New Yahoo preference settings to ignore pre / post market data.
  • Yahoo
    Yahoo has disabled their interface for day data due to licensing from their data providers. They indicate that they are looking to acquire other licenses and the possibility of a new api service, which I will look at supporting if and when available.

    This version continues to support yahoo day data but through a different interface which remains active. It is slower and contains less data so hopefully is not impacted by the new restrictions.
  • Norgate Data
    Uses an updated interface with Norgate Data and adds support for their Canadian data (including for delisted symbols).
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.34.31931)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931

23.3

21 April 2023
 
  • Uses alternative processing for Yahoo day data due to requests failing.
  • Includes many internal updates and changes based on feedback.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.34.31931)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931

23.2

21 March 2023
 
  • New options for Historic Intraday
    In addition to specifying 0 or 1 in formulae to return (0) market hours only ,or (1) also include pre / post market, it is now also possible to specify
    2 - Market hours (with gaps), and
    3 - all hours (with gaps).
    with gaps excludes bars where no trades occurred between first and last trade of the day.
  • New preference settings
    Under general, in addition to choosing to delete all data on exit -once, which deletes data within xlq, it is now possible to also chose to
    Delete extra data for all sources on exit – once,
    With options, if preferred to do so by source (EODHD, IB, or IQFeed).
    If set to yes, the stored data retrieved from these sources will also be deleted forcing retrieval of all data on next load. For IB and IQFeed this will only be for historic intraday data, but for EODHD will also remove all fundamental data etc.
    By default now, when installing xlq the extra source data files along with xlq data files will be removed ensuring a clean start.


    Under data source specific / EODHD, IB and IQFeed you can now also choose to set Historic intraday settings / keep retrieved data for reuse to no. This will ensure that if historic intraday data needs to be reloaded, all will be re-requested. If yes (default) reloading of data will be faster and would be recommended if requesting many days.
  • Miscellaneous updates to Historic Intraday based on feedback.
  • All InteractiveBrokers historic requests have been updated with improved handling of the time zone provided to TWS on sign in.
  • All EODHD option requests, in addition to US equities will also work with the following indexes: DJI, GSPC, NDX, RUT, SP100, VIX (.indx).
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.34.31931)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931

23.1

1 March 2023
 
  • New Historic Intraday functionality
    introducing a whole new way to work with intraday data:
    • Works with multiple time intervals (specified in the formulae).
    • Can work with months of data (depending on source) including historic and / or current day / realtime updating .
    • Can reference data by date / time or relative reference.
    • Can work with market hours only and / or include pre/post market.
    • All calculation formulae have been ported
    • Range formulae are available
    • New view with intraday by date allowing for multiple intervals.

    For more information on all new possibilities and the hundreds of new formulae available click here
  • Can now set an alternative day source to be used for 0 date calculations for Norgate Data and EODHD.
    Set under xlq preferences / data source specific. If an alternative source is set, it will be used to return the last pricing info for the 0 date calculation into the current trading day.
  • The CMB composite index is now available in all calculation formats (day /week /month / intraday etc), i.e. xlqhCMBComposite, xlqhCMBCompositeFast, xlqhCMBCompositeSlow etc.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.34.31931)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931

22.3

20 December 2022
26 December 2022 (22.3a)
31 December 2022 (22.3b)
 
  • xlq2 22.3b update
    - update for 22.3 and 22.3a fixing problem where historic updates may be slower due to a library conflict.
  • xlq2 22.3a update
    - minor improvements to recent yahoo changes for smoother processing.
  • Updated for Yahoo compatibility
  • Updated to latest InteractiveBrokers API.
  • Many internal changes including error handling and managing of non subscribed sources with all supporting libraries upgraded.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.34.31931)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.34.31931

22.2

7 September 2022 (22.2)
29 September 2022 (22.2b)
5 October 2022 (22.2c)
11 October 2022 (22.2d)
14 November 2022 (22.21)
 
  • xlq2 22.21 update
    - Technical update on the new processing containing improvements, updates, bug fixes, including a fix to avoid a potential crash.
    - Also from the xlq stock manager (historic tabs) there are now 2 additional right click menu options available
    Refresh Data Calls – will force an update of all excel cells as if data has changed.
    Clear Requests – will clear all excel requests and all processing and updating will be re-initialized. Ideally this should be followed by clicking refresh all in the xlq menu in excel to ensure all requests are again made.
    These requests may be applied per row for an individual symbol or to a range of selected symbols.
  • xlq2 22.2d update
    - The latest InteractiveBrokers TWS update is now incorrectly returning “The date, time, or time-zone entered is invalid.” error for intraday data for some symbols. xlq 22.2d re-requests the data differently if detected.
  • xlq2 22.2c update
    - Fixes a problem with the new update processing concerning =xlqxhm historic requests to ensure any date can be used to reference the month. (In 22.2a/b using only the 1st of the month or -x references returned results.)
  • xlq2 22.2b update
    - The latest InteractiveBrokers TWS update is incorrectly returning “The date, time, or time-zone entered is invalid.” errors again for some symbols. xlq 22.2b has been updated to work around this problem by re-requesting the data differently if detected.
    - Additional updating changes.
  • Improved excel updating
    This version includes the new excel update processing that has been in development for a couple of years providing up to 3 times faster refreshing time on opening (with data pre-requested).
    Speed improvement of up to 25% have also been noted with all data needing to be retrieved.
  • New special version of formulae for Bollinger Bands calculation, i.e. xlqxhBollingerBands2Upper, xlqxhBollingerBands2Middle, xlqxhBollingerBands2Lower ,xlqxhBollingerBands2B, xlqxhBollingerBands2Width (+ weekly / monthly and xlqxi intraday versions) allowing you to specify the standard deviation method (population or sample) and data and average types like the RSI2 and MACD2, i.e. allowing you to chose the average type used (from the 8 choices as per the flex average) and the data type used for the calculation (from the 22 types available).
  • Same for Keltner Channels, i.e. xlqxhKeltnerChannels2Lower, xlqxhKeltnerChannels2Middle, xlqxhKeltnerChannels2Upper (+ weekly / monthly and xlqxi intraday versions).
  • In xlqdemo.xlsx the squeeze2 sheet has been added using Bollinger bands 2 and Keltner Channels 2 allowing for results to be compared using different parameters.
  • New preferences setting (under data settings / historic formulae) allowing you to choose the standard deviation calculation method which is applied to other Bollinger Bands calculations. The default now is to use the population method. For compatibility with prior xlq versions choose sample.
  • Standard Deviation (Population)
    All xlq standard deviation formulae return results as per a sample (like excel’s stdev.s). New formulae have been added to return results for population (like excel’s stdev.p). These include xlqxhStdDevP (+ week, month), xlqxhFlexAveStdDevP (+ week, month), xlqxiStdDevP, xlqxiFlexAveStdDevP and the range version xlqrhStdDevP (+ week, month).
  • Copy with headers
    It is now possible to copy data from any of the xlq views or xlqCompanion choosing to copy only the data or the data with headers. This can be done by either selecting the data, then right clicking and choosing copy or copy (with headers), or pressing ctrl-C to copy or ctrl-shift-C to include the headers.
  • Midpoint
    xlqMidpoint is now available being the midpoint of the bid and ask. Xlq2 users working with option data from EODHD also have xlqhOptionsMidpoint which is also included in the views and can be filtered and sorted on.
  • CoinMarketCap
    The following new formulae have also been added:
    • xlqSelfReportedCirculatingSupply
    • xlqSelfReportedMarketcap
    • xlqVolumeChange24h
    • xlqTotalValueLocked
    • xlqTotalValueLockedRatio
  • InteractiveBrokers
    The following new formulae are supported:
    • xlqIsHalted
    • xlqAuctionPrice
    • xlqAuctionVolume
    • xlqAuctionImbalance
    • xlqMarketHoursLast

    It is now possible to specify the primary exchange for data requests when using smart to ensure all quotes are returned. i.e. certain symbol are ‘ambiguous’ if they are listed on different exchanges, e.g. CSCO (or CSCO[smart,stk,usd]. CSCO[bats,stk,usd] etc. can be used for direct quotes from bats, and now CSCO[smart&nasdaq,stk,usd], may be used for all quotes as the underlying exchanges is provided removing ambiguity.

    New preference setting to set the maximum no. of years for historic data requests, between 1 and 30 years. Default is now set to 5.

    Updated for compatibility with a recent TWS change to avoid a “The date, time, or time-zone entered is invalid.” error when requesting historic data.
  • Yahoo
    Yahoo processing has been updated reducing alerts for connection failures.
  • Tiingo
    Historic Tiingo processing has been updated to correctly handle symbols such as BRK-B.
  • Insider Transactions (EODHD)
    Insider transaction data is now available from EODHD available per symbols and as bulk requests for all symbols, and includes the following formulae:
    • xlqhInsiderTransactionsDate
    • xlqhInsiderTransactionsOwnerCIK
    • xlqhInsiderTransactionsOwnerName
    • xlqhInsiderTransactionsTransactionDate
    • xlqhInsiderTransactionsTransactionCode
    • xlqhInsiderTransactionsTransactionAmount
    • xlqhInsiderTransactionsTransactionPrice
    • xlqhInsiderTransactionsTransactionAcquiredDisposed
    • xlqhInsiderTransactionsPostTransactionAmount
    • xlqhInsiderTransactionsSEClink
    • xlqhInsiderTransactionsReportDate
    • xlqhInsiderTransactionsOwnerRelationship
    • xlqhInsiderTransactionsOwnerTitle
    • xlqhInsiderTransactionsDateIndex
    • xlqhInsiderTransactionsValidDateOrNext

    xlq2demo has been updated, and the data is also viewable via the eodhd view and the eodhd period view where it is possible to view and manipulate the data month by month for all symbols.
    To work with the data symbol by symbol in xlq preferences under data source specific / EOD Historical data ensure process fundamentals is set to yes.
    To work with the bulk data ensure Process Bulk Insider Transactions is set to yes.
  • Other EODHD Changes
    • more detailed bulk dividend data
    • Extra Balance Sheet formulae (Quarterly (xlqhbsq…) and yearly (xlqhbsy…)
      - PropertyPlantAndEquipmentNet
      - CapitalStock
      - CashAndEquivalents
      - CurrentDeferredRevenue
    • and Cash Flow (xlqhcfq / xlqhcfy)
      - IssuanceOfCapitalStock
  • Norgate Data
    • Additional data sources Norgate-AUWarrant and NorgateAUETO covering Australian Warrants and Exchange Traded Options.
    • xlqhTurnover is now available working with all their data sources.
    • From the Norgate data view in xlq it is now possible to double click a row (or select a range of rows, right click and choose Retrieve) to add the symbol to xlq for processing.
  • xlq2 Data The xlq2 data source with underlying data from iex cloud has been updated.
    Some of the new formulae include:
    • xlqHighTime
    • xlqLowTime
    • xlqIEXOpen
    • xlqIEXOpenTime
    • xlqIEXLastTradeTime
    • xlqIEXClose
    • xlqIEXCloseTime
    • xlqOddLotDelayedPrice
    • xlqOddlotDelayedPriceTime
    • xlqPreviousVolume
    • xlqVolumeFromIEX
    • xlq52WeekHighSplitDivAdj
    • xlq52WeekLowSplitDivAdj
    • xlqPricePerEarnings
    • xlqSIC
    • xlqAddress1
    • xlqAddress2
    • xlqState
    • xlqCity
    • xlqZip
    • xlqCountry
    • xlqPhone
    Times are now all eastern time.

    All xlq2 data source processing is now handled through a new server interface. The old interface used by prior versions of xlq will remain active for a few weeks before being shutdown giving time to upgrade.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.32.31332
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.32.31332
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.32.31332

22.1

4 January 2022
 
  • Interface with Interactivebrokers has been updated, including the following changes:
    • Historic data is no longer limited to 1 year and is now possible to work with up to 30 years of data.
    • Monthly historic data is now also available.
    • The following new formulae are supported:
      xlqShortableShares
      xlqAveOptionVolume
    • It is now possible to get streaming realtime, historic and intraday backfill for the crypto currencies supported though IB.
      Examples of symbols:
      Bitcoin: BTC.USD[PAXOS,CRYPTO,USD]
      Ethereum: ETH.USD[PAXOS,CRYPTO,USD]
      Litecoin: LTC.USD[PAXOS,CRYPTO,USD]
      Bitcoin Cash: BCH.USD[PAXOS,CRYPTO,USD]
  • Yahoo processing has been updated to better handle re-retrieval of data due to data changes detected and would be a recommended update for anyone using their data.
  • Xlq2 is now built using visual studio 2022 and all supporting libraries have been upgraded accordingly.
  • Requires Microsoft Visual C++ 2022 Redistributable (version 14.30.30704
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2022 runtime libraries version 14.30.30704
    64bit Microsoft Visual C++ 2022 runtime libraries version 14.30.30704

21.3

11 October 2021
 
  • Xlq2 has been converted to Unicode for better string handling and support of accented characters etc. All string handling, supporting libraries, interfaces etc. have been updated, including to latest versions
  • String handling via formulae has also been updated for longer lengths ...
  • including the new formula xlqhDescriptionLong making the long text descriptions from Norgate Data and EODHD available in excel. (xlq2demo has updated examples including using merged cells).
  • The install program has been updated and all programs are now signed with Extended Validation SSL certificates.
  • All calculation processing has been updated.
  • New formulae for Choppiness Index xlqhChop as well weekly / monthly, xlqxh and xlqxi intraday versions.
  • New special version of formulae for RSI calculation, i.e. xlqxhAveGain2, xlqxhAveLoss2, xlqxhRelativeStrength2 and xlqxhRSI2 (+ weekly / monthly and xlqxi intraday versions) that take 2 extra parameters allowing you to chose the average type used (from the 8 choices as per the flex average) and the data type used for the calculation (from the 22 types available).

    This allows for some complex possibilities such as calculating an RSI on typical price using a triple ema, or on range using a hull moving average etc. etc.
  • Same for MACD, i.e. xlqxhMACD2, xlqxhMACD2Trigger and xlqxhMACD2Histogram(+ weekly / monthly and xlqxi intraday versions). Used with an SMA and appropriate settings will return results as per the LBR 3-10 Oscillator.
  • Close Price*Volume has been added as a 22nd data type and may be used with the flex average and all other formulae allowing a type parameter. For the full list of data types, average types and supported formulae see xlq historic formulae in xlqdemo.xlsx.
  • New COM interface functions have been added, xlqHistValue6 and xlqIntraValue6 to support the extra parameter.
  • CoinmarketCap processing has been updated. Data will now be returned for symbols containing spaces and other non-standard characters. Handling of duplicate symbols has been improved. Error messages will be shown in the status view and supports 2 new formulae for their data, xlqMarketCapitalizationDiluted and xlqMarketCapDominance (xlqCryptoCurrencies.xlsx has been updated).
  • Supports IQFeed's 6.2 protocol and would require using iqconnect 6.2.020 or later. It can be downloaded from here
  • For EODHD users, beta and type (common stock, etf, fund, currency etc) have been added to the bulk historic data viewable via the xlq2 EODHistoricalData Period view.
  • The following new EODHD options formulae have also been added (xlq2demo.xlsx updated with examples) :
    • xlqhOptionDatePutVolume
    • xlqhOptionDateCallVolume
    • xlqhOptionDatePutCallVolumeRatio
    • xlqhOptionDatePutOpenInterest
    • xlqhOptionDateCallOpenInterest
    • xlqhOptionDatePutCallOpenInterestRatio
    • xlqhOptionContractPeriod (returning whether the option is weekly / monthly)
  • Updated Yahoo Processing
  • Supports Windows 11 and Excel 2021
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.29.30037
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.29.30037
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.29.30037

21.2

20 May 2021
 
  • New historic, range and intraday formulae for Median allowing to return the median over a number of periods, or between 2 periods on any of the 21 supported types (close, range, volume, typical price etc).
  • This is a recommended update for anyone using xlqxi formulae (intraday calculations) as excel refreshing has been changed.
  • Extra financial formulae supported through EODHD (quarter and year)
    Balance Sheet
    • xlqhbsqNetDebt
    • xlqhbsqNetWorkingCapital
    • xlqhbsqNetInvestedCapital

    Income Statement
    • xlqhisqSellingAndMarketingExpenses
    • xlqhisqReconciledDepreciation
    • xlqhisqEbitda
    • xlqhisqDepreciationAndAmortization

    Cash Flow
    • xlqhcfqChangeInWorkingCapital
    • xlqhcfqOtherNonCashItems
    • xlqhcfqFreeCashFlow
  • Extra formulae for bonds, cryptos, ETFs and funds supported through EODHD
    Bonds
    • xlqhName
    • xlqhISIN
    • xlqhCUSIP
    • xlqhWKN
    • xlqhSedol
    • xlqhFIGI
    • xlqhBondType
    • xlqhDebtType
    • xlqhGICIndustry
    • xlqhGICSubIndustry
    • xlqhSubProductAsset
    • xlqhSubProductAssetType
    • xlqhCurrency
    • xlqhMoodyRating
    • xlqhMoodyRatingUpdateDate
    • xlqhSPRating
    • xlqhSPRatingUpdateDate
    • xlqhCoupon
    • xlqhLastPrice
    • xlqhLastTradeDate
    • xlqhMaturityDate
    • xlqhYieldToMaturity
    • xlqhCallable
    • xlqhNextCallDate
    • xlqhMinimumSettlementAmount
    • xlqhParIntegralMultiple
    • xlqhEODHDUpdateDate
    • xlqhIssueDate
    • xlqhOfferingDate
    • xlqhFirstCouponDate
    • xlqhFirstTradingDay
    • xlqhCouponPaymentFrequency
    • xlqhCompanyName (Issuer)
    • xlqhCountryName
    • xlqhWebSite

    Cryptos
    • xlqhUrlInfo

    ETFs
    • xlqhName
    • xlqhCompanyName
    • xlqhISIN
    • xlqhWebSite
    • xlqhUrlInfo
    • xlqhYield
    • xlqhDividendPayingFrequency
    • xlqhInceptionDate
    • xlqhOngoingCharge
    • xlqhOngoingChargeDate
    • xlqhExpenseRatio
    • xlqhAnnualHoldingsTurnover
    • xlqhTotalAssets
    • xlqhAverageMktCapMil

    Mutual Funds
    • xlqhCategory
    • xlqhStyle
    • xlqhNAV
    • xlqhLastPrice
    • xlqhEODHDUpdateDate
    • xlqhPortfolioNetAssets
    • xlqhShareClassNetAssets
    • xlqhInceptionDate
    • xlqhCurrency
    • xlqhCountryName
    • xlqhYield
    • xlqhYieldYTD
    • xlqhYield1YearYTD
    • xlqhYield3YearYTD
    • xlqhYield5YearYTD
    • xlqhExpenseRatio
    • xlqhExpenseRatioDate
  • The xlq2 EODHistoricalData view will now also show the ISIN as part of the symbol list.
  • Sample worksheets have been udpated
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.28.29913
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.28.29913
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.28.29913

21.1

12 April 2021
 
  • New Versioning
    Rather than just increment .x version of each update, the new versioning is more meaningful, i.e. XX.YZ XX will be the year 20(21), and Y will be the sequence of releases for the year. .1 being first, .2 next etc. Z will refer to any minor updates.
  • One download, introducing xlq2Lite:
    To ensure all users benefit from xlq2 design changes and enhancements, going forward there will be one xlq2 download for everyone.
    A new xlq2Lite license will provide core xlq2 functionality, also ensuring all existing xlqPlus features remain and will be built upon.
    Some changes:
    • It is now possible to download and install xlq2 without a license, which will run as a trial with all xlq2Lite features for around 3 weeks, with the possibility to request a full xlq2 trial (3weeks), allowing up to 45 days to trial all functionality.
    • A valid and up to date xlq2 license is still required to use all xlq2 features. When an xlq2 license expires, if it is not renewed it will continue to function as xlq2Lite until renewed.
    • When xlq2 is running with all xlq2 features the Q will be green, and when it is running as xlq2Lite it will be orange.
    • xlq2Lite will continue to run using an expired license. (Any features added that are indicated as requiring a valid license will no longer function until renewed).
    • What does not change is that a license will only work with versions released before its expiry date, and any renewal (extending the existing license by 1,2 or 3 years), or upgrade needs to be done within 3 month of expiry. After the 3 months the license is no longer eligible for the special discounted renewal pricing.
  • EODHD added as a data source (with special pricing for xlq2 users)
    EODHistoricalData has been added as a new data source providing vast amounts of new data and new possibilities. It is impossible to cover all changes here as there are hundreds of new formulae along with new views within xlq2. All new formulae are documented in xlq2demo.xlsx and elsewhere on the site
    • Over 60 different worldwide exchanges are covered.
    • Including virtual exchanges covering forex, commodities, cryptos, bonds, indexes etc.
    • Detailed options data is also available
    • Historic day / week / month data is available as unadjusted, splits adjusted or dividend and split adjusted
    • Delayed snapshot data.
    • Historic dividends, splits, earnings, financials available for many markets going back over 20 years
    • Upcoming dividends, splits, earnings and targets for many markets
    • Historic short interest
    • Other detailed statistics / fundamentals.
    • Bulk data requests including all data for a market day etc.
    • Index constituent data
    • Extra formulae for Cryptos, Bonds ...
    • and more.
  • New formulae for the xlq2 day data source (underlying data provided by iex cloud)
    xlqIndustry, xlqSector, xlqWebsite, xlqCEO, xlqSecurityType, xlqDividendPayDate and xlqNextEarningsDate (date should be upcoming but is more often the prior date)
  • New formulae for CoinMarketCap
    PercentChange30day, PercentChange60day, PercentChange90day
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.28.29913
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.28.29913
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.28.29913
Above: New versioning. One download for all. New xlq2Lite (including all xlqPlus functionality and more)
  • All licenses
  • included with xlqPlus license and above
  • requires xlq2 license
Below: Prior versioning is used. Seperate downloads for xlq (xlqPlus / xlqLite) and xlq2

6.7

29 June 2020 (release 6.7)
6 July 2020 (xlq2 release 6.71)
23 July 2020 (release 6.72)
1 September 2020 (release 6.73)
4 September 2020 (release 6.73a)
27 November 2020 (xlq2 release 6.74)
 
  • xlq2 6.74 update
    - The xlq2 historic source with underlying data from iex cloud will no longer be supported after 1 December due to iex removing key data.
    xlq2 6.74 has been updated accordingly.
  • 6.73 update
    - Interactivebrokers compatibility update (forex, bonds, commodities, bills)
    - TDAmeritrade compatibility update (avoids errors while TDA fixes problems with certain option symbols)
    - Update Tiingo crypto handling for last price (6.73a)
  • 6.72 update
    - Interactivebrokers compatibility update (equities and warrants)
  • xlq2 6.71 update
    - fix a problem with xlq2 data source upcoming events not showing after a refresh.
    - Update TDA-SNAP (and TDA in snapshot mode) to increase symbol limit when update frequency is increased to 2,10, 20 or 240 minutes).
    - xlqDelete will remove all symbols for a source if *** is passed e.g. =xlqDelete("***","xlq2"). Can also be used with a macro or programming language when finished working with a selection. Should not be called repeatedly.
    - Deleting all historic symbols for a source in the stock manager is much faster, and also may be done programmatically with xlqhDelete("***", source). xlqhDelete will return 0 if succesful, or an error if unable to delete if background processing is being performed.
  • This update is a major update and includes workbook initialization improvements, especially for .xlsx and .xlsm file formats (Excels binary files, i.e. .xlsb remains the recommended format).
  • Xlq2Bridge will now close automatically if it detects excel is no longer communicating with it.
  • TDAmeritrade
    This version supports TDAmeritrade's new interface.
    They will be ending support for the old later this year. xlqPlus supports this providing all equivalent functionality where possible for a seamless transition. Signed in with a TDAmeritrade account support for free streaming real-time data, intraday backfill, and historic data for US equities and indexes continue to be available, as well as streaming real-time options.
    Streaming data is limited to 500 symbols
  • For TDAmeritrade, it is now possible for you to use a personal consumer key for their API rather than the default for xlq.
    This will eliminate recent connection and request errors from occurring.
    To make the change you would need to register and request a consumer key with TDAmeritrade, then enter it into xlq. This page (XLQ_TDAmeritradeGuide) has been setup providing detailed instructions.
  • When xlq is running it is now possible to press Alt-Ctrl-Shift-T to display the TDA authorization window.
  • The following formulae are now also supported for TDAmeritrade in xlqPlus:
    xlqAverageVolume
    xlqDividendAmount (also xlqDividendRate)
    xlqBeta
    xlqSharesOutstanding
    xlqPricePerBook
    xlqMarketCapVal
  • Addtional TDAmeritrade support is available via xlq2, including for real-time futures (e.g. /ES) and currencies (e.g. EUR/USD).
  • In xlq2 if you do not have a TDAmeritrade account it is possible to work with delayed snapshot (equities, indexes, options, futures and currencies) and historic.
  • In xlq2 you may further control the TDAmeritrade streaming data by choosing the speed of updates as follows:
    500 ms
    750 ms
    1000 ms (default)
    1500 ms
    3000 ms
    5000 ms
    Or to return the data as real-time x minute snapshots (as per the snapshot setting)
  • In xlq2 you may enable a 2nd TDAmeritrade snapshot source (TDA-SNAP), with its own interval. This will allow for example to only stream real-time data for the symbols you need while monitoring others, only updated every couple of minutes.
    (If signed in to TDAmeritrade, TDA-SNAP will return real-time snapshots, if not, delayed).
  • The following additional formulae are supported for TDAmeritrade in xlq2:
    xlqCusip
    xlqAverageVolume10
    xlqAverageVolume3M
    xlqPRRatio
    xlqPCFRatio
    xlqQuickRatio
    xlqCurrentRatio
    xlqPEGRatio
    xlqReturnOnEquity
    xlqReturnOnAssets
    xlqttmEPS
    xlqGrossMarginTTM
    xlqGrossMarginMRQ
    xlqNetProfitMarginTTM
    xlqNetProfitMarginMRQ
    xlqOperatingMarginTTM
    xlqOperatingMarginMRQ
    xlqReturnOnInvestment
    xlqInterestCoverage
    xlqTotalDebtToCapital
    xlqLTDebtToEquity
    xlqTotalDebtToEquity
    xlqEPSChangePercentTTM
    xlqEPSChangeYear
    xlqEPSChange
    xlqRevenueChangeYear
    xlqRevenueChangeTTM
    xlqRevenueChangeIn
    xlqMarketcapFloat
    xlqBookValuePerShare
    xlqShortInterestToFloat
    xlqShortInterestDaysToCover
    xlqDividendGrowthrate3Year
  • XLQ2 source:
    The entire update processing has been redesigned and optimized. The old update processing will continue to be supported for a couple of months before being phased out.
  • XLQ2 source:
    Historic earnings data is now available for quarters and years, with the views being updated accordingly. The original formulae starting with xlqhEarnings have been renamed to xlqhEarningsQ… and the yearly are now xlqhEarningsY…
  • XLQ2 source:
    Historic data is now also available for the following countries:
    Belgium (suffix -BB)
    Canada (suffix -CV or -CT) previously supported
    France (suffix -FP)
    Germany (suffix -GY)
    Ireland (suffix -ID)
    Mexico (suffix -MM) previously supported
    Netherlands (suffix -NA)
    Portugal (suffix -PL)
    United Kingdom (suffix -LN)
  • Norgate Data:
    For Australia it is now possible to work with the partial day snapshots during the current market day, which are updated automatically. The -1, or current date reference will return the most recent values, with prior close becoming -2 if more recent data is available.
  • Yahoo:
    processing has been updated to avoid symbols being returned as not available.
  • Xlq2Demo.xlsx is now included with the xlqPlus installation, allowing for the possibility to consult the extra functionality even though the formulae will not work. It has also been updated with a new TDA sheet.
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.26.28720)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.26.28720
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.26.287207

6.61

12 March 2020
 
  • This update is an interim technical refresh built against updated libraries (and runtimes).
  • It fixes and addresses all issues found since the last release, notably
    - last historic day could be missing from Yahoo.
    - corrects a problem where a windows update could cause a javascript error in the TDAmeritrade authentication window
    - improved handling of xlqFx and xlqFxStatic wrappers
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.24.28127
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.24.28127
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.24.28127

6.6

11 December 2019
 
  • The XLQ2 data source (supplied from IEX Cloud) now supports Canadian And Mexican historic data.
    Canadian symbols have a suffix of -CV or -CT and Mexican -MM e.g. AAL-CV, BND-MM
    Historic mutual fund data is now also available. Financial and dividend data are now available for a lot more symbols including for OTC and mutual funds.
  • TDAmeritrade login procedure will change on 31 December 2019. After that date the old login process will no longer work. This version supports the new login process where you no longer need to provide your account or password to xlq, using OAuth2 instead.
  • This update supports IQFeeds updated 6.1 protocol and would require using iqconnect 6.1.020 or later. It can be downloaded from here
  • This version has been updated to maintain compatibility with recent changes at Yahoo. These breaking changes have been rolled out over the last week.
  • As it has now been more than 2 years since xlqLite sales ended, effective immediately renewal or extending of xlqLite licenses is no longer possible. New releases of xlq will continue to support xlqLite license that are valid, and it will remain possible to upgrade the license to xlqPlus until 3 months after the expiry date.
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.23.27820
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.23.27820
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.23.27820

6.5

5 September 2019
 
  • New data source "XLQ2" available in XLQ2 (with around 200 formulae added to cover the extra information)
    - Data is managed from dedicated xlq2 servers offering a range of data complementing existing sources, covering US equities including:
    - Upcoming Dividends, Splits, Earnings along with estimates and target pricing
    - Historic quarterly (12 quarters) and yearly (4 years) Balance sheet, Income statement, Cash flow, and up to 5 years of historic Earnings, Dividends and Splits.
    - Historic Day data (up to 15 years, also for OTCs)
    - Real-time IEX or delayed snapshot data with frequency configurable via preferences.
    - Other information such as industry, sector, website, CEO, number of employees, market cap, beta, float, dividend rate, yield, pe ratio, pre calculated change percentages etc. For full list please consult xlq2demo.xlsx.
    - This service is offered free to xlq2 users.
    - Underlying Data is provided by IEX Cloud.
    - click here for more info.
  • Historic views within XLQ2 have been updated to show the new data. The historic period view will now include upcoming dividends, historic earnings, and a new tab for upcoming earnings announcements along with estimates and target price information.
  • IEX has been removed as a source due to the service being discontinued.
  • Xlqfx wrappers (xlqfx and xlqfxtatic) have been modified to work with formulae such as xlqhNorgate taking 3 string fields.
  • CoinMarketCap - You may now choose the update interval for CoinMarketCap, to have a lower frequency if monitoring 24/7, or higher if using one of their paid tiers.
  • xlqCompanion has 2 new fields that may be chosen from the field chooser, i.e. alert high % and alert low%. Working with the existing alert high and low $ fields. These new fields will work like the trailing stop % showing how close the $ alerts are to being triggered.
  • Yahoo - a prior fix to clean data such as for Australia where dates were offset by one day has been removed. Previously the returned data was all offset, or all correct, but the data now returned from yahoo can be both incorrect and correct depending on the date returned, reducing the possibility of effectively applying a fix so is now left as is.
  • Requires Microsoft Visual C++ 2019 Redistributable (version 14.22.27821
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2019 runtime libraries version 14.22.27821
    64bit Microsoft Visual C++ 2019 runtime libraries version 14.22.27821

6.4

15 March 2019
 
  • Stockwatch supported as new historic source
    - Unlike other sources, this data is retrieved per market day and per exchange and not per symbol, including for all options traded.
    - Supports US and Canadian exchanges, and you may choose in preferences which you wish to work with.
    - Requires an Intermediate Subscription with Stockwatch (around C$ 10 per month).
    - Due to the number of symbols, if using options (> 500,000), it is more suited for near-term analysis or when data for numerous options are required.
    - Works well with the filters in the historic and historic period view to find symbols based on indicator values.
    - click here for more info
  • Norgate Data - new preference setting to "disable NDU connection".
    If active Norgate will be removed from xlq as a source until re-activated and will not try connect with NDU.
  • CoinMarketCap - is again supported, now using their new sign up interface, including support fro their Basic (free) subscription.
    Your CMC token would need to be entered into XLQ and can be obtained from https://coinmarketcap.com/api/pricing/
    - Data will be refreshed every 30 minutes to ensure compatibility with the Basic subscription.
    - (Tiingo has expanded on the number of symbols covered and may be used as additional real-time or historic data is required).
  • Interactivebrokers -
    This version now uses their latest API and should avoid/eliminate timeout restrictions if you hit any of their throttle limits, in which case requests are queued and not rejected.
    It also eliminates a problem that has been occurring more frequently with the old api after a windows update with being unable to connect to TWS.
  • SuperTrend -
    New formula xlqhSuperTrend, as well as weekly/month/xlqxh and intraday variants, allowing you to calculate the super trend. You may change the settings for the number of periods for the ATR and multiplier, and may choose how the ATR is calculated (Wilder / SMA / EMA).
  • This version includes updated handling of day/real-time data. It lays the groundwork for future updates with the base methods and memory handling being faster and more efficient. As a result any stored day data from previous versions will not be compatible and the data will be re-requested.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.16.27024)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.16.27024
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.16.27024

6.3

26 October 2018
 
  • XLQ2 released. (new subscription level)
    Too many new features to mention but include
    - redesigned data engine
    - enhanced views allowing queries per column.
    - new views including historic period view, dividend view etc.
    - over 100 new formulae covering dividends, splits, financials, constituents, fundamentals. examples in new xlq2Demo.xlsx
    - click here for more info
  • NorgateData supported as new data source.
    covering thorough historic data for US and Australian equities and indexes, futures and currencies. (requires subscription)
    - data adjusted as needed. includes dividend details.
    - supports data back till 1950 including for delisted companies
    - historic index constituent data.
    - additional financial and fundamental data
    - many new formulae covering the additional data.(see formulae help pages for more info)
  • IEX supported as new data source. (data is free)
    covering day and historic US equity data (5 years) as well as financials / fundamentals.
    - historic dividend and split information.
    - historic earnings and financials
    - many new formulae covering the additional data. (see formulae help pages for more info)
  • new AAII custom fields that can be used with xlqaaii in addition to those provided by aaii. There are around 50 new fields calculated on existing values and included in a new 'xlq aaii custom formulae.xlsx' (can also be applied for quarterly / yearly values)
    includes calculations such as for Net Operating Assets, Excess cash, NOPAT, NOPAT return on invested capital etc.
  • COM interface has been updated to handle all new formulae and sources. New request functions xlqHistString, xlqHistString1 and xlqHistNorgate have been added to cover requests returning string values or requiring additional string parameters
  • Tiingo supported as new data source (requires registration, data is either free or subscription)
    covering day and historic data (back to 1960's) for US and Chinese equities, funds and crypto currencies.
    - data may be adjusted for dividends.
    - Token needs to be entered into xlq before it can be used see https://blog.tiingo.com/how-to-find-your-tiingo-api-token/ for more info
    - For historic crypto-currencies it is possible to get the unique data for the currency pair. e.g. btc-usd will include all historic data converted to usd, whereas btc-usd* will only return data where btc has traded directly to usd. Another example xcp-usd will return all XCP trades converted to USD, xcp-usd* will not return data as there are no direct trades, but you can view direct trades with xcp-btc* etc.
  • Supports IQFeed's latest protocol (requires iqconnect 6.0.0.4 or later to run)
  • New Interactivebroker setting to choose whether historic data contains only regular trading hours, or includes pre/post market data (default RTH only). Seperate setting for intraday backfill.
  • Supports Coinmarketcap's new interface (coinmarketcap have since indicated the interface will be taken offline on December 4)
  • Supports Excel 2019 (Windows).
  • New preference setting for Yahoo to ignore data with 0 volume (default no) Can correct problems with certain exchanges returning data for weekends or holidays.
  • Google removed as historic data source as data is no longer available for download.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.15.26706)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.15.26706
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.15.26706

6.2

24 May 2018
 
  • Updated TDAmeritrade data handling to avoid a crash on certain symbols due to a feed change.
  • New preference setting “Time Reference” under "xlq preferences / data source specific / Intraday preferences” which can be used to modify the intraday times, e.g. if 1 hour intervals based on a 9:30 open etc. are required.
  • New formulae xlqxhOnBalanceVolume + weekly, monthly and intraday versions allowing for the results to be returned based on different types other than close, and to calculate the value into the current market day.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.13.26020)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.13.26020
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.13.26020

6.1

27 March 2018
 
  • Added the possibility for xlq to display a popup message concerning information on some recent event.
    The message will be displayed up to 5 times, unless dismissed and the functionality may be disabled under general preference settings by changing “Enable Information Alerts” to no. As emails are only sent for new major releases and not minor builds, this method can now be used to notify of such updates and possibly other events such as a source outage, a breaking change etc. Messages will be kept to a minimum.
  • CoinMarketCap
    New formula =xlqPriceInBitcoin(), to also return their prices in bitcoin. xlqPrice continues to return the US Dollar value.
    A crash that could occur requesting data from CoinMarketCap has been eliminated.
    Duplicate symbols are now handled by appending a number to those lower on the list
  • Yahoo
    Includes a number of extra checks and routines to clean Yahoo's downloaded data including for European and Asian historic data where their date references are currently incorrect.
    For example Australian day data being referenced as Sunday to Thursday, and monthly as the month before (US symbols return a date of the 1st of the month, Europe and Asia will return the same data referenced as the last day of the prior month). Xlq will now look for the different problems in the data and correct the dates.

    Compatibility change: Yahoo’s old download service returned the Forward Earnings per Share, which was returned via =xlqEarningsPerShare, they also return EPS estimates which they no longer do. Their new service now returns “eps trailing 12 month” and “eps forward”. For this version going forward, “eps trailing 12 month” will now be returned via =xlqEarningsPerShare, and “eps forward” will be returned via =xlqEPSEstCurrentYear.
  • New formulae xlqhAveVolume (+ week and month) has been added, calculated based on the preference settings. To avoid the need to specifically calculate one using the available xlqxh versions.
  • New preference setting for DMI/ADX allowing you to choose the calculation method (weighted (default) or EMA) for the xlqxh calculated versions. A separate preference setting remains for the xlqh versions.
  • This version also includes numerous internal updates as well as updated supporting libraries.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.12.25810)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.12.25810
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.12.25810

6.0

12 January 2018
 
  • CoinMarketCap
    has been added as a datasource.
  • In addition to pricing info, the following new formulae have been added to support their data:
    xlqRank
    xlq24hVolume
    xlqMarketCapVal
    xlqAvailableSupply
    xlqTotalSupply
    xlqMaxSupply
    xlqPercentChange1h
    xlqPercentChange24h
    xlqPercentChange7day
  • xlqMarketCap and xlqMarketCapMkt (which returned results as a string) have been removed and replaced by xlqMarketCapVal, which now returns a numeric value (from yahoo and iqfeed).
  • New xlqCryptoCurrencies.xlsx sample spreadsheet included with install.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.12.25810)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.12.25810
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.12.25810

5.9

28 November 2017
 
  • Interactivebrokers
    Xlq now works with the latest interface to Interactivebrokers and will automatically return delayed quotes if you do not have a real-time subscription. Even though delayed pricing can be returned, to receive historic data / backfill or other values a real-time subscription is still required.
  • Yahoo
    Yahoo day quotes are again available. On November 1 Yahoo stopped their old day quote download service and were initially removed as a source. But it appears that they have developed a new service returning many of the fields that were available previously (although some have been removed). With no information available, there could be changes. As a result, there is now an option in xlq preferences / data source specific / Yahoo to “Enable as day source”, which is set to yes. If set to no, yahoo, as a source for day data would be removed from all processing.

    The formulae no longer supported are xlqShortRatio, xlqDivPerShare, xlqPricePerSales, xlqEPSEstNextYear, xlqEPSEstNextQtr, xlqPEGRatio and xlqEBITDA.
  • A new day and historic source, “<unused>”, has been added which can be used to disable any request. This will allow for example in xlqCompanion to turn off day requests, either as default or per row.
  • A workaround has been included to avoid the problem of #Name when opening an excel file when clicking on a link, caused due to a recent excel update. i.e. when opening via a link, com addins are only being loaded after the workbook is initialized, rather than before as should be the case. For an alternative fix to change the order, or for more info see xlq support
  • The sale of new xlqLite license will stop around the end of the year. Existing xlqLite license will continue to be supported and may be renewed etc.
  • Requires Microsoft Visual C++ 2017 Redistributable (version 14.10.25017)
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017

5.8

21 September 2017
 
  • Yahoo
    Historic:
    Yahoo are now returning split adjusted open, high, low and unadjusted close data (previously this data was unadjusted for splits).
    Due to this change, to keep things standard, the default close returned by Yahoo will now be split adjusted only.
    In xlq preferences / data source specific there is now a new setting to choose to return the dividend adjusted close as xlqhClose (and to be used in calculations).
    There is also an additional setting to now adjust the open, high and low by the dividend adjustment, allowing for the first time to use a dividend adjusted open, high, low and close.
    You must change the settings in xlq preferences to work with yahoo’s dividend adjusted data and any symbols should be deleted so that the data is re-requested.
    Regardless which adjustment is chosen, the original close values are available via xlqhAdjustedClose and xlqhUnadjustedClose.
    Historic data is again available from Yahoo for currencies and Dow indexes.

    Day Data:
    Xlq now requests Yahoo day data using SSL / https.
  • Google
    On September 5 Google removed support for current day price downloads. As a result Google has been removed as a day source.

    A couple of days later Google resumed their service for historic data which will continue to be supported.
    Historic data for mutual funds and currencies is now available via Google via xlqhClose (i.e. not open, high, low)
    Currencies will have the syntax EURUSD:CURRENCY
    And mutual funds as DWUGX:MUTF

    Occasionally Google is missing prices for the close, high, and less often the open, leaving gaps in the data with those prices being 0 which can impact calculations.
    In xlq preferences / data source specific / Google it is now possible to set an option to have those values replaced by the close reducing the impact of the 0 prices.
    If the open is also available the high/low will be set appropriately. This will also modify those values for currencies and mutual funds. The default is to not adjust.
  • TDAmeritrade
    The status view will now be shown if there is no valid login info showing a corresponding message, and xlq will not try to connect until a new id / password has been entered.
  • New formulae: xlqxhOnBalanceVolume as well as weekly, monthly equivalents.
  • In addition for formulae using the Type parameter, 2 new types have been added for Volume (20) and On Balance Volume (21). Using xlqxhFlexAve with OnBalanceVolume will allow for a signal line to be plotted. The OnBalanceVolume type is also available for intraday calculations (There is no intraday formula for On Balance Volume but it can be accessed with xlqxiFlexAve using an sma of 1).
    The updated type list is:
    0 Close
    1 Open
    2 Low
    3 High
    4 Typical Price (high + low + close) / 3
    5 Weighted Price (open + high + low + close) / 4
    6 Rate of Return (%Change)
    7 Range (high-low)
    8 True Range
    9 ATR%
    10 CLOP (close - open)
    11 CLOP% (close - open)/open
    12 HIOP (high - open)
    13 HIOP% (high - open)/open
    14 LOOP (low - open)
    15 LOOP% (low - open)/open
    16 CLLO (close - low)
    17 CLLO% (close - low) / low
    18 CLHI (close - high)
    19 CLHI% (close - high) / high
    20 Volume
    21 On Balance Volume
  • New formulae: xlqhAroonUp, xlqhAroonDown, xlqxhAroonOscillator along with their xlqxh, weekly, monthly and intraday equivalents.
    A sample chart has been added to xlqDemo.
  • Bug Fixes:
    A number of bugs etc. have been fixed, most notably a crash caused when a computer wakes up from Sleep mode.
    Keltner Channels Upper and Lower have been corrected due to an error applying the stddev multiplier.
  • Microsoft Visual C++ 2017 Redistributable (version 14.10.25017)
    This version uses an update to the c++ runtime libraries.
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017

5.7

22 May 2017
 
  • Updated to re-enable Yahoo historic downloads using their new method (requiring https cookie and crumb).
    xlq will only connect for historic data if a valid cookie is returned, avoiding connection errors if any further changes occur
    With the upcoming merger of Yahoo with AOL under the name Oath further breaking changes could be expected, and updates will be posted here.
  • Microsoft Visual C++ 2017 Redistributable (version 14.10.25017)
    This version uses an update to the c++ runtime libraries.
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017
    64bit Microsoft Visual C++ 2017 runtime libraries version 14.10.25017

5.6

20 March 2017 (release 5.6)
14 April 2017 (release 5.61)
 
  • 5.61 Technical update fixing all reported problems found since the 5.6 release. These include
    changes to IQFeed afterhours intraday handling,
    A problem with IQFeed if it was already being used by another program subscribed for the same symbol,
    A problem with xlqhEarliestDate,
    A problem with the Q icon possibly remaining on the task bar after program exit when xlq was started by another program.
  • New formulae: xlqxhFlexAve, xlqxhFlexAveSlope, xlqxhFlexAveIntercept, xlqxhFlexAveStdDev along with their weekly, monthly and intraday equivalents.
    The formulae will calculate different averages on the underlying data (see data types below). The types of averages (specified as a parameter) currently supported are:
    0 SMA
    1 EMA
    2 DEMA (Double EMA)
    3 TEMA (Triple EMA)
    4 TrMA (Triangular EMA)
    5 Wilder Moving Average
    6 Weighted Moving Average
    7 Volume Weighted Moving Average
    8 Hull Moving Average

    A different period range can be specified for the Slope / Intercept calculation.
    A new sheet has been added to xlqDemo.xlsx with more info.
  • Data Types

    In addition to the existing data types:
    0 Close
    1 Open
    2 Low
    3 High
    4 Typical Price (high + low + close) / 3
    5 Weighted Price (open + high + low + close) / 4
    6 Rate of Return (%Change)
    7 Range (high-low)
    8 True Range
    9 ATR%
    These new types can be used with all formulae using the type parameter:
    10 CLOP (close - open)
    11 CLOP% (close - open)/open
    12 HIOP (high - open)
    13 HIOP% (high - open)/open
    14 LOOP (low - open)
    15 LOOP% (low - open)/open
    16 CLLO (close - low)
    17 CLLO% (close - low) / low
    18 CLHI (close - high)
    19 CLHI% (close - high) / high
  • Intraday data handling has been improved.
    It is now possible to work with up to 2000 bars of intraday data. To increase, or reduce the number of intraday bars, change the xlq preference settings.

    Additional 15 and 30 second intervals have been added (backfill available from IB and IQFeed).
    Backfill will now only be requested if supported by source, but is still possible to use interval without backfill.
  • New formula xlqIntraEarliestPeriod, returning the earliest -x reference for the intraday series.
  • IQFeed:
    New formulae:
    xlqBidTime, xlqAskTime for the time of the bid and ask change.
    xlqIsMarketOpen will return 1 if market is open for the symbol, if not 0.

    New IQFeed preference settings:
    “Ignore Pre-market Data” and “Ignore Afterhours Data” to filter the streaming data. There is a separate parameter for backfill data.
  • InteractiveBrokers:
    Implied Volatility now stored with Greeks if “Keep Last Greeks” Specified in xlq preferences
  • TDAmeritrade:
    New preference settings to apply a filter to market and/or backfill data limiting data to certain hours (to exclude pre or post market data).
  • The xlqPseudoHist… formulae allowing to store a small series of historic data built from day data while xlq is running, previously available for Yahoo, can now also be used with Google if activated in xlq preferences.
  • Other optimizations, changes and fixes. Help file and xlqDemo updated.

5.5

17 October 2016
 
  • Following the large number of changes to 5.4, this version, based on feedback, concentrates on tuning and stability. Many changes are internal, but include the following:
  • Improved on control key handling.
  • Fixed problem with xlqfxstatic when using 0 date or when used with aaii.
  • Fixed problems with COM interface introduced in 5.4.
  • Fixed crashes based on crashreports.
  • InteractiveBrokers:
    Fixed problem working with WAR (warrant) or CMDTY data types.
    Detects when tws shuts down and can re-connect automatically. Also detects when tws updates to new version and handles accordingly.
    Now possible to reset the connection with Interactivebrokers from the IB day status view.
    New xlq preference setting to “Keep last Greeks” from one trading session to the next, i.e. during the time that they are not provided by IB.
  • Improved handling of the IQFeed data stream.
  • Supports recent changes with Yahoo and handles new messages.
  • Improved handling of xlqCompanion column settings ensuring changes made to the different views are always stored, and the settings for view 1 are always stored with the data.
  • Xlq stock manager column settings now unique per source.
  • Row headers will now automatically resize to show the full row number.
  • Fixed problem with formulae using the type parameter (other than 0 (close) when the underlying data is refreshed (left overnight, or selected from menu).
  • Microsoft Visual C++ 2015 Redistributable Update 3 (version 14.0.24212)
    This version uses an update to the c++ runtime libraries.
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2015 runtime libraries version 14.0.24212
    64bit Microsoft Visual C++ 2015 runtime libraries version 14.0.24212

5.4

24 June 2016
 
  • A major update with redesigned excel cell updating to make better use of the bridge:
    - Making this the fastest xlq yet. (e.g. a test with over 500,000 data points refreshes over 6 times faster.)
    - Memory usage has also been considerably reduced.
    - Can now detect and fix the most common issues with addins and the bridge.
  • New formula for True Strength Index:
    xlqhTrueStrengthIndex, xlqhTrueStrengthSignal and xlqhTrueStrengthHistogram, along with xlqxh and intraday versions.
  • New formula for Up Down Volume Ratio:
    xlqhUDVR and xlqhUDVRSlope, along with xlqxh and intraday versions.
  • New formula for Symbol Count (day sources):
    xlqSymbolCount will now return the number of symbols that are currently active.
    xlqUninitializedSymbolCount will return the number of symbols for the source that have not yet received any data from the feed. When a connection with a streaming feed is reset the count will again include all the symbols until re-initialized.
  • Possible to reset the IQFeed or TDA streaming feed using xlqdelete with special parameters:
    =xlqDelete("RESETCONNECTION","IQFEED" or "TDA").
  • IQFeed:
    Xlq now supports IQFeed’s new microsecond protocol and would require IQConnect 5.2 or later
    Excel cannot display microseconds, but it is possible to view the milliseconds by formatting the cell with .000 e.g. dd-mm-yy h:mm.ss.000.
    Stream handling has been redesigned to be faster and handle a lot more data, ensuring no lag, even when streaming 1800 active symbols with intraday calculations.
  • InteractiveBrokers:
    The interface with InteractiveBrokers has been updated to use their POSIX interface which has been customized to ensure better handling of Greeks.
    New preference setting “ignore pre-market data”.
  • TDAmeritrade:
    Processing has been optimized and a problem which could cause a crash has been fixed.
  • AAII:
    Support for AAII Stock Investor Pro 4.5 with the following new fields:
    Dividend Total Q1-Q8, Y1-Y7 and 12m
    EPS Diluted Normalized Q1-Q8, Y1-Y7 and 12m
    Shares Diluted Q1-Q8, Y1-Y7
  • Accessibility:
    Improvements have been made to xlq and xlqCompanion making them more friendly for use with screen readers (such as window-eyes) for the blind or visually impaired.

    Overall keyboard support has been improved:
    - In the stock manager ctrl-tab (and ctrl-shift-tab) may be used to move between tabs, and when ctrl-enter is pressed the day view or historic view will be displayed for the symbol on the active row. (alt tab will again set focus to the stock manager). Pressing ctrl-I will display the intraday view and activate the symbol.
    -Ctrl-M will display the mouse menu.
    -Ctrl-R will refresh the display
    -Ctrl-S will show the add symbol dialog.
    -Standard windows shortcuts such as ctrl-c, ctrl-a will also work.
    -support for Ctrl-M, ctrl-R and ctrl-S are also available from the other grid views, with ctrl-tab being available when there are tabs for different views etc.

    -From the status view, the following shortcuts have been added:
    -Ctrl-Tab, ctrl-shift-tab will move through the different status views.
    -Ctrl-D will clear the contents of the current log.
    -Ctrl-L will select all the contents from the current log and copy it to the clip board.
    -Ctrl-P will pause the updating of the logs.
    -Ctrl-R will reset the connection (when on the TDA or IQFeed day status view).

    From the Day list view Ctrl-Enter and Ctrl-I will now also display the day view and intraday view for the selected symbol.
  • #Busy is now shown when a symbol has been requested but no data has yet been received from the source.
  • Help file and sample spreadhseets have been updated (Demo Spreadsheets are now .xlsx and no longer .xls).
  • Microsoft Visual C++ 2015 Redistributable Update 2 (version 14.0.23918)
    This version uses an update to the c++ runtime libraries.
    The install process will check if they are present, and if not, will download and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2015 runtime libraries version 14.0.23918
    64bit Microsoft Visual C++ 2015 runtime libraries version 14.0.23918

5.3

16 October 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 =xlqFx as alternative wrapper for working with formulae.
    - New =xlqFxStatic, 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 and install them first. In such a case the installation process will require an internet connection and a reboot.
    Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

    If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you may install them first from here:
    32bit Microsoft Visual C++ 2015 runtime libraries version 14.0.23026
    64bit Microsoft Visual C++ 2015 runtime libraries version 14.0.23026

5.2

24 February 2015 (release 5.2a)
13 February 2015 (release 5.2)
 
  • 5.2a release (24 February 2015)
  • Corrects a problem in 5.2 that could cause symbols to be dropped from the real-time stream when using TDAmeritrade.
  • 5.2 release (13 February 2015)
  • Redesigned processing of xlqxh formulae. If you have very large workbooks, or rely heavily on many xlqxh.. calculations opening and refresh times of large workbooks can be reduced by as much as 70%.
  • Google has been added as a day source providing real-time snapshot quotes and supports the following formulae:
    - xlqName
    - xlqPrice
    - xlqTradeTime
    - xlqChange
    - xlqChangePercent
    - xlqPreviousClose
    - xlqOpen
    - xlqHigh
    - xlqLow
    - xlqVolume
    - xlqAverageVolume
    - xlqTypicalPrice
    - xlq52WeekLow
    - xlq52WeekHigh
    - xlqMarketCap
    - xlqPricePerEarnings
    - xlqBeta
    - xlqEarningsPerShare
    - xlqSharesOutstanding
    - xlqInstitutionalPcnt
    - xlqSecurityType
    - xlqExchange
    - xlqDividendAmount (only retrievable when market is not open)
    - xlqYield (only retrievable when market is not open)

    Various markets are covered (no currencies, no options).
    Symbol can be used as AAPL, or with the exchange i.e. AAPL:NASDAQ.
    If there is a symbol conflict, the exchange would need to be supplied, i.e. ADT:NYSE instead of ADT.
    Same applies for indexes e.g. Dow Jones can be .DJI or .DJI:INDEXDJX
    and international exchanges, Danske Bank Copenhagen will be DANSKE:CPH, Deutsche Telecom Frankfurt will be DTE:FRA etc.
    Mutual funds would use :mutf, e.g. PRGFX:MUTF
    More information on exchange can be found here: http://www.google.com/intl/en/googlefinance/disclaimer/ or https://www.google.com/finance.
  • MSN has been removed as a source. Due to MSN no longer provides any download data and removing all such services from their site MSN is no longer a valid source.
  • TDAmeritrade data handling has been improved, especially for options, and adding symbols to an existing stream.
  • Updated YAHOO to reference new historic servers.
  • Numerous internal changes and bug fixes.
  • xlqDemo.xls and help have been updated.

5.1

21 December 2014
 
  • New formulae for Keltner Channels, xlqhKeltnerChannelsLower, xlqhKeltnerChannelsMiddle, xlqhKeltnerChannelsUpper allowing you to specify the Number of Periods, Number of ATR periods, multiplier and whether the calculation uses an EMA or SMA. + xlqxh..., weekly, monthly and intraday versions.
  • New formula supporting the Vortex Indicator, xlqhVortexPositive and xlqhVortexNegative + xlqxh..., weekly, monthly and intraday versions.
  • New intraday formulae for the following:
    - xlqxiSlope
    - xlqxiLSMA
    - xlqxiMaxLSMA
    - xlqxiDMIpositive
    - xlqxiDMINegative
    - xlqxiDX
    - xlqxiADX
    (available in earlier versions as historic only)
  • Added 3 new types (7,8,9) that can be used in the different formulae accepting the parameter, making the list of types as follows:
    0 Close
    1 Open
    2 Low
    3 High
    4 Typical Price (high + low + close) / 3
    5 Weighted Price (open + high + low + close) / 4
    6 Rate of Return (%Change)
    7 Range (high-low)
    8 True Range
    9 ATR% (x day ATR as specified in preferences as a % of the last periods close).
  • New formula xlqhATRPercent being an x day ATR as specified in preferences as a % of the last periods close, also used as the Type 9 in supported formulae. + xlqxh..., weekly, monthly and intraday versions.
  • New formula xlqxhMean, returning an sma for any of the above Types for the number of periods specified + weekly, monthly and intraday versions.
  • New range formula xlqrhMean, as above but specifying start and end period.
  • New formula xlqxhRateOfReturn, complimenting xlqrhRateOfReturn, returning the %change for the number of periods + weekly, monthly and intraday versions.
  • Add 2 new fields / columns to xlqCompanion allowing for the entry of a 2nd custom text and value, along with the possible to change the description in xlqCompanion preferences.
  • Possible to display the Q menu when xlq is active by pressing Alt-Ctrl-Shift-Q.
  • Changes the xlq preference setting ”Data Retrieval Defaults” / “Number of Days” to accept values greater than 999, allowing for a much larger value to be specified, to have all available data for a symbol be downloaded on the first request.
  • Numerous internal changes.
  • xlqDemo.xls and help have been updated.

5.0

17 March 2014
 
  • New reverse calculation formulae xlqxhReverseRSI and xlqxhReverseConnorsRSI returning the price needed to obtain the specified RSI/CRSI target (as well as xlqxi intraday versions).
  • New formula supporting Connors RSI, i.e. xlqhConnorsRSI, xlqxhConnorsRSI + weekly, monthly and intraday versions.(for more info: ConnorsRSI-Pullbacks-Guidebook.pdf).
  • New formula for Streak, i.e. returning the number of consecutive up or down periods, i.e. xlqhStreak, xlqxhStreak + weekly, monthly and intraday versions.
  • May calculate the streak on the following types: 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return (% change).
  • New 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.
  • May calculate the PercentRank on the following types: 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return (% change).
  • New 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).
    xlqxh version allows you to also specify the following types: 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return (% change).
  • New formula for Fractal Dimension Index, i.e. xlqhFractalDimension, xlqxhFractalDimension + weekly, monthly and intraday versions. (for more info: http://en.wikipedia.org/wiki/Fractal_dimension).
    xlqxh version allows you to also specify the following types: 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return (% change).
  • 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.
  • Numerous bug fixes, including the following:
  • Fix 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.
  • Fix a problem with re-retrieval of Yahoo data after a dividend adjustment has been detected.
  • Fix 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.

4.9

20 August 2013 (release 4.92)
9 August 2013 (release 4.91) / updated 12 August 2013
24 June 2013 (release 4.9)
 
  • 4.92 release (20 August 2013)
  • Various updates and tuning to ensure compatibility with the recent changes at msn and yahoo.
  • including an important fix removing a memory leak (and possible crash) when handling the new msn processing.
  • 4.91 release 2 (12 August 2013):
  • Fixes a problem where yahoo historic data could be flagged N/A if earlier data than is available is requested.
  • 4.91 release (9 August 2013)
  • Support changes to MSN Historic data. On June 28th MSN stopped updating their existing historic data system. Since then they have introduced a new service covering only weekly data. This service, covers less historic periods, less symbols and does not contain data for the last partial week. xlq 4.91 covers these changes, allowing for this weekly data to be used via excel/com and removes msn as a source for historic day/month data. xlqCompanion no longer supports msn as an historic source.
  • More fault tolerance has been added for msn (current) day data to avoid valid symbols being marked as invalid.
  • Each source has had their own date system for week and monthly dates, 4.91 now standardizes across each source using the Monday date for week data and the 1st for monthly date. This is the best date as previously some queries using real dates could have returned the prior week/month data instead. Also this eliminates problems where weeks or months sometimes had more than one date entry for the same period. The exception to this is InteractiveBrokers weekly data as their weekly data is returned over a 7 day period rather than a calendar week.
    Due to the changes in this version, the installation will automatically remove the market data files to ensure all the data is correctly retrieved in the new format.
  • 4.9 release (24 June 2013)
  • Support for the new MSN. On June 19th MSN rolled out a new version of their web site, making the old connection for day data incompatible. The functionality has been restored, and all known issues solved. If other issues are found, or other changes are made to the site over the next weeks, new updates will be made available from the site. Note that the changes not only impact the connection, but also symbols. Currency and options symbols have changed as well as some indexes.
  • Support for IQFEEDs new millisecond precision (requires IQConnect 5.0.0.13). It is now possible to view the trade time (last trade, intraday tick data etc.) with millisecond precision. In excel this can be done by formatting the time cell with an extra .000 e.g. dd-mm-yy h:mm.ss.000. The xlqDay view and Intraday view will also show the millisecond time for iqfeed.
  • For IQFeed and Interactivebrokers there is now an option where you can specify an earlier time for historic updates. This allows for the historic data to be downloaded and used prior to midnight EST. The option would need to be enabled in xlq preference / data source specific / IQFeed or InteractiveBrokers. The “Historic Update Time” can be specified in local time, or EST, and for practical reasons should correspond with a time between 5pm and midnight EST.
  • New formula xlqhRateOfReturn (+ week and month version) being (close – prior close)prior close *100
  • New Formula xlqrhRateOfReturn (+ week and month version), being the rate of return between the start and end dates specified.
  • Changed xlqxhStdDev to also use a type of 6 to return the stddev of the rate of return,
    i.e. 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return
    Certain other formulae using calculations on the different types can also use the new type 6, the DrawUp/Down formulae, and Kauffman Efficiency Ratio
  • New Formula xlqrhStdDev (+week and month versions), allowing for the calculation of a stddev given a start and end date rather than a number of periods.
    For types: 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price, 5 = weighted price, 6 = rate of return
  • New formulae supporting the Trix indicator, i.e. xlqhTrix, xlqhTrixTrigger and xlqhTrixHistogram. Settings can be changed in xlq preferences with the default being a 15 day Trix and 9 day Trigger.
    xlqxh (+ week and month) versions of the Trix, TrixTrigger and TrixHistogram allowing for the periods to be specified in the formulae as well as
    xlqxhTrixDbMA, returning the partial calculation of the trix, i.e. the double ema (ema of ema) and
    xlqxhTrixTrMA, returning the partial calculation of the trix, i.e. the triple ema (ema of double ema) xlqxi…
    (intraday versions of the Trix formulae)
  • Thanks to the crash reports sent (included in 4.8), a number of crash situations have been detected and eliminated.
    Problems were also found and corrected which could have caused TDA and IQFeed to stop updating..
  • XLQ can now solve many situation which used to cause #xlq to be shown in excel.
  • Improve load speed on large spreadsheets.
  • XLQ will now detect the version and platform of excel during installation warning if there is an incompatibility. Also in xlq’s general status view, the version and platform of excel will be shown.
  • Various other changes.
  • xlqDemo.xls and help have been updated

4.8

15 January 2013
 
  • XLQ is built with supporting libraries for Windows 8 and Office 2013.
  • XLQ is now (also) completely 64 bit.
    xlq is available as 3 different downloads
    - 64 bit for users working with a 64 bit version of excel (also includes the 64 bit data engine, xlqCompanion etc.) on windows Vista and later
    - 32 bit for users working with 32 bit versions of excel on windows Vista and later.
    - XP Version (32 bit only) only for users working with windows XP. It contains the same functionality, but without requiring newer features found only in more recent versions of windows.
    (for further info please read the support page )
  • xlq now includes crash reporting:
    If xlq does crash you may now choose to send a crash report, which may help to determine the problem and make xlq more robust. These reports (which also allow you to include additional information) have already helped eliminate some rare crashes that have not been possible to replicate to date.
  • Increase amount of data returned by intraday backfill from InteractiveBrokers to maximum request limits (maximum in xlq 1000 bars)
    hourly bars increased to 34 days (roughly from 240 to 460 bars including afterhours)
    30 minute increased to 34 days (roughly from 500 to 910 bars including afterhours)
    15 minute increased to 20 days (1000 bars including afterhours or 500 market hour bars)
    5 minute increased to 10 days (from 695 to 1000 bars afterhours or 700 market hour bars)
    2 minute increased to 7 days (1000 bars including afterhours or 800 market hour bars)
    1 minute will return 1000 bars.
  • new formula xlq1YTargetPrice has been added returning the value from Yahoo.
  • New historic and intraday formulae for Parabolic SAR xlqhPSAR. xlqxhPSAR, xlqxiPSAR, and weekly monthly versions.
    xlqhPSARLongShort (etc.) will also return 1 or -1 indicating the direction.
  • New historic and intraday formulae for Force Index xlqhForceIndex. xlqxhForceIndex, xlqxiForceIndex and weekly / monthly versions.
  • New formula for Yahoo historic data xlqhAdjustedClose (xlqhwAdjustedClose, xlqhmAdjustedClose)
    Xlq already returned the xlqhUnadjustedClose, and allowed for the calculations to use either the adjusted close (default), or the unadjusted. When the unadjusted close was used for calculations (and xlqhClose) it was no longer possible to see the adjusted close. xlqhAdjustedClose now allows this. All historic yahoo data should be deleted and re-retrieved to populate the value correctly.
  • Fixed a problem with xlqxh formulae where they may not be recalculated if earlier data was requested, also resulting in #range being incorrectly shown.
  • Fixed a problem with xlqxi formulae not calculating correctly after backfill data was requested, especially concerning calculations depending on volume, open, high and low for new bars.
  • Improved excel processing when making many changes to the underlying data being requested
  • Include additional pacing violation checks for InteractiveBrokers as well as additional error logging
  • (InteractiveBrokers) Fix problem where certain symbols such as currencies would return the current days data included in historic.
  • xlq now uses NTP (Network Time Protocol) to work with exact times, and no longer http services.
  • new general status view has been added, currently showing the exact time.
  • Various other changes.
  • xlqDemo.xls and help have been updated

4.7

17 September 2012 (release 4.72)
2 August 2012 (release 4.71)
2 July 2012 (release 4.7)
 
  • 4.72 Release (17 September 2012)
  • Updated for compatibility with IQFeed,
    Fixes a bug in xlq which could cause xlq to crash when connecting with iqfeed. The problem started today after an update at iqfeed.
  • 4.71 Release (2 August 2012)
  • Updated for compatibility with Yahoo historic data,
    Yahoo has begun including the current partial days data in their historic download data, offsetting date references by 1. This version will now detect this when the data is retrieved.
  • 4.7 Release (2 July 2012)
  • Support for AAII's Stock Investor Pro 4.0 (http://www.aaii.com/stock-investor-pro/whatsnewinsipro4)
    with over 30 new fields including next dividend payment, ex-dividend and payment date:
    - Buyback Yield
    - Buyback Yield-1 year ago
    - Buyback Yield-Average 3 years, 5 years, 7 years
    - Buyback Yield Y1-Y7
    - Common Dividends Paid 12m, Y1-Y7
    - Common Dividends Paid Q1-Q8
    - Depreciation and Amortization 12m, Y1-Y7
    - Depreciation and Amortization Q1-Q8
    - Dividend-Ex Date
    - Dividend-Next Quarter
    - Dividend-Pmt Date
    - Earnings before interest and taxes (EBIT) Q1-Q8
    - Earnings before interest and taxes (EBIT) 12m, Y1-Y7
    - EBITDA 12m, Y1-Y7y
    - EBITDA Q1-Q8
    - Enterprise Value Q1-Q8
    - Enterprise Value Y1-Y7
    - Enterprise Value/EBITDA
    - Enterprise Value/EBITDA-1 year ago
    - Enterprise Value/EBITDA-Average 3 years, 5 years, 7 years
    - Enterprise Value/EBITDA-Y1-Y7
    - EPS Est Q0-Exp Rep Date
    - EPS Est Q1-Exp Rep Date
    - Market Cap (Historical) Q1-Q8, Y1-Y7
    - Minority Interest Q1-Q8
    - Minority Interest Y1-Y7
    - Retained Earnings Q1-Q8
    - Retained Earnings Y1-Y7
    - Shareholder Yield
    - Shareholder Yield-1 year ago
    - Shareholder Yield-Average 3 years, 5 years, 7 years
    - Shareholder Yield-Y1-Y7
    - Working Capital Q1-Q8
    - Working Capital Y1-Y7
    - Z-Score Q1-Q8, Y1-Y7
  • aaiiDemo.xls has been updated

4.6

14 May 2012
 
  • Historic data processing has been redesigned to be more efficient. As a result data files from prior versions are not compatible, and will be deleted upon detection. The new data files will be populated as new requests are made. Improvements include:
    - Faster processing.
    - More efficient disk writing reducing locking and possibility of any data corruption.
    - Better in-memory management of the data.
    - Proper sorting of historic symbols.
    - Eliminate midnight crash that occurred for certain users.
  • Complete rebuild of IQFeed processing to be much more efficient, both in terms of speed and resource usage.
  • Can now reset the IQFeed connection in xlq status view (iqfeed day).
  • Improve TDA data feed handling.
  • Can now change the IB port in xlq preferences. Allowing for simpler management connecting to the IB gateway, or when using multiple instances of TWS.
  • New historic formulae xlqhPPO (Percentage Price Oscillator) xlqhPPOTrigger, xlqhPPOHistogram as well as support for weekly, monthly and xlqxh versions.
  • New Intraday formulae xlqxiPPO, xlqxiPPOTrigger and xlqxiPPOHistogram.
  • New Intraday formulae xlqxiMACD, xlqxiMACDTrigger, xlqxiMACDHistogram
  • New xlqDelete and xlqhDelete formulae allowing for the deletion of a symbol in xlq via COM, VBA, or an excel cell. For use by more experienced users.
  • TDA will now return “OPTION” via xlqSecurityType for options, and will also return xlqStrike and xlqExpirationDate.
  • New formula xlqIsShortable. Will work with TDA and IB with return values 0,1,2,3 with the following meaning:
    . 0 is not shortable,
    . 1 (TDA) will return 1 if it is shortable,
    . 2 (IB) The contract will be available for short sale if shares can be located
    . 3 (IB) There are at least 1000 shares available for a short sale
  • New formula xlqTypicalPrice calculated in realtime being the (High+Low+Last)/3. For historic series, xlqhTypicalPrice can now be used with a 0 date to return the current day’s Typical Price.
  • New formula for IQFeed xlqTickID, which is a unique ID for the returned tick data.
  • xlqSpread and xlqRange now return results for TDA / IB.
  • Correct xlqxh/xlqxiStdDev and BollingerBand formulae to use n-1, and not n.
  • Fix message frequency errors in IB
  • TDA can now work with symbols such as HLM-
  • Yahoo (Australian .AX symbols): xlq will no longer include them in checks to ensure the last trade time is more recent than what has already been retrieved. This is due to the returned trade times being in EST, but the date being local…
  • Due to MSN restricting historic access after 200 requests, xlq now has a built in limit of 200 symbols (day + week + month) for msn historic data.
  • Various other changes.
  • Documentation and xlqDemo.xls have been updated.

4.5

16 November 2011 (release 4.51)
25 August 2011 (release 4.5)
 
  • 4.51 Release (16 November 2011)
  • TDA - Ensure compatibility with historic data, fixing historic dates being offset by 1.
  • IB - Ensure compatibility with TWS versions greater than 920.5
  • IB - Handle IB historic data pacing limits (not more than 60 historic requests in a 10 minute period). If limit reached xlq will continue additional requests after 10 minutes. Does not impact streaming data.
  • 4.5 Release (25 August 2011)
  • TDAmeritrade (TDA) supported as a new data source.
    - Streaming real-time data for US equities and options.
    - Historic and intraday 1 minute backfill data for equities.
    - up to 600 symbols.
    - Market Data is free for (non-professional) TDAmeritrade Account Holders. - No monthly data fees or maintenance costs.
    - Option symbol syntax is symbol_MMDDYY(C or P)Price e.g. msft_071611C30 (or with decimal 30.5).
    - Includes data such as ex-div date, dividend amount, open interest, Delta, Gamma, Vega, Theta, Rho.
    - New status views for TDA, with possibility to reset connection.
  • New filter added for Yahoo data:
    eliminates the problem where price updates have been interlaced with older recent quotes. Xlq will now only update a quote if the trade date/time is more recent than the last one stored locally.
  • Add new day formulae xlqPseudoHistOpen/Close/High/Low/Volume/Date, and an option in xlq preferences (under yahoo specific) to enable the functionality. Reserved for yahoo as the source, if enabled, xlq will record a log for 5 days for the related values. This can be useful when xlq is run frequently and the historic data for the symbols are not always available at market open (notably for Asian and some European markets), or for symbols that do not have any historic data from Yahoo
    The reliability of the data would depend on xlq being run around market close to record the data.
    xlqPseudoHistDate also returns the time of the data.
    Xlq Com interface has new function (xlqDayData1) to support xlqPseudoHist… formulae.
  • Add xlqDelta, xlqGamma, xlqVega, xlqTheta supporting option quotes from IB and TDA.
    In addition TDA also supports xlqRho.
    Implied Volatility now shown for IB options.
  • xlqCompanion will now show a red Q overlay in windows 7 task bar when alert is active.
  • Improved grid scrolling and editing when using the keyboard. (e.g. entering a cell now keeps it original contents. Can now press tab (or shift tab), cursor keys to end editing).
  • Support for new AAII Stock Investor Pro fields covering net current assets per share, relative earnings growth, relative price strength etc. aaiiDemo.xls has been updated.
  • From the status views, new option to delete the contents of a log.
  • Built with latest c++ and supporting libraries.
  • Yahoo-eu and yahoo-uk are no longer supported as day sources. Yahoo no longer has separate links for these, and the same data may be accessed via yahoo.
  • Modify xlqExDividendDate, xlqDividendPayDate and xlqDaysToExpiry to always return values and no longer text (**possible compatibility issues if you have been parsing the text**).
  • Various other changes.
  • Documentation, xlqDemo.xls and aaiiDemo.xls have been updated.

4.4

8 July 2011 (release 4.4.8)
25 May 2011 (release 4.4.7)
3 March 2011 (release 4.4.6)
8 November 2010 (release 4.4.5)
...
9 September 2010 (pre-release 4.4.1)
 
  • 4.4 release 8 (18 July 2011)
  • Fixes a data issues caused by an apparent faulty server at Yahoo by filtering of the garbage data, indicated by a message in the status view. Problems include garbage data, 1970 trade dates, xlq not closing on exit and high cpu usage.
  • 4.4 release 7 (25 May 2011)
  • Re-establishes processing of msn day data (which stopped processing on 24 May after an msn update)
  • 4.4 release 6 (3 March 2011)
  • Technical update addressing changes and compatibility issues with different data sources
    - Addresses different issues due to recent changes at Yahoo which could lead to corrupt data, symbols not updating, and program hangs. Due to the changes aliases are no longer supported. If you are using an alias you would need to replace it with the underlying symbol, e.g. brkb with brk-b or ^spx with ^gspc.
    - Address issues with msn where symbols could be invalidated due to minor server outages.
    - Compatibility changes with iqfeed.
    - better mouse support when using the views in xlq / xlqCompanion.
  • 4.4 release 5 (8 November 2010)
  • Corrects all reported issues to date, including
    - problem when using google with xlqxh formulae and 0 date as no day source, now invalidates.
    - updated database handling.
    - Allow correct copying from xlq to excel for countries using space as thousands separator. Space is now removed during copy to ensure pasted values are not treated as text.
    - changes to msn day data processing with improved validation.
    - update iqfeed processing to improve connection and avoid timeouts.
    - Interactivebrokers- when using currency data from IB for Ideal and IdealPro no last price is returned from IB. xlq will now show last bid as last price, allowing for intraday calculations.
  • Pre-release 4 update (4 October 2010)
  • - problem with selection when copying from xlq/xlqCompanion to other applications.
    - row not remaining selected after being moved in xlqCompanion
  • Pre-release 3 update (21 September 2010)
  • - resolves #xlq in excel in certain installations.
    - eliminates a possible crash when using the stock manager.
    - status view splitter was not always visible
  • Pre-release 2 update (14 September 2010)
  • 4.4 supports display and input of values based on windows settings (e.g. with , as decimal). This update corrects issues when entering fractions and ensures all values have the same formatting.
  • Pre-release 1 (9 September 2010)
  • Fixes data issues with Yahoo starting September 8 when requesting data for the symbol ^dji causing an invalid response and the whole data request to be rejected. New messages in status view, and symbols marked as not available shown in red in the stock manager.
  • XLQ 4.4 is a major update starting with the rebuilding of all projects and libraries from scratch, eliminating numerous old libraries and replacing and rebuilding a lot of the existing code. At the same time xlq /xlqCompanion now works with a new grid technology and provides an improved interface. It is also built with the latest version of c++ (as a result windows 2000 is no longer supported, windows XP or later is required).
  • New grids for all views allowing for the possibility to drag and drop columns, including to and from a field chooser (on the toolbar), allowing to sort by multiple columns, with a single click, etc. etc.
  • Add rsi intraday formulae (xlqxiAveGain, xlqxiAveLoss, xlqxiRelativeStrength, xlqxiRSI).
  • For bollinger bands, you can now enter a multiplier as xxx, e.g. 2 will be 2, 12 (and 112) will be 1.2, 108 will be .8, which will allow for fraction only multipliers.
  • Add Kaufman Efficiency Ratio (xlqhKaufmanER) as well as weekly, monthly, intraday and xlqxh versions.
  • Add 46 new aaii fields to xlq, notably Period Type (Q+Y) Update Type (Q+Y) and Depreciation and Amortization (cash flow) (Q+y+12m)
  • Stock Manager - fix problems with bulk deletes, also can now right click top left cell to both select all cells and display the menu
  • Redesigned add symbol dialog and status views.
  • Old style registration codes (with serial number) can no longer be entered. If you are using one, contact me for a compatible registration code.
  • If using iqfeed, requires latest iqfeed client (4.7.1.3).
  • xlqCompanion has been totally rebuilt. At the same time some new features have been added, such as:
    - moving, copying, cutting multiple rows.
    - Multiple views, the first is as before unique to each grid, with the other 3 being common for all grids.
    - Possibility to now include blank lines
    - New grid with drag / drop column selection, possibility to sort multiple columns
  • Documentation, xlqDemo.xls and aaiiDemo.xls have been updated.

4.3

23 April 2010 (release 4.32)
27 January 2010 (release 4.31)
5 January 2010 (release 4.3)
 
  • 4.32 release (23 April 2010)
  • Support for Microsoft Excel 2010 64 bit.
  • 4.31 release (27 January 2010)
  • Update to address changes related to each data sources implementation of new option symbols.
    For more details on the new formats please look at the FAQ
  • 4.3 release (5 January 2010)
  • This version contains numerous changes concentrating on performance and stability.
    (directly working and testing with a number of users since the release of 4.2, this version addresses various issues and changes have been made offering a notable improvement in speed, stability and interaction).
    Certain users have reported processing and / or calculation times reduced by more than half.
  • xlqxh... calculations have been moved to background processing. This offers improved opening times and interaction with excel. While calculations are still being performed, the results in excel will show #xlqcalc, the center of the Q will remain red, and messages will be displayed in the xlq status views showing how many calculations still need to be done, with excel being refreshed on completion
  • New status views for day data. Backfill status messages will now show how many symbols still need processing
  • Supports Microsoft Excel 2010 32 bit

4.2

20 October 2009
 
  • Changes to historic data management initiated over the last few versions have been finalized, allowing for numerous improvements including faster processing and access, reduced memory overhead and overall optimized performance.
    (As a result the historic data files have changed, and the old data is no longer compatible and will not be converted to the new version. Any data required will be automatically re-retrieved. All personal data files, excel spreadsheets and xlqCompanion remain compatible)
  • New data specific historic formulae (week and month data also supported):
    - InteractiveBrokers: xlqhNoOfTrades, xlqhWAP (weighted average price)
    - IQFeed: xlqhOpenInterest
    - Yahoo: xlqhUnadjustedClose
  • Support for US market historic data (day and week) from Google. If there is a symbol conflict with a non US stock, the symbol needs to include the exchange, e.g. CA needs to be entered as NASDAQ:CA, BSX as NYSE:BSX.
  • xlqintra... intraday data are now based on timed intervals.
  • Interactivebrokers (IB) intraday backfill has been improved, also backfill messages are now shown in the status view.
  • xlqName now returns name from IB.
  • IB: xlqExpirationDate, xlqDaysToExpiration and xlqStrike now return values for future options.
  • Much faster processing of IQFeed data, including better backfill handling.
  • Supports IQFeed client 4.6.1.0.
  • Allows limiting of intraday backfill data from IQFeed to specific hours, such as market hours or including 1 hour pre/post market etc.
  • IQFeed related formulae xlqExtTradingLast and xlqExtHoursChange have been removed and replaced with xlqMarketHoursLast and xlqMarketHoursChange. xlqPrice and xlqChange will now show both market and non market hours trades. During afterhours xlqExtTradingDifference will show the difference between the last market hours trade and the last afterhours trade.
  • New status view for iqfeed day data (intraday backfill).
  • Supports Windows 7.
  • Signed with new digital certificate.
  • Numerous other changes.
  • Documentation and xlqDemo have been updated.

4.1

30 April 2009 (release 4.11)
14 April 2009 (release 4.1)
 
  • 4.11 release (30 April 2009)
  • Fixes all reported problems since the release of xlq 4.1, including:
    when using custom file paths with no ending /.
    when using very long symbols.
    when deleting symbols in the stock manager.
    with data retrieval with certain preference settings modified.
    when using COM interface function xlqHistValue4.
  • 4.1 release (14 April 2009)
  • 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.

4.0

13 November 2008
 
  • The fastest version of xlq by far. This version introduces the new core to xlq's data processing engine allowing for much faster updating and simultaneously reducing processing and resource requirements. All processing via Excel, xlqCompanion and xlq's com interface are improved
  • The fastest Excel processing by far (see new videos). xlq's excel interface has been optimized allowing xlq to provide almost streaming updates. In addition to faster updating and processing, xlq allows for faster recalculations, reduced delays, including faster opening and closing of spreadsheets.
  • Automatic smart updating of US and Canadian symbols from non-streaming data sources. xlq will only update data as it is changing, avoiding unnecessary updates afterhours. Update settings have also been changed to offer better performance with less bandwidth usage.
  • Built with the latest c++ and supporting libraries from Microsoft (as a result xlq will no longer work with versions of windows earlier than Windows 2000)
  • New formulae xlqhWeightedPrice (+ week and month versions), being (O+H+L+C)/4
  • New BollingerBands formulae xlqhBollingerBandsUpper, Middle, Lower, B, and Width (+ week and month versions)
  • Xlqxh versions of the BollingerBands formulae allowing multiple period ranges as well as calculations into the current day
  • xlqxi versions of the BollingerBands formulae for intraday calculations.
  • Bollingerbands may be calculated on close, open, low, high, typical or weighted price.
  • Can calculate a bollingerband on a fractional stddev multiplier such as 2.1.
  • New preference settings for bollingerbands, defaults are 20 periods, 2 stdDev multiplier, using weighted price.
  • Lsma and drawdown/up may now also be calculated on weighted price.
  • New xlqxhStdDev and xlqxiStdDev to calculate a standard deviation over a number of periods (close, open, low, high, typical or weighted price may be used)
  • New range formulae (allowing you to specify the date range as real or relative dates and not number of periods) for the following:
  • xlqrhTotalVolume (+w+m) being the sum of the volume for the specified periods e.g. =xlqrhTotalVolume("msft",-6,-2)
  • xlqrhAveVolume being the average for the specified periods.
  • Tested and fixed compatibility issues with Vista 64. (xlq runs as 32 bit)
  • Modify to use long InteractiveBrokers symbols such as for corn future options, e.g. “C OZC MAY 09 4300[ECBOT,FOP,USD]”
  • Ensure compatibility with InteractiveBrokers TWS version 888
  • Signed with new digital certificate.
  • Fixed problem where excel could hang on exit
  • Fixed a problem where xlq would not save day data on exiting if started by another program
  • Numerous other changes.
  • Documentation and xlqDemo have been updated.

3.9

2 May 2008
 
  • 18 formulae covering Stochastics %k and %d (Fast, Slow and Full) for day, week and month.
  • xlqxhStochastic... formulae allowing multiple period ranges as well as calculations into the current day.
  • xlqxiStochastic formulae to calculate the Stochastics %k and %d (Fast, Slow and Full) on intraday bars.
  • Add Williams %R calculation (xlqh, xlqxh, and xlqxi versions) covering day, week, month, different period ranges and intraday bars.
  • New xlq preference options to specify the default period settings for Stochastics and Williams%R
  • Support new InteractiveBrokers interface.
  • Update to ensure compatibility with Yahoo historic data changes concerning handling of invalid symbols.
  • Additional checks to ensure symbol is valid.
  • Misc. internal changes.
  • Documentation and xlqDemo have been updated.

3.8

22 February 2008
 
  • xlqxhMaxLSMA (+ week and month versions) - Returns the Max of Least Square Moving Average for all periods between the 2 period ranges specified. The LSMA will be calculated for each and the maximum value for each result is returned. The 3rd period parameter specifies on what data the lsma is calculated, i.e. 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price.
  • xlqxhSlope (+week and month version) being the slope of the lsma calculation.
  • To better differentiate range formulae new range formulae will have the syntax xlqrh…, e.g.:
  • xlqrhDrawDownFromHighest (+w+m) - return the % drawdown from the highest value in the period range to the end value. The 3rd period parameter specifies on what data the drawdown is calculated, i.e. 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price. When Close is specified, the drawdown will be from the highest close in the range to the last close of the range. For the other values, it will be from the highest value to the low, e.g. from the highest high in the series to the low of the last period.
  • xlqrhMaxDrawDownFromHighest (+w+m) - Calculates the % DrawDown as above for each period in the range, and return the highest (MAX) value calculated within the series.
  • xlqrhDrawUpFromLowest (+w+m) – similar to xlqrhDrawDownFromHighest but returns the % drawup from the lowest value in the period range to the end value. When Close is specified, the draw up will be from the lowest close in the range to the last close of the range. For the other values, it will be from the lowest value to the high.
  • xlqrhMaxDrawUpFromLowest (+w+m) - Calculates the % DrawUp as above for each period in the range, and return the highest (MAX) value calculated within the series
  • Add new sheet to xlqDemo showing a nice example of using the above formulae.
  • Support new IQFeed client, allowing faster processing with less cpu usage. IQFeed subscribers should also install the new client software version 4.3.0.3
  • + is now allowed in IQFeed symbols correcting a problem with not being able to show symbols such as +cl# (crude oil), +ho# (heating oil) for day and historic.
  • Fix problem with IQFeed weekly and monthly historic data (if you use their week and month data, delete the symbols in the stock manager to re-retrieve the values)
  • Optimize handling of IQFeed intraday backfill retrieval.
  • Futures and Options historic data from InteractiveBrokers will now show volume information.
  • Change minimum xlqxh... period value to be 2 (used to be 3).
  • Modify update frequency menu option in excel to enter value in seconds and allow to store value.
  • Add disconnect xlq menu option to excel, which can be used when no formulae are being used.
  • xlqhSymbolsToProcess is now volatile.
  • Fix problem with insufficient additional periods being retrieved for calculations.
  • Misc. internal changes.
  • Documentation and xlqDemo have been updated.

3.7

19 September 2007
 
  • Update to ensure compatibility with MSN historic data changes concerning handling of invalid symbols.
  • Update handling of Yahoo day data to ignore recent zero value returns (could result in values changing between value and #N/A in excel).
  • New intraday formulae (function the same as their existing xlqxh… equivalents, but on intraday data (when an interval is set)
    xlqxiCCI (Commodity Channel Index)
    xlqxiSMATP (SMA of Typical Price)
    xlqxiSMATPMD (Mean Deviation of SMATP)
  • New COM formulae for intraday xlqIntraValue2, allowing the handling of the 2nd numeric parameter required for xlqxi formulae.
  • New historic formula xlqhLSMA and weekly and monthly equivalents, being the Least Square Moving Average. The LSMA is also known as the linear regression value, moving linear regression and regression oscillator. In preferences it is possible to choose the period range (default = 25), and whether the value is based on the close, open, low, high or typical price (default = close).
  • An xlqxh version of the LSMA, i.e. xlqxhLSMA and weekly and monthly equivalents, in addition to the period range, a 2nd parameter specifies whether the calculation is based on 0 = close, 1 = open, 2 = low, 3 = high or 4 = typical price.
    e.g. =xlqxhLSMA(“msft”,-1,25,4, ”msn”) will return a 25 day lsma based on the typical price.
  • New preference settings for InteractiveBrokers
    - You may now choose for all times to be returned in Eastern US time (not default).
    - You may now choose to have xlq ignore any data streamed afterhours (not default).
  • Xlqxh formulae will now accept period ranges up to 730 periods (used to be 365)
  • Modify preference settings for historic calculations for better readability.
  • Documentation and xlqDemo have been updated.

3.6

15 August 2007
 
  • Update to ensure compatibility with recent MSN historic data changes (which could result in the current partial trading day being included in the historic data).
  • New preference setting for Yahoo! historic data “Adjust Open / High / Low per Ratio”.
    By default not enabled. When enabled, their normally unadjusted Open, High and Low will be adjusted by the ratio between the unadjusted and adjusted close. The values will not reflect the real O/H/L adjusted for splits and dividends, but will provide a close equivalent of a high /low/close including these adjustments.
  • All programs have been signed with a new digital certificate.
  • xlqXh.. versions of the adx calculation, i.e. xlqxhDMIpositive, xlqxhDMInegative, xlqxhDX, xlqxhADX (and their weekly and monthly equivalents). Allowing the period range to be specified in the calculation, allowing the calculation of multiple adx’s, as well as using 0 for the period to have the data calculated into the current trading day
  • Messages from InteractiveBrokers are now included in the status view for historic data retrieval.
  • Historic range formulae will now return #error if date parameters are inverted or invalid.
  • Documentation and xlqDemo have been updated.

3.5

12 June 2007
 
  • xlqhMACDHistogram (being the difference between the macd and the macd trigger)
  • xlqxhMACD, xlqxhMACDTrigger, and xlqxhMACDHistogram and their weekly and monthly equivalents.
    These formulae will allow you to specify the periods within the formulae, taking an additional 2 parameters covering the 2nd ema, and the trigger,
    e.g. =xlqxhMACD("msft",-1,12,26, 9, "msn") for a 12/26 period macd and a 9 day trigger.)
  • In the COM interface, a new function xlqHistValue4, will allow you to use xlqxhMACD by specifying the additional parameters needed.
  • xlqhTypicalPrice being the (high + low + close) / 3
  • xlqhsmatp, xlqhsmatpmd and xhqhCCI and their weekly and monthly equivalents. These formulae, all part of CCI (Commodity Channel Index) calculations will use the period setting in xlq preferences (by default 20)
    xlqhsmatp = the sma of the typical price
    xlqhsmatpmd = the mean deviation of the smatp
    and xlqhcci the final calculation of the cci
  • xlqxhsmatp, xlqxhsmatpmd, xlqxhcci (+ week and month variations) are the same as above but you may specify the period range within the calculation.
  • All the above xlqXh… formulae will allow you to use a period of 0 to include the calculation on the last price information from the corresponding day source.
  • Support for IQFeed’s new servers (and client software) If you use IQFeed, to be compatible with their new servers, you must install their latest client 4.2.1.4.
  • The interface with excel has been optimized. This is the first step in a number of changes, but the effect should already show a notable improvement.
  • Improved intraday processing.
  • Updated compatibility with yahoo-eu and yahoo-uk [Note yahoo-uk will be removed in a future version as yahoo-eu returns the same results]
  • The historic database will be modified on the first run of version 3.5, this will happen transparently, but could mean the first startup could be slower if you have large databases.
  • Documentation and xlqDemo have been updated.

3.4

16 February 2007
 
  • Update to ensure compatibility with recent Yahoo historic changes.
  • Support for InteractiveBrokers historic (daily and weekly) data. (this includes for options data)
  • The following existing day formulae now work for InteractiveBrokers: xlqOpen, xlq52WeekHigh, xlq52WeekLow, xlqAverageVolume, xlqHistoricVolatility, xlqOpenInterest
  • The following new formulae now cover data from IB (not available from other sources)
    xlq13WeekLow, xlq13WeekHigh, xlq26WeekLow, xlq26WeekHigh, xlqImpliedVolatility
    xlqOptionCallOpenInterest, xlqOptionPutOpenInterest, xlqOptionCallVolume, xlqOptionPutVolume
  • New status views covering both historic and day data from InteractiveBrokers.
  • Add a new page to xlq preferences for InteractiveBrokers, allowing for a setting to choose whether afterhours market data is included or excluded from intraday / historic data. By default the data is included.
  • Allow for a bigger font to be used in xlq and xlqCompanion grids. To enable the alternate font, choose xlq preferences and select the file / save / other page, and enable the option “use bigger font…”.
  • Built with the latest updates for c++ and misc. related libraries.
  • Additional changes ensuring Vista compatibility.
  • Supports IQFeed’s new client software (4.2.0.7).
  • Miscellaneous other changes.

3.3

6 December 2006
 
  • Supports Excel 2007
    (note!: Earlier versions of xlq are not compatible with the new .xlsx file format. You will also need to be using the excel 2007 final release (or at least the beta 2 technical refresh (B2TR)) for xlq to function correctly.)
    XLQ continues to support versions of Excel starting from Excel 97.
  • Supports Windows Vista
    (note!: Various issues have been addressed making xlq compatible with windows Vista, including allowing it to be run as a standard user.
    Also under Vista, the default data directory will now be c:\Users\[user id]\AppData\Local\xlq, and no longer in the “program files…” directory. This does not change for prior versions of windows.)
    XLQ continues to support versions of Windows from Windows 98.
  • New historic range formulae xlqhHighestVolume, xlqhLowestVolume, xlqhHighestVolumeDate, xlqhLowestVolumeDate as well as their weekly and monthly equivalents. Equivalent columns / fields have been added to xlqCompanion based on the purchase date.
  • Added references to xlqxhAveVolume and xlqxhAveVolumeEMA (and their weekly and monthly equivalents) to xlqDemo.xls. The formulae have been around for a while but not mentioned in the documentation.
  • Due to recent changes concerning ecn data, yahoo-ecn as a source has been removed. Excel and com will report any reference to yahoo-ecn as an invalid source (a global replace will allow you to re-assign yahoo-ecn to another source if needed) xlqCompanion will automatically convert any reference of yahoo-ecn to yahoo-rt. Afterhours data is not currently accessible via the yahoo sources. If you require afterhours data iqfeed, or interactivebrokers should be used. For the same reason xlqPricePerEarningsMkt and xlqMarketCapMkt no longer function with any Yahoo sources (xlqPricePerEarnings and xlqMarketCap should be used instead).
  • Improved error handling in excel, including avoiding potential crashes.
  • Improved historic processing, avoiding current problems where looping could occur
  • Improved handling of invalid symbols for historic processing. If after a couple of attempts / days, no historic data can be retrieved for a symbol, it will be blocked from further processing, improving start up times and overall program performance. When blocked, in the stock manager, the status will include the text “BLOCKEDFORUPDATES”. Such symbols can be left to avoid reprocessing in the future. If you want to try and retrieve data for a symbol again, delete the entry in the stock manager.
  • New formula xlqVWAP, currently supporting data from iqfeed.
  • Fixed problem with sorting in xlqCompanion.
  • Miscellaneous bug fixes as per user feedback.

3.2

9 August 2006
 
  • Important update to ensure compatibility with recent Yahoo! changes. Resolves problems with Yahoo! real-time subscription returning sometimes delayed / sometime real-time.
  • Programs signed with new digital certificate extended by 1 year.
  • Fixed formatting problem in certain columns in xlq views (and xlqCompanion).

3.1

25 July 2006
 
  • XLQplus now allows you to work with up to 5 different AAII Stock Investor Pro databases simultaneously, allowing for numerous back testing possibilities. If you do not have old AAII SIP disks, AAII subscribers can download data going back to 2003. You need to specify the location of the different directories in xlq preferences.
  • In xlq’s COM interface, a new function xlqAAII2 has been added which allows you to specify the database value. (using xlqAAII defaults to dataset 0).
  • aaiiDemo.xls has been updated allowing you to change the database value on each page.
  • Updated xlq to reflect recent network changes which could cause historic data retrieval to possibly slow down and /or continue to process invalid symbols.
  • Fixed problem with InteractiveBrokers intraday backfill data when a frequency of x minutes specified.
  • New formula = xlqhSymbolsToProcess(source) allowing you to see how many historic symbols still need to be processed. This can be useful especially for macros etc, that have made historic requests to ensure the data has been retrieved. Using the formula with no source specified will return the total no of symbols to process for all sources.
  • Modify xlqhLastUpdate. If no symbol is specified, it will now return the time of the last update for the source specified. If in addition no source is specified it will return the last update for historic data for all sources.
  • New day formulae =xlqLastUpdate, like its historic counterpart it will return the time of the last update for the specific symbol / source.
  • Supports IQFeed’s new client software (4.1.2.0)
  • Fixed a problem where xlq could crash if trying to view data for a source that is not used.
  • A new option has been added to xlq Preferences / Excel options allowing you to disable the enhanced functionality that xlq uses in Excel 2002 and later. i.e. it will cause xlq to treat Excel 2002 and later as if it were Excel 2000.
    In certain cases where you are running a lot of vba macros it could provide a performance improvement, but in most cases using this option would cause a slowdown in Excel.
    If you change the setting, you would need to restart excel for the change to take effect.)
    (NOTE** If you are using the current beta of Excel 2007, you would need to enable this option at least until the next Excel beta. Microsoft are busy working on the underlying problem.)

3.0

13 March 2006
 
  • Support for streaming real-time (and intraday backfill) data from InteractiveBrokers. Covering equities, options, futures, forex, etc. etc. for more than 50 markets. Data is free if you have an account with them, and their trading commissions are extremely competitive.
  • Various improvements have been made with IQFeed both within xlq, and by iqfeed themselves. This version uses the new client software of IQFeed, i.e. version 4.1.1.1
  • Numerous internal program changes reducing cpu usage and optimizing day processing.
  • The various views of xlq have been given a facelift, now using toolbars as opposed to dialog buttons. As well as allowing you to un-pin the window, leaving only the header shown.
  • The various grids such as the day list view, have been improved, allowing you to refresh the view, keeping your current position, sort order etc. making it much easier to use and quickly monitor stocks by %change etc.
  • Xlq’s day and intraday views will no longer require any additional cpu usage and will show changes as the data is streamed.
  • Fixed a problem in excel 2002 and later where under certain situations the data was not updated on opening the xls.
  • All xlq programs and supporting libraries have been ported to and are now built with the latest version of c++.
  • In excel 2002 and later, it is now possible to slow down updates up to a 2 minute interval (rather than 20 seconds) if required.
  • Fixed a problem with dmi calculations accidentally introduced in 2.91.
  • Fixed a problem with the saving of .csv files where the symbols contains a \.
  • Fixed a problem in xlqCompanion, which would crash if try to open an invalid file (or deleted file from the most recently used list).
  • Changed intraday csv files to store order as ohlc and no longer ochl.
  • Add additional error handling to excel 2000 and earlier.
  • A message will now be shown notifying when a support license is about to expire.
  • Changed documentation and references to the license names, which are now xlqPlus and xlqLite. XLQ now only refers to the program and concept, and not to the licensing or features included with a license.

2.9

15 September 2005 (release 2.91)
9 September 2005 (release 2.9)
 
  • 2.91 release (15 September 2005)
  • Corrects a problem with corrupt data from Yahoo! when a company names includes a comma
  • Corrects a problem with excel 2000 and xlqaaii formulae
  • Corrects a problem in xlqCompanion where last column does not update.
  • 2.9 release (9 September 2005)
  • 12 new historic formulae covering RSI calculations, i.e. xlqhAveGain, xlqhAveLoss, xlqhRelativeStrength, xlqhRSI and their weekly / monthly equivalents.
  • Possibility to change default period range for the rsi calculations in preferences, by default 14.
  • New historic formulae beginning with xlqxh allowing you to specify the range within the formulae, with the format =xlqxh…(symbol, date ref., period range, source). The calculation is done "on the fly", and not pre-calculated as per the xlqh formulae. Weekly and monthly versions also exist (xlqxhw / xlqxhm)
    e.g. =xlqxhRSI(“msft”,-1,21,”msn”) will return the 21 day RSI for Microsoft from MSN.
  • It is possible to use a period of 0 with the xlqxh formulae allowing for the continued calculation results to be returned on the current days data, either to return the sequence during market hours, or allow you to work on calculations at day end before historic data becomes available.
  • The 36 new xlqxh formulae include xlqxhEMA, xlqxhSMA, xlqxhAveRange, xlqxhAveRangeEMA, xlqxhAveTrueRange, xlqxhAveTrueRangeEMA, xlqxhAveVolume, xlqxhAveVolumeEMA, xlqxhAveGain, xlqxhAveLoss, xlqxhRelativeStrength, xlqxhRSI and their weekly / monthly equivalents.
  • These new formulae (and their xlqh equivalent) will also ensure sufficient additional historic data is retrieved to calculate the values, i.e. if a 200 day average is chosen, the additional 200 days of data will be retrieved in addition to the earliest date required.
  • xlqCompanion
    New preference setting allowing you to choose whether the trailing stop calculation will use the latest price available or last close. The default is latest price, but if you do not want trailing stops triggered on intraday movement, you may now choose to use only historic data via the preference menu.
    The custom text and value headers are now shown correctly if alternate text is set via preferences.
    xlqCompanion will no longer prompt to save if the file has already been saved and no changes have occurred since.
  • Fixed problem with missing dates for historic options data via IQFeed.
  • Fixed a problem with historic updates for IQFeed, with the centre of the Q remaining red.
  • Fixed a problem in excel in the situation where vba routines change cell values, then use the result.
  • Redesigned thread management with improved resource usage.
  • All programs signed with new digital certificate.
  • xlqDemo, the documentation and the getting started guide have been modified.

2.8

18 April 2005 (release 2.81)
14 April 2005 (release 2.8)
 
  • 2.81 release (18 April 2005)
  • Corrects a problem with closing workbooks in Excel 2000 on Windows XP (without closing Excel)
  • All programs have had their digital certificates resigned to ensure they can be "authenticated"
  • 2.8 release (14 April 2005)
  • Support for streaming realtime data, intraday backfill and historic day/week/month data for US and Canadian Equities as well as options and futures from IQFeed.net
  • 50 new formulae covering IQFeeds detailed quotes including Range, Spread, % Off Ave. Volume, Change from Open, Exchange of last trade, Extended Trading changes, Bid and Ask change, Volatility, no. of trades today, calendar year high and low with dates, 52 week high / low dates, Dividend info, Institutional %, Beta, Current Assets / Liabilities, Long Term Debt, last 2 split ratios and dates, SIC, Root Options Symbols and Leap Symbols, Net Asset Value, Open Interest, Strike, Settle, Delay, Average Maturity, 7 day yield, Expiration Date.
  • It is now possible to access data in AAII Stock Investor Pro without knowing the symbol, i.e. using !x for the symbol will return the x’th symbol in alphabetical order allowing for numerous research possibilities e.g. =xlqaaii(“!1”,”name”).
  • A new xls is included with the install (aaiiMacro.xls), which contains a vba macro which will query the AAII database for all symbols matching certain criteria (in the example stocks in the health care sector with a beta value greater than 1.5), and populate a new worksheet with the results. The example macro is also included in the help file under the section Within Microsoft Excel / Using xlq with vba.
  • xlqCompanion
    • New columns / fields supporting the new formulae as above.
    • New buttons on the toolbar allow for easily moving rows up, down or to another tab.
    • Sold items now appear with a blue background
    • When an alert is set, the programs Q icons, including on the task bar, will also be shown in red allowing you to watch for alerts even when the program is in the background or minimized.
    • Alerts are no longer triggered for sold items.
    • The summary view is now a dockable view placed as a tab along with the fields view (which you can undock or reposition elsewhere, hide etc.)
    • The summary view has been split into sold, unsold and realized sections, with the total now being of unsold + realized.
    • Fees are no longer included in the cost, and sell fees may be included in the G/L calculation of unsold items.
    • Various bugs have been fixed, including deleting a row by removing the symbol in the fields view and changing the historic source in the fields view.
  • Intraday processing redesigned to avoid overhead and resource usage.
  • 4 new intraday formulae covering the High, Low, Open and Close for an interval
  • Intraday now stored in text files (.csv) which may be used directly / via excel.
  • Possible to save day / intraday data at regular intervals and to create backup files. (date files not compatible with prior versions)
  • Opening a workbook containing xlq formulae will now be faster in Excel 2002 and later.
  • Documentation has been updated and now also includes an example of using xlq with the perl programming language.
  • New Getting Started with XLQ pdf included with install.
  • Misc. bug fixes including problem with reconnecting after internet disconnect

2.7

6 October 2004
 
  • Completely rebuilt xlq's communication structure making xlq a lot faster with less resource usage. (i.e. xlq, xlqCompanion, excel and COM).
  • Redesigned the way xlq works with excel, especially for Excel 2002 and later, dramatically reducing calculation times and improving performance. A new xlq menu is now available in excel 2002 and later.
  • All XLQ programs are now signed with digital certificates allowing them to run on computers and excel configured for heightened security.
  • XLQ's Day View has been changed. The view is now resizable and the data is now updated automatically as it changes.
  • Support for proxies requiring a userid and password.
  • XLQCompanion has a new "Fields" view showing the values for all fields for the currently chosen symbol. Editable fields may be changed here as well as in the grid. The data is updated automatically and the view may be hidden or repositioned.
  • It is now possible to change the AAII directory to that of your CD’s Drive letter and use the AAII Stock Investor Pro disks directly (useful if you wish to extract data from previous years / quarters).
  • Misc. bug fixes including for weekly msn historic data. / XLQ preferences have been modified to cover the new functionality.

2.6

26 April 2004 (release 2.61)
20 April 2004 (release 2.6)
 
  • 2.61 release (26 April 2004)
  • Corrects a problem with the 2.6 installation where for some users the automatic connection between excel and xlq was not established. (No changes to actual programs)
  • 2.6 release (20 April 2004)
  • Support for MSN MoneyCentral delayed "day" data.
  • Support for AAII's Stock Investor Pro package for using the data in excel via xlq formulae (and via xlq's COM interface) i.e. over 2800 data points for around 8000 companies offering all the financial and fundamental data you could probably need (includes historic financial statements, estimates, valuations, ratios of all kinds as well as sector and industry data. (Requires a subscription with AAII)
  • Updated documentation, including a new aaiiDemo.xls showing the AAII data available and example usage.
  • xlqCompanion has been optimized offering much better performance and reduced resource use.
  • May now move rows and "unsort" in xlqCompanion via right click menu.
  • xlqCompanion - now possible to enter fractional quantities.

2.5

2 March 2004 (release 2.51)
11 February 2004 (release 2.5)
 
  • 2.51 release (2 March 2004)
  • Minor bug fixes (also corrects problem with reduced trial period on xlqPlus)
  • 2.5 release (11 February 2004)
  • 24 new historic formulae covering Directional Movement (including DM+/-, DI+/-, DMI+/-, DX and ADX)
  • 15 additional historic formulae returning 2nd custom EMA and SMA, Last Update, No of Periods and Earliest Date
  • New look and new grid technology (including customizing of columns).
  • Updated help (including xlqCompanion and c# programming example) and xlqDemo
  • New preferences covering 2nd sma / ema, periods for adx and Yahoo! historic data
  • New xlqCompanion program allowing for the flexible management of portfolios and/or for classifying and analyzing data. Allows setting custom alerts including for TRAILING STOPS. Supports multiple custom views covering entered and calculated data as well as support for all xlq day formulae and historic range formulae. Too many features to mention - consult the help file.

2.4

1 December 2003 (release 2.42)
30 September 2003 (release 2.41)
8 September 2003 (release 2.4)
 
  • 2.42 release (1 December 2003)
  • Updated to work with Yahoo! changes.
  • 2.41 release (30 September 2003)
  • Updated to work with Yahoo! changes.
  • 2.4 release (8 September 2003)
  • Historic Data Processing completely re-written offering much faster, much better processing.
  • New Status View shows detailed information concerning historic data retrieval.
  • Compiled with the latest version of c++ and updated libraries.
  • Historic symbols currently being used in a workbook are now retrieved on priority.
  • Yahoo and MSN Historic data are now retrieved simultaneously.
  • New installation procedure using Inno Setup.
  • Misc. optimizations and bug fixes.

2.3

27 May 2003
 
  • Support for MSN MoneyCentral daily / weekly and monthly historic data.
  • Excel now only connects to xlq if an xlq formula is used.
  • 6 new historic formulae allowing for custom daily / weekly and monthly simple and exponential moving average calculations.
  • 11 new "day quote" formulae - xlqPricePerEarningsMkt, xlqShortRatio, xlqDivPerShare, xlqPricePerSales, xlqPricePerBook, xlqEPSEstCurrentYear, xlqEPSEstNextYear, xlqEPSEstNextQtr, xlqPEGRatio, xlqMarketCapMkt and xlqEBITDA.
  • Updated preferences, with new layout, new historic default data source, and settings for custom EMA/SMA calculations as well as possibility to calculate MACD on different period range.
  • Uninstall now deletes all xlq data files and registry settings.
  • Updated documentation (includes example using xlq with VB.NET) and updated xlqDemo (includes new market overview sheet).
  • Miscellaneous bug fixes.

2.2

3 March 2003
 
  • New COM interface allowing xlq formulae to be used with any program or programming language supporting COM. (help file includes examples for Visual Basic and C++)
  • Intraday data support (including 10 new formulae). Log intraday data for multiple symbols, with possibility to customize frequency, no. of records etc.
  • New intraday view with data refreshed as retrieved.
  • May choose whether historic .CSV files are written in ascending or descending order.
  • Single left clicking the Q in the task bar will now bring all active xlq windows to the foreground.
  • While historic data is being updated, hovering the mouse over the Q will now display the progress (i.e. x of x stocks updated)
  • "Pause Data Retrieval" will now block retrieval of historic data.
  • Updated xlqDemo and program help.

2.1

29 December 2002
 
  • Redesigned historic data management, allowing for the handling of a lot more data with improved processing logic , as well as reduced memory and resource usage.
  • 27 new historic formulae for daily / weekly and monthly data covering 12 and 26 day EMA, MACD (and Trigger), Range, Average Range, True Range, Average True Range and relative date index.
  • Now possible to generate .CSV files (comma delimited) for Historic Data.
  • New Optimized Historic Refresh Option.
  • Updated xlqDemo, help and Historic View.

2.0

26 September 2002
 
  • Compatible with recent Yahoo historic data changes.
  • Built with the latest version of C++ (and additional new libraries).
  • Restructured internally to provide better workload distribution across threads, offering faster processing.
  • New minimum excel update time setting, ensures that xlq will not cause excel to recalculate during at least x seconds even if new data is available.
  • New login option for Yahoo realtime data i.e. to use the settings directly from Internet Explorer. Now possible to change where xlq data is stored.

1.9

19 June 2002
 
  • Support for Yahoo's realtime subscription data. (new data source YAHOO-RT)
  • 3 New Formulae: xlqLastSize, xlqBidSize, xlqAskSize.
  • Support for proxy servers.
  • Can now change the default data source.
  • New Day List View showing all details of all day quotes.
  • Enhanced data retrieval routines, update xlqDemo and documentation.

1.8

21 April 2002
 
  • Optimized Historic Data routines.
  • 6 new historic formulae for daily / weekly and monthly change and change percent in the format xlqHChange, xlqHWChangePercent etc.
  • xlq historic view now shows change and change percent as per these formulae.
  • New historic preferences dialog to configure data retrieval options.
  • Possibility to use the Historic day formulae with an offset of 0, e.g. xlqHClose("msft",0) will return the day quotes equivalent results, allowing you to include last price / days close in your trends (i.e. xlqHClose("msft",0) = xlqPrice("msft").
  • Certain problems that occurred with historic weekly and monthly data have been corrected.
  • Other minor changes, update xlqDemo and documentation.

1.7

19 February 2002
 
  • New configuration options allowing more control on how xlq interacts with Microsoft Excel, including:
    - toggle whether workbooks are refreshed on opening.
    - toggle whether day quote formulae are volatile.
    - toggle whether historic formulae are volatile.
    - toggle whether excel recalculates when xlq receives new day data.
    - toggle whether excel refreshes when xlq receives new historical data
    - toggle whether xlq is automatically started with excel 2000 (or later)
  • Help file now contains information showing how to use xlq with vba to create your own formulae and additional analysis functionality.
  • xlqDemo.xls updated, also including currency examples
  • Other minor changes.

1.6

26 November 2001
 
  • Can now launch and run xlq separately from Excel.
  • 12 new historical formulae for weekly and monthly historical data in the format xlqHWClose, xlqHMOpen etc.
  • add new 'day quote' formulae xlqChangePercent, xlqPreviousClose, xlqPricePerEarnings, xlqEarningsPerShare, xlqYield, xlqMarketCap, xlqSharesOutstanding
  • Stock manager includes new add and refresh options, as well as storing last used screen position and size.
  • New options to view all stock data per share, or all historic (including weekly and monthly) data per share.
  • Other minor changes, update xlqDemo and documentation.

1.5

11 October 2001 (release 1.5b)
6 September 2001 (release 1.5)
 
  • 11 October 2001 (1.5b release)
  • Corrects problems relating to historical data for indices and mutual funds.
  • 6 September 2001 (1.5 release)
  • Add new preferences menu allowing configuration of refresh options per source, including days, time range, and refresh frequency.
  • Add new option to refresh all or individual sources whenever needed, even when data retrieval is paused.
  • Cater for tickers with multiple aliases, e.g. 555750.DE (Deutsche Telekom) may now also be accessed as DTEGN.DE, correcting differences due to Yahoo changes in Europe.
  • Other minor changes.

1.4

27 July 2001
 
  • Add new day quote formulae xlqBid, xlqAsk, xlqName, xlqExchange, xlqAverageVolume, xlq52WeekLow, xlq52WeekHigh.
  • Add data sources YAHOO-ECN and YAHOO-UK.
  • Add stock manager to see when last a stock was updated, the historical data available and to delete unwanted stocks.
  • Add Pause / Resume option for data retrieval.
  • Improved data retrieval and socket management, including connection monitoring.
  • Improve file management and error handling (including memory leaks).
  • Historical data is now refreshed periodically, and no longer only at startup.
  • A number of other minor changes and bug fixes.

0.3

9 April 2001 (First public Beta)
 
  • Help now included with program.
  • Tray icon displayed while running, with menu for help and about (including registration).
  • Add data sources YAHOO-EU and YAHOO-INT.
  • Optimize memory use.
  • Offer 45 day trial period, allow secure online registration.
  • A number of other minor changes and bug fixes.

0.2

11 January 2001 (Non Public Beta)
 
  • Allow multiple copies of Excel to access xlq simultaneously.
  • Changed design to be multithreaded.
  • Improved data storage, and optimized data retrieval.
  • Create historical quote formulas xlqHClose, xlqHOpen, xlqHHigh, xlqHLow, xlqHVolume, xlqHDate, working with data source YAHOO.
  • Sample spreadsheet now included with installation
  • Add support for Excel 97.
  • A number of other minor changes and bug fixes.

0.1

7 November 2000 (Non Public Beta)
 
  • Initial release to selected testers with basic program structure and data engine designed and main base classes created.
  • Create day quote formulas xlqPrice, xlqChange, xlqHigh, xlqLow, xlqVolume, xlqTradetime, working with data source YAHOO.
  • Supports Excel 2000 (and later).
New Tips and Tricks Page
  • A quick reference guide to using xlq2 with excel including shortcuts, tips etc.

  • Examples and explanations for all user levels.
Also available via the Resource menu above, along with references for formulae, symbols etc.

LATEST NEWS:

12 September 2024

XLQ2 24.41 released

  • xlqPrice2x, xlqBid2x and xlqAsk2x

    Specialized versions based on price differences to return

    • up to 20 prior values
    • the trend
    • as positive or negative depending on movement.
  • Schwab

    includes all the latest updates.

    Option Chain functionality now supported and Schwab view added

  • New option date formulae

    To calcualte a trend and target price for a given expiry date based on volume and open interest

  • More. >>

Current Offers

1 year of upgrades included
Purchase xlq2Lite for $159
Purchase xlq2 for $299

Pleased with the service and support
or feel extra has been earned?

Your acknowledgement is appreciated.
Thank you

User Comments

It is so uncommon in this day and age to receive top-level, human support and I appreciate that immensely. The quality, breadth and utility of your product is incredible, but even more impressive is the level of support you provided to me, just one individual customer. You may quote me on that. Thank you.

- C.B.

Wow, you did a lot of work on this version. New interface and other things as well. I must give you credit for being the most responsive software engineer that I've ever encountered. Every question that I've sent you over the many years (since 2003!!!) has been answered quickly and professionally. I just wanted to let you know that it is appreciated.

- M.N.

I have to say Leo that the last two versions have made some tremendous improvements to what has been for years an outstanding application. Thank you for your continued efforts.

- C.A.

Just to let you know that, the new version works much better & faster than the older one. I like it a lot, fantastic job you did!!!

- R.S.

Many thanks indeed for your clear and very rapid reply. I am not used to this type of quality service - I thought it went out of fashion years ago !!

- P.G.

In only 40 some days XLQ has helped me with a number of research projects I couldn't possibly have done without it and I'm now using it to help manage and track current trades and to alert me to potential new trades.

- D.P.

I just wanted to take a moment and thank you for creating XLQ. I use it regularly for scanning/monitoring securities in Excel 2007.  I have programmed in trailing stops for securities I own and numerous techniques using indicators for securities on my watch list. The combination of Excel 2007 and XLQ has opened up nearly an unlimited capability that is only constrained by my imagination.

- E.H.

Thank you for the amazing package -- I use it daily and it's ridiculously useful! Others (.....) have added some of the features you have, but none of them even comes close to matching what you've built.

- R.B.

Your product is fantastic, amazing, and really strong. It has real enabling capability. Thank you for putting this into the market!

- R.G.

You have an exceptional customer service, you have always answered my questions, I thank you for that, made it really easy to use this software, will be your long term customer. Thanks.

- A.D.

I was halfway resigned to have to program something like this myself. Only it would have taken me forever, and I couldn't have done it half as well. Thanks!

- M.S.

I also want to thank you for making the XLQ program. It is something that is very useful and incredible helpful. Like it was made for my needs.

- J.T.

I have already modified your demo sheet to fit my needs.  Your program allows me to turn my excel spreadsheet into a total information center that updates automatically. It's elegant.

- W.H.

First, I want to say that your program is probably the finest piece of work I have ever seen. The depth is simply amazing. Congratulations and thanks.

- D.B.

Thanx, Leo.  You're a great sport.  By the way, partially because of the application of xlq in my screen, I have passed 30% up in the market this year!!!!

- B.H.

This is a wonderful product -- simple to use and just plain useful!

- C.B.

I want to say you have created THE ULTIMATE data interface software for traders like me who prefer to use Excel for everything. Thanks a bunch.

- M.Y.

I just wanted to say, that I very much like your xlq package. I have tried many similar products and this is by far the best I have come across. Simple, fuss-free setup, integrates well with Excel, and has its own stand alone interface to track your portfolio throughout the day. Since I am from Europe, and trade US, European and Japanese securities, the ability to use a variety of feeds simultaneously and transparently is particularly valuable to me.

- H.S.

I really appreciate your quick responses. And your program is terrific. The Plus version adds a lot with it‘s AAII interface. I’ll definitely register it since in the last week it has become an indispensable part of my stock analysis.

- R.S.

I found XLQ yesterday afternoon – and I am blown away by how useful it is. You really need to market this thing because it is AWESOME!!!

- D.B.

Your explanation was very good. I understand now and find it very useful. If you always reply so quickly to questions, I will have to believe that you supply the best and fastest support of any software company.

- D.H.

I have “dabbled” for several years creating many of the things you present in this great program. I first began using the “*.iqy” external query (update times horrendous), then Excel VBA and lately attempting to learn “C” or “C++” in order to have smoother, faster updates as well as a great appearing “front end”. Your program certainly is, by far, the leader and has the greater edge over any I have seen, or tried to accomplish. Thank you for such a great program.

- R.H.

You are a very special person to reply so quickly and I want to thank you again. I enjoy your program. It gives me everything I need, and I know there is so much more functionality that I'm not even exploiting.

- F.D.

I love your program. XLQ combined with the power of Excel brings limitless possibilities to manipulate data for better trading. I recommend it to everyone I know interested in trading.

- P.S.

Thanks for such a great program. I have no programming experience and was trying to find a way to do just what you have done. Only you did much more. It’s fantastic and reasonably priced too!

- D.T.

Thank you so much for your help and your phenomenal programming. XLQ is awesome.

- T.K.

I use your XLQ product all the time. Some of the best money I've ever spent on software.

- L.S.

First, a thank you for the excellent and useful adjunct to EXCEL. I seem to discover a new use every day – and I’m sure I haven’t even scratched the surface to utilize XLQ’s full potential. The new version is really great.

- W.H.

First let me say that I feel XLQ is terrific. I really appreciate the versatility you have made possible with this package. I have set up a few worksheets and find it easy to learn and use with the aid of the included demo sheets. This application has the potential in my opinion to be unmatched in power, efficiency and productivity.

- C.A.

Your software is on its way to becoming the only window that I need to the market’s numbers. With the ability to arrange thing EXACTLY the way I want them, and the use of conditional formatting to trigger alarms and display changes to suit my needs, I am gradually replacing all of the other market tools I’ve been using. I can’t be a more enthusiastic supporter of what you are doing. Thanks.

- W.G.

I'm wowed by your software!! I used to enter data in my spreadsheet for two hours for each update, and therefore only did it once or twice a week. Now I do it with the close each day - in about 30 seconds!!! And I've added some data points to help with my analysis that I just could not manage to maintain before. Thanks again for a great program, a great deal, and great support!!!!!

- R.K.

Your software is great. I'm hooked on the info I can generate for stock purchasing and selling using your program. In two weeks I've become an XLQ junkie.

- V.D.

Please let me tell you how much I have come to depend on XLQ in a short period. This is a great product!! You have made my job significantly more streamlined, and my tasks simpler and more elegant. Many, many thanks!

- L.D.

I have been evaluating XLQ for the past few weeks and am thoroughly impressed with the product. It is versatile, easy to use, accurate and very intuitive. It is a real bargain compared to competitive products plus it runs right from within Excel. Based on this I just entered my purchase order.

- M.M.

I ADORE your program. It has really helped me to learn about how the markets work, and building my own system indicator by indicator is the best way to learn.

- B.K.

Leo: count me as a satisfied customer. I gave it a good workout for a month, decided to buy it when it saved me 5 hours of administration the first week, and helped me do some studies I had been postponing for months due to slow data retrieval. Your product is smooth, fast and elegant with a very clean presentation. Well done!

- K.L.

The more I work with XLQ, the more I like it. It is fast! And so rich... I like it so much I have decided to adopt it as my #1 tool for the long term.

- S.C.

Thanks very much for writing XLQ - I like it very much as it gives me the opportunity to manipulate data as I want without a very steep learning curve.

- T.B.

I just downloaded a trial of XLQ and have been "playing" with it for hours. I am so impressed. I wish I would have known about your program years ago.

- D.F.

I just purchased your software and think it is the next best thing since the spreadsheet.

- R.D.

Thanks for the best (and least complicated) investing software out there!!

- F.B.

Your software is simply brilliant, for the last week that I have been trying it, I have been impressed no end.

- G.R.

Thanks, Xlq is a great piece of software, its actually saving me a heap of time and time is the precious commodity in these hectic days.

- J.P.

The XLQ interface with Excel is excellent. I have been waiting for this capability for years.

- H.A.

Please accept my thanks for your wonderful product - it is a pleasure to use.

- D.L.

Your software is just what I have needed. It provides me with the capability to customize data and construct charts which give me the views I like - not just what someone thinks I would like.

- D.E.

Firstly, let me say that the philosophy and idea behind XLQ is exactly what I am looking for.

- S.P.

The more I use XLQ the more I appreciate what can be done with it.

- S.M.

Just like to say, excellent work. A potentially good bit of software for me.

- M.C.

I love your product so far. ... Thank you for making such product available.

- A.T.

Thanks for the Tip. You know, your program is really super.

- P.B.

Great software! Simple, elegant, well-thought-out and fast.

- R.M.

I am always finding new ways to use your program in my investment / speculative Market endeavors.

- S.S

Thanks for such a wonderful product. It certainly does handle my most precious need which is to monitor the market realtime..

- W.B

It is a pleasure doing business with such a responsive person who obviously understands the value of good customer service. I have just registered and intend to make good use of this program.

- E.D.

Your fast and thorough answer is more than what I expected. Your service is awesome and your product is very stable. Keep up with your good work. Sincerely appreciated :)

- V.P.

Just a note to let you know that I really like you software. It's a wonderful interface that has been of great utility to me.

- J.B.

Join the XLQ2 Users Group

Books

xlq2 has been recommended in the following:

Definitive Guide to Position Sizing

Van Tharp

Paul King