Basic Features

The free features fall into four 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.

Pro Users can pass in a range of cells for either argument, which will return a range of data. See the Data Range Pro Feature for more.

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
  • dividendDate - Dividend Date
  • earningsTimestamp - Most recent earnings date
  • earningsTimestampStart - Next earnings date, start of range
  • earningsTimestampEnd - Next earnings date, end of range
  • trailingAnnualDividendYield - Annual dividend yield
  • trailingAnnualDividendRate - Annual dividend rate
  • averageDailyVolume3Month - Average Daily Volume for past 3 months
  • averageDailyVolume10Day - Average Daily Volume for past 10 days
  • 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.

Pro Users can pass in a range of cells for either argument, which will return a range of data. See the Data Range Pro Feature for more.

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
  • beta - Beta (3Y Monthly)
  • earningsQuarterlyGrowth - Quarterly Earnings Growth (yoy)
  • enterpriseToRevenue - Enterprise Value/Revenue
  • enterpriseToEbitda - Enterprise Value/EBITDA
  • 52WeekChange - 52-Week Change
  • SandP52WeekChange - S&P500 52-Week Change
  • bookValue - Book Value
  • priceToBook - Price to Book ratio
  • lastFiscalYearEnd - End date of the last fiscal year
  • nextFiscalYearEnd - End date of the next fiscal year
  • mostRecentQuarter - Most recent quarter
  • netIncomeToCommon - Amount of net income to common shares
  • trailingEps - Trailing EPS
  • forwardEps - Forward EPS
  • pegRatio - PEG Ratio

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.

Pro Users can pass in a range of cells for either argument, which will return a range of data. See the Data Range Pro Feature for more.

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 - Total Debt to Equity (mrq)
  • 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

Profile Data

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

=STOCK_PROFILE_DATA(symbol, data)

This function 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.

Pro Users can pass in a range of cells for either argument, which will return a range of data. See the Data Range Pro Feature for more.

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

List of data arguments

  • address1 - Address Street Line 1
  • address2 - Address Street Line 2
  • city - Address City
  • state - Address State
  • zip - Address Zip Code
  • country - Address Country
  • phone - Phone Number
  • website - Website URL
  • industry - Industry Category
  • sector - Sector Category
  • longBusinessSummary - Summary about business
  • fullTimeEmployees - Number of full-time employees

Video Overview