P
(PeteCresswell)
I'm thinking ISO 4217 as shown on
http://www.xe.com/iso4217.php
Bond trading system.
Users are definitely OK with all of a given security's trades
being restricted to a single currency.
They currently claim to even be ok with all of a given fund or
portfolio's trades being restricted to a single currency -
although my alarms flickered briefly when I heard that one...
What comes to mind:
-------------------------------------------------------------
- Show amounts suffixed by the 3-character ISO 4217 currency code
e.g. 3,002,400.33 USD
10,000,000.00 EUR
9.500,000.00 CAD
- Don't bother trying to format using the currency's symbol
e.g. $30,000.0 would not appear anywhere. Instead,
one would see 30,000 USD.
- When the first trade for a given security is committed, the
currency chosen on that trade's buy ticket determines the
currency for all subsequent trades against that security - or
maybe even for all trades within that fund or portfolio.
- I'm taking it as a matter of faith that now that we're
all in the 21st century, all currencies are going tb decimal.
- When we do reports, we section each report by currency and
don't allow any totals that include multiple currencies.
--------------------------------------------------------------
First problem I see is valuation of a fund whose securities have
been traded in multiple currencies. My initial reaction to that
would be to hope that the user's claim that all the securities in
a given fund will be traded in a single currency proves tb true.
Anybody actually been here and lived with the consequences?
Architecture?
Gotchas?
http://www.xe.com/iso4217.php
Bond trading system.
Users are definitely OK with all of a given security's trades
being restricted to a single currency.
They currently claim to even be ok with all of a given fund or
portfolio's trades being restricted to a single currency -
although my alarms flickered briefly when I heard that one...
What comes to mind:
-------------------------------------------------------------
- Show amounts suffixed by the 3-character ISO 4217 currency code
e.g. 3,002,400.33 USD
10,000,000.00 EUR
9.500,000.00 CAD
- Don't bother trying to format using the currency's symbol
e.g. $30,000.0 would not appear anywhere. Instead,
one would see 30,000 USD.
- When the first trade for a given security is committed, the
currency chosen on that trade's buy ticket determines the
currency for all subsequent trades against that security - or
maybe even for all trades within that fund or portfolio.
- I'm taking it as a matter of faith that now that we're
all in the 21st century, all currencies are going tb decimal.
- When we do reports, we section each report by currency and
don't allow any totals that include multiple currencies.
--------------------------------------------------------------
First problem I see is valuation of a fund whose securities have
been traded in multiple currencies. My initial reaction to that
would be to hope that the user's claim that all the securities in
a given fund will be traded in a single currency proves tb true.
Anybody actually been here and lived with the consequences?
Architecture?
Gotchas?