Available Data Types
Explore all the types of financial data you can access through Tickerdata.
Overview
Tickerdata provides access to multiple categories of financial data through two functions:
- TICKERDATALIVE - Real-time data (prices, company info)
- TICKERDATA - Historical data (financial statements, metrics)
Excel spells them TICKERDATA.LIVE and TICKERDATA.DATA - see what the functions are called.
Use the Attribute Explorer to search and browse all 200+ available attributes with descriptions, example formulas, and use cases.
Data Categories
Real-time market data via TICKERDATALIVE:
| Attribute | Description | Example |
|---|---|---|
| Price | Current stock price | 178.50 |
| Market Cap | Market capitalization | 2.8T |
| Beta | Stock volatility | 1.25 |
| Average Volume | Average volume (formerly “Vol Avg”) | 52,400,000 |
| Last Dividend | Annual dividend (formerly “Dividend”) | 0.96 |
| Dividend Yield | Yield percentage | 0.54% |
| 365 Day Range | 52-week high/low | 124.17 - 198.23 |
=TICKERDATALIVE("AAPL", "Price")=TICKERDATA.LIVE("AAPL", "Price")Time Periods for TICKERDATA
| Period | Description | Example |
|---|---|---|
| Year | Specific fiscal year | =TICKERDATA("AAPL", "Revenue", 2023)=TICKERDATA.DATA("AAPL", "Revenue", 2023) |
| TTM | Trailing twelve months | =TICKERDATA("AAPL", "Revenue", "ttm")=TICKERDATA.DATA("AAPL", "Revenue", "ttm") |
| Q1-Q4 | Specific quarter | =TICKERDATA("AAPL", "Revenue", 2023, "Q1")=TICKERDATA.DATA("AAPL", "Revenue", 2023, "Q1") |
Info
Not all metrics support TTM. If you get an error with TTM, try using a specific year instead.
Data Availability
- US Stocks: Full data coverage
- International: Coverage varies by exchange
- Crypto: Price and market cap data via TICKERDATALIVE
Next Steps
- Browse the Attribute Explorer for a complete searchable reference of every attribute
- See the Functions Reference for complete documentation
- Explore TICKERDATA attributes
- Explore TICKERDATALIVE attributes
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.