Overview
This template is designed to give you visability into the return on your investments both at the account level and asset level. With the Return calculated both for the last month as well as for the last 12 months.
You can also run the detail as of any date. The return taxes into account new investments as they happen.
Installation
To add it to your spreadsheet create the 5 tabs Inv_Dashboard, Inv_Holdings, Inv_Accounts, Inv_Manual_History and Inv_Calc.
Setup
First in Inv_Accounts setup the basic info for your accounts i.e. Institution, category.
Inv_Accounts is used to create and match categories for: Institution, Account_Name, Tax_Type, Category. This is required for it to work.
Inv_Manual_History is exactly what it sounds like and can be used to add in additional information before you were able to import the data via tiller.
Usage
Day to day as long as you dont add any new accounts you shouldnt need to do anything.
Permissions
Go ahead and make it your own.