Connect currency exchange transactions and pricedb, or not?

Derek Atkins warlord@MIT.EDU
30 Dec 2002 19:57:45 -0500


Nicholas Lee <nj.lee@plumtree.co.nz> writes:

> 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.

Yea, been there, done that, decided I was wrong...  The pricedb is
just for convenience of user-input..  Each transaction can have its
own exchange rate.

> Nicholas

-derek
-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord@MIT.EDU                        PGP key available