PortfolioSlicer-Source.xlsx tables
Overview
The file PortfolioSlicer-Source.xlsx contains all information about investments you want to track in Portfolio Slicer.
That includes information about accounts, Symbols (investments), how investments are categoriezed and most important all investment transactions.
You will have to update this table manually. You should expect the initial setup to take some time, but after that you will just be entering new transactions such as deposits, buys, sells, and dividends.
After updating this table, you will need to run the .bat scripts that will prepare files for Portfolio Slicer reports and then open and refresh Portfolio Slicer reports (Excel or Power BI).
Tables in this workbook
- Excel table data entry - general information on how to enter data into Excel tables.
- Account table - information about investment account.
- Allocation table - information about allocation categories and targets.
- CompareTo table - information on how you want to compare your portfolio performance.
- Config table - configuration table.
- TransType table - system table that list supported transactions types.
- ReportCurrency table - information on currencies you will work with.
- srcReview table - this is system table used just for quick review of holdings by account.
- Symbol table - information about your investments and indexes you want to compare your investments too.
- SymbolAlias table - helper table to allow you to setup multiple names for the same Symbol when entering transactions.
- SymbolAllocation table - information on how Symbols are split between allocation categories.
- SymbolSector table - information on how Symbols are split between Sectors and Sensitivity categories.
- Transactions table - investment transaction table.