Vested Portfolio Analyzer
A fully client-side tool to analyze trade ledgers exported from Vested. It calculates FIFO holdings, long/short-term capital gains tax holding periods, and handles corporate actions like stock splits.
Case Study Details
When managing investments across international brokerages like Vested, tracking cost basis, tax holdings (Long Term vs Short Term), and corporate action adjustments can be a challenge. This interactive tool provides complete client-side portfolio analysis directly from your trade ledger spreadsheet.
Key Capabilities
- Client-side Excel Parsing: No data is sent to any server. All your transaction history is parsed securely in your browser using SheetJS (
xlsx). - Chronological FIFO Ledger: Simulates your holdings over time, matching sell orders against the oldest buy lots for exact realized gain/loss calculations.
- Holding Period Categorization: Automatically splits holdings into Short-Term (< 2 years) and Long-Term (> 2 years) assets for tax reporting based on a configurable evaluation date.
- Corporate Actions & Stock Split Warning System: Detects if your holding quantity goes negative due to a stock split (e.g., SMCI 10-for-1 split in Oct 2024) and guides you through adjusting your Excel ledger or auto-fixing it with one click.
Interactive Trade Tracker
Load the preloaded demo dataset from Vested.xlsx or upload your own transaction ledger to analyze your holdings.
Upload Trade Ledger
Analyze your holdings securely client-side
Upload the Excel file containing your transaction sheet named "Trades". The application processes all calculations directly in your browser. None of your financial records are uploaded to any server.
Simulation Settings
Purchases prior to 7/17/2024(> 2 years) will be classified as Long-term holdings.