export/import from/to gnucash; and Cost Basis report

David Zelinsky dzpost at dedekind.net
Mon Feb 11 19:15:10 EST 2013


On Feb 10, 2013, at 8:44 PM, David Zelinsky <dzpost at dedekind.net> wrote:

> QUESTION 1 -- How can I export the mutual fund accounts data from my
> gnucash file in a form that she can import to her gnucash file?
[...]
> QUESTION 2: Is there a way (e.g. a report) to get gnucash to calculate
> the average cost basis?

On 2/11/2013 1:20 AM, David T. wrote:

> I seem to recall that some users have found a way to generate a report,
> import it into a spreadsheet, edit it a little, then import it into a
> gnucash file.  Search the FAQs in the Gnucash website.

David Carlson <carlson.dl at sbcglobal.net> writes:

> GnuCash doesn't have an export feature. Try looking at
> http://gnucashtoqif.sourceforge.net/ It appears to offer this, but my
> reading suggests that you'd have to find a way to prune the result,
> since it appears to work only on complete files.
> 
> As for cost basis, try looking at the Advanced Portfolio report. It
> may successfully give you a cost basis for the mutual fund
> investment. There have been reported problems with this calculation,
> but since your account has no sales, the report may work for you.


The Advanced Portfolio does indeed give the cost basis.  I'll give up on
the export+import idea for now, or else hack together my own.

Thanks for both responses.

-David


More information about the gnucash-user mailing list