portfolioslicer.com

What It Is

Portfolio Slicer is not a traditional cloud SaaS product, but a free Excel template for portfolio tracking and reporting. It is designed for investors who want to perform in-depth analysis using their own data. Through Excel tables, a Power Pivot data model, external price/exchange-rate files, and prebuilt reports, it can analyze stocks, ETFs, mutual funds, indexes, cash, dividends, multi-account portfolios, and multi-currency portfolios.

Core Features and Workflow

Its core value lies in the historical perspective: it does not only show current market value, but also lets users review historical holdings, portfolio changes, capital gains/losses, dividend income, cash balances, allocation targets, and performance across different periods. Users maintain the data in Excel tables, while external files provide dates, prices, exchange rates, and optional dividend data. After refreshing the workbook, it generates dashboards and reports for holdings, dividends, portfolio movements, and more. Advanced users can further customize analysis using Excel, Power Pivot, Power BI, and DAX.

Pricing and Deployment

The main documentation clearly states that it is a free Excel workbook/template. No paid plans, subscriptions, or enterprise editions were found. Deployment is local-file based: it requires 64-bit Windows, Excel 2016 or later, PowerShell 3.0+, at least 8GB of memory, and 16GB is recommended. Mac Office is not supported. Files can be placed in OneDrive, Google Drive, Dropbox, or similar cloud-drive folders for version recovery, but this does not make it a cloud-hosted product.

Pros and Cons

Its strengths are that it is free, transparent, open as files, and highly customizable. Its multi-currency support and historical performance analysis also go deeper than ordinary investment snapshot tools. The drawbacks are also clear: it does not connect to brokers and does not automatically sync accounts. Initial setup involves folders, PowerPivot, PowerShell, configuration files, and data refreshes, so the learning curve is relatively steep. It also lacks the team permissions, security certifications, APIs, and mobile experience commonly found in SaaS products.

Who It’s For and Access from China

It is suitable for individual investors who are comfortable with Excel, willing to maintain transaction records manually, and value data control and long-term review. It is not suitable for users who only want one-click broker syncing, a quick view of current total assets, or Mac support. Access from China is not covered in the source text, so it is considered unknown. Payment is not an issue, as the text indicates that it is free. Chinese users may compare it with alternatives such as broker apps, Tonghuashun/East Money, self-built Excel workbooks, Portfolio Performance, Quicken, or Sharesight, depending on their needs.