XLQ 4.51
XLQ 4.51 summary
XLQ 4.51 screenshot
XLQ 4.51 description
XLQ 4.51 comes as a sophisticated and innovative program that complements existing stock market applications by integrating worldwide stock. XLQ delivers live and historic stock market data available on the internet directly to your computer, allowing you to view this data via Microsoft Excel, XLQ/xlqCompanion or in any program or programming language supporting COM, giving you the flexibility needed to maintain your portfolio your way and for you to perform custom financial analysis.
It provides you with a set of formulae allowing you to design your own portfolio manager and financial spreadsheets for stock analysis. The days of downloading, importing, keying in and re-keying in stock data are over, and your spreadsheets will never become outdated as the data is automatically refreshed. In addition you may view the data, day quotes from multiple sources, intraday logs for multiple symbols, and historical daily, weekly and monthly data directly in xlq.
The spreadsheet xlqDemo.xls has been provided, giving a working live example of how xlq can be used and may be used as a basis for creating your own spreadsheets or incorporating xlq formulas into existing ones. In addition this help files provides examples on how to create your own formulae in excel and how to use the COM interface to use XLQ with languages such as Visual Basic and C++.
XLQ is written in C++ and makes no use of VB / VBA to ensure the fastest possible processing speed and the data sources on the internet have been chosen for their high quality services that they offer. XLQ will continue to grow and provide you with the functionality that you want and expect. All comments and suggestions will be considered for incorporation in the future.If you want to view information regarding stock market data in a simple format, just try XLQ!
Major Features:
- Over 300 different formulae.
- Work with multiple data sources simultaneously (free and subscription).
- Historic, Streaming, Realtime, Delayed and intraday quotes.
- Detailed fundamental data (xlq provides an excel and com interface to AAII's renowned Stock Investor Pro Database).
- Covers worldwide stock, index, fund, options, futures and currency data.
- Built in Trailing stop calculations and alerts via xlqCompanion.
- May be used through VBA to create custom formulae and analysis routines as well as via excel charts.
- XLQ is digitally signed allowing it to work on computers with tightened security.
- 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.
- 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.
XLQ 4.51 keywords
XLQ 4.51 for Developers
XLQ 4.51 Copyright
- ChequePrinting.Net Software 4.0.2
- Biometric Handpunch Manager Enterprise 7.20.17
- EasyBilling Maker of Sales Document 4.2.2
- NBL Finance Tool 1.4.5
- Ecolaw Lawyer Client Account Software 1.19
- Anti Scam Indicator for MetaTrader 4 1.0.0.1
- Biometric Handpunch Manager Professional 7.19.17
- PayPunch Enterprise 9.20.238
- Club Manager 6.0.1
- Store Manager for PrestaShop Professional Edition 2.3.9.448
masocongty