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.