MarketXLS

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

Syntax

=hf_Revenue(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Revenue value

Examples

=hf_Revenue("AAPL", "2023", "4")
Q4 2023 revenue
=hf_Revenue("MSFT", "2023", "3")
Q3 2023 revenue
=hf_Revenue("AAPL", "lq")
Last quarter revenue
=hf_Revenue("GOOGL", "2023", "4", "TTM")
TTM revenue
=hf_Revenue(A1, B1, C1)
Cell references

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

Why am I getting "NA"?

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

What currency is the value in?

Revenue is in the company's reporting currency. For US companies, this is USD.

How do I get trailing twelve months revenue?

Set the TTM parameter to "TTM": =hf_Revenue("AAPL", "2023", "4", "TTM")

Excel Templates Using Revenue (Historical)

These ready-made MarketXLS templates call hf_Revenue() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

See hf_Revenue used in a complete workbook: Dividend Tracker Excel: Build a Real-Time Income Portfolio Dashboard in 2026

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Revenue (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions