VOL. XCIV, NO. 247

★ FINANCIAL TOOLS & SERVICES DIRECTORY ★

PRICE: 5 CENTS

Sunday, October 26, 2025

View Capitol Trades View MarketXLS Home My Collections

Head-to-head

Capitol Trades vs MarketXLS comparison

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

Quick takeaways

Capitol Trades adds US Government Trades, Regulatory Filings Monitoring, and Newsletters coverage that MarketXLS skips.

MarketXLS includes Sheets / Excel Add-ins, Broker Connectors, Screeners, 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, and GDP categories that Capitol Trades omits.

Capitol Trades highlights: Near real‑time publication of newly disclosed trades and analytics., Comprehensive filters: chamber (Senate/House), party, committee, state, asset type, transaction type, size, issuer country/sector and more., and Politician pages with bios, committee memberships, tweets, trading activity and preferred sectors; issuer pages with frequent‑trader stats..

MarketXLS is known for: 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..

Capitol Trades has a free tier, while MarketXLS requires a paid plan.

Capitol Trades

capitoltrades.com

Free, public dashboard tracking U.S. politicians’ trade disclosures under the STOCK Act. Near real‑time postings of newly published disclosures, with rich filters (chamber, party, committee, state, asset type, transaction type, trade size, sector, etc.). Asset coverage spans stocks, ETFs, mutual funds, bonds (incl. munis/USTs), options, and crypto. Operated by 2iQ Research.

Platforms

Web

Pricing

Free

Quick highlights

Near real‑time publication of newly disclosed trades and analytics.
Comprehensive filters: chamber (Senate/House), party, committee, state, asset type, transaction type, size, issuer country/sector and more.
Politician pages with bios, committee memberships, tweets, trading activity and preferred sectors; issuer pages with frequent‑trader stats.
Coverage includes bonds (e.g., municipal/UST) and crypto transactions, alongside equities and funds.
Weekly email newsletter; active X/Twitter feed with immediate updates.

Community votes (overall)

0% upvotes 0% downvotes

You haven't voted yet

View full profile Visit site

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

DesktopWeb

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

View full profile Visit site

Overlap

Shared focus areas

1 overlap

Both tools cover this research theme.

Blogs

Where they differ

Capitol Trades

Distinct strengths include:

US Government Trades Regulatory Filings Monitoring Newsletters

Near real‑time publication of newly disclosed trades and analytics.
Comprehensive filters: chamber (Senate/House), party, committee, state, asset type, transaction type, size, issuer country/sector and more.
Politician pages with bios, committee memberships, tweets, trading activity and preferred sectors; issuer pages with frequent‑trader stats.
Coverage includes bonds (e.g., municipal/UST) and crypto transactions, alongside equities and funds.

MarketXLS

Distinct strengths include:

Sheets / Excel Add-ins Broker Connectors Screeners Options & Derivatives Options Options P&L Monte Carlo Risk Metrics (VaR/ES/Drawdown)

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.

Feature-by-feature breakdown

Attribute	Capitol Trades	MarketXLS
Categories Which research workflows each platform targets	Shared: Blogs Unique: US Government Trades, Regulatory Filings Monitoring, Newsletters	Shared: Blogs Unique: Sheets / Excel Add-ins, Broker Connectors, Screeners, 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
Asset types Supported asset classes and universes	Stocks, ETFs, Mutual Funds, Bonds, Options, Cryptos	Stocks, ETFs, Options, Mutual Funds, Currencies, Futures, Cryptos
Experience levels Who each product is built for	Beginner, Intermediate, Advanced	Beginner, Intermediate, Advanced
Platforms Where you can access the product	Web	Desktop, Web
Pricing High-level pricing models	Free	Subscription
Key features Core capabilities called out by each vendor	Unique Near real‑time publication of newly disclosed trades and analytics. Comprehensive filters: chamber (Senate/House), party, committee, state, asset type, transaction type, size, issuer country/sector and more. Politician pages with bios, committee memberships, tweets, trading activity and preferred sectors; issuer pages with frequent‑trader stats. Coverage includes bonds (e.g., municipal/UST) and crypto transactions, alongside equities and funds. Weekly email newsletter; active X/Twitter feed with immediate updates. Site shows up to 3 years of history (full archive available via 2iQ enterprise products).	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).
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 Capitol Trades and MarketXLS both support?

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

Which tool offers a free plan?

Capitol Trades 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 Capitol Trades and MarketXLS?

Both Capitol Trades and MarketXLS 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?

Capitol Trades differentiates itself with Near real‑time publication of newly disclosed trades and analytics., Comprehensive filters: chamber (Senate/House), party, committee, state, asset type, transaction type, size, issuer country/sector and more., and Politician pages with bios, committee memberships, tweets, trading activity and preferred sectors; issuer pages with frequent‑trader stats., whereas MarketXLS stands out for 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..

Keep exploring

Stay on top of related tools

Browse the categories and profiles that overlap most with this comparison to round out your shortlist.