Revenue (Historical)
Returns historical revenue (total sales) for a company for a specified period. Revenue is the top-line income from sales of goods and services.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (e.g., 2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last quarter |
| lq-1 | Two quarters ago |
| ly | Last year |
| ly-1 | Two years ago |
Notes
- Values are in the company's reporting currency
- Quarterly data shows that quarter only (not cumulative)
- Use TTM="TTM" for trailing twelve month revenue
Examples
=hf_Revenue("AAPL", "2023", "4")=hf_Revenue("MSFT", "2023", "3")=hf_Revenue("AAPL", "lq")=hf_Revenue("GOOGL", "2023", "4", "TTM")=hf_Revenue(A1, B1, C1)When to Use
- Analyzing historical sales trends
- Building financial models
- Comparing quarterly performance
- Calculating growth rates
- Valuation analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current revenue | Revenue() |
| Need revenue growth | RevenueGrowth() |
| Need gross profit | hf_Gross_Profit() |
| Need net income | hf_Net_Income() |
| Need operating income | hf_Operating_Income() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is valid and has fundamental data available
- The year/quarter combination exists in the data
- The company has reported financials for that period
Q: What currency is the value in? A: Revenue is in the company's reporting currency. For US companies, this is USD.
Q: How do I get trailing twelve months revenue?
A: Set the TTM parameter to "TTM":
=hf_Revenue("AAPL", "2023", "4", "TTM")
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?