[GNC] Example of importing Stock transactions from CSV
Jon Schewe
jpschewe at mtu.net
Tue Jul 12 09:45:28 EDT 2022
That looks similar to what I'm doing, except all of my data is on a
single line in the CSV file. The biggest problem seems to be how to
convince GnuCash to use 2 different commodities for the transaction
when importing from CSV.
On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote:
> Hi Jon
>
> This isn't exactly what you are asking for, but it may give you some
> clues. Importing Dividends from CSV:-
>
> https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html
>
>
> Good luck!
>
> Geoff
> =====
>
> On 12/07/2022 12:35 pm, Jon Schewe wrote:
> > Does anyone have an example of importing stock transactions from
> > CSV?
> >
> > I have matched columns to Date, Description, Account, Price,
> > Deposit,
> > Transfer Account.
> > The "Account" column is the mutual fund account.
> > The "Transfer Account" column is the currency account.
> >
> > When I start the import process all of my transactions need an
> > account
> > to transfer from, despite specifying the Transfer Account. When I
> > try
> > and select my currency account I'm told that it has the wrong
> > commodity.
> >
> > I have another column for the currency amount, but I don't know
> > what to
> > map that to in the importer.
> >
> > I tried checkout out
> > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
> >
> > but it doesn't seem to address this.
> > Suggestions on where I'm going wrong.
> >
> > Jon
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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.
More information about the gnucash-user
mailing list