Your solution to working with market data in Microsoft Excel since 2000 |
|
|
||||||||||||||||||||||||||||
Streaming Real-time | Intraday | Snapshots | Historic | Daily | Weekly | Monthly | Upcoming Events |
Your solution to working with market data in Microsoft Excel since 2000 |
|
|
||||||||||||||||||||||||||||
Streaming Real-time | Intraday | Snapshots | Historic | Daily | Weekly | Monthly | Upcoming Events |
|
XLQ2 allows you to work with market data in the way you want. No interface or program design restrictions. Create your own layout or easily modify any existing spreadsheets to have them always updated and up to date, even in real-time.
As xlq2 allows you to work with multiple data sources simultaneously you may choose the best source for specific data, or use mulitple to compare, or simply switch in case of an outage.
XLQ2 is used by the individual investor for basic portfolio management or following of trailing stops. By financial advisors, journalists, newsletter editors, financial institutions and professional traders in many different markets around the world.
It is used for investment tracking, financial analysis, decision making, risk assessment, back-testing, and as the core of trading systems.
via xlq2 / xlq2Lite you may use formulae to access all of AAII's Stock Investor pro data in excel and through xlq's COM interface, allowing for new levels of custom analysis.
Over 3000 data points for around 7000 companies covering quarterly and yearly historic P&L, balance sheet, and cash flow.
As well as valuations, estimates, growth, multiples and ratios of all sorts. (including for sector and industry.)
Requires a subscription for Stock Investor Pro with AAII
Click here to visit AAII and find out morevia xlq2 / xlq2Lite you can work with data for cryptocurrencies from CoinMarketCap (currently over 4000).
Includes formulae for their Rank, MarketCap, Available Supply, and 1 hour, 24 hour and 7 day percent change.
You would need to enter your CMC token into xlq. The functionality supported is the same for all their subscription levels, including the Basic / free subscription.
Data is updated every 30 minutes (may be changed)
Click here to visit CoinMarketCapxlq2 provides a thorough interface to access and work with the vast amount of data available via EOD Historical Data.
Over 60 exchanges covered as well as options, cryptos, forex, commodities, bonds etc. etc.
Historic daily, weekly, monthly data (unadjusted, split, or split and dividend adjusted) + delayed data
Over 20 years of quarterly and yearly financial data (balance sheet, cash flow, income statement)
Historic and upcoming dividends, splits, earnings. target pricing, constituents, insider transactions etc. etc.
Bulk data requests... Special views...
Raw data files saved for further use.
Click here to visit EODHistoricalData (special xlq2 pricing)xlq2 provides a thorough interface to access and work with the vast amount of data available via Financial Modeling Prep (FMP).
Over 50 exchanges covered as well as cryptos, forex, commodities etc. etc.
Historic daily, weekly, monthly data (split, or split and dividend adjusted) + realtime snapshot data
Over 30 years of quarterly and yearly financial data (balance sheet, cash flow, income statement)
Formulae covering quarterly and yearly financial growth, key metrics and ratios, as well as TTM
Historic and upcoming dividends, splits, earnings. target pricing, insider transactions etc. etc.
Bulk data requests... Special views...
Raw data files saved for further use.
financialmodelingprep.com (xlq2 signup and special pricing)xlq2 / xlq2lite supports streaming real-time data as well as intraday backfill and historic data from Interactive Brokers for numerous markets and products around the world.
Requires an account with Interactivebrokers and works with your the data with which you have a subscription.
Click here to visit Interactive Brokersxlq2 / xlq2Lite supports streaming real-time data as well as intraday backfill and historic data from IQFeed
Requires a subscription with them. Possibility to request a trial of their service. Their $50 startup fee is waived for xlq users
You will also need to download their client software, which you can do from here
Click here to visit IQFeedxlq2 supports historic data for US, Canadian and Australian equities (+ Australian Warrants and Exchange Traded options), indexes, futures and forex from Norgate Data.
xlq2 supports real-time snapshot data for US markets from Schwab.
xlq2 supports historic equities, options and indexes for US and Canadian symbols from Stockwatch.
xlq2 supports streaming real-time data for US equities and options from Tradier.
xlq2 / xlq2Lite supports historic and real-time snapshot data for US and Chinese equities, funds and crypto
currencies from Tiingo.
Historic equity data from the 1960's.
Their free and subscription data is support. Requires signup with them to receive a token.
Click here to visit TiingoVia xlq2 / xlq2Lite you can work with Yahoo Finance download data covering historic data for a number of different markets around the world.
Click here to visit Yahoo! Finance
Base Functionality | xlq2Lite | xlq2 | |
xlq2 Data engine:
|
|||
XLQ2 data engine (Extras)
|
|||
COM interface. Use formulae from any program or programming language supporting COM. | |||
xlqCompanion. A grid based portfolio or stock list manager. | |||
Formulae (for more details, choose Resources / Formulae help from menu at top of page) | |||
Day formulae Around 40 formulae covering basic historic price information such as price, bid, ask, size, volume, high, low, time, yield, price per earnings etc. |
|||
Day formulae (additional) Over 70 extra formulae covering other information such as dividend amount, institutional %, beta, open interest, delta, gamma, vega, theta, rho, volatility, split date etc. |
|||
Day formulae (more additional) Over 80 more, covering other information such as short interest, insider %, float, cash, debt, revenue per share, revenue per employee etc. |
|||
'xlqh' Historic Formulae (day, week and month) Around 40 formulae covering basic market information such as open, close, low, high, volume, change (and %) and additional calculated values based on preference settings such as SMA,EMA, MACD, True Range, DMI, ADX etc. |
|||
'xlqh' Historic Formulae (additional) Around 50 pre-calculated formulae (based on preference settings) such as RSI, CCI, LSMA, Stochastics, Williams %R, Bollinger Bands, Kaufmann Er, PPO, PSAR, Force Index, Trix, Fractal Dimension, Connors RSI, Keltner Channels, Vortex Indicator etc. |
|||
'xlqxh' Historic Formulae Same as 'xlqh' but allows for 'on the fly' calculations with intervals and options specified as parameters for unlimited calculation possibilities (around 70 formulae). Possible to calculate results on a series into the current trading day and last real-time price. |
|||
'xlqrh' / Historic Range Formulae Returns calculation results based on start and end dates. e.g. highest close or date (or highest high, lowest low etc.), drawdown or drawup, rate of return, StdDev, mean etc. |
|||
Historic Formulae (additional) Extra historic formulae covering the extra data available via xlq2, including for
|
|||
Historic Intraday Formulae Providing xlqhi, xlqxhi and xlqrhi equivalent to the above historic formulae but on x minute intervals.
|
|||
Intraday Formulae (original / deprecated) Like historic data, but on an X minute interval returning basic market information such as open, close, low, high, volume, change, or for tick data bid + size, ask + size, last price + size. Backfill data is automatically requested from supported sources. 'xlqxi' Intraday Formulae - Like the xlqxh formulae, returns calculated results on an X minute interval for around 70 formulae. limited to one interval and 2000 bars maximum, superseded by the more powerful historic intraday formulae above. |
|||
Upcoming Events Upcoming Dividends, Splits, Earnings Announce dates and Estimates, Target |
|||
xlqaaii formula Returns results for over 3000 fields from the AAII Stock Investor Pro database (if installed). Covering income statement, balance sheet and a lot of other financial and fundamental data for listed companies, as well as their sector and industry. |
|||
xlqaaii custom formula Over 50 additional values calculated on AAII data including for
|
|||
Supported Data Sources | |||
AAII Stock Investor Pro | |||
AAII Stock Investor Pro (Additional Support) | |||
CoinMarketCap | |||
EOD Historical Data (EODHD) | |||
Financial Modeling Prep (FMP) | |||
Interactive Brokers | |||
IQFeed | |||
Norgate Data | |||
Schwab | |||
Stockwatch | |||
Tiingo | |||
Tradier | |||
Yahoo |
Specialized versions based on price differences to return
includes all the latest updates.
Option Chain functionality now supported and Schwab view added
To calcualte a trend and target price for a given expiry date based on volume and open interest
1 year of upgrades included
Purchase xlq2Lite for $159
Purchase xlq2 for $299
Copyright © 2000 - 2024 Leo van Rijswijk | All Rights Reserved.
Copyright © 2000 - 2024 Leo van Rijswijk | All Rights Reserved.