MarketXLS

Foreign Currency to USD Exchange Rate (Historical)

Returns the exchange rate used to convert the company's reporting currency to USD for a specific period.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Notes

  • For US companies, this typically returns 1.0
  • For foreign companies, shows the conversion rate used
  • Useful for understanding currency impact on financials

Syntax

=hf_Foreign_Currency_to_USD_Exchange_Rate(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

Exchange rate to USD

Examples

=hf_Foreign_Currency_to_USD_Exchange_Rate("AAPL", 2023, 4)
US company = 1.0
=hf_Foreign_Currency_to_USD_Exchange_Rate("SAP", "ly")
German company rate
=hf_Foreign_Currency_to_USD_Exchange_Rate("TSM", 2023)
Taiwan company rate

When to Use

  • Understanding currency impact on financials
  • Normalizing international comparisons
  • Historical FX analysis for companies
  • Currency risk assessment

When NOT to Use

Scenario Use Instead
Current forex rates Forex functions
Real-time FX Streaming forex functions
Spot rates Currency pair functions

Common Issues & FAQ

Why is the rate always 1.0?

US-based companies report in USD, so the rate is 1.0.

What currency is being converted?

The company's reporting currency is converted to USD.

Related Formulas

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

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 Foreign Currency to USD Exchange Rate (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions