Exchange rate
fx_rateConvert between two ISO currencies using European Central Bank daily reference rates; pass a date for historical rates needed in cross-currency returns or balance-sheet comparisons.
Instructions
Exchange rate between two currencies, from the European Central Bank's daily reference rates via Frankfurter. No credential, no cap. Needed whenever a screen leaves the US — a balance sheet in yen cannot be compared against a dollar cash balance without one. Pass a date to get a historical rate, which is what a return calculation across currencies requires.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| on | No | Rate as of this date. Omit for the latest. Weekends and holidays return the last published rate before them. | |
| base | Yes | ISO currency code to convert FROM, e.g. "USD". | |
| quote | Yes | ISO currency code to convert TO, e.g. "JPY". |