Difference between revisions of "Currency Maintenance"

From GnuCash
Jump to: navigation, search
(First draft)
 
(Newsletter)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
Sometimes regions change their currency, go out of business, join, split ...  
 
Sometimes regions change their currency, go out of business, join, split ...  
  
==Services by currency-iso.org==
+
==ISO 4217 Committee==
currency-iso.org is publishing several files in the section lists:
+
===Canonical Machine-readable files===
 +
The official [https://www.currency-iso.org ISO 4217 committee website] maintains 3 XML files reflecting the current ISO 4217 standard:  
  
 
;Schema: https://www.currency-iso.org/dam/downloads/schema.xsd
 
;Schema: https://www.currency-iso.org/dam/downloads/schema.xsd
Line 9: Line 10:
  
 
;Current currency & funds code list: https://www.currency-iso.org/dam/downloads/lists/list_one.xml
 
;Current currency & funds code list: https://www.currency-iso.org/dam/downloads/lists/list_one.xml
:This has also the SCU as <CcyMnrUnts>
+
:This is the list of currenciess now in effect; it provides the country, currency name, currency abbreviation, currency code, and number of decimal places for the smallest currency unit.
  
 
;Current funds codes list: https://www.currency-iso.org/dam/downloads/lists/list_two.doc
 
;Current funds codes list: https://www.currency-iso.org/dam/downloads/lists/list_two.doc
Line 15: Line 16:
 
   
 
   
 
;Amendments: https://www.currency-iso.org/dam/downloads/overview_amendments.xlsx
 
;Amendments: https://www.currency-iso.org/dam/downloads/overview_amendments.xlsx
:Changes to the currency codes lists occur if a currency is created, withdrawn or parts thereof altered.
+
:Changes to the currency codes lists occur if a currency is created, withdrawn or parts altered. This spreadsheet provides only the country name, currency abbreviation, amendment number, and month the amended standard was issued. In June 2019 the actual amendments can be accessed from https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_XXX.pdf by replacing "XXX" with the amendment number. The directory page is not accessible. Amendments < 100 are not zero filled, e.g. https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_62.pdf not https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_062.pdf.
 +
 
 +
===Newsletter===
 +
The swiss exchange SIX as office of currency-iso.org offers the free newsletter service that notifies subscribers about any changes related to currency codes: https://www.six-group.com/en/products-services/financial-information/data-standards/newsletter.html.
  
 
==Current targets==
 
==Current targets==
 
# Create an XSLT to facilitate the maintainance of our list.
 
# Create an XSLT to facilitate the maintainance of our list.
 
#:A few thoughts: https://lists.gnucash.org/logs/2019/06/25.html#T17:22:04
 
#:A few thoughts: https://lists.gnucash.org/logs/2019/06/25.html#T17:22:04
 +
# Decide behaviour of GnuCash for existing accounts after changes
 +
#: This is currently only a collection if thoughts.
 +
## General rule: let the user do the changes by creating new accounts and closing the old in the new accounts.
 +
## Decimals dropped
 +
## Replacement, e.g. 1000 RUR-> 1 RUB
 +
# Document what the users should do after currencies, which are used in their accounts, changed
  
 
[[Category:Maintenance]]
 
[[Category:Maintenance]]

Latest revision as of 22:02, 15 September 2023

Sometimes regions change their currency, go out of business, join, split ...

ISO 4217 Committee

Canonical Machine-readable files

The official ISO 4217 committee website maintains 3 XML files reflecting the current ISO 4217 standard:

Schema
https://www.currency-iso.org/dam/downloads/schema.xsd
List of codes for historic denominations of currencies & funds
https://www.currency-iso.org/dam/downloads/lists/list_three.xml
Current currency & funds code list
https://www.currency-iso.org/dam/downloads/lists/list_one.xml
This is the list of currenciess now in effect; it provides the country, currency name, currency abbreviation, currency code, and number of decimal places for the smallest currency unit.
Current funds codes list
https://www.currency-iso.org/dam/downloads/lists/list_two.doc
Some central banks registered beneath their currency special funds. This doc explains them.
Amendments
https://www.currency-iso.org/dam/downloads/overview_amendments.xlsx
Changes to the currency codes lists occur if a currency is created, withdrawn or parts altered. This spreadsheet provides only the country name, currency abbreviation, amendment number, and month the amended standard was issued. In June 2019 the actual amendments can be accessed from https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_XXX.pdf by replacing "XXX" with the amendment number. The directory page is not accessible. Amendments < 100 are not zero filled, e.g. https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_62.pdf not https://www.currency-iso.org/dam/downloads/dl_currency_iso_amendment_062.pdf.

Newsletter

The swiss exchange SIX as office of currency-iso.org offers the free newsletter service that notifies subscribers about any changes related to currency codes: https://www.six-group.com/en/products-services/financial-information/data-standards/newsletter.html.

Current targets

  1. Create an XSLT to facilitate the maintainance of our list.
    A few thoughts: https://lists.gnucash.org/logs/2019/06/25.html#T17:22:04
  2. Decide behaviour of GnuCash for existing accounts after changes
    This is currently only a collection if thoughts.
    1. General rule: let the user do the changes by creating new accounts and closing the old in the new accounts.
    2. Decimals dropped
    3. Replacement, e.g. 1000 RUR-> 1 RUB
  3. Document what the users should do after currencies, which are used in their accounts, changed