[GNC] Example of importing Stock transactions from CSV

[Jon Schewe]

Jack,

I have tried using this configuration multiple times to get the import
to work. I have a list of column assignments, none of which have worked
correctly. Thus the python script that does in fact work. In your
screenshot I see column options that don't exist for me. Are you
importing transactions or prices? I'm trying to import transactions.

Jon


On Sat, 2022-08-20 at 11:54 -0400, Jack Frillman via gnucash-user
wrote:
> I use CSV import almost every day and it works just fine.
> You do have to setup a configuration file that tells the importer how
> to 
> interpret your CSV data. I suspect you did not do that.
> Here is an example of my CSV data:
> 
> ARSIX,14.82,Ray Jay,2022/08/20,USD
> BAFGX,26.47,Ray Jay,2022/08/20,USD
> BAGIX,10.07,Ray Jay,2022/08/20,USD
> CISMX,16.75,Ray Jay,2022/08/20,USD
> GSFTX,29.98,Ray Jay,2022/08/20,USD
> 
> Each column of the separated values above are defined when you set
> the 
> importer up.
> I saved this in a file called "ira quotes" and it's selected in the 
> attached screen shot.  The bottom window is the result of mapping of
> the 
> "irs quotes" file to the CSV data above.
> 
> As for your Python script I have no idea what it's supposed to do.
> I have a much smaller Python script that scrapes the closing day
> prices 
> off a web page and creates the CSV file I import.
> 
> Jack
> 
> On 8/19/22 10:33 PM, Jon Schewe wrote:
> > So I didn't get the CSV import tool to work. However I was able to
> > write a python script to do the import. I would think that this
> > would
> > be possible with the CSV import, but I can't seem to figure out how
> > to
> > do the right column assignments to make it work. I have attached
> > the
> > python script and a sample input CSV file.
> > 
> > If someone that knows how the CSV import code works and can compare
> > with my script and tell me how to use the CSV import tool for this,
> > that would be great.
> > 
> > Thanks,
> > 
> > Jon
> > 
> > 
> > On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote:
> > > 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.
> > > _______________________________________________
> > > 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.
> > 
> > _______________________________________________
> > 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
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.