> On Jan 31, 2025, at 06:51, Michael or Penny Novack via gnucash-user > <gnucash-user@gnucash.org> wrote: > > On 1/31/2025 7:31 AM, 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? > > It's all in how you set up your CoA. You cannot report on data that you do > not capture. > > I assume your CoA now has: > > Assets > > Investments > > Stocks > > Bonds > > etc. > > You want > > Assets > > investments > > stocks > > financial > > industrial > > etc. > > bonds > > financial > > etc. > > Now the data has been captured. Your next question is going to likely be that > you want to be able to have reports be EITHER hierarchy. Sorry, not WITHIN > gnucash as only one CoA hierarchy in standard bookkeeping. So while you can > get ONE directly, for the reverse, you'll need to export and rearrange > outside of gnucash.
You could also use commodity namespaces, but neither accounts nor namespaces show up in the Advanced Portfolio Report so that’s perhaps not too helpful. I think the simplest way to get there is to create a lookup table in a spreadsheet that maps symbols (which are displayed in the APR) to sector or whatever other category you want to summarize. Paste in an APR covering the period you want to analyze, add a column to do the sector lookup for each line in the APR, and make a pivot table to calculate the summary. Regards, John Ralls _______________________________________________ gnucash-user mailing list gnucash-user@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.
