Revenue USD (Historical)
Returns the company's revenue converted to US dollars. Useful for comparing international companies that report in different currencies.
Notes
- Revenue translated to USD
- Useful for comparing global companies
- Exchange rate as of reporting period
- Eliminates currency comparison issues
Syntax
=hf_Revenue_USD(Symbol, Year, [Quarter], [TTM])Examples
=hf_Revenue_USD("AAPL", 2023)=hf_Revenue_USD("MSFT", 2023, 2)=hf_Revenue_USD("GOOGL", "lq")=hf_Revenue_USD("TSLA", "ly")=hf_Revenue_USD(A1, B1, C1)When to Use
Global company comparisons, USD-normalized analysis, international peer comparison
When NOT to Use
| Need local currency revenue | hf_Revenue() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Revenues Year To Date (Historical)
- Sale Of Long Term Investments (Historical)
- Sale Of Property Plant Equipment (Historical)
- Sale Of Short Term Investments (Historical)
- Sales Indicator (Historical)
- Sales Per Dollar Inventory (Historical)
- Sales Per Dollar Receivables (Historical)
- Sales Per Employee (Historical)
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?