Working with Historical Data
Learn how to use TICKERDATA to fetch historical financial data and fundamentals.
Beyond Live Prices
Now that you’ve fetched your first stock quote with TICKERDATALIVE, let’s explore the TICKERDATA function for historical financial data. In this guide, you’ll learn how to:
- Fetch historical financial statements
- Get annual vs quarterly data
- Use TTM (trailing twelve months) data
The TICKERDATA Function
The TICKERDATA function retrieves historical financial data spanning 30+ years.
Syntax
=TICKERDATA(ticker, attribute, timeperiod, period)=TICKERDATA.DATA(ticker, attribute, timeperiod, period)| Parameter | Required | Description |
|---|---|---|
| ticker | Yes | Stock symbol (e.g., “AAPL”) |
| attribute | Yes | Financial metric to retrieve |
| timeperiod | Yes | Year (2023) or “ttm” |
| period | No | Quarter: “Q1”, “Q2”, “Q3”, “Q4” |
Example: Annual Revenue
Enter the Formula
In any cell, enter:
=TICKERDATA("AAPL", "Revenue", 2023)=TICKERDATA.DATA("AAPL", "Revenue", 2023)View the Result
You’ll see Apple’s annual revenue for fiscal year 2023.
Working with Time Periods
For full-year data, just specify the year:
=TICKERDATA("AAPL", "Revenue", 2023)=TICKERDATA.DATA("AAPL", "Revenue", 2023)Building a Financial Summary
Create a company financial snapshot:
| Metric | 2023 | 2022 | 2021 |
|---|---|---|---|
| Revenue | =TICKERDATA("AAPL", "Revenue", 2023)=TICKERDATA.DATA("AAPL", "Revenue", 2023) | =TICKERDATA("AAPL", "Revenue", 2022)=TICKERDATA.DATA("AAPL", "Revenue", 2022) | =TICKERDATA("AAPL", "Revenue", 2021)=TICKERDATA.DATA("AAPL", "Revenue", 2021) |
| Net Income | =TICKERDATA("AAPL", "Net Income", 2023)=TICKERDATA.DATA("AAPL", "Net Income", 2023) | =TICKERDATA("AAPL", "Net Income", 2022)=TICKERDATA.DATA("AAPL", "Net Income", 2022) | =TICKERDATA("AAPL", "Net Income", 2021)=TICKERDATA.DATA("AAPL", "Net Income", 2021) |
| EPS | =TICKERDATA("AAPL", "EPS", 2023)=TICKERDATA.DATA("AAPL", "EPS", 2023) | =TICKERDATA("AAPL", "EPS", 2022)=TICKERDATA.DATA("AAPL", "EPS", 2022) | =TICKERDATA("AAPL", "EPS", 2021)=TICKERDATA.DATA("AAPL", "EPS", 2021) |
Popular Attributes
Tip
Swap the attribute for any of these and the rest of the formula stays the same:
=TICKERDATA("MSFT", "Revenue", 2023)=TICKERDATA.DATA("MSFT", "Revenue", 2023)- Income statement -
Revenue,Gross Profit,Operating Income,Net Income,EPS - Balance sheet -
Total Assets,Total Debt,Cash And Cash Equivalents,Total Equity - Cash flow -
Operating Cash Flow,Free Cash Flow,Capital Expenditure - Key metrics -
Price To Earnings Ratio,Return On Equity,Debt To Equity Ratio,Current Ratio
Pro Tips
Use cell references for flexibility, e.g.
=TICKERDATA(A1, B1, C1, D1)=TICKERDATA.DATA(A1, B1, C1, D1), where A1 contains the ticker, B1 the attribute, and so onDouble quotes required - All text must use double quotes (not single)
Case insensitive - “Revenue” and “revenue” work the same
Next Steps
- Browse the Attribute Explorer to find and search all 200+ available attributes
- View all available TICKERDATA attributes
- Learn about data types and what each metric means
- Build a Stock Analyzer template
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.