[GNC] CVS Import of Security Transaction

Matthew Clay mpclay at gmail.com
Mon May 4 09:31:59 EDT 2020


Dear Geert,

Thank you very much for your quick reply. I can manipulate the data I
have (e.g., via python) to get it into a csv format that works. Do you
know what the lines of a csv file would look like for the following
multi-split transaction?

Account 1. Date "01/01/2020", stock account "XYZ", shares purchased
"5", share price "7.00"
Account 2. Date "01/01/2020", bank account "BANK", dollars withdrawn 35.00

Sorry I do not know something so basic, but I haven't seen these types
of files/formats before.

When I go to import such a CSV file, would I import it for the stock
account, or maybe it doesn't matter?

Thank you very much for your time and help.

Sincerely,
Matthew

On Mon, May 4, 2020 at 7:09 AM Geert Janssens
<geert.gnucash at kobaltwit.be> wrote:
>
> 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