Overview
Portfolio tracking is the foundation of investment management. Before any analysis, any decision, any reporting — the portfolio needs to be known accurately. What is held, in what quantity, at what cost, in what account, across what currencies, through what brokers and custodians, and what is it worth right now. When the portfolio spans multiple asset classes, multiple accounts, multiple brokers, multiple currencies, and multiple jurisdictions, assembling this picture manually — from broker statements, from exchange account balances, from on-chain wallets, from direct holdings — is a daily operational burden that grows with portfolio complexity and produces a view that is already out of date by the time it is assembled.
Portfolio tracking software automates the data collection, aggregation, and valuation that produces the portfolio view — connecting directly to the sources where positions are held, pulling current prices from market data feeds, and presenting a consolidated portfolio view that is current, complete, and correct without requiring manual assembly.
We build custom portfolio tracking systems for professional investors, fund managers, proprietary trading firms, family offices, and any organisation managing a portfolio across multiple accounts, asset classes, or platforms that needs a consolidated view it cannot get from any single platform or broker interface.
What Portfolio Tracking Covers
Multi-asset position tracking. A portfolio that spans equities, fixed income, derivatives, cryptocurrencies, forex, commodities, real estate, and private holdings cannot be tracked through any single broker or exchange interface — because no single broker or exchange holds all of it. Portfolio tracking software aggregates positions across every account and custodian, normalises the position data from each source to a common representation, and presents the full multi-asset portfolio in a single view.
Each asset class requires specific position representation: equities as shares with cost basis and corporate action adjustments; fixed income as face value with accrued interest; options and derivatives with the underlying, strike, expiry, and Greeks; cryptocurrency as units with chain and wallet attribution; forex as notional amounts in each currency pair. The tracking system handles the representation appropriate to each asset class rather than forcing all assets into a generic position format.
Real-time and end-of-day valuation. Positions without current prices are holdings without a current value. Portfolio tracking software prices positions from the market data feeds appropriate to each asset class — exchange feeds for listed equities and derivatives, WebSocket price feeds for cryptocurrency, FX rate feeds for currency valuation, and configurable pricing sources for less liquid assets where market prices are not continuously available.
Valuation currency consolidation — converting all positions to a common reporting currency using current FX rates — gives the aggregate portfolio value in the currency that matters to the investor rather than in the mixture of currencies in which positions are held.
Transaction history and cost basis. Portfolio valuation requires knowing not just what is held but what it cost. Transaction history — every purchase, sale, dividend, interest payment, corporate action, and transfer — is the record from which cost basis is calculated. Portfolio tracking software maintains the full transaction history, applying the cost basis method appropriate to the investor's tax jurisdiction and preferences — FIFO, LIFO, average cost, specific identification — and calculating realised and unrealised P&L at position and portfolio level.
Corporate action handling — stock splits, rights issues, spin-offs, mergers, special dividends — adjusts the position record and cost basis correctly rather than appearing as unexplained position discrepancies.
Account and custodian aggregation. Positions may be held across multiple broker accounts, multiple exchange accounts, multiple custody arrangements, and directly through on-chain wallets. Each account has its own interface, its own data format, and its own reporting. Portfolio tracking software aggregates across all accounts into the consolidated portfolio view — with the ability to drill down to individual account level when the per-account view is needed.
Currency and FX tracking. Portfolios with positions in multiple currencies have FX exposure that is as much a part of the portfolio risk as the individual position risks. Currency tracking shows the gross and net exposure in each currency, the FX gain or loss on non-base-currency positions, and the overall currency attribution of portfolio P&L. FX hedges are tracked alongside the positions they hedge, with the net currency exposure after hedging visible alongside the gross exposure.
Performance attribution. Total portfolio return tells you how much was made. Performance attribution tells you why — which positions contributed positively, which detracted, what the attribution was by asset class, by geography, by sector, by strategy. Performance attribution requires the transaction history, the position history, and the price history that portfolio tracking systems maintain — and the attribution calculation that converts those inputs into the decomposed performance view that investment analysis requires.
Data Sources and Connectivity
The range of sources a portfolio tracking system needs to connect to reflects the range of places positions can be held.
Broker APIs. Interactive Brokers TWS API for equities, options, futures, and forex positions and transaction history. Other broker APIs where available — positions, transactions, and account data pulled directly from the broker rather than imported from PDF statements.
Cryptocurrency exchanges. Binance, Bybit, Kraken, Coinbase, and other CEX platforms — account balances, open positions in futures and margin accounts, transaction history, and real-time prices via REST and WebSocket APIs. Each exchange has its own API conventions, its own rate limits, and its own data model for positions and transactions — the connectivity layer handles these differences and normalises the data to the common portfolio model.
On-chain wallets. For cryptocurrency holdings in self-custody wallets, on-chain data provides the position and transaction history — wallet balances queried from blockchain node RPC endpoints, transaction history from block explorers or indexing services, token balances across ERC-20 and other token standards. Multi-chain support for the chains the portfolio spans — Ethereum, Base, Arbitrum, Solana, and others — with the chain-specific data retrieval that each requires.
MetaTrader. Position and transaction data from MT4 and MT5 accounts for forex and CFD positions — integrated via the MetaTrader API or through the account history exports that MetaTrader supports.
Market data feeds. Real-time and end-of-day price data from the sources appropriate to each asset class — exchange feeds for listed securities, aggregated cryptocurrency price feeds, FX rate feeds, and configurable manual price inputs for illiquid assets.
Manual holdings. Private equity, real estate, direct lending, and other assets that do not have electronic data feeds are tracked through manual transaction entry and periodic valuation updates — integrated into the portfolio view alongside the electronically tracked positions.
Portfolio Views and Analysis
Consolidated portfolio view. The full portfolio in a single view — all positions across all accounts, valued at current prices, converted to the reporting currency. Filtered and grouped by asset class, by account, by sector, by geography, by currency, or by any other dimension relevant to how the portfolio is managed. Summary cards showing total value, day change, period return, and the key metrics that the portfolio overview requires.
Position detail. Each position with its full context — current price, position size, market value, cost basis, unrealised P&L, P&L percentage, days held, and the transaction history that explains how the position reached its current state. For derivatives, the Greeks and the expiry profile. For fixed income, the yield and duration. For cryptocurrency, the chain and wallet attribution.
Allocation analysis. Portfolio allocation by asset class, by sector, by geography, by currency, and by any custom grouping relevant to the investment mandate. Target allocation versus actual allocation — showing where the portfolio has drifted from its target and what rebalancing is required to bring it back to target weights.
P&L analysis. Daily, weekly, monthly, and period P&L — realised and unrealised. P&L attribution by position, by asset class, by strategy. Contribution analysis showing the P&L contribution of each position to the total portfolio return, identifying the positions that drove performance and the positions that detracted.
Drawdown and risk metrics. Portfolio drawdown from peak — current drawdown, maximum historical drawdown, and the time to recovery from past drawdowns. Volatility, Sharpe ratio, Sortino ratio, and the risk-adjusted return metrics that portfolio performance evaluation requires. Correlation analysis between positions for the concentration risk assessment that individual position analysis does not reveal.
Transaction history. The complete transaction record — every trade, every dividend, every corporate action, every transfer — filterable by account, by asset class, by date range, and by transaction type. Transaction history is the primary input for tax reporting, for performance verification, and for the audit trail that institutional investors and fund administrators require.
Multi-Portfolio and Fund Management
For organisations managing multiple portfolios — separate accounts for different clients, multiple funds with different mandates, portfolio segregation by strategy — the tracking system provides both the individual portfolio view and the aggregate view across all managed portfolios.
Portfolio segregation. Each portfolio is tracked independently — its own positions, its own transaction history, its own cost basis, its own performance record. Positions in the same instrument held across different portfolios do not aggregate into a single position record that obscures the per-portfolio view.
Aggregate management view. The aggregate view across all managed portfolios — total assets under management, total positions by instrument and by asset class, total exposure — for the portfolio manager's overview of the full book.
Benchmark comparison. Portfolio return compared against the benchmark appropriate to the portfolio's mandate — a market index, a custom blended benchmark, or a defined target return — with the active return and tracking error that relative performance analysis requires.
Investor reporting. Performance reports, portfolio statements, and transaction confirmations in the format that investors and fund administrators require — generated from the tracking system's data without manual assembly.
Tax and Compliance
Realised gain and loss reporting. Tax-year realised gains and losses calculated from the transaction history and cost basis records, applied with the method appropriate to the investor's jurisdiction — FIFO, LIFO, average cost — and presented in the format that tax reporting requires.
Wash sale and similar transaction tracking. For jurisdictions where wash sale rules or equivalent provisions affect the tax treatment of losses, the tracking system identifies transactions that trigger these provisions and adjusts the cost basis records accordingly.
Regulatory position reporting. For investors with regulatory reporting obligations — large shareholding notifications, short position reporting — the tracking system identifies positions that approach or exceed reporting thresholds and produces the notification data in the required format.
Technologies Used
- Rust / Axum — real-time price processing, position aggregation, performance calculation engine, on-chain data retrieval
- C# / ASP.NET Core — broker API integrations, complex corporate action processing, transaction history management
- React / Next.js — portfolio dashboard, position views, analytics interfaces, investor reporting
- TypeScript — type-safe frontend and API code throughout
- SQL (PostgreSQL, MySQL) — position history, transaction records, price history, portfolio configuration
- Redis — real-time position state, price cache, calculation coordination
- Interactive Brokers TWS API — equities, options, futures, and forex position data
- Binance / Bybit / Kraken / Coinbase APIs — cryptocurrency exchange position and transaction data
- Ethers-rs / Web3 / Solana SDK — on-chain wallet balance and transaction history
- MetaTrader API — MT4/MT5 forex and CFD position data
- WebSocket / REST — real-time and polling-based market data and position feeds
- Exact Online / AFAS — financial reporting integration for fund accounting
The Limits of Platform-Native Portfolio Views
Every broker, every exchange, and every custody platform provides its own portfolio view. Each shows the positions held with that provider, valued at prices from that provider's data feeds, in the performance calculation that provider applies. None of them show the full portfolio. None of them apply consistent valuation and performance methodology across all positions regardless of where they are held. None of them allow the investor to see how a position held with one broker interacts with a position held at another.
The gap between the individual account views and the consolidated portfolio view is exactly the gap that custom portfolio tracking software fills. When the portfolio is held in one place, the platform view is sufficient. When the portfolio is held across multiple accounts, multiple platforms, and multiple asset classes — which is the case for most professional and institutional portfolios — the consolidated view requires infrastructure built specifically to aggregate across all of them.
Know Your Portfolio, Completely
Portfolio management starts with knowing what you hold. A tracking system that connects to every account, prices every position from current market data, and presents the consolidated view in real time gives the foundation that every investment decision, every risk assessment, and every performance evaluation depends on.