Connect currency exchange transactions and pricedb, or not?
Nicholas Lee
nj.lee@plumtree.co.nz
Tue, 31 Dec 2002 12:23:59 +1300
On Sat, Nov 30, 2002 at 12:09:01PM -0500, Derek Atkins wrote:
> 2) The plan to use the pricedb is to store _one exchange rate per
> commodity-pair per day_. In other words, it is _NOT_
> per-transaction. Similarly, the pricedb entries are only used for
> display purposes.. The transactions will still contain the exact
> same information they do today. In particular, each Split will
> still contain the "amount" (in its account currency) and the
> "value" (in the transaction currency).
Bad idea. There is nothing that states that any two given currency
transactions of a given day should have the same rate. In fact in NZ the
rate can move 100 points in a day.
Furthermore, if any sort of currency contracts (FECs, CFCs, etc) are
used its very likely that transactions, even processed in the same
mintue will have the same rate.
Nicholas