XLQ2 allows you to work with market data (real-time, intraday, historic, chains, dividends etc.) from tradier via excel formulae, xlq companion, any program or programming language supporting COM, or directly in the xlq2 data engine. XLQ2 has been in constant development since 2000 providing well over 1000 formulae to work with all aspects of market data including streaming real-time data, snapshots, daily, weekly and monthly data covering numerous indicators as well as dividends, splits, financials and fundamentals from multiple data sources simultaneously. xlq2 is available in 2 versions, xlq2 and xlq2lite. It is possible to trial xlq2lite for 3 weeks by simply downloading and installing. A 3 week trial covering all xlq2 functionality is also available on request.

• Unique historic intraday formulae allow you to work with multiple x minute intervals simultaneously with all parameters specified directly in excel formulae, updated in real-time with possibilities to include and / or exclude extended hours, reference data by date / time, or work with a series from any given data point.
• Formulae are available for options, to reference prior / next dates, and or strikes to construct views / chains as wished directly in excel and always up to date/ reusable by changing any cell reference or updated on current price. Streaming real-time, intraday or historic option data is also available per symbol.
• Option data is also available directly in the xlq2 engine for all dates allowing it to be filtered for further analysis.
• Period views are available to view multiple symbols per date including upcoming and prior dividends for a given month.
• Sample spreadsheets are included.