Get currency price
Returns the current price of a given currency.
URL
https://api.excelapi.org/currency/rate
Configuration
| Configuration | Required | Description |
|---|---|---|
| pair | ✔ | Specify the currency pair. Include hyphen. |
Pair
| symbol name | Currency Pair Name |
|---|---|
| aud-chf | Australian-dollar/Swiss-franc |
| aud-jpy | Australian-dollar/yen |
| aud-nzd | Australian dollar/New Zealand Dollar |
| aud-usd | Australian dollar/US dollar |
| cad-jpy | Canadian-dollar/yen |
| chf-jpy | Swiss-franc/yen |
| eur-aud | Euro/australian_dollar |
| eur-cad | Euro/Canadian-dollar |
| eur-chf | Euro/Swiss-franc |
| eur-gbp | Euro/British-pound |
| eur-jpy | Euro/yen |
| eur-nzd | Euro/new_zealand_dollar |
| eur-usd | Euro/US Dollar |
| gbp-aud | British-pound/Australian dollar |
| gbp-chf | British-pound/Swiss-franc |
| gbp-jpy | British-pound/Yen |
| gbp-nzd | British-pound/New Zealand Dollar |
| gbp-usd | British-pound / US Dollar |
| nzd-jpy | New Zealand Dollar/Yen |
| nzd-usd | New Zealand Dollar/US Dollar |
| usd-cad | US Dollar/Canadian-dollar |
| usd-chf | US Dollar/Swiss-franc |
| usd-jpy | US Dollar/Yen |
| zar-jpy | South African rand/Yen |
Example
B2:
=WEBSERVICE("https://api.excelapi.org/currency/rate?pair="&A2)
To reflect directly in a cell:
=WEBSERVICE("https://api.excelapi.org/currency/rate?pair=usd-jpy")