What is Portfolio Slicer
What Portfolio Slicer Is
Portfolio Slicer is an Excel-based investment tracking and reporting solution for people who want deeper analysis than a simple portfolio snapshot can provide.
It is built for investors who are comfortable working with structured data in Excel and who want to track portfolio performance over time using their own transactions, market data, and reporting setup.
Portfolio Slicer is not a broker-connected app. It does not automatically import your holdings for you. Instead, it gives you a flexible Excel and Power Pivot model that you control.
How Portfolio Slicer Works
Portfolio Slicer combines:
- Excel tables where you maintain your portfolio data
- external files that provide dates, quotes, currency exchange rates, and optionally dividends
- prebuilt reports that summarize holdings, gains and losses, income, allocation, and historical performance
At a high level, you enter or maintain your source data, update the required external files, and then refresh the reports.
This design takes more effort than a simple web tracker, but it gives you much more flexibility, transparency, and historical depth.
Read more about data required for Portfolio Slicer.
What You Can Track
Portfolio Slicer can help you track:
- stocks, ETFs, mutual funds, and market indexes
- multiple investment accounts
- cash balances
- dividend income
- cost basis
- portfolio allocation targets
- multi-currency reporting
One of the main advantages of Portfolio Slicer is that it is built around historical analysis. Instead of only showing what your portfolio is worth now, it helps you understand how your portfolio changed over time.
Who It Is For
Portfolio Slicer may be a good fit if:
- you use Windows and Excel
- you want to keep all of your investment transactions in one place
- you want to analyze portfolio performance over time
- you want more flexibility than a typical consumer portfolio tracker provides
- you are comfortable with a more hands-on setup process
- you value having direct control over your own data
Who It Is Not For
Portfolio Slicer may not be the right fit if:
- you use a Mac
- you want fully automatic account syncing from your broker
- you only care about a current snapshot of portfolio value
- you do not want to manage investment data in Excel
Why Some Users Prefer It
Portfolio Slicer was created to show how far Excel and Power Pivot can be taken for investment analysis. The files are open rather than hidden behind a black-box system, which means advanced users can inspect the model and customize reports to suit their own workflow.
That flexibility is one of Portfolio Slicer’s biggest strengths. It is best suited to users who value control and transparency more than one-click simplicity.
Learn More
If you want to start using Portfolio Slicer, these are the best next steps: