App Icon
Serghei Gorodetki
•  
12,278
Overview
Includes functions for currency conversion according to exchange rates from European Central Bank and other sources.
This add-on adds functions to your Google Sheets document for currency conversion that use historical reference exchange rates gathered from European Central bank and other sources.  Functions support 40 types of traditional currencies since 2000 and 12 types of cryptocurrencies.

To get started, open your document and select any item in the menu "Add-ons" | "Currency Converter".

Functions:

1. CurrencyConverter 
Converts a given amount from one currency to another for a given date. Currency alphabetic codes should follow the ISO 4217 standard.  For better performance, it is recommended to pass a range of values as input instead of using the function multiple times on a large range of data.

Sample Usage
 =CurrencyConverter(100, "USD", "EUR", "2/28/2020") returns 91.09957183.
 =CurrencyConverter(A2:A41, "usd", C2:C41) returns an array of converted values from US dollar to a range of currencies for the latest available date.
 =CurrencyConverter(A2:A41, B2:B41, C2:C41, "2/18/2019") returns an array of converted values for date 2/18/2019.
 =CurrencyConverter(A2:A41, B2:B41, C2:C41, D2:D41) returns an array of converted values.

Syntax
CurrencyConverter(amount, currencyFrom, currencyTo, [date])
 - amount - The value to convert from OR single-column range of values.
 - currencyFrom - The currency alphabetic code to convert from OR single-column range of codes.
 - currencyTo - The currency alphabetic code to convert to OR single-column range of codes.
 - date - The date to search in rates history OR single-column range of dates. If it is not provided, the latest available date is used.
 - Returns a converted value OR a single-column range of converted values.
Note, in some countries,  arguments in formulas should be separated by a semi-colon (;) instead of comma (,).

2. CurrencyConverter_Currencies 
Gets alphabetic codes of supported currencies for a given date. Currency alphabetic codes should follow the ISO 4217 standard.

Sample Usage
 =CurrencyConverter_Currencies ("2/28/2020")

Syntax
CurrencyConverter_Currencies([date])
 - date - The date to search in rates history.  If it is not provided, the latest available date is used.
 - Returns a list of supported currencies.


Supported currencies:
AED - UAE Dirham, AUD - Australian dollar, AZN - Azerbaijani manat, BGN - Bulgarian lev, BRL - Brazilian real, BYN - Belarusian ruble, CAD - Canadian dollar, CHF - Swiss franc, CLP - Chilean peso, CNY - Chinese yuan renminbi, CZK - Czech koruna, DKK - Danish krone, EGP - Egyptian pound, EUR - Euro, GBP - Pound sterling, HKD - Hong Kong dollar, HRK - Croatian kuna, HUF - Hungarian forint, IDR - Indonesian rupiah, ILS - Israeli shekel, INR - Indian rupee, ISK - Icelandic krona, JPY - Japanese yen, KRW - South Korean won, KZT - Kazakhstani tenge, MDL - Moldovan leu, MXN - Mexican peso, MYR - Malaysian ringgit, NOK - Norwegian krone, NZD - New Zealand dollar, PHP - Philippine peso, PLN - Polish zloty, RON - Romanian leu, RUB - Russian rouble, SAR - Saudi riyal, SEK - Swedish krona, SGD - Singapore dollar, THB - Thai baht, TRY - Turkish lira, TWD - New Taiwan dollar, UAH - Ukrainian hryvnia, USD - US dollar, ZAR - South African rand.
Supported cryptocurrencies:
ATOM - Cosmos, BCH - Bitcoin Cash, BTC - Bitcoin, DASH - Dash, EOS - EOS, ETC - Ethereum Classic, ETH - Ethereum, LINK - Chainlink, LTC - Litecoin, XLM - Stellar, XRP - XRP, XTZ - Tezos.
Reviews
Language:
Sort by:
Profile Picture
ed salbo
May 27, 2021
HI, this is great, can you please add the colombian peso (COP),thanks!
Is this review helpful?
Yes
No
Profile Picture
A K
April 6, 2021
Really useful and easy to use, great add-on. Can you please add support for the Sri Lankan Rupee (LKR), it would be greatly appreciated. Thanks.
Is this review helpful?
Yes
No
Profile Picture
Joel Gans
April 4, 2021
I have a strange issue. If I ask the exchange rate with currencyconverter(1,”eur”,”usd”,”01/11/21”), it gives me 1.225... although the official ECB rate is 1,2163??... I always have to give the “date+1”!!... Am I doing something wrong ? Although I can get through it by inserting the date+1, but can’t understand why!! Am I the only one ? Thanks for yr help.
Is this review helpful?
Yes
No
Profile Pciture
Serghei Gorodetki
April 7, 2021
Hi Joel, Thank you for your feedback. The issue might be related to your time zone. We need more details to help you. Please check the time zone setting in your spreadsheet document by clicking in the menu: File -> Spreadsheet settings -> Time zone. Then click the Support link at the bottom of this page. It will redirect you to our Support page. In the Contact section, fill a form and describe your problem and provide your current location time zone and your document time zone.
Profile Picture
Jawaid Iqbal
March 1, 2021
jk
Is this review helpful?
Yes
No
Profile Picture
Jessica Hsieh
February 22, 2021
easy to use, and does what i need. Can we also support some minor currencies such as New Taiwanese Dollar to USD?
Is this review helpful?
Yes
No
Profile Pciture
Serghei Gorodetki
March 30, 2021
Jessica, we have added New Taiwanese Dollar (TWD). Happy currency conversion!
Profile Pciture
Serghei Gorodetki
February 24, 2021
Thank you for your feedback. We will consider adding the Taiwanese Dollar. Happy currency conversion! :)
Profile Picture
Hans Christian Rodríguez
January 8, 2021
Works really great. Easy to use and no issues :-)
Is this review helpful?
Yes
No
Profile Pciture
Serghei Gorodetki
January 14, 2021
Thank you for your feedback. Happy currency conversion! :)
Profile Picture
Hussen Ali
December 11, 2020
Hello
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 3, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Fabián Hernández
August 11, 2020
Please add the Chilean currency "CLP"
Is this review helpful?
Yes
No
Profile Pciture
Serghei Gorodetki
March 30, 2021
Fabián, we have added Chilean peso (CLP). Happy currency conversion!
Profile Picture
Aaron D'cruz
August 2, 2020
Works great and Serghei was quick to add AED currency support after my request.
Is this review helpful?
Yes
No
1-10 of 13
Additional information
Serghei Gorodetki
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu