Investment Partner – Google Sheets Add-on

Real-Time Canadian Stock Data in Google Sheets

Access live market data and comprehensive financials of companies trading on TSX, TSX Venture and The Canadian Securities Exchange

Get Started Free

Powerful Features for Investors

📊

Real-Time Market Data

Get live stock prices, volume, market cap, trading data and more.

💼

Comprehensive Financials

Access 10 years of quarterly and annual financial statements.

📈

Key Metrics

Important metrics including financial ratios, TTM metrics, margins, and growth rates.

🎯

Simple Functions

IPLIVE() for real-time data and IP() for historical financials and company information.

🇨🇦

Complete Canadian Coverage

Covers over 3,000 companies trading on TSX, TSX Venture and the Canadian Securities Exchange.

💎

Small & Micro-Cap Specialists

The only add-on with comprehensive coverage of all Canadian small and micro-cap companies.

Easy-to-Use Functions

IPLIVE – Real-Time Market Data

=IPLIVE(“SHOP.TO”, “Price”)
=IPLIVE(“GSI.V”, “Volume”)
=IPLIVE(“URL.CN”, “MarketCap”)

Get current price, volume, market cap, P/E ratio, 52-week highs/lows, and more. Updates every 5 minutes during market hours.

IP – Financial Data & Metrics

=IP(“URL.CN”, “Revenue”, “TTM”)
=IP(“GSI.V”, “NetIncome”, “LQ”)
=IP(“SHOP.TO”, “ROE”, “2024-Q3”)

Access financial statements, ratios, company info, and calculated metrics. Supports TTM (trailing twelve months), LQ (last quarter), LY (last year), or specific periods.

Company Information

=IP(“EPF.V”, “Sector”)
=IP(“URL.CN”, “Industry”)
=IP(“SHOP.TO”, “Description”)

Get company details like sector, industry, CEO, employee count, website, address, and business description.

Financial Ratios

=IP(“SHOP.TO”, “CurrentRatio”, “LQ”)
=IP(“GSI.V”, “DebtToEquity”, “TTM”)
=IP(“URL.V”, “GrossMargin”, “2024”)

All ratios calculated consistently across all companies. Includes profitability, liquidity, leverage, and efficiency ratios.

Comprehensive Data Coverage

2,000+
Canadian Companies
TSX, TSX-V, and CSE coverage
10
Years of History
Quarterly and annual financials
5min
Update Frequency
During market hours
50+
Financial Metrics
Ratios, margins, and KPIs

Ready to Supercharge Your Investment Analysis?

Join investors who trust Investment Partner for their Canadian stock research

Install Add-on Now

Scroll to Top