VOL. XCIV, NO. 247

★ FINANCIAL TOOLS & SERVICES DIRECTORY ★

PRICE: 5 CENTS

Sunday, October 5, 2025

Head-to-head

MarketXLS vs QuantRocket comparison

Compare pricing, supported platforms, categories, and standout capabilities to decide which tool fits your workflow.

Quick takeaways

MarketXLS adds Sheets / Excel Add-ins, Options & Derivatives, Options, Options P&L, Monte Carlo, Risk Metrics (VaR/ES/Drawdown), Portfolio, Watchlist, Correlation, Financials, ETF Overview, ETF Holdings, ETF Fundamentals, Which ETF includes this Stock?, Interest Rates, Unemployment Rates, Inflation Rates, GDP, and Blogs coverage that QuantRocket skips.

QuantRocket includes Quant, Backtesting, Auto-Trading & Bots, Advanced Order Types, Paper Trading, and Data APIs categories that MarketXLS omits.

MarketXLS highlights: Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users., Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year., and Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter..

QuantRocket is known for: Includes survivorship-bias-free US minute-bar data (from 2007 onward) for Zipline backtests and live trading, with optional real-time feeds from brokers like IBKR and Alpaca., Supports point-in-time screening and ranking pipelines, and integrates with Alphalens and Pyfolio for in-notebook analysis inside Jupyter., and Global coverage through Interactive Brokers’ historical and real-time data across 60+ exchanges, plus optional feeds like EDI global EOD, Sharadar fundamentals, and Brain sentiment datasets..

QuantRocket keeps a free entry point that MarketXLS lacks.

MarketXLS logo

MarketXLS

marketxls.com

Excel‑first market data & analytics add‑in with 1,000+ functions. Default data is 15‑min delayed (QuoteMedia); real‑time streams and intraday history available with data add‑ons. Web screener, ETF database/overlap tools, options chains & Greeks, and portfolio templates (incl. Efficient Frontier). Direct order‑ticket functions for Thinkorswim, Tradier, Orion, plus IBKR integration via TWS API. No public data API for redistribution; personal use license.

Platforms

Desktop
Web

Pricing

Subscription

Quick highlights

  • Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users.
  • Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year.
  • Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter.
  • Portfolio & research templates: Efficient Frontier, correlation/volatility/drawdowns, fundamentals and historical statements via hf_* functions.
  • Web screener with hundreds of metrics; stock ranks (Value/Quality/Technical); spreadsheet builder to generate ready‑made workbooks.

Community votes (overall)

0% upvotes 0% downvotes
You haven't voted yet
QuantRocket logo

QuantRocket

quantrocket.com

A Docker-based research, backtesting, and live-trading platform built around Jupyter. The free tier is limited to research, while paid plans unlock live and paper trading along with bundled US minute-bar data. Broader global datasets are available via third-party providers. Its tight IBKR integration brings advanced order types, while real-time market data can be streamed from IBKR, Polygon, or Alpaca.

Platforms

Web
API

Pricing

Free
Subscription

Quick highlights

  • Includes survivorship-bias-free US minute-bar data (from 2007 onward) for Zipline backtests and live trading, with optional real-time feeds from brokers like IBKR and Alpaca.
  • Supports point-in-time screening and ranking pipelines, and integrates with Alphalens and Pyfolio for in-notebook analysis inside Jupyter.
  • Global coverage through Interactive Brokers’ historical and real-time data across 60+ exchanges, plus optional feeds like EDI global EOD, Sharadar fundamentals, and Brain sentiment datasets.
  • Deep IBKR integration enabling advanced order types such as algorithmic, parent-child, and bracket orders, as well as combos/spreads, margin 'what-if' checks, option greeks, and auction imbalance data.
  • Streams tick-level data into TimescaleDB with WebSocket access, and allows flexible bar aggregation.

Community votes (overall)

0% upvotes 0% downvotes
You haven't voted yet
Overlap

Shared focus areas

2 overlaps

Mutual strengths include Broker Connectors, and Screeners.

Where they differ

MarketXLS

Distinct strengths include:

  • Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users.
  • Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year.
  • Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter.
  • Portfolio & research templates: Efficient Frontier, correlation/volatility/drawdowns, fundamentals and historical statements via hf_* functions.

QuantRocket

Distinct strengths include:

  • Includes survivorship-bias-free US minute-bar data (from 2007 onward) for Zipline backtests and live trading, with optional real-time feeds from brokers like IBKR and Alpaca.
  • Supports point-in-time screening and ranking pipelines, and integrates with Alphalens and Pyfolio for in-notebook analysis inside Jupyter.
  • Global coverage through Interactive Brokers’ historical and real-time data across 60+ exchanges, plus optional feeds like EDI global EOD, Sharadar fundamentals, and Brain sentiment datasets.
  • Deep IBKR integration enabling advanced order types such as algorithmic, parent-child, and bracket orders, as well as combos/spreads, margin 'what-if' checks, option greeks, and auction imbalance data.

Feature-by-feature breakdown

AttributeMarketXLSQuantRocket
Categories

Which research workflows each platform targets

Shared: Broker Connectors, Screeners

Unique: Sheets / Excel Add-ins, Options & Derivatives, Options, Options P&L, Monte Carlo, Risk Metrics (VaR/ES/Drawdown), Portfolio, Watchlist, Correlation, Financials, ETF Overview, ETF Holdings, ETF Fundamentals, Which ETF includes this Stock?, Interest Rates, Unemployment Rates, Inflation Rates, GDP, Blogs

Shared: Broker Connectors, Screeners

Unique: Quant, Backtesting, Auto-Trading & Bots, Advanced Order Types, Paper Trading, Data APIs

Asset types

Supported asset classes and universes

Stocks, ETFs, Options, Mutual Funds, Currencies, Futures, Cryptos

Stocks, ETFs, Futures, Currencies, Options

Experience levels

Who each product is built for

Beginner, Intermediate, Advanced

Beginner, Intermediate, Advanced

Platforms

Where you can access the product

Desktop, Web

Web, API

Pricing

High-level pricing models

Subscription

Free, Subscription

Key features

Core capabilities called out by each vendor

Unique

  • Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users.
  • Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year.
  • Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter.
  • Portfolio & research templates: Efficient Frontier, correlation/volatility/drawdowns, fundamentals and historical statements via hf_* functions.
  • Web screener with hundreds of metrics; stock ranks (Value/Quality/Technical); spreadsheet builder to generate ready‑made workbooks.
  • Broker/trading connections: Thinkorswim, Tradier (single & multi‑leg), Orion (single‑leg), Interactive Brokers (via TWS API).

Unique

  • Includes survivorship-bias-free US minute-bar data (from 2007 onward) for Zipline backtests and live trading, with optional real-time feeds from brokers like IBKR and Alpaca.
  • Supports point-in-time screening and ranking pipelines, and integrates with Alphalens and Pyfolio for in-notebook analysis inside Jupyter.
  • Global coverage through Interactive Brokers’ historical and real-time data across 60+ exchanges, plus optional feeds like EDI global EOD, Sharadar fundamentals, and Brain sentiment datasets.
  • Deep IBKR integration enabling advanced order types such as algorithmic, parent-child, and bracket orders, as well as combos/spreads, margin 'what-if' checks, option greeks, and auction imbalance data.
  • Streams tick-level data into TimescaleDB with WebSocket access, and allows flexible bar aggregation.
  • REST API ('Houston') with Python client and CLI tools; endpoints return CSV or JSON for easy downstream use.
Tested

Verified by hands-on testing inside Find My Moat

Not yet

Not yet

Editor pick

Featured inside curated shortlists

Standard listing

Standard listing

Frequently Asked Questions

Which workflows do MarketXLS and QuantRocket both support?

Both platforms cover Broker Connectors, and Screeners workflows, so you can research those use cases in either tool before digging into the feature differences below.

Which tool offers a free plan?

QuantRocket offers a free entry point, while MarketXLS requires a paid subscription. Review the pricing table to see how the paid tiers compare.

How can you access MarketXLS and QuantRocket?

Both MarketXLS and QuantRocket prioritize web or desktop access. Investors wanting a mobile-first workflow may need to rely on responsive web views.

What unique strengths set the two platforms apart?

MarketXLS differentiates itself with Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users., Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year., and Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter., whereas QuantRocket stands out for Includes survivorship-bias-free US minute-bar data (from 2007 onward) for Zipline backtests and live trading, with optional real-time feeds from brokers like IBKR and Alpaca., Supports point-in-time screening and ranking pipelines, and integrates with Alphalens and Pyfolio for in-notebook analysis inside Jupyter., and Global coverage through Interactive Brokers’ historical and real-time data across 60+ exchanges, plus optional feeds like EDI global EOD, Sharadar fundamentals, and Brain sentiment datasets..

Curation & Accuracy

This directory blends AI‑assisted discovery with human curation. Entries are reviewed, edited, and organized with the goal of expanding coverage and sharpening quality over time. Your feedback helps steer improvements (because no single human can capture everything all at once).

Details change. Pricing, features, and availability may be incomplete or out of date. Treat listings as a starting point and verify on the provider’s site before making decisions. If you spot an error or a gap, send a quick note and I’ll adjust.