[GNC] Asset Allocation by Sector
brad
bradhaack at fastmail.com
Mon Feb 3 21:21:29 EST 2025
If you have individual stocks & bonds, then what 'Michael or Penny'
suggested is probly the easiest. Mine are mostly index funds which
don't always have just one sector.
I'm doing something similar to what John R suggested, but in Octave.
I have an Octave script (matlab-like) which has the asset allocation
portions for each fund. I export a GC report, convert to CSV, load it
into Octave. The script prints an asset allocation table to the screen
which I cut and paste into a spreadsheet. I run this every month or 2
or 3. I don't track the business sectors like you mentioned, just the
macro sectors like large cap, value, international...
You could probly do it in a spreadsheet, but I'm more comfortable with
octave/matlab for something like this
It's kind of convoluted and messy but works reliably for me.
Brad
On 1/31/25 05:31, rsbrux via gnucash-user wrote:
> I have been using GC for years for all of my bookkeeping, including investment tracking.
> I have managed to make rudimentary Asset Allocation reports for the major investment types (stocks, bonds, funds, etc.) but would like to also monitor the distribution of my investments over sector (financial, industrial, pharmaceutical, etc.)
> I don't find any way to do this in GC, or even a way to associate a given investment with a given sector.
> How do other GC users handle this? Is there some add-on or external tool anyone can recommend?
>
> _______________________________________________
> 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.
More information about the gnucash-user
mailing list