InvestorLens for Google Sheets
Live prices, financial statements and key metrics for TSX, TSXV and CSE companies, straight into your spreadsheet. Type a formula and InvestorLens fills in the numbers.
Get started
- Install InvestorLens from the Google Workspace Marketplace (listing coming soon).
- In Google Sheets, open Extensions → InvestorLens → Open InvestorLens and sign in with Google. Your 7-day free trial starts automatically.
- Type a formula such as
=IL("RY.TO","Revenue",2025), or use the sidebar to search a company and insert formulas or whole statements. - Use Extensions → InvestorLens → Refresh data to reload the latest numbers.
Tickers can include the exchange suffix (RY.TO, TMG.V, ABC.CN) or not (RY). Field names are not case-sensitive.
Formulas
=IL(ticker, field, [period], [endPeriod])
Financial statement data: income statement, balance sheet and cash flow.
| =IL("RY.TO","Revenue") | Latest fiscal year |
| =IL("RY.TO","Revenue",2025) | Fiscal 2025 |
| =IL("RY.TO","Net Income","2025-Q3") | A single quarter (paid) |
| =IL("RY.TO","Free Cash Flow","TTM") | Trailing twelve months (paid) |
| =IL("RY.TO","Total Debt","LQ") | Latest quarter (paid) |
| =IL("RY.TO","Revenue",2021,2025) | A row of five years in one formula |
=ILPRICE(ticker, [field])
Live price and valuation data. Defaults to Price.
| =ILPRICE("SHOP.TO") | Current price |
| =ILPRICE("ENB.TO","Dividend Yield") | Dividend yield |
| =ILPRICE("CNQ.TO","Market Cap") | Market capitalization |
| =ILPRICE("TD.TO","P/E Ratio") | Price to earnings |
=ILMETRIC(ticker, field)
Key metrics: margins, returns, growth, financial health, dividends, bank and REIT metrics (paid).
| =ILMETRIC("RY.TO","ROE") | Return on equity |
| =ILMETRIC("ATD.TO","Revenue CAGR 4Y") | Four-year revenue growth |
| =ILMETRIC("FTS.TO","Consecutive Dividend Increases") | Dividend growth streak |
| =ILMETRIC("REI-UN.TO","FFO Per Share") | REIT funds from operations |
=ILPROFILE(ticker, [field])
Company profile. Defaults to Company Name.
| =ILPROFILE("CSU.TO","Sector") | Sector |
| =ILPROFILE("CSU.TO","Industry") | Industry |
| =ILPROFILE("CSU.TO","Latest Filing") | Most recent reporting period |
=ILTABLE(ticker, [statement], [periods], [count])
A whole financial statement as a table, oldest period on the left. Statement: "Income", "Balance", "Cash Flow" or "All". Periods: "Annual" or "Quarterly".
| =ILTABLE("RY.TO") | Last 5 years of the income statement |
| =ILTABLE("RY.TO","Balance","Annual",10) | 10 years of balance sheets (paid) |
| =ILTABLE("RY.TO","Cash Flow","Quarterly",8) | Last 8 quarters of cash flow (paid) |
Available fields
- Income statement
- Revenue, Cost of Revenue, Gross Profit, Research and Development, SG&A, Operating Expenses, Operating Income, Interest Expense, Interest Income, Depreciation and Amortization, EBITDA, Income Before Tax, Income Tax Expense, Net Income, EPS, EPS Diluted, Weighted Average Shares, Weighted Average Shares Diluted
- Balance sheet
- Cash and Cash Equivalents, Short Term Investments, Cash and Short Term Investments, Receivables, Inventory, Total Current Assets, Property Plant and Equipment, Goodwill, Intangible Assets, Total Assets, Accounts Payable, Short Term Debt, Total Current Liabilities, Long Term Debt, Total Debt, Net Debt, Total Liabilities, Retained Earnings, Shareholders Equity
- Cash flow
- Operating Cash Flow, Capital Expenditure, Free Cash Flow, Investing Cash Flow, Financing Cash Flow, Dividends Paid, Stock Based Compensation, Common Stock Issued, Common Stock Repurchased, Net Change in Cash
- Calculated
- Gross Margin, Operating Margin, Net Margin, Date (period end)
- ILPRICE
- Price, Change, Change %, Open, Day High, Day Low, Previous Close, Volume, Average Volume, Market Cap, Enterprise Value, P/E Ratio, P/B Ratio, EV/EBITDA, Beta, 52 Week High, 52 Week Low, 50 Day Average, 200 Day Average, Dividend Yield, Shares Outstanding, EPS, Book Value Per Share
- ILMETRIC
- Gross/EBITDA/EBIT/Operating/Net/OCF/FCF Margin, ROE, ROA, EPS TTM, Cash Flow/FCF/Revenue/Book Value/Tangible Book Value Per Share, Revenue/Gross Profit/EBITDA/Net Income/OCF/EPS/Book Value CAGR 4Y, Revenue/EBITDA/OCF YoY Growth, Current Ratio, Quick Ratio, Debt to Equity, Debt to Assets, Payout Ratio, FCF Payout Ratio, Dividend Per Share TTM, Consecutive Dividend Years, Consecutive Dividend Increases, Dividend CAGR 5Y/10Y, Net Interest Margin, Efficiency Ratio, Tier 1 Capital Ratio, FFO, FFO Per Share, Price to FFO, Distribution Yield, FFO Payout Ratio
- ILPROFILE
- Company Name, Ticker, Exchange, Sector, Industry, Description, Website, Is Bank, Is REIT, REIT Property Type, Latest Filing
Plans
Free
$0
- ✓ 5 years of annual data
- ✓ Prices and company profiles
- ✓ 100 requests a day
7-day trial
Free
- ✓ Every paid feature for 7 days
- ✓ No credit card needed
- ✓ Returns to Free afterwards
Sheets
$4.99 CAD/mo
- ✓ 10 years of annual data
- ✓ 40 quarters and TTM
- ✓ Key metrics (ILMETRIC)
- ✓ 2,000 requests a day
- ✓ Included in InvestorLens Premium
Upgrade from the add-on sidebar. InvestorLens Premium (see pricing) includes the Sheets add-on.
Your data and privacy
The add-on uses your Google email address to sign you in and only works inside the spreadsheet you have open. Your spreadsheet contents are never sent to InvestorLens: only the ticker, field and period in each formula. See the Privacy Policy and Terms of Service.
Questions? Visit Support or email support@investorlens.io.