Functions Overview
Learn about the two core Tickerdata functions and when to use each one.
The Two Core Functions
Tickerdata provides two functions that cover all your financial data needs:
| Function | Purpose | Use When |
|---|---|---|
TICKERDATA | Historical & fundamental data | You need past financials, ratios, or metrics |
TICKERDATALIVE | Real-time market data | You need current prices, company info, or live metrics |
What They Are Called
Excel groups an add-in’s functions under a namespace; Google Sheets does not. The same two functions are therefore spelled differently depending on which spreadsheet you are in:
| Purpose | Google Sheets | Microsoft Excel |
|---|---|---|
| Historical & fundamental | TICKERDATA | TICKERDATA.DATA |
| Real-time market data | TICKERDATALIVE | TICKERDATA.LIVE |
The arguments are identical, so only the name changes. A formula copied out of a Google Sheet will not work in Excel until it is renamed, and the same the other way round.
TICKERDATA
Syntax:
=TICKERDATA(ticker, attribute, timeperiod, period)=TICKERDATA.DATA(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 (Price To Earnings Ratio, Return On Equity, Dividend Yield, etc.)
Examples:
=TICKERDATA("AAPL", "Revenue", 2023)=TICKERDATA.DATA("AAPL", "Revenue", 2023)=TICKERDATA("MSFT", "Net Income", 2023, "Q1")=TICKERDATA.DATA("MSFT", "Net Income", 2023, "Q1")=TICKERDATA("GOOGL", "Free Cash Flow", "ttm")=TICKERDATA.DATA("GOOGL", "Free Cash Flow", "ttm")TICKERDATALIVE
Syntax:
=TICKERDATALIVE(ticker, attribute)=TICKERDATA.LIVE(ticker, attribute)Use this for real-time data including:
- Current stock price
- Market capitalization
- Company information (name, sector, industry)
- Live market metrics (Beta, Dividend Yield, Average Volume)
Examples:
=TICKERDATALIVE("AAPL", "Price")=TICKERDATA.LIVE("AAPL", "Price")=TICKERDATALIVE("TSLA", "Market Cap")=TICKERDATA.LIVE("TSLA", "Market Cap")=TICKERDATALIVE("BTCUSD", "Price")=TICKERDATA.LIVE("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 dividend yields and market stats
Tip
Asset Class Support
Both functions support multiple asset classes with specific formatting:
| Asset Class | Format | Example |
|---|---|---|
| US Stocks | Standard ticker | “AAPL”, “MSFT” |
| Cryptocurrency | Symbol + currency | “BTCUSD”, “ETHUSD” |
| International | Ticker + exchange suffix | “MC.PA”, “7203.T” |
See Ticker Formats for complete formatting guide.
Common Parameters
| Parameter | Description |
|---|---|
ticker | Stock symbol - format varies by asset class |
attribute | The specific data field to retrieve (browse all) |
timeperiod | Year (e.g., 2023) or “ttm” for trailing twelve months |
period | Quarter: “Q1”, “Q2”, “Q3”, or “Q4” (TICKERDATA only) |
Info
Error Handling
When a function encounters an error, it returns a standard error message:
| Error | Meaning |
|---|---|
#VALUE! | Invalid ticker or parameter |
#N/A | Data not available |
Loading... (Sheets) or #BUSY! (Excel) | Data is being fetched - wait or refresh |
Tip
=IFERROR(TICKERDATALIVE("INVALID", "Price"), "Not found")=IFERROR(TICKERDATA.LIVE("INVALID", "Price"), "Not found")Next Steps
- Browse the Attribute Explorer to search all 200+ available attributes
- Explore TICKERDATA for historical and fundamental data
- Learn TICKERDATALIVE for real-time quotes and company info
Didn't find what you came for?
Tell us the sheet you're trying to make and we'll point you at the right numbers.