[GNC] Best Practices using GC for Investment Portfolio Management

[Kalpesh Patel]

While what has been said by all others is correct, I did want to mention that GC does have capabilities to import such transactions listed in an OFX/QFX, QIF or CSV formats (in that preferred order) which does prompt to create securities if it is not already defined. Your financial institutions has to permit downloads in said formats, though, this is where YMMV. If the financial institution doesn't then you are on your own. Over time I have written python scripts that otherwise takes somewhat complex accounts and converts them into QIF format to be able to import transactions but it still is hit or miss as they constantly change format. I get about 90% automated with 10% to clean up with that script.

So if you are importing in any afore-mentioned formatted files then below stands:

1) Importer will do so but not exactly in very clean fashion -- post-processing will be required. However this burden becomes less as time goes on as it learns, improves and retains that heuristics map. However, if the institution that permitted download "tinkers" with format then it could be some work to right it again as I mentioned.

2) Importer will do that at a bare minimum level. You will still have to fine tune it by enabling pricing download, precisions of pricing kept, etc.

3) Importer will update internal pricing database from the commodity transactions, and pricing database can be supplemented with its own but distinct and separate importer or automated through tightly coupled Finance::Quote Perl module. GC can work without this module and permit you to enter prices manually if you so desire.

4) Importer supports limited set of defined file formats mentioned above, and few others but afore-mentioned ones are the most popular. 

GC definitely is *not* a professional portfolio management software. It is great for tracking home finances.

-----Original Message-----
From: Wm Tarr <wm at ilipsis.net> 
Sent: Wednesday, July 15, 2026 5:22 AM
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Best Practices using GC for Investment Portfolio Management

It would help if you gave some indication of how many securities you'd 
be creating per day / week / month and how many transactions per d/w/m.

Wm

On 2026-07-15 02:19, Jediator wrote:
> I was new to investment features in GC, trying to load brokerage 
> transactions into GnuCash, and realized it wasn't an easy task. There 
> are multiple manual steps involved and very time-consuming. I'd like 
> to ask fellow GC users for advice of how to best use GC for portfolio 
> management, and better ways to automate many of the tasks.  Or is 
> there any automation tools for GC that enable the user to:
>
> 1. Set up stock/commodity accounts automatically by inspecting the new
>    accounts from brokerage transaction files
> 2. Add new stock/commodity definitions in GC automatically by
>    inspecting the brokerage transaction files
> 3. Populate the corresponding price database (optional)
> 4. Import trading transactions automatically using brokerage
>    transaction files
>
> Any suggestions are highly appreciated.  Thanks in advance!
>
> -- ND
>
>
> _______________________________________________
> 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.