Best Sheets / Excel Add-ins Tools for Investing

EIA Open Data

EIA Open Data is the U.S. government's source for energy statistics and operational data. Browse the series or use the free API, bulk files, and spreadsheet tools for commodity, utility, macro, and energy-market research.

Financial Modeling Prep (FMP)

Financial Modeling Prep provides API and spreadsheet access to market data, fundamentals, news, calendars, transcripts, ownership, and macroeconomic data. The free Basic tier is an end-of-day test plan. Real-time, global, transcript, 13F, intraday, and bulk access require paid plans. Display or redistribution requires a separate commercial agreement.

FinancialData.Net

FinancialData.Net provides market data, fundamentals, ownership, options, funds, ESG, calendars, and news through REST, Excel, and MCP interfaces. It covers stocks, ETFs, mutual funds, futures, crypto, foreign exchange, commodities, OTC securities, and indexes. The free plan is limited, and the homepage security claims are not supported by a public audit report.

Finbox

Finbox combines global stock screens with company financials, valuation models, charts, watchlists, and spreadsheet exports. Investors can move from a screen into a company model or peer comparison. Regional access and export rights depend on the subscription.

FRED (Federal Reserve Economic Data)

FRED is the Federal Reserve Bank of St. Louis' free macroeconomic database. Use its series, charts, release calendar, Excel tools, mobile apps, and REST API for inflation, rates, GDP, employment, FX, credit, and market indicators. It is macro context, not equity fundamentals or brokerage infrastructure; API access needs a free key.

Hunter

Hunter finds, verifies, and enriches professional email addresses for analysts, founders, sales, and deal teams. It can support expert outreach, customer discovery, diligence interviews, and partnerships, but it is not investing data. Credits, API use, consent, opt-outs, and deliverability all need attention.

MarketXLS

MarketXLS puts market data, options, portfolio analytics, screens, and templates inside Excel. It covers stocks, ETFs, options, funds, crypto, forex, fundamentals, FRED, ETF holdings, and broker order tickets. It is personal-use spreadsheet software, not a redistributable data API; real-time coverage and exchange access are tiered.

OpenBB

OpenBB combines an open-source data layer with a hosted Workspace for dashboards, AI research, agents, and teams. It connects your providers, internal data, widgets, and MCP tools rather than supplying production market data itself. Community, Lite, and Pro cover different collaboration and enterprise needs.

Semrush

Semrush provides SEO, marketing, traffic, and AI-search visibility data that investors can use as alternative evidence for search-dependent companies, publishers, SaaS, ecommerce, and consumer brands. Its metrics are modeled signals, not reported revenue or fundamentals. Semrush is marketing software, not a broker or portfolio system.

Similarweb

Similarweb estimates web traffic, app usage, keywords, referrals, competitors, technologies, and online market share. It is alternative data for digital businesses, not reported financials. History, exports, APIs, integrations, and enterprise use are paid or custom.

StreamXLS

StreamXLS puts Interactive Brokers quotes, balances, positions, P&L, and open orders into Windows Excel through RTD. It can stage an order ticket for manual review in TWS, but it does not transmit trades, provide market-data entitlements, support Mac or browser Excel, or replace IBKR.

Tegus

Tegus is now part of AlphaSense. Its expert interviews, custom calls, financial models, filings, benchmarks, Excel tools, and AI research tools are built for professional diligence. AlphaSense does not publish Tegus prices.

Trading Economics

Trading Economics provides indicators, calendars, forecasts, market data, company financials, news, ratings, and events through web, REST, WebSocket, spreadsheet, BI, and AI integrations. It is data infrastructure for dashboards and pipelines, not a broker or adviser. Plans control streaming, limits, and commercial rights.

Trendlyne

Trendlyne is an India-first research and portfolio service with screens, DVM scores, forecasts, alerts, backtests, transcripts, broker sync, and options tools. Global plans add U.S. coverage, but the strongest fit remains Indian equities.

Visible Alpha

Visible Alpha provides model-derived estimates, company KPIs, consensus, historical actuals, and research tools. Access is licensed through S&P Global. It is not a retail screener or open API.

WhaleWisdom

WhaleWisdom organizes institutional 13F, 13D/G, and other ownership filings into fund pages, holdings, changes, screens, alerts, and data exports. It is useful for studying disclosed institutional portfolios, but the filings are delayed and incomplete.

Wisesheets

Wisesheets brings financial statements, ratios, prices, estimates, dividends, and other market data into Google Sheets and Excel. It suits spreadsheet-heavy research and models, not brokerage execution, a full terminal, or unrestricted redistribution.

YCharts

YCharts is a professional charting and reporting platform for market data, fundamentals, economics, portfolios, comparisons, and client-ready visuals. It suits advisors and analysts building repeatable research or reports, not retail brokerage execution.