Trade Performance Analysis
The Analysis sheet is an interactive deep dive into your trading performance. Filter your trading history by asset, status, dates, or category, and the sheet shows aggregated metrics like Success Rate, ROI, and FX Impact for exactly that group of trades.
Filter Controls
The left side of the sheet holds the filters. Adjusting these values instantly updates the header metrics and the underlying results.
| Filter | Description |
|---|---|
| Selected asset | Set to TRUE to only include the specific asset below in the analysis. |
| Specific Asset | If "Selected asset" is TRUE, select a specific ticker or root symbol here to isolate one asset. |
| Status | Choose "Open" to analyze unrealized positions or "Closed" for completed trades. |
| Year | If the status is set to "Closed," use this to filter results by a specific calendar year. |
| Custom Range | A checkbox to enable a specific "From" and "To" date filter. |
| Date Range | If "Custom Range" is TRUE, enter the "From" and "To" dates to filter by the opening date of the trades. |
| Category Mode | A checkbox to restrict the analysis to trades matched within a single category. |
| Category | If "Category Mode" is TRUE, select the specific category (e.g., "Swing" or "Hedge") to analyze. |
Header Vital Signs
The header displays the aggregated results of your filters in your base currency, reflecting only the trades that meet your active criteria.
- Total Trades: The count of individual trades that meet all active filter criteria.
- Success Rate: The percentage of filtered trades that resulted in a positive ROI.
- P&L: The total profit or loss in your base currency, including market movement and FX impact.
- ROI: The percentage return on the capital invested for the filtered group.
- Estimated Tax: The projected tax liability for the filtered trades. Note: This value is hidden when Category Mode is active.
- FX Impact: The total impact of currency fluctuations on the filtered trades relative to your base currency.
Category Analysis
When Category Mode is enabled, the analysis covers only the trades matched within the selected category, letting you isolate the performance of a specific trading style (e.g., "Option Income" vs. "Crypto Long-term") without manually separating your data. Tax figures are hidden in this mode — category matching doesn't follow the legal FIFO/LIFO order, so taxes are only meaningful on the main Trades sheet (see Trade Tagging & Categories).
Tips and Best Practices
- Root Symbol Matching: When filtering by a specific asset, both the spot equity and its corresponding options are matched, giving you a true "total position" view.
- Bypassing Filters: If you want to see all closed trades for all time, simply ensure "Selected asset" is FALSE, Status is set to "Closed," and Year/Date Range filters are left blank or disabled.
If the Analysis header returns zeros or no results, check if your status and year filters are conflicting.