Capital Gains from mutual funds

Derek Atkins warlord at MIT.EDU
Thu Nov 24 10:04:57 EST 2005


Matti Picus <matti at picus.org> 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
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-devel mailing list