Trades Analytics and Transaction Ledger
Firewire Analytics provides continuous tracking of all investment transactions across broker accounts. The Trades Activity Heatmap and transaction ledger enable investors to review purchase and sale patterns, analyze rebalancing behavior, and assess impact on money-weighted returns.
The trades activity widget is available on the Main Dashboard (via Bento Grid) and inside the dedicated Trades view. Hovering over any date displays bought and sold securities, tickers, quantities, and fiat amounts. Transactions arrive in real-time via broker WebSockets or report imports with automated deduplication.
1. Trades Activity Heatmap
The activity heatmap visualizes trading frequency across time:
- Color Intensity: indicates trade count per calendar day (ranging from a subtle tint for a single execution to vivid emerald for intensive sessions).
- Interactive Breakdown Tooltip: hovering over any active date reveals an informative popover with:
- Total number of transactions executed on that date;
- Bought Assets (BUY): styled with green badges, plus indicator, ticker, lot quantity, and monetary volume;
- Sold Assets (SELL): styled with red badges, minus indicator, ticker, and realized volume;
- Compact Mode: when more than 3 transactions of a single type occur, prominent trades appear alongside a neat count badge (“+N more...”) to prevent viewport overflow.
Screenshot: Trades activity heatmap with tooltip displaying bought bonds and sold equities
2. Transaction Ledger and Filtering
Inside the Trades section, investors access an immutable chronological record of all operations:
| Parameter | Description | Value for Investor |
|---|---|---|
| Account Selector | Filter by specific broker account or aggregated multi-account view | Segregate taxable accounts, IIS tax-advantaged accounts, and crowdlending. |
| Ticker & Asset Search | Instant search by ticker symbol, ISIN, or company name | Inspect complete entry and exit history for individual securities. |
| Fees & Accrued Interest | Tracks broker fees, exchange commissions, and bond accrued interest (NKD) | Accurate cost accounting when evaluating net profit and loss. |
| Data Export | Export filtered transactions to Excel, CSV, or PDF formats | Effortless preparation for tax reporting and external portfolio auditing. |
Screenshot: Detailed transaction ledger table with multi-criteria filters and export controls
3. Data Ingestion and Intelligent Deduplication
Firewire aggregates trades via multiple ingestion channels:
- Real-Time WebSocket Streaming: exchange executions stream directly via broker WSS endpoints without manual page refresh.
- Scheduled API Synchronization: automated reconciliation with official broker gateways.
- Broker Report Ingestion: parse historical statement files (Excel, CSV, PDF) with AI-assisted schema mapping.
- Duplicate Protection: composite uniqueness constraints (trade ID, order ID, ticker, exact timestamp) prevent duplicate volume counting across concurrent sources.
4. Impact on Financial Metrics and Yield Formulas
Every recorded execution automatically feeds into platform calculation engines:
- Average Cost Basis: purchases update open position cost basis using weighted average calculation.
- Cash Flow in XIRR: buy and sell transactions serve as capital inflows and outflows anchored to exact settlement dates.
- Realized PnL in PnL Decomposition: position closes crystallize capital gain/loss after net fee subtraction.
- AI Copilot Alerts: monitors recent turnover to warn against excessive asset concentration and emotional trading.
5. Frequently Asked Questions (FAQ)
Why does the tooltip display limited trades for busy days?
To preserve visual clarity on screens of any size, the tooltip highlights the top 3 transactions per direction with a “+N more...” indicator. The complete list of executions is always available in the full ledger table below.
Are broker commissions included in trade totals?
Yes. While the tooltip displays gross asset turnover for readability, the complete ledger table itemizes broker and exchange commissions, automatically factoring them into net PnL and XIRR.
How can I add the trades activity widget to my dashboard?
Go to the Main Dashboard, click “Customize Dashboard”, open the widget library, and place the “Trades Activity” card (TradesActivityCard). Learn more in the Bento Grid Guide.