2/2/2024 0 Comments Currency converterKeep in mind that you'll also need to update your shipping to match shipping requirements for your target country. While your currency will be converted in your ads and listings, in order to target a new country, you’ll still need to meet the language requirements for that country. The converted price estimate shown in your ad or listing is based on exchange rates from Google Finance. If you provide prices in a currency different than the currency of the target country in your campaign, the prices will automatically be converted and shown in the local currency. This makes your ads and listings understandable to users in other countries while allowing you to continue using your existing website and landing pages with minimal changes. If you don’t support the target country currency, currency conversion may help you broaden your reach.Ĭurrency conversion automatically converts the price in your product data to the currency of the new target country and displays both prices in your ads and free product listings. Automatically show ads for your products in another country without making changes to your website.This article covers how currency conversion works. Returns a list of supported currencies.ĪED - 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.ĪTOM - 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, ADA - Cardano, DOGE - Dogecoin, DOT - Polkadot, SOL - Solana.Currency conversion is currently unavailable in South Korea. If it is not provided, the latest available date is used. date - The date to search in rates history. Currency alphabetic codes should follow the ISO 4217 standard. Gets alphabetic codes of supported currencies for a given date. Note, in some countries, arguments in formulas should be separated by a semi-colon ( ) instead of comma (,). Returns a converted value OR a single-column range of converted values. date - The date to search in rates history OR single-column range of dates. currencyTo - The currency alphabetic code to convert to OR single-column range of codes. currencyFrom - The currency alphabetic code to convert from OR single-column range of codes. amount - The value to convert from OR single-column range of values. =Currenc圜onverter(A2:A41, B2:B41, C2:C41, D2:D41) returns an array of converted values.Ĭurrenc圜onverter(amount, currencyFrom, currencyTo, ) =Currenc圜onverter(A2:A41, B2:B41, C2:C41, "") returns an array of converted values for date. =Currenc圜onverter(A2:A41, "usd", C2:C41) returns an array of converted values from US dollar to a range of currencies for the latest available date. 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. To get started, open your document and select any item in the menu "Add-ons" | "Currency Converter".Ĭonverts a given amount from one currency to another for a given date. Functions support 40 types of traditional currencies since 2000 and 12 types of cryptocurrencies. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |