How to use Wisesheets – The Ultimate Guide

Wisesheets tutorial

Wisesheets is the most powerful stock add-in to help you retrieve all the essential stock data you need to make great investment decisions. From real-time stock data to company financials, using Wisesheets, you can get all the stock data you need in your Excel or Google Sheets spreadsheet. This guide will teach you how to use Wisesheets to make better investment decisions and save time by not copying/pasting stock data.

Table of Contents

If you prefer a video version, see the video below.

Historical Stock Data in Excel and Google Sheets

Currently, Wisesheets offers two ways to get historical stock data:

Statement Dump

When you log into Wisesheets, you will see the statement dump window that looks like the image below. Here you can get stock financial statements, key metrics, and growth metrics going back 19 years and 72 quarters. Simply enter the stock ticker or company name you'd like to retrieve data for, select annual or quarterly, select standardized financials or SEC as reported financials, and get all of the information at once in different tabs of your spreadsheet.

Wisesheets financials

Keep in mind we recommend using standardized financials because they are better for comparing financial performance across companies. Reported SEC financials are also helpful to better understand the specific items and amounts reported to the SEC. SEC statement dump is in BETA as the financial items are not spaced or capitalized yet, and the items may be out of order. This will be addressed in future updates where financial statement notes and segmented revenue information is likely to be included.

The WISE function

Instead of getting all the stock data at once, you can get specific items from the financial statements using the WISE function. This allows you to build custom models that enable you to analyze a stock in any way you'd like, such as building stock dashboards, DCFs, or any other stock analysis model.

The WISE function syntax is =WISE("ticker", "parameter/s", "period/s", "quarter")

For a visual tutorial on cell referencing, press the tutorial button on the WISE function menu.

Wisesheets WISE function
WISE function tutorial

The first parameter is where you enter the company's stock ticker you are looking to get data for. For example, Apple's ticker is "AAPL". Note that for stock exchanges outside of the USA, you might need to add an extension. For example, Shopify's (listed on the Toronto Stock Exchange) ticker is "SHOP.TO". If you are unsure about your stock's ticker, use the same convention as Yahoo Finance. For a list of stock exchanges covered and their respective extension, see the stock exchanges covered section.

The second parameter is for the data point you would like to retrieve from the stock you entered. For a full list of data points available, click here. Currently, the data available includes all items listed under the income, statement, balance sheet, cash flow statements, key metrics, growth metrics section, and more. Again, capitalization and spacing do not matter, but the spelling must be the same.

The third parameter is the period you'd like to get the data from. Here you can select either a specific year, "TTM" (which returns the results from the sum of the last 4 quarters), "LY" (Last Fiscal Year), or "LQ" (Last Fiscal Quarter). You can also use "LY-1", "LY-2", "LY-3"… and "LQ-1", "LQ-2", "LQ-3", etc., to get the data from previous fiscal quarters or years.

The fourth parameter is optional. If it is not entered, the function will return the data for the selected period. However, if you'd like to retrieve quarterly data, you need to use "Q1", "Q2", "Q3," or "Q4". These quarterly periods are based on the company's fiscal years, which may or may not be aligned with the current calendar year.

Altogether here is an example of a simple function call =WISE("AAPL", "revenue", 2020, "Q4")

*Note if you are thinking of requesting large volumes of data, we have a better option for you below.

Large Data Requests Option

Instead of making too many simultaneous function requests, we have developed a way for you to get multiple stock data points at once.

This functionality is very simple as you saw before the WISE function syntax is =WISE("ticker", "parameter/s", "period/s", "quarter")

All you need to do is enter a range of cells instead of a singular parameter or enter a range of periods instead of a single period. You can see how that works in this example:

WISE function parameters

As you can see, the function is getting all these key metrics for Apple across the different periods in a single function call. This saves you a lot of time and makes your spreadsheet faster.

Note that if the key metrics were the columns and the periods the rows, the function would still return the data in the format you need.

Cell Referencing

Instead of manually writing the function parameters in the function, you can reference cells that contain the parameters you are looking for. In this example, you can see a model build to retrieve a company's revenue over 3 years.

Wisesheets income statement model

Cell locking is very useful when you want to drag the function across cells and get the data you need. To lock cells horizontally, use $ before the cell letter, to lock cells vertically, use $ after the cell letter, to lock cells entirely, use the $ before and after the cell letter.

Historical quarterly dividend payments

Using the WISE function, it is simply to get past stock and ETF dividend payments. You can get individual quarterly dividend payments as follows:

=WISE("ticker", "dividend", "LQ")

This will return the latest quarterly dividend paid by a stock or ETF.

Dividends in Excel

Moreover, you can get multiple historical dividends or their sum by entering multiple quarterly periods in the WISE function.

Historical dividend payments sheet

As you can see, this returns the past 4 dividend payments. You can also warp this into a SUM function to get the SUM of the past 4 dividend payments in one cell like this:

=SUM(WISE("aapl","dividend",{"lq","lq-1","lq-2","lq-3"}))

Lastly, you can get the sum of the dividend payments for a particular year by entering the following function command:

=WISE("ticker", "dividend", year/s)

dividend payments excel

This will provide you with the sum of the dividend payments made in that year regardless of the payment frequency of the ETF or stock.

Historical dividend payment history

If you are looking for stock's dividend data on Excel or Google Sheets, you will love this. With the =WISEPRICE function, you can get all the dividend data you need for the companies you need in a single function call. All you have to do is enter =WISEPRICE("ticker", "dividend")

Dividend stock data on Excel
The image is cropped but the data goes back to 1985

As you can see, this will return the date, dividend, adjusted dividend, payment date, and declaration date.

Segment & geographic revenue breakdowns

Looking to get a specific company’s revenue breakdown across key business segments and geographic markets?

Using the WISE function, you can get this data on a quarterly and annual basis.

To get segment revenue breakdowns, all you have to do is use the function as follows =WISE(“ticker”, “segment revenues”, period).

For example, to get apple’s revenue breakdown per segment in 2020, you can use =WISE(“aapl”, “segment revenues”, 2020)

Apple Segment revenues Excel

You can also substitute the specific year for “LY”, “LY-1”, “LY-2” etc, which provides you with the latest fiscal year data or the previous fiscal years.

The same concept applies to geographic revenues, except you need to use “geographic revenues” as the parameter. For example, to get apple’s geographic revenue breakdown 3 quarters ago, you can use this function call =WISE(“aapl”, “geographic revenues”, “LQ-2”)

Apple geographic revenues Excel

Due to some technical details for quarterly data, you can only use the LQ, LQ-1, etc, period type for this data.

*This feature is only for companies that report to the SEC since the data comes from these reports.

Historical price data

You can also retrieve historical price data for stocks and ETFs using Wisesheets via the =WISEPIRCE function.

The formula syntax works as follows: =WISEPRICE("ticker", "parameter", "number of days", "start date", "end date").

The list of available historical parameters includes:

  • Open
  • High
  • Low
  • Close
  • AdjClose
  • Volume
  • Unadjusted Volume
  • Change
  • Change Percent
  • Vwap
  • Label
  • ChangeOverTime

The number of days parameter is optional. If you do enter a value like 30 it will return the last 30 business days worth of historical data for whatever parameter you've selected along with the respective date.

For example =WISEPRICE("AAPL", "Close", 30)

Apple historical stock price

In cases where you want to get this data for a specific period, like between January 1, 2022 and January 30, 2022 you can leave this parameter blank.

You have the option to enter a specific date range from which to get data. Make sure to use the yyyy-mm-dd format.

For example, if you are looking to get Apple's volume between March 1st and March 30th in 2022 you need to enter the following function command in a cell =WISEPRICE("AAPL", "volume", , "2022-03-01", "2022-03-30")

Apple's volume Excel

You can also use cell referencing to enter multiple parameters at once in the function and reference cells that are in the date format to ensure you are getting the data for the correct time period.

Real-Time Stock Data

Besides being able to retrieve historical stock data, you can also get real-time stock data for the following parameters:

  • Symbol
  • Name
  • Price
  • Changes Percentage
  • Change
  • Day Low
  • Day High
  • Year High
  • Year Low
  • Market Cap
  • Price Avg 50
  • Price Avg 200
  • Volume
  • Avg Volume
  • Exchange
  • Open
  • Previous Close
  • EPS
  • PE
  • Shares Outstanding
  • Earnings announcement
  • Timestamp

WISEPRICE function

The WISEPRICE function is used to get the live stock data. The syntax for this function is =WISEPRICE("ticker/s", "parameter/s")

Similar to the WISE function, the first parameter is where you enter the stock ticker/s of the company you are looking to get data for. The same rule from above for stock exchanges outside of the USA applies.

The second parameter/s is where you select your data point. The list of available parameters is available above. Keep in mind, that capitalization and spacing do not matter, but the spelling must be the same.

Refreshing Live Stock Data

One of the benefits of the WISEPRICE function is that you can refresh the data at any point by pressing the refresh button on the WISEPRICE function window. This will allow you to refresh the data for cells containing the WISEPRICE formula and get the data you need updated.

Wisesheets real-time stock data on Google Sheets

Cell Referencing

Similar to the WISE function, instead of manually writing the function parameters in the function, you can reference cells that contain the parameter/s and ticker/s you are looking for. In this example, you can see a model build to retrieve multiple stock's live prices, pe, and market cap.

Live stock data Google Sheets

Note that if the tickers were the columns and the parameters the rows, the function would still return the data in the format you need

TTM Key Metrics

Getting stock TTM key metrics which some change all the time based on factors like the stock price has never been easier. Via the =WISE function you can get access to the following metrics:

  1. Revenue Per Share
  2. Net Income Per Share
  3. Operating Cash Flow Per Share
  4. Free Cash Flow Per Share
  5. Cash Per Share
  6. Book Value Per Share
  7. Tangible Book Value Per Share
  8. Shareholders Equity Per Share
  9. Interest Debt Per Share
  10. Market Cap
  11. Enterprise Value
  12. Pe Ratio
  13. Price To Sales Ratio
  14. Pocfratio
  15. Pfcf Ratio
  16. Pb Ratio
  17. Ptb Ratio
  18. Ev To Sales
  19. Enterprise Value Over EBITDA
  20. Ev To Operating Cash Flow
  21. Ev To Free Cash Flow
  22. Earnings Yield
  23. Free Cash Flow Yield
  24. Debt To Equity
  25. Debt To Assets
  26. Net Debt To EBITDA
  27. Current Ratio
  28. Interest Coverage
  29. Income Quality
  30. Dividend Yield
  31. Payout Ratio
  32. Sales General And Administrative To Revenue
  33. Research And Ddevelopement To Revenue
  34. Intangibles To Total Assets
  35. Capex To Operating Cash Flow
  36. Capex To Revenue
  37. Capex To Depreciation
  38. Stock Based Compensation To Revenue
  39. Graham Number
  40. Roic
  41. Return On Tangible Assets
  42. Graham Net Net
  43. Working Capital
  44. Tangible Asset Value
  45. Net Current Asset Value
  46. Average Receivables
  47. Average Payables
  48. Average Inventory
  49. Days Sales Outstanding
  50. Days Payables Outstanding
  51. Days Of Inventory On Hand
  52. Receivables Turnover
  53. Payables Turnover
  54. Inventory Turnover
  55. Roe
  56. Capex Per Share

All you have to do is enter =WISE("ticker", parameter/s, "ttm"). For example =WISE("AAPL", "Dividend yield", "TTM")

Company profile information

Using the =WISEPRICE function, you can access important stock information for a company or list of companies, including:

  • Beta
  • Vol Avg
  • Last Div
  • Range
  • Currency
  • Cik
  • ISIN
  • CUSIP
  • Exchange
  • Exchange Short Name
  • Industry
  • Website
  • Description
  • CEO
  • Sector
  • Country
  • Full Time Employees
  • Phone
  • Address
  • City
  • State
  • Zip
  • Is ETF
  • Is Actively Trading
  • Is ADR
  • Is Fund

For example, you can use the following function call to get the beta, sector, and industry for this list of stocks.

Beta, sector and industry on your spreadsheet

How To Build A Custom Stock Screener

Building a custom-made stock screener and obtaining the necessary data is super simple with Wisesheets. Here's all you need to do:

  1. Get a list of stocks in your Excel or Google Sheets spreadsheet. Remember, we use the same ticker system as Yahoo Finance.
  2. Select the parameters from which you'd like to retrieve data. This includes income statement items, balance sheet, cash flow statement, key metrics, growth metrics, and real-time price data. You can refer to the table below for the full list of items and available periods.

Once you have the list of stocks and parameters set up, you can easily proceed to the next steps. Simply navigate to the WISE Screener section of the add-in.

In the WISE Screener section, use your mouse to select the list of tickers you would like to gather data for. Once selected, click on the 4 square icon to proceed.

Stock list

Next, do the same for the parameters you've chosen. Don't forget to include the period in the parameter, such as LQ [Latest quarter], LY [Latest year], and TTM [Trailing twelve months]. If you omit the period, the default value returned will be LY (latest fiscal year value). It's worth noting that capitalization and spacing do not matter.

Excel stock screener

Once you've completed the above steps, it's time to retrieve the data. Simply click on the "Get Data" button, and your screener will be generated. You will notice a bucket created, holding the tickers and parameters you've selected.

You can easily manage the screener by utilizing the refresh button, which allows you to obtain the latest data at any time. Additionally, you have the option to rename the bucket for future reference or delete it when no longer needed.

Please keep in mind that the bucket can only be refreshed in the spreadsheet tab where you have the tickers and parameters located together. Refreshing the data in another tab will not work.

The beauty of using Wisesheets for your stock screening needs is that it returns and updates the data more quickly compared to using functions. It also provides the flexibility to apply filters, such as sorting companies by highest revenue, without the functions automatically refreshing.

Screener data available

Data CategoryItem/metricPeriod/s AvailableExample
SymbolLive Price DataNASymbol
NameLive Price DataNAName
PriceLive Price DataNAPrice
Changes PercentageLive Price DataNAChanges Percentage
ChangeLive Price DataNAChange
Day LowLive Price DataNADay Low
Day HighLive Price DataNADay High
Year HighLive Price DataNAYear High
Year LowLive Price DataNAYear Low
Market CapLive Price DataNAMarket Cap
Price Avg 50Live Price DataNAPrice Avg 50
Price Avg 200Live Price DataNAPrice Avg 200
VolumeLive Price DataNAVolume
Avg VolumeLive Price DataNAAvg Volume
ExchangeLive Price DataNAExchange
OpenLive Price DataNAOpen
Previous CloseLive Price DataNAPrevious Close
EPSLive Price DataNAEPS
PELive Price DataNAPE
Shares OutstandingLive Price DataNAShares Outstanding
Earnings AnnouncementLive Price DataNAEarnings Announcement
TimestampLive Price DataNATimestamp
DateIncome StatementLY,LQ, TTMDate LY
RevenueIncome StatementLY,LQ, TTMRevenue TTM
Reported CurrencyIncome StatementLY,LQ, TTMReported Currency LY
PeriodIncome StatementLY,LQ, TTMPeriod LY
CIKIncome StatementLY,LQ, TTMCIK LQ
Filling DateIncome StatementLY,LQ, TTMFilling Date TTM
Accepted DateIncome StatementLY,LQ, TTMAccepted Date LY
Calendar YearIncome StatementLY,LQ, TTMCalendar Year LQ
Cost Of RevenueIncome StatementLY,LQ, TTMCost Of Revenue LQ
Gross ProfitIncome StatementLY,LQ, TTMGross Profit LQ
Gross Profit RatioIncome StatementLY,LQ, TTMGross Profit Ratio LQ
Research And Development ExpensesIncome StatementLY,LQ, TTMResearch And Development Expenses LY
General And Administrative ExpensesIncome StatementLY,LQ, TTMGeneral And Administrative Expenses TTM
Selling And Marketing ExpensesIncome StatementLY,LQ, TTMSelling And Marketing Expenses LQ
Other ExpensesIncome StatementLY,LQ, TTMOther Expenses TTM
Operating ExpensesIncome StatementLY,LQ, TTMOperating Expenses LY
Cost And ExpensesIncome StatementLY,LQ, TTMCost And Expenses LQ
Interest ExpenseIncome StatementLY,LQ, TTMInterest Expense LY
Depreciation And AmortizationIncome StatementLY,LQ, TTMDepreciation And Amortization LQ
EBITDAIncome StatementLY,LQ, TTMEBITDA LQ
EBITDA RatioIncome StatementLY,LQ, TTMEBITDA Ratio LQ
Operating IncomeIncome StatementLY,LQ, TTMOperating Income LQ
Operating Income RatioIncome StatementLY,LQ, TTMOperating Income Ratio LQ
Total Other Income Expenses NetIncome StatementLY,LQ, TTMTotal Other Income Expenses Net LY
Income Before TaxIncome StatementLY,LQ, TTMIncome Before Tax TTM
Income Before Tax RatioIncome StatementLY,LQ, TTMIncome Before Tax Ratio TTM
Income Tax ExpenseIncome StatementLY,LQ, TTMIncome Tax Expense TTM
Net IncomeIncome StatementLY,LQ, TTMNet Income LY
Net Income RatioIncome StatementLY,LQ, TTMNet Income Ratio LQ
EPSIncome StatementLY,LQ, TTMEPS LY
EPS DilutedIncome StatementLY,LQ, TTMEPS Diluted LY
Weighted Average Shs OutIncome StatementLY,LQ, TTMWeighted Average Shs Out TTM
Weighted Average Shs Out DiIncome StatementLY,LQ, TTMWeighted Average Shs Out Di LY
DateBalance SheetLY,LQ, TTMDate LQ
Cash And Cash EquivalentsBalance SheetLY,LQ, TTMCash And Cash Equivalents LY
PeriodBalance SheetLY,LQ, TTMPeriod TTM
CIKBalance SheetLY,LQ, TTMCIK LQ
Filling DateBalance SheetLY,LQ, TTMFilling Date TTM
Accepted DateBalance SheetLY,LQ, TTMAccepted Date LY
Calendar YearBalance SheetLY,LQ, TTMCalendar Year LQ
Short Term InvestmentsBalance SheetLY,LQ, TTMShort Term Investments LY
Cash And Short Term InvestmentsBalance SheetLY,LQ, TTMCash And Short Term Investments TTM
Net ReceivablesBalance SheetLY,LQ, TTMNet Receivables LY
InventoryBalance SheetLY,LQ, TTMInventory LY
Other Current AssetsBalance SheetLY,LQ, TTMOther Current Assets TTM
Total Current AssetsBalance SheetLY,LQ, TTMTotal Current Assets TTM
Property Plant Equipment NetBalance SheetLY,LQ, TTMProperty Plant Equipment Net TTM
GoodwillBalance SheetLY,LQ, TTMGoodwill TTM
Intangible AssetsBalance SheetLY,LQ, TTMIntangible Assets TTM
Goodwill And Intangible AssetsBalance SheetLY,LQ, TTMGoodwill And Intangible Assets LQ
Long Term InvestmentsBalance SheetLY,LQ, TTMLong Term Investments TTM
Tax AssetsBalance SheetLY,LQ, TTMTax Assets TTM
Other Non Current AssetsBalance SheetLY,LQ, TTMOther Non Current Assets LY
Total Non Current AssetsBalance SheetLY,LQ, TTMTotal Non Current Assets LY
Other AssetsBalance SheetLY,LQ, TTMOther Assets LY
Total AssetsBalance SheetLY,LQ, TTMTotal Assets LQ
Account PayablesBalance SheetLY,LQ, TTMAccount Payables LY
Short Term DebtBalance SheetLY,LQ, TTMShort Term Debt LQ
Tax PayablesBalance SheetLY,LQ, TTMTax Payables LY
Deferred RevenueBalance SheetLY,LQ, TTMDeferred Revenue LY
Other Current LiabilitiesBalance SheetLY,LQ, TTMOther Current Liabilities LY
Total Current LiabilitiesBalance SheetLY,LQ, TTMTotal Current Liabilities LY
Long Term DebtBalance SheetLY,LQ, TTMLong Term Debt LY
Deferred Revenue Non CurrentBalance SheetLY,LQ, TTMDeferred Revenue Non Current LQ
Deferred Tax Liabilities Non CurrentBalance SheetLY,LQ, TTMDeferred Tax Liabilities Non Current LY
Other Non Current LiabilitiesBalance SheetLY,LQ, TTMOther Non Current Liabilities TTM
Total Non Current LiabilitiesBalance SheetLY,LQ, TTMTotal Non Current Liabilities LQ
Other LiabilitiesBalance SheetLY,LQ, TTMOther Liabilities LQ
Total LiabilitiesBalance SheetLY,LQ, TTMTotal Liabilities LQ
Minority InterestBalance SheetLY,LQ, TTMMinority Interest LY
Total EquityBalance SheetLY,LQ, TTMTotal Equity TTM
Total Liabilities and Total EquityBalance SheetLY,LQ, TTMTotal Liabilities and Total Equity LY
Common StockBalance SheetLY,LQ, TTMCommon Stock LQ
Preferred StockBalance SheetLY,LQ, TTMPreferred Stock LY
Retained EarningsBalance SheetLY,LQ, TTMRetained Earnings LQ
Accumulated Other Comprehensive Income LossBalance SheetLY,LQ, TTMAccumulated Other Comprehensive Income Loss LQ
Other Total Stockholders EquityBalance SheetLY,LQ, TTMOther Total Stockholders Equity TTM
Total Stockholders EquityBalance SheetLY,LQ, TTMTotal Stockholders Equity LY
Total Liabilities And Stockholders EquityBalance SheetLY,LQ, TTMTotal Liabilities And Stockholders Equity LQ
Total InvestmentsBalance SheetLY,LQ, TTMTotal Investments LY
Total DebtBalance SheetLY,LQ, TTMTotal Debt LY
Net DebtBalance SheetLY,LQ, TTMNet Debt LQ
DateCash FlowLY,LQ, TTMDate LQ
Deferred Income TaxCash FlowLY,LQ, TTMDeferred Income Tax TTM
Net Income CashflowCash FlowLY,LQ, TTMNet Income Cashflow LQ
Depreciation and AmortizationCash FlowLY,LQ, TTMDepreciation and Amortization LQ
PeriodCash FlowLY,LQ, TTMPeriod LY
CIKCash FlowLY,LQ, TTMCIK LY
Filling DateCash FlowLY,LQ, TTMFilling Date LY
Accepted DateCash FlowLY,LQ, TTMAccepted Date LQ
Calendar YearCash FlowLY,LQ, TTMCalendar Year LQ
Stock Based CompensationCash FlowLY,LQ, TTMStock Based Compensation LQ
Change In Working CapitalCash FlowLY,LQ, TTMChange In Working Capital LQ
Accounts ReceivablesCash FlowLY,LQ, TTMAccounts Receivables LY
Accounts PayablesCash FlowLY,LQ, TTMAccounts Payables TTM
Other Working CapitalCash FlowLY,LQ, TTMOther Working Capital TTM
Other Non Cash ItemsCash FlowLY,LQ, TTMOther Non Cash Items TTM
Net Cash Provided By Operating ActivitiesCash FlowLY,LQ, TTMNet Cash Provided By Operating Activities TTM
Investments In Property Plant And EquipmentCash FlowLY,LQ, TTMInvestments In Property Plant And Equipment LY
Acquisitions NetCash FlowLY,LQ, TTMAcquisitions Net TTM
Purchases Of InvestmentsCash FlowLY,LQ, TTMPurchases Of Investments TTM
Sales Maturities Of InvestmentsCash FlowLY,LQ, TTMSales Maturities Of Investments LY
Other Investing ActivitesCash FlowLY,LQ, TTMOther Investing Activites TTM
Net Cash Used For Investing ActivitesCash FlowLY,LQ, TTMNet Cash Used For Investing Activites TTM
Debt RepaymentCash FlowLY,LQ, TTMDebt Repayment LQ
Common Stock IssuedCash FlowLY,LQ, TTMCommon Stock Issued LY
Common Stock RepurchasedCash FlowLY,LQ, TTMCommon Stock Repurchased LQ
Dividends PaidCash FlowLY,LQ, TTMDividends Paid TTM
Other Financing ActivitesCash FlowLY,LQ, TTMOther Financing Activites LQ
Net Cash Used Provided By Financing ActivitiesCash FlowLY,LQ, TTMNet Cash Used Provided By Financing Activities LQ
Effect Of Forex Changes On CashCash FlowLY,LQ, TTMEffect Of Forex Changes On Cash LY
Net Change In CashCash FlowLY,LQ, TTMNet Change In Cash LY
Cash At End Of PeriodCash FlowLY,LQ, TTMCash At End Of Period TTM
Cash At Beginning Of PeriodCash FlowLY,LQ, TTMCash At Beginning Of Period LQ
Operating Cash FlowCash FlowLY,LQ, TTMOperating Cash Flow LQ
Capital ExpenditureCash FlowLY,LQ, TTMCapital Expenditure LQ
Free Cash FlowCash FlowLY,LQ, TTMFree Cash Flow TTM
Inventory CashflowCash FlowLY,LQ, TTMInventory Cashflow LQ
DateKey MetricsLY,LQ, TTMDate LQ
Revenue Per ShareKey MetricsLY,LQ, TTMRevenue Per Share LY
Net Income Per ShareKey MetricsLY,LQ, TTMNet Income Per Share TTM
Operating Cash Flow Per ShareKey MetricsLY,LQ, TTMOperating Cash Flow Per Share TTM
Free Cash Flow Per ShareKey MetricsLY,LQ, TTMFree Cash Flow Per Share TTM
Cash Per ShareKey MetricsLY,LQ, TTMCash Per Share TTM
Book Value Per ShareKey MetricsLY,LQ, TTMBook Value Per Share LY
Tangible Book Value Per ShareKey MetricsLY,LQ, TTMTangible Book Value Per Share TTM
Shareholders Equity Per ShareKey MetricsLY,LQ, TTMShareholders Equity Per Share LQ
Interest Debt Per ShareKey MetricsLY,LQ, TTMInterest Debt Per Share LY
Market CapKey MetricsLY,LQ, TTMMarket Cap LQ
Enterprise ValueKey MetricsLY,LQ, TTMEnterprise Value TTM
PE RatioKey MetricsLY,LQ, TTMPE Ratio TTM
Price To Sales RatioKey MetricsLY,LQ, TTMPrice To Sales Ratio LQ
POCF RatioKey MetricsLY,LQ, TTMPOCF Ratio LQ
PFCF RatioKey MetricsLY,LQ, TTMPFCF Ratio LY
PB RatioKey MetricsLY,LQ, TTMPB Ratio LY
PTB RatioKey MetricsLY,LQ, TTMPTB Ratio LQ
EV To SalesKey MetricsLY,LQ, TTMEV To Sales TTM
Enterprise Value Over EBITDAKey MetricsLY,LQ, TTMEnterprise Value Over EBITDA TTM
EV To Operating Cash FlowKey MetricsLY,LQ, TTMEV To Operating Cash Flow LY
EV To Free Cash FlowKey MetricsLY,LQ, TTMEV To Free Cash Flow LQ
Earnings YieldKey MetricsLY,LQ, TTMEarnings Yield LQ
Free Cash Flow YieldKey MetricsLY,LQ, TTMFree Cash Flow Yield LQ
Debt To EquityKey MetricsLY,LQ, TTMDebt To Equity LY
Debt To AssetsKey MetricsLY,LQ, TTMDebt To Assets TTM
Net Debt To EBITDAKey MetricsLY,LQ, TTMNet Debt To EBITDA LY
Current RatioKey MetricsLY,LQ, TTMCurrent Ratio TTM
Interest CoverageKey MetricsLY,LQ, TTMInterest Coverage LY
Income QualityKey MetricsLY,LQ, TTMIncome Quality LY
Dividend YieldKey MetricsLY,LQ, TTMDividend Yield TTM
Payout RatioKey MetricsLY,LQ, TTMPayout Ratio LY
Sales General And Administrative To RevenueKey MetricsLY,LQ, TTMSales General And Administrative To Revenue TTM
Research And Ddevelopement To RevenueKey MetricsLY,LQ, TTMResearch And Ddevelopement To Revenue LY
Intangibles To Total AssetsKey MetricsLY,LQ, TTMIntangibles To Total Assets LQ
Capex To Operating Cash FlowKey MetricsLY,LQ, TTMCapex To Operating Cash Flow LQ
Capex To RevenueKey MetricsLY,LQ, TTMCapex To Revenue LY
Capex To DepreciationKey MetricsLY,LQ, TTMCapex To Depreciation LY
Stock Based Compensation To RevenueKey MetricsLY,LQ, TTMStock Based Compensation To Revenue LY
Graham NumberKey MetricsLY,LQ, TTMGraham Number LQ
ROICKey MetricsLY,LQ, TTMROIC LY
Return On Tangible AssetsKey MetricsLY,LQ, TTMReturn On Tangible Assets LY
Graham Net NetKey MetricsLY,LQ, TTMGraham Net Net LY
Working CapitalKey MetricsLY,LQ, TTMWorking Capital TTM
Tangible Asset ValueKey MetricsLY,LQ, TTMTangible Asset Value LQ
Net Current Asset ValueKey MetricsLY,LQ, TTMNet Current Asset Value LY
Net Current Asset ValueKey MetricsLY,LQ, TTMNet Current Asset Value LQ
Average ReceivablesKey MetricsLY,LQ, TTMAverage Receivables TTM
Average PayablesKey MetricsLY,LQ, TTMAverage Payables TTM
Average InventoryKey MetricsLY,LQ, TTMAverage Inventory LQ
Days Sales OutstandingKey MetricsLY,LQ, TTMDays Sales Outstanding TTM
Days Payables OutstandingKey MetricsLY,LQ, TTMDays Payables Outstanding LQ
Days Of Inventory On HandKey MetricsLY,LQ, TTMDays Of Inventory On Hand LQ
Receivables TurnoverKey MetricsLY,LQ, TTMReceivables Turnover TTM
Payables TurnoverKey MetricsLY,LQ, TTMPayables Turnover LY
Inventory TurnoverKey MetricsLY,LQ, TTMInventory Turnover TTM
ROEKey MetricsLY,LQ, TTMROE LY
Capex Per ShareKey MetricsLY,LQ, TTMCapex Per Share LY
DateGrowth MetricsLY, LQ,Date LQ
Revenue GrowthGrowth MetricsLY, LQ,Revenue Growth LY
Gross Profit GrowthGrowth MetricsLY, LQGross Profit Growth LQ
EBIT growthGrowth MetricsLY, LQEBIT growth LY
Operating Income GrowthGrowth MetricsLY, LQOperating Income Growth LY
Net Income GrowthGrowth MetricsLY, LQNet Income Growth LQ
EPS GrowthGrowth MetricsLY, LQEPS Growth LQ
EPS Diluted GrowthGrowth MetricsLY, LQEPS Diluted Growth LQ
Weighted Average Shares GrowthGrowth MetricsLY, LQWeighted Average Shares Growth LY
Weighted Average Shares Diluted GrowthGrowth MetricsLY, LQWeighted Average Shares Diluted Growth LQ
Dividends Per Share GrowthGrowth MetricsLY, LQDividends Per Share Growth LQ
Operating Cash Flow GrowthGrowth MetricsLY, LQOperating Cash Flow Growth LY
Free Cash Flow GrowthGrowth MetricsLY, LQFree Cash Flow Growth LY
Ten Y Revenue Growth Per ShareGrowth MetricsLY, LQTen Y Revenue Growth Per Share LQ
Five Y Revenue Growth Per ShareGrowth MetricsLY, LQFive Y Revenue Growth Per Share LY
Three Y Revenue Growth Per ShareGrowth MetricsLY, LQThree Y Revenue Growth Per Share LQ
Ten Y Operating CF Growth Per ShareGrowth MetricsLY, LQTen Y Operating CF Growth Per Share LY
Five Y Operating CF Growth Per ShareGrowth MetricsLY, LQFive Y Operating CF Growth Per Share LQ
Three Y Operating CF Growth Per ShareGrowth MetricsLY, LQThree Y Operating CF Growth Per Share LY
Ten Y Net Income Growth Per ShareGrowth MetricsLY, LQTen Y Net Income Growth Per Share LQ
Five Y Net Income Growth Per ShareGrowth MetricsLY, LQFive Y Net Income Growth Per Share LQ
Three Y Net Income Growth Per ShareGrowth MetricsLY, LQThree Y Net Income Growth Per Share LY
Ten Y Shareholders Equity Growth Per ShareGrowth MetricsLY, LQTen Y Shareholders Equity Growth Per Share LY
Five Y Shareholders Equity Growth Per ShareGrowth MetricsLY, LQFive Y Shareholders Equity Growth Per Share LQ
Three Y Shareholders Equity Growth Per ShareGrowth MetricsLY, LQThree Y Shareholders Equity Growth Per Share LQ
Ten Y Dividend Per Share Growth Per ShareGrowth MetricsLY, LQTen Y Dividend Per Share Growth Per Share LY
Five Y Dividend Per Share Growth Per ShareGrowth MetricsLY, LQFive Y Dividend Per Share Growth Per Share LQ
Three Y Dividend Per Share Growth Per ShareGrowth MetricsLY, LQThree Y Dividend Per Share Growth Per Share LY
Receivables GrowthGrowth MetricsLY, LQReceivables Growth LY
Inventory GrowthGrowth MetricsLY, LQInventory Growth LQ
Asset GrowthGrowth MetricsLY, LQAsset Growth LQ
Book Value per Share GrowthGrowth MetricsLY, LQBook Value per Share Growth LQ
Debt GrowthGrowth MetricsLY, LQDebt Growth LY
RD Expense GrowthGrowth MetricsLY, LQRD Expense Growth LQ
SGA Expenses GrowthGrowth MetricsLY, LQSGA Expenses Growth LY

Final words

Now you know how to get stock financials and real-time price data on Excel and Google Sheets using Wisesheets without wasting countless hours copying/pasting stock data.

We hope this helps you make better investment decisions.

We will continue updating the list of available functions, so stay tuned for more updates!

For a free Wisesheets account, click here.

Best Regards,

The Wisesheets Team

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts