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 main functions:
- TICKERDATALIVE - Real-time data (prices, company info)
- TICKERDATA - Historical data (financial statements, metrics)
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 |
| PE | Price-to-earnings ratio | 28.5 |
| Beta | Stock volatility | 1.25 |
| Vol Avg | Average volume | 52,400,000 |
| Dividend | Annual dividend | 0.96 |
| Dividend Yield | Yield percentage | 0.54% |
| 365 Day Range | 52-week high/low | 124.17 - 198.23 |
=TICKERDATALIVE("AAPL", "Price")
=TICKERDATALIVE("AAPL", "Market Cap")
=TICKERDATALIVE("AAPL", "PE")Time Periods for TICKERDATA
| Period | Description | Example |
|---|---|---|
| Year | Specific fiscal year | =TICKERDATA("AAPL", "Revenue", 2023) |
| TTM | Trailing twelve months | =TICKERDATA("AAPL", "Revenue", "ttm") |
| Q1-Q4 | Specific quarter | =TICKERDATA("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