gnc-pricedb

Christian Stimming stimming@uclink.berkeley.edu
Sun, 25 Feb 2001 22:36:39 -0800


-----BEGIN PGP SIGNED MESSAGE-----

I have a question on what your pricedb is able to do and what it is not. 
It seems the price-db is intended to store the instant exchange rates, 
probably for each multi-currency transaction that happens. Do you intend 
to modify the multi-currency transaction entering process such that this 
price gets stored in the price-db?

Anyway, I would like to have an exchange rate based on a weighted average 
of existing currency account transactions. Example: I bought USD 100 for 
DEM 200, later I bought USD 200 for DEM 300, so "my personal" price for 
USD should be 1 USD = (200+300)/(100+200) = 1.66 DEM. But if I only store 
the two prices, i.e. 1 USD = 2 DEM and 1 USD = 1.5 DEM, then I can't 
reconstruct the weighted average. The "weighting" is gone...

Question: Is this the intended way how things are gonna be? Does this mean 
that for a weighted average I still have to do a manual query over all 
transaction accounts, do a for-each over all their splits and so forth? 

Christian

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: noconv

iQCVAwUBOpn5d2XAi+BfhivFAQGq7QP+Osz4wKwR/CnTcuczq+EOXMrhikfs5JIU
6HuoEwDKPu6wuiLv6lbAOxwqtSvy554yjSrjH9l42lt2QPNPeIzPXm5GpHf9eMVF
2OlEScrjyNUFkrJ/WvkrEaE5uroDdZ5BG4XouTL9873MK872iVG3r5FznltR6ua5
66Aosi+TnoQ=
=0bgU
-----END PGP SIGNATURE-----