Available Data

139 data points for TSX, TSXV and CSE companies in InvestorLens for Google Sheets. Find one, copy the formula, paste it in a cell.

Select a category

Choose a category to see its data points and copy the formula, or search for what you need.

Popular

How the formulas work

=IL(ticker, field, [period], [endPeriod])

One value for a company: a financial statement line, a key metric or a profile field. Statement fields take a period (a year, a quarter, "TTM" or "LQ"); add an end period to fill a row of years.

=IL("RY.TO","Revenue",2021,2025)

=ILPRICE(ticker, [field])

Price and valuation data. Returns the price when no field is given.

=ILPRICE("ENB.TO","Dividend Yield")

=ILTABLE(ticker, [statement], [periods], [count])

A whole statement as a table. Statement is "Income", "Balance", "Cash Flow" or "All"; periods is "Annual" or "Quarterly".

=ILTABLE("SHOP.TO","Income","Annual",5)

New to the add-on? See how it works. Questions? Visit Support.