Basic Features


The free features fall into three main categories:

Each category has a unique function associated with it. And each function can take a lot of options, providing you with a number of different ways to access the data you need.

Fundamental Data

To pull a stock’s Fundamental Data, use the function:

=STOCK_FUNDAMENTALS(symbol, data)

This function takes two required arguments. The first is the symbol of the stock you would like data for. An example is GOOG. This argument can be either a string using double quotes—like "GOOG"—or it can be a reference to a spreadsheet cell that has the symbol as text in it—like A1.

The second argument is the type of fundamental data you want for the stock. Like the first argument, this can be passed in as either a string using double quotes or as a reference to a cell with the information. There are many options for this argument.

Below is a full list of every available option and what data it refers to.

List of data arguments

  • regularMarketPrice - Price
  • regularMarketChange - Change
  • regularMarketOpen - Open
  • regularMarketDayHigh - High
  • regularMarketDayLow - Low
  • regularMarketVolume - Volume
  • averageDailyVolume3Month - Avg Vol (3 month)
  • averageDailyVolume10Day - Avg Vol (10 day)
  • regularMarketChangePercent - Change in price per share
  • regularMarketDayRange - Range of prices per share for the most recent trading day
  • regularMarketPreviousClose - Closing price per share for the previous trading day
  • longName - Name of company
  • bid - Bid price
  • bidSize - Bid size
  • ask - Ask price
  • askSize - Ask size
  • forwardPE - Forward PE
  • trailingPE - P/E (TTM)
  • priceToBook - Price/Book
  • epsTrailingTwelveMonths - EPS (TTM)
  • epsForward - Forward EPS
  • bookValue - Book Value per share
  • sharesOutstanding - Shares Outstanding
  • marketCap - Market Cap
  • trailingAnnualDividendYield - Annual dividend yield
  • trailingAnnualDividendRate - Annual dividend rate
  • fiftyDayAverage - Average price over last 50 days
  • fiftyDayAverageChange - Average price change over last 50 days
  • fiftyDayAverageChangePercent - Average price change over last 50 days as %
  • twoHundredDayAverage - Average price per share over last 200 days
  • twoHundredDayAverageChange - Average price change over last 200 days
  • twoHundredDayAverageChangePercent - Average price change over last 200 days as %
  • fiftyTwoWeekRange - Range of prices for the last 52 weeks
  • fiftyTwoWeekHigh - High in the last 52 weeks
  • fiftyTwoWeekHighChange - Change in the high in the last 52 weeks
  • fiftyTwoWeekHighChangePercent - Change in the high in the last 52 weeks as a %
  • fiftyTwoWeekLow - Low in the last 52 weeks
  • fiftyTwoWeekLowChange - Change in the low in the last 52 weeks
  • fiftyTwoWeekLowChangePercent - Change in the low in the last 52 weeks as a %

Key Statistics

To get a stock’s Key Statistics, use the function:

=STOCK_KEY_STATISTICS(symbol, data)

This function takes two required arguments, just like above. The first is the symbol of the stock you want data for—as either a string or cell reference–and the second is the type of data you want.

Below is a full list of every available option and what data it refers to.

List of data arguments

  • enterpriseValue - Enterprise Value
  • forwardPE - Forward P/E
  • profitMargins - Profit Margins
  • floatShares - Float
  • sharesOutstanding - Shares Outstanding
  • heldPercentInsiders - % Held by Insiders
  • heldPercentInstitutions - % Held by Institutions
  • shortRatio - Short Ratio
  • sharesShort - Shares Short
  • shortPercentOfFloat - Short % of Float
  • sharesPercentSharesOut - Short % of Shares Outstanding
  • sharesShortPriorMonth - Shares Short (prior month)
  • sharesShortPreviousMonthDate - Date of prior month for Shares Short (as unix timestamp)
  • beta - Beta (3Y Monthly)
  • earningsQuarterlyGrowth - Quarterly Earnings Growth (yoy)
  • enterpriseToRevenue - Enterprise Value/Revenue
  • enterpirseToEbitda - Enterprise Value/EBITDA
  • 52WeekChange - 52-Week Change
  • sandP52WeekChange - S&P500 52-Week Change

Financial Data

To get a stock’s Financial Data, use the function:

=STOCK_FINANCIAL_DATA(symbol, data)

This function also takes two required arguments. The first is the symbol of the stock you want data for—as either a string or cell reference–and the second is the type of data you want.

Below is a full list of every available option and what data it refers to.

List of data arguments

  • currentPrice - Current price
  • targetHighPrice - Target High
  • targetLowPrice - Target Low
  • targetMedianPrice - Target Median
  • totalCash - Total Cash (mrq)
  • totalCashPerShare - Total Cash Per Share (mrq)
  • ebitda - EBITDA
  • totalDebt - Total Debt (mrq
  • quickRatio - Quick ratio
  • currentRatio - Current Ratio (mrq)
  • totalRevenue - Total Revenue
  • debtToEquity - Debt to equity
  • revenuePerShare - Revenue Per Share (ttm)
  • returnOnAssets - Return on Assets
  • returnOnEquity - Return on Equity
  • grossProfits - Gross Profit (ttm)
  • freeCashflow - Free Cash Flow
  • operatingCashflow - Operating Cash Flow
  • earningsGrowth - Earnings Growth
  • revenueGrowth - Quarterly Revenue Growth (yoy)
  • grossMargins - Gross Margins
  • ebitdaMargins - EBITDA Margins
  • operatingMargins - Operating Margins
  • profitMargins - Profit Margins
  • financialCurrency - Financial Currency

Video Overview