Search results
Jan 12, 2022 · Send Money Receive Money. View today's currency exchange rates and use currency converter to calculate value of one currency to another. Updated: January 12, 2022. Updated list of currency names. 3 character alphabetic and 3 digit numeric ISO 4217 codes for each country.
Apr 25, 2024 · Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes. For example, enter "USD/EUR" to get the exchange rate from one United States Dollar to Euros.
People also ask
How many digits are there in a currency code list?
How does ISO 3166-1 code a currency?
What is a currency code?
How do I know if a currency code is USD or EUR?
- Overview
- Data
- Preparation
- Version
- License
List of currencies and their 3 digit codes as defined by ISO 4217. The data provided here is the consolidation of Table A.1 "Current currency & funds code list" and Table A.3 "Historic denominations".
Note that the ISO page offers pay-for PDFs but also links to http://www.currency-iso.org/en/home/tables.html which does provide them in machine readable form freely.
The data provided (see data/codes.csv) in this data package provides a consolidated list of currency (and funds) codes by combining these two separate tables:
•ISO Tables A.1 - Current Currencies and Funds
The script requires recode package to be istalled. Install it by running:
sudo apt install recode
Run the following script to download and convert the data from XML to CSV:
The raw XML files are stored in ./archive. The cleaned data are ./data/codes-all.csv.
The current tables have a published date of 28 March 2014 (as indicated in the XML files).
Placing in the Public Domain under the Public Domain Dedication and License. The original site states no restriction on use and the data is small and completely factual.
Jan 20, 2022 · The ISO has also agreed and issued equivalent numeric currency codes - these are 3-digit codes which correspond to the more common alphabetic codes. USD for example has the equivalent numeric code of 840.
Numeric codes. List of ISO 4217 currency codes. Active codes (list one) Historical codes. Currency details. Minor unit fractions. Code position in amount formatting. USD, USN: two US currency codes. Non ISO 4217 currencies. Currencies without ISO 4217 currency codes. Non-standard codes. Unofficial codes for minor units of currency.
CodeNumD [a]CurrencyAED7842AFN9712ALL0082AMD0512The first two letters of the ISO 4217 three-letter code are the same as the code for the country name, and, where possible, the third letter corresponds to the first letter of the currency name. For example: The US dollar is represented as USD – the US coming from the ISO 3166 country code and the D for dollar.
May 31, 2022 · From Currency / To Currency. You can use a colon instead of a slash if you prefer, but Excel will convert it to a slash when you apply the data type. Related: How to Convert Currency in Microsoft Excel. So, to obtain the exchange rate and details from U.S. dollars to Euros, you would enter: USD/EUR