Home > Forum Home > Excel Portfolio Performance Tracking Template > How can I add more investment categories? > Adding portfolio categories Share

Adding portfolio categories

Excel Help for Adding Portfolio Categories in Excel Portfolio Performance Tracking Template


Forum TopicLogin

Adding Portfolio Categories

Rate this:
(4/5 from 2 votes)
OopsThe template logic is limited to 10 categories.  One workaround is to combine categories so to limit the number accordingly.

If absolutely necessary, it is possible to add more categories with some work involved. The portfolio monitoring template needs to be unprotected using the password provided on purchase.

In the "PreDefined" sheet cells E2 to H11 provide details for the naming conventions and reference formulas for the categories in column A.  These need to be updated to accommodate the new categories in column A with new prefixes supplied at the end of column E.

The "Value", "Trans" and "Perf" sheets then need to have the new categories added by copying the inserting rows of the last category and changing the cell naming conventions and formulas to the corresponding prefixes chosen in the "PreDefined" sheet as per the step above.

It is recommended to make a copy of the template first to make such modifications so that testing can be made to ensure all of the processes function correctly.

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Adding portfolio categories in the