[GNC] CVS Import of Security Transaction

Geert Janssens geert.gnucash at kobaltwit.be
Mon May 4 08:09:04 EDT 2020


Op maandag 4 mei 2020 02:36:58 CEST schreef Matthew Clay:
> Dear Gnucash Community,
> 
> Sorry if I missed this in the documentation, but is it possible to use
> the CSV importer for security (stock) transactions? When I attempt to
> import a CSV file into a security account, in the drop-down menu to
> indicate what the columns in the CSV file are used for, I do not see
> "Share" or "Price" as options. I'd like to set the "Share" and "Price"
> columns, and then have Gnucash calculate the "Buy"/"Sell" price and
> the "Balance" of shares after the transaction.
> 
> Sincerely,
> Matthew

The csv importer is fairly limited when importing share/price data or multicurrency data. It 
depends a bit on the format of your import data.

If the import data is multi-split (that is it contains the debit and credit side of a single 
transaction in separate lines) and it contains a transaction currency, the importer knows how to 
handle it.

Single line import can have issues like these bugs:
https://bugs.gnucash.org/show_bug.cgi?id=796955
https://bugs.gnucash.org/show_bug.cgi?id=797450

So your mileage may vary.

Regards,

Geert


More information about the gnucash-user mailing list