T
TradeMetricsPERFORMANCE INTELLIGENCE
PERSONAL WORKSPACE  A
PERFORMANCE WORKSPACE / OVERVIEW

Trading, measured.

A rigorous view of what your realized returns say about your trading.

↑

Import your trading history

Upload CSV or Excel. Select the returns column; other columns are optional and ignored by the V1 calculation engine.

Enriched workbook mapping

Optional columns unlock additional analysis
Upload an Excel or CSV ledger to map columns. Returns remain the only required field; P&L, dates, IDs, classification and execution fields are optional.
Analysis dimension: SetupSequence: original row order
Illustrative sample report loaded. Upload your own file to replace it.

Performance snapshot

250 observations · illustrative sample

Cumulative trade returns

Additive sequence · no capital assumption

Core statistics

Returns only

Return distribution

Frequency by bucket
Frequency
Return (BPS)

Bucket frequency table

Counts and percentages

Return distribution · detailed view

Per-observation return · BPS

Drawdown profile

Summary statistics from the ordered return series

Underwater curve

Drawdown from prior cumulative peak

Performance diagnostics

Rule-based observations · not investment advice

Consistency and sequence diagnostics

Sequence-aware analytics · original observation order

Rolling Profit Factor

Trailing 30 observations · adjustable in specification

Setup analytics

Setup-based performance analysis
Breakeven classification: returns between -5 and +5 BPS, inclusive. Change the threshold to suit your ledger.

Win / loss composition

Configurable breakeven band

Pareto decomposition · all observations

Top / bottom 15%, middle 70%

Capital and return views

Nominal capital assumptions

Setup and execution diagnostics

Setup grouping and mapped execution fields

Setup performance

Performance grouped by Setup

Duration and execution

Enriched workbook fields

Setup-level comparison

Returns aggregated by Setup

Calculation methodology

Transparent definitions
Breakeven

Winning: return greater than +threshold. Losing: return less than -threshold. Within the band: breakeven, reported separately from wins and losses.

Pareto

Rank all observations by return. Top 15% and bottom 15% use the full observation count; middle 70% is the remainder. Ties are resolved consistently by original row order.

Drawdown

Closed-trade peak-to-trough drawdown is measured on the additive cumulative return sequence. Worst sequential losing run is separately measured as the most negative uninterrupted run of loss-classified observations.

Capital

Fixed-capital ROR divides cumulative mapped P&L by the stated nominal. Dynamic ROR compounds row-level returns when a capital-at-risk / starting-equity column is mapped. These are different denominators.

Grouping

Setup analytics aggregate observations sharing the same Setup value. Setup groups can contain different numbers of observations.

Limitations

Rolling and annualized ratios are shown only when sufficient dated monthly observations are available. Results depend on the selected date basis and return aggregation convention. Without initial risk, R-multiples are unavailable. Metrics are not inferred from missing fields.

Methodology: returns are converted to decimal internally and reported in BPS where appropriate. observation returns are accumulated additively for the closed-trade curve; dynamic account ROR is compounded only when a valid starting-capital column is mapped. Grouped trade and position returns sum constituent observation returns. Sharpe-like and Sortino-like ratios are per observation, not annualized. Execution leakage is the sum of mapped slippage, miscellaneous P&L and error P&L; map these fields with consistent sign conventions.

PERFORMANCE WORKSPACE / MONTHLY

Monthly statistics.

Calendar-month returns and rolling risk metrics, grouped by the selected trade date.

Monthly returns are the sum of mapped trade returns within each calendar month. Rolling windows require 12, 36 or 60 complete monthly observations. Misc. P&L basis points use the fixed nominal capital entered here. Probabilistic Sharpe uses a finite-sample approximation; the deflated Sharpe estimate applies a simplified multiple-testing penalty based on the trials count, not a full strategy-return correlation model.

Lifetime return distribution

Across monthly aggregated returns

Rolling and since-start risk metrics

Latest available month · metrics also shown by month below

Monthly history and rolling metrics

One row per calendar month · scroll horizontally for all fields

Lifetime miscellaneous and error P&L

Totals for included dated observations
PERFORMANCE WORKSPACE / ANNUAL

Annual statistics.

Calendar-year returns grouped by the selected trade date.

Annual returns are the sum of mapped trade returns within each calendar year. Missing dates are excluded and counted in the status below.

Lifetime return distribution

Across annual aggregated returns

Annual history

One row per calendar year

Lifetime miscellaneous and error P&L

Totals for included dated observations
REFERENCE / METHODOLOGY

Calculation details.

Definitions and formulas used by the TradeMetrics report.

Return normalization

BPS ÷ 10,000; percent ÷ 100; decimal unchanged. Auto mode infers units from the header and cell values.

Net return

Net = Σ rᵢ, the sum of observation returns.

Expectancy (EV)

EV = Σ rᵢ / N, the arithmetic mean return per observation.

Win rate (WR)

With breakeven threshold T: WR = winning observations / all observations. Decisive WR excludes breakeven observations from the denominator.

Profit factor (PF)

PF = gross winning returns / absolute gross losing returns. With gains but no losses, PF is infinite.

Average win, average loss and payoff

Average win is mean return above +T. Average loss is mean return below −T. Payoff = average win / absolute average loss.

Standard deviation

Sample SD = √[Σ(rᵢ − mean)² / (N − 1)].

Skewness and excess kurtosis

Skewness is the third standardized central moment. Excess kurtosis is the fourth standardized central moment minus 3.

Equity and drawdown

Eₜ = Σᵢ₌₁ᵗ rᵢ. Peak Pₜ = max(E₀…Eₜ). Drawdown Dₜ = Eₜ − Pₜ. Maximum drawdown is |min(Dₜ)|.

Ulcer Index

UI = √[ΣDₜ² / N] for the underwater series.

Sharpe and Sortino

Per-observation Sharpe = mean / sample SD. Sortino = mean / downside deviation; downside deviation = √[Σmin(0,rᵢ)² / N].

Pareto slices

Sort observations by return, descending. The selected percentage determines top and bottom slices; the middle contains the remainder. Slice size rounds up to a whole observation.

Monthly and annual returns

Returns are summed within calendar periods using selected Entry Date or Exit Date. Rolling windows use 12, 36 and 60 monthly observations.

Calmar and MAR

Calmar = annualized mean / absolute maximum drawdown over the selected window. MAR uses since-start return and since-start drawdown.

Probabilistic Sharpe

Uses a finite-sample approximation based on sample size, skewness and kurtosis. The deflated estimate applies a simplified multiple-testing penalty from the specified trial count; it is not a full correlation-aware DSR implementation.

Miscellaneous and error P&L

These values are summed from mapped dollar columns. Miscellaneous P&L (BPS) = miscellaneous P&L / fixed nominal capital × 10,000.

Missing data

Missing dates are excluded from calendar grouping. Unmapped optional numeric fields remain unavailable rather than being inferred.

Trade ledger

Imported observations, one row per record

Observation records

Filtered to valid mapped returns
TradeMetrics · Private trading analyticsPreview build · Cloud account services not connected