[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