1. Functions Reference
  2. Functions Overview

Functions Overview

Learn about the two core Tickerdata functions and when to use each one.

The Two Core Functions

Tickerdata provides two powerful functions that cover all your financial data needs:

FunctionPurposeUse When
TICKERDATAHistorical & fundamental dataYou need past financials, ratios, or metrics
TICKERDATALIVEReal-time market dataYou need current prices, company info, or live metrics

TICKERDATA

Syntax: =TICKERDATA(ticker, attribute, timeperiod, period)

Use this for historical financial data including:

  • Income statements (Revenue, Net Income, EPS, etc.)
  • Balance sheets (Assets, Liabilities, Debt, etc.)
  • Cash flow statements (Operating Cash Flow, Free Cash Flow, etc.)
  • Key metrics and ratios (PE Ratio, ROE, Dividend Yield, etc.)

Examples:

=TICKERDATA("AAPL", "Revenue", 2023)
=TICKERDATA("MSFT", "Net Income", 2023, "Q1")
=TICKERDATA("GOOGL", "Free Cash Flow", "ttm")

Full TICKERDATA Documentation

TICKERDATALIVE

Syntax: =TICKERDATALIVE(ticker, attribute)

Use this for real-time data including:

  • Current stock price
  • Market capitalization
  • Company information (name, sector, industry)
  • Live valuation metrics (PE, DCF)

Examples:

=TICKERDATALIVE("AAPL", "Price")
=TICKERDATALIVE("TSLA", "Market Cap")
=TICKERDATALIVE("BTCUSD", "Price")

Full TICKERDATALIVE Documentation

Quick Reference

When to Use TICKERDATA

  • Building financial models with historical data
  • Analyzing year-over-year trends
  • Comparing quarterly performance
  • Calculating valuation metrics from fundamentals
  • Researching past financial statements

When to Use TICKERDATALIVE

  • Tracking current portfolio value
  • Building stock watchlists
  • Getting company information
  • Monitoring real-time prices
  • Checking live valuation ratios

Tip

Most portfolios and dashboards use both functions together - TICKERDATALIVE for current prices and TICKERDATA for fundamental analysis.

Asset Class Support

Both functions support multiple asset classes with specific formatting:

Asset ClassFormatExample
US StocksStandard ticker“AAPL”, “MSFT”
CryptocurrencySymbol + currency“BTCUSD”, “ETHUSD”
InternationalTicker + exchange suffix“MC.PA”, “7203.T”

See Ticker Formats for complete formatting guide.

Common Parameters

ParameterDescription
tickerStock symbol - format varies by asset class
attributeThe specific data field to retrieve (browse all)
timeperiodYear (e.g., 2023) or “ttm” for trailing twelve months
periodQuarter: “Q1”, “Q2”, “Q3”, or “Q4” (TICKERDATA only)

Info

All functions are case-insensitive. `=TICKERDATALIVE("aapl", "price")` works the same as `=TICKERDATALIVE("AAPL", "Price")`.

Error Handling

When a function encounters an error, it returns a standard error message:

ErrorMeaning
#VALUE!Invalid ticker or parameter
#N/AData not available
Loading...Data is being fetched - wait or refresh

Tip

Wrap functions in `IFERROR()` to handle errors gracefully: `=IFERROR(TICKERDATALIVE("INVALID", "Price"), "Not found")`

Next Steps