Intrinio Excel Add-in

The Intrinio Excel Add-in transforms Microsoft Excel into a powerful financial data workstation by providing direct access to Intrinio's API without requiring programming skills.

Reviewed by 7wData
API Available

On this page

Publisher review

The Intrinio Excel Add-in transforms Microsoft Excel into a powerful financial data workstation by providing direct access to Intrinio's API without requiring programming skills. Designed for financial analysts, portfolio managers, and retail investors who rely on Excel for modeling and analysis, it bridges the gap between spreadsheet functionality and professional-grade market data. The add-in supports both Windows and Mac versions of Excel, making it accessible to a broad user base. Its core value proposition lies in enabling users to pull real-time, historical, and alternative data directly into Excel cells through simple formulas, eliminating the need for manual data entry or complex integrations.

The add-in offers comprehensive financial data coverage, including real-time and streaming stock prices, detailed options data with full chains and Greeks, and extensive fundamental data like income statements and balance sheets. It supports economic data series and alternative datasets, providing over 100,000 unique financial data tags and metrics. Unique among competitors, it integrates with Snowflake for direct database access, enabling large-scale data analysis. Pre-built templates for financial modeling and analysis accelerate workflow, while API keys allow programmatic access for advanced users. The tool also supports data visualization and reporting, making it suitable for both ad-hoc analysis and formal reporting needs.

Compared to alternatives like MarketXLS and Microsoft 365 Stocks, Intrinio stands out for its depth of options data and Snowflake integration, though it lacks some of MarketXLS's streaming capabilities. It offers more financial data coverage than Daloopa's equity research tools but requires more setup than plug-and-play solutions like Finsheet. Quandl/Nasdaq Data Link provides comparable historical data but lacks Intrinio's real-time functionality and Excel-native interface. The add-in occupies a middle ground between basic free tools and expensive enterprise solutions, making it ideal for serious analysts who need professional data without terminal-level complexity.

Trade-offs include a steeper learning curve than simpler portfolio trackers, particularly when leveraging advanced features like Snowflake integration. While comprehensive, the data coverage may overwhelm casual users who only need basic stock quotes. The pricing structure, while not exorbitant, positions it as a premium tool compared to free alternatives like Microsoft 365 Stocks. Some users report initial setup challenges, particularly with firewall configurations, though the troubleshooting documentation is thorough. The add-in's strength in fundamental and options data comes at the expense of lighter technical analysis features compared to specialized trading platforms.

Get the AI & data signal, daily.

48k+ subscribers read this every morning. One email, both newsletters. Unsubscribe anytime.

How it works

  1. Real-time stock prices

    Provides streaming and real-time equity pricing data that updates automatically in Excel cells, supporting active trading strategies.

  2. Full options chains

    Delivers complete options market data including strikes, expirations, open interest, and Greeks (delta, gamma, theta, vega).

  3. Fundamental data integration

    Access to 100,000+ financial metrics including income statements, balance sheets, and cash flow statements for global companies.

  4. Snowflake database integration

    Direct connection to Snowflake enables large-scale data analysis without leaving Excel, a unique capability among add-ins.

  5. Economic data series

    Includes macroeconomic indicators and alternative datasets for broader market analysis beyond company-specific metrics.

  6. Pre-built Excel templates

    Offers ready-to-use financial models and analysis templates that accelerate common workflows like DCF modeling.

  7. Cross-platform support

    Works on both Windows and Mac versions of Excel, with consistent functionality across operating systems.

Strengths and trade-offs

Strengths

  • The add-in provides unmatched options data depth among Excel tools, including full chains with Greeks for sophisticated derivatives analysis.
  • Snowflake integration allows direct querying of massive datasets within Excel, a capability absent in most competing financial add-ins.
  • With over 100,000 financial data tags, it offers more fundamental metrics than alternatives like Finsheet or Portfolio123.
  • The real-time data streaming functionality outperforms delayed-data competitors such as Microsoft 365 Stocks for active trading scenarios.

Trade-offs

  • The extensive data options require substantial Excel expertise to fully leverage, creating a steep learning curve for casual users.
  • Firewall configuration issues commonly arise during setup, particularly in corporate environments with strict IT policies.
  • Pricing falls between free basic tools and premium platforms, potentially deterring budget-conscious individual investors.
  • Technical analysis features are less developed than specialized trading platforms, limiting charting and indicator capabilities.

Pricing context

Mid-range pricing ($$–$$$), positioned between free basic tools and premium enterprise solutions, with tiered access based on data needs.

Getting started with Intrinio Excel Add-in

  1. Sign up

    Create an account on Intrinio's website to access the Excel Add-in. Provide your email, set a password, and verify your account to proceed.

  2. Download add-in

    Download the Intrinio Excel Add-in from the official website. Ensure compatibility with your Excel version (Windows or Mac) before installation.

  3. Install add-in

    Open Excel and install the downloaded add-in. Follow the installation prompts and enable the add-in from Excel's settings or add-ins menu.

  4. Connect API key

    Obtain your API key from Intrinio's dashboard. Enter the key in the add-in's settings to authenticate and enable data access.

  5. Pull data

    Use Intrinio's Excel formulas to pull real-time stock prices, options data, or financial metrics directly into your spreadsheet cells.

Frequently Asked Questions

What is the Intrinio Excel Add-in?

The Intrinio Excel Add-in transforms Microsoft Excel into a financial data workstation, enabling users to access real-time, historical, and alternative data directly in Excel. It supports Windows and Mac versions, making it accessible for financial analysts and investors without requiring programming skills.

How does Intrinio Excel Add-in compare to MarketXLS?

Intrinio Excel Add-in offers deeper options data and Snowflake integration compared to MarketXLS. While MarketXLS excels in streaming capabilities, Intrinio provides more comprehensive financial data coverage, making it ideal for advanced financial modeling and analysis.

Can I use Intrinio Excel Add-in on a Mac?

Yes, Intrinio Excel Add-in supports both Windows and Mac versions of Excel. It offers consistent functionality across operating systems, allowing users to access real-time and historical financial data seamlessly on either platform.

What kind of financial data can I access with Intrinio Excel Add-in?

Intrinio Excel Add-in provides access to real-time stock prices, full options chains, fundamental data like income statements, and economic data series. It supports over 100,000 financial metrics, enabling detailed financial analysis directly within Excel.

Is Intrinio Excel Add-in easy to set up?

While Intrinio Excel Add-in is powerful, it has a steeper learning curve than simpler tools. Initial setup may involve firewall configuration challenges, but thorough troubleshooting documentation is available to assist users in overcoming these hurdles.

How much does Intrinio Excel Add-in cost?

Intrinio Excel Add-in is priced mid-range, offering tiered access based on data needs. It positions itself between free basic tools and premium enterprise solutions, making it a cost-effective choice for serious financial analysts requiring professional-grade data.

Alternatives

How Intrinio Excel Add-in compares

Direct head-to-head against 3 competitors. Picked by 7wData.

This tool

Intrinio Excel Add-in

Pricing
Mid-range pricing ($$–$$$), positioned between free basic tools and premium enterprise solutions, with tiered access based on data needs.
Target
The Intrinio Excel Add-in transforms Microsoft Excel into a powerful financial data workstation by providing direct access to Intrinio's API without requiring programming skills.
Strength
The add-in provides unmatched options data depth among Excel tools, including full chains with Greeks for sophisticated derivatives analysis.
Watch for
The extensive data options require substantial Excel expertise to fully leverage, creating a steep learning curve for casual users.

MarketXLS

Pricing
$49.95/month or $499.95/year
Target
Professional investors, options traders, financial advisors
Deployment
Excel add-in
Strength
Real-time streaming stock prices and full options chains with Greeks
Watch for
Steeper learning curve for casual users

Daloopa

Pricing
Custom/Enterprise pricing
Target
Equity research analysts, financial modelers
Deployment
Excel add-in
Strength
AI-powered financial data extraction and normalization
Watch for
No real-time data, enterprise-focused pricing

Quandl / Nasdaq Data Link

Pricing
$49/month starter plan, $499/month premium
Target
Developers, quantitative analysts
Deployment
API with Excel integration
Strength
Deep historical and alternative datasets
Watch for
No real-time streaming, API-first approach

User reviews

No user reviews yet. Be the first to write one.

Sources

Reporting on this tool draws on these publicly available sources.

  1. help.intrinio.com
  2. marketxls.com
  3. intrinio.com
  4. github.com
  5. docs.intrinio.com