Documentation

This documentation explains how to install, configure, and use Portfolio Slicer, including how to prepare data, refresh reports, work with scripts, and troubleshoot common issues.

If you are new to Portfolio Slicer, start with the guides in the first section below.

Start Here

If you are new to Portfolio Slicer, read these pages first:

• What is Portfolio Slicer?
• System requirements
• Setup PowerShell on your computer
• Install Portfolio Slicer
• First time users guide

Understand the Data

These pages explain what data Portfolio Slicer needs and how it is organized:

• Required data overview
• PortfolioSlicer-Source.xlsx file
  • Source table data entry FAQ
  • Excel table data entry basics
  • Tracking cash
  • Tracking cost basis
  • Changing minimum date

• Data management script set

  • Batch to execute scripts
  • Files prepared for Portfolio Slicer reports
  • Script configuration file psConfig.txt
  • How Quote | Currency exchange data is stored locally
  • Choosing data source for Quotes | Currency Exchange
  • Creating fixed price Symbol quotes
  • How to schedule external data updates

• Portfolio Slicer Excel & Power BI reports

  • Refreshing Excel | Power BI reports
  • Data Refresh FAQ
  • Changing Excel | Power BI data location
  • Customize reports
  • Technical information
  • DAX measures
  • How model calculates capital gain, dividend percent, and profit percent

• Known limitations

Legacy and Version-Specific Topics

Older documentation is kept for users working with legacy versions or older Excel setups:

• Upgrade from older versions
• Migration to v3.x from older version
• Excel 2010 and PowerPivot
• Excel 2010 refresh data
• Excel 2010 change data location

Portfolio Slicer is powerful, but it expects a more hands-on workflow than a typical consumer portfolio app. These docs are meant to help you get to a reliable working setup and understand how the system behaves once it is in place.