IP.EXCHANGERATE function
Description
Returns the exchange rate.
Syntax
=IP.EXCHANGERATE(BaseCurrency, ComparisonCurrency, DateTime, RateType)
| Attribute | R/O | Description |
|---|---|---|
| BaseCurrency | (required) | Base currency code (3 char) |
| ComparisonCurrency | (required) | Comparison currency code (3 char) |
| DateTime | (required) | Date and time effective from (yyyy-mm-dd hh:mm) |
| RateType | (optional) | Exchange rate type code |
Example:
=IP.EXCHANGERATE("GBP","EUR","2024-01-25 12:00","DEFAULT")
Important
The DateTime parameter must be enclosed in double quotes.
e.g. "2024-01-25 12:00"
Note
Exchange rate types
There are Author based exchange rate types but the User can add their own.
Updated June 2025