Earnings per Basic Share USD (Historical)
Returns the historical basic earnings per share (EPS) converted to US dollars. This is essential for comparing EPS across companies that report in different currencies.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, TSM) |
| Year | Yes | Fiscal year (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 | Description |
|---|---|
lq |
Last reported quarter |
lq-1 |
One quarter ago |
ly |
Last fiscal year |
ly-1 |
Previous fiscal year |
lt |
Last twelve months (TTM) |
Notes
- USD conversion uses period-end exchange rates
- For US companies, same as basic EPS
- Enables apples-to-apples EPS comparisons globally
- Formula: Net Income to Common (USD) / Weighted Average Basic Shares
Examples
=hf_Earnings_per_Basic_Share_USD("AAPL", 2023, 4)=hf_Earnings_per_Basic_Share_USD("TSM", "ly")=hf_Earnings_per_Basic_Share_USD("ASML", 2023, , "TTM")=hf_Earnings_per_Basic_Share_USD(A1, B1, C1)=hf_Earnings_per_Basic_Share_USD("BABA", "lq")When to Use
- Comparing EPS across countries/currencies
- Building global stock screeners
- International portfolio analysis
- Currency-neutral earnings comparisons
- Cross-border valuation analysis
When NOT to Use
Common Issues & FAQ
Q: Why is USD EPS different from local currency EPS? A: Exchange rate fluctuations cause differences. The USD value reflects the exchange rate at period end.
Q: Which EPS should I use for P/E ratios? A: Use the same currency as the stock price. If using USD stock prices, use USD EPS.
Q: Is this adjusted for ADR ratios? A: This is per-share of the underlying stock. For ADRs, you may need to adjust for the ADR ratio.
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?