John, I like the way you're pointing here, but I'd suggest a slightly different approach.
I'd create a spreadsheet with the APR data in a separate worksheet, and then I'd compile data in other worksheets using that data. You can create formulae that pull data from the APR and derive meaningful information accordingly. This allows the user run the APR, paste it into the worksheet and update their information quickly and efficiently. I've done this for a rapid online portfolio value update. The APR data is loaded into one worksheet as is, and other worksheets compile current information off that. David T. On Jan 31, 2025, 8:32 PM, at 8:32 PM, John Ralls <jra...@ceridwen.us> wrote: > > >> 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. _______________________________________________ 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.
