[GNC] Recording stock holdings

2022-08-21 Thread aeg via gnucash-user
I have been using GnuCash for about 6 years, starting with version 2.6 and now use 3.5 on a Windows 10 laptop. I like it very much, but have a persistent problem with entering stock investments. The day-to day financial transactions cause me no problems at all, but I've never been able to fully

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David Carlson
Jon, The exported CSV security purchase transaction did have more than two split lines because it had a commission and fees, so to simplify things I deleted the commission and fee lines. If there had been a dividend or if it was a sale rather than a purchase there would have been other distractio

Re: [GNC] USAA OFX Direct connect stopped working

2022-08-21 Thread john
> On Aug 21, 2022, at 7:54 PM, Daffy Duck wrote: > > Hello, > > A while back, USAA changed their OFX stuff and there had to be a > workaround with a PIN, etc. > > I did that, without a problem, but I just noticed today it has broken > again? > > This is the output: > > AqBanking v6.5.2.0st

[GNC] USAA OFX Direct connect stopped working

2022-08-21 Thread Daffy Duck
Hello, A while back, USAA changed their OFX stuff and there had to be a workaround with a PIN, etc. I did that, without a problem, but I just noticed today it has broken again? This is the output: AqBanking v6.5.2.0stable Sending jobs to the bank(s) Sorting commands by account Sorting account q

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David Carlson
Jon, I just tried exporting one transaction from a security account and re-importing it with the CSV importer. It worked like a charm! I don't have time right now to detail what I did here, but I did not need to select the Multi split box after all. Have fun On Sun, Aug 21, 2022 at 12:16 PM Da

Re: [GNC] gnucash-user Digest, Vol 233, Issue 68

2022-08-21 Thread Chris Skudder
GnuCash will do the accounting fine. It won't do the equipment, RMA, and inventory tracking. I suspect it'll be very hard to find a software which integrates these other functions with accounting - because of that, if it were me, I'd use GnuCash for the accounting, and look for other

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David T. via gnucash-user
The thread at https://lists.gnucash.org/pipermail/gnucash-user/2019-March/083442.html goes into quite a discussion about how to import multi line csv files. On August 21, 2022 6:26:24 PM GMT+03:00, Jon Schewe wrote: >David, > >I'm using GnuCash 4.11 from FlatPak. I have all of my transactions

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread john
> On Aug 21, 2022, at 6:37 AM, Jon Schewe wrote: > > On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: >> On 8/19/2022 10:33 PM, Jon Schewe wrote: >>> So I didn't get the CSV import tool to work. >> >> Perhaps a reminder on what CSV is and is not. >> >> CSV stands for "common

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread Jon Schewe
David, I'm using GnuCash 4.11 from FlatPak. I have all of my transactions on single lines (I've posted samples in this thread).  I would greatly appreciate someone explaining how to make this work and I'd be happy to help update the documentation on this. Jon On Sun, 2022-08-21 at 09:17 -0500,

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David Carlson
Jon, If you are not using some recent 4.x version of GnuCash you may not have the latest improvements to the CSV transaction importer. A normal stock purchase or sale transaction has two parts, one, a deposit or withdrawal of cash from a brokerage account, the other an exchange of the cash for a

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread Jack Frillman via gnucash-user
I’m importing prices —— I smell carrots a-cooking and where there’s carrots, there’s a rabbit. — Yosemite Sam > On Aug 21, 2022, at 9:34 AM, Jon Schewe wrote: > >  > Jack, > > I have tried using this configuration multiple times to get the import to > work. I have a list of column assignment

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread Jon Schewe
On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: > On 8/19/2022 10:33 PM, Jon Schewe wrote: > > So I didn't get the CSV import tool to work. > > Perhaps a reminder on what CSV is and is not. > > CSV stands for "common separated variables. That means the data is in > the form of a

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread 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 transact