Matti Picus <[EMAIL PROTECTED]> writes:
> Thanks for the hint. How would that give me a handle on creating a
> report that converts each transaction in the mutual fund account from
> dollars to Israeli shekels at the conversion rate valid on the date of
> the transaction? While I programmed in LISP many years ago, the shceme
> code is a little obscure to my untrained eye...
> Matti
Well, first you can look at the existing Advanced Portfolio
Report.. Then, you have to ask yourself, where do you have
the exchange rate from Shekels to Dollars available? Are
the transactions denoted in Dollars or Shekels? Did you have
a conversion at the time? Do you have an entry in the
PriceDB for the exchange rate on that date?
I don't know the structure of your data so I can't really answer
this.. But if the information isn't available then you've got
a problem of lack-of-data. Ideally you'd have a three-commodity
transaction where the transaction common-currency is Dollars,
and then one split is Dollars->Shares, and the other split is
Dollars->Shekels. Then you'd have the proper exchange rate for
the transaction. But... That presupposes you entered your
transactions that way.
Good Luck,
-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
[EMAIL PROTECTED] PGP key available
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
