Overview
The Foreign Exchange Rates API provides access to current and historical foreign exchange rates published by the European Central Bank. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can lookup and convert currencies as well as list currency rates directly in your spreadsheet.
What you can do
With this integration, you can:
- Convert currencies using current or historical rates
- Lookup current conversion rates published by the European Central Bank
- Lookup historical conversion rates for a set of dates
- List foreign exchange rates for a basket of currencies
What you need
You need to have a Flex.io account to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.
Functions and Syntax
This integration for Microsoft Excel or Google Sheets includes the following functions:
Currency Converter
Returns an amount in one currency type from an amount in another currency type
Syntax
=FLEX("YOUR_TEAM_NAME/currency-converter", amt, cur1, cur2, [date])
Sample Usage
=FLEX("YOUR_TEAM_NAME/currency-converter", 100, "USD", "EUR") =FLEX("YOUR_TEAM_NAME/currency-converter", 200, "EUR", "USD", "2018-12-31") =FLEX("YOUR_TEAM_NAME/currency-converter", A1, B1, C1)
Parameters
| Property | Type | Description | Required |
|---|---|---|---|
amt |
number | The value to convert from one currency to another | true |
cur1 |
string | The currency type to convert from | true |
cur2 |
string | The currency type to convert to | true |
date |
date | The exchange rate date | false |
Returns
| Property | Type | Description |
|---|---|---|
amount |
numeric | The converted currency amount |
Notes
This function uses the https://exchangeratesapi.io API to convert the rates from one into another.
The following currency types are allowed: CAD, HKD, ISK, PHP, DKK, HUF, CZK, GBP, RON, SEK, IDR, INR, BRL, RUB, HRK, JPY, THB, CHF, EUR, MYR, BGN, TRY, CNY, NOK, NZD, ZAR, USD, MXN, SGD, AUD, ILS, KRW, PLN
Currency Exchange Rates
Returns a list of currency exchange rates for a particular currency and date
Syntax
=FLEX("YOUR_TEAM_NAME/currency-rates", cur, [date])
Sample Usage
=FLEX("YOUR_TEAM_NAME/currency-rates", "USD") =FLEX("YOUR_TEAM_NAME/currency-rates", "EUR", "2018-12-31") =FLEX("YOUR_TEAM_NAME/currency-rates", A1, B1)
Parameters
| Property | Type | Description | Required |
|---|---|---|---|
cur |
string | The currency type to use as the base | true |
date |
date | The exchange rate date | false |
Returns
| Property | Type | Description |
|---|---|---|
currency |
string | The type of currency |
amount |
numeric | The currency exchange rate |
Notes
This function uses the https://exchangeratesapi.io API to list the rates.
The following currency types are allowed: CAD, HKD, ISK, PHP, DKK, HUF, CZK, GBP, RON, SEK, IDR, INR, BRL, RUB, HRK, JPY, THB, CHF, EUR, MYR, BGN, TRY, CNY, NOK, NZD, ZAR, USD, MXN, SGD, AUD, ILS, KRW, PLN
Need help?
Have questions? Need help getting started? Need other Currency Conversion templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!