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.gnuc...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
