Are excess return and active return the same?

Active return normally means return above an investment benchmark. Excess return may refer to that difference or to return above a risk-free proxy. State the baseline instead of assuming the terms identify the same calculation.

Can excess return be positive while active return is negative?

Yes. In the hypothetical three-month example, the strategy earns 4.0094%, cash earns 0.9027% and the benchmark earns 5.0322%. It beats cash by about 3.1067 percentage points but trails the benchmark by 1.0228 percentage points.

Can I add monthly excess returns to get the total?

Adding gives an arithmetic sum of monthly differences. To compare actual compounded accounts, compound each underlying series separately and subtract their cumulative returns. Label a relative-wealth ratio separately if you use one.

Does an index benchmark have to be investable?

An index can serve as an analytical reference. To answer what an investor could have earned instead, specify an investable fund or replicable portfolio and its costs. Index performance and achievable investor performance are different inputs.

TradingView Backtesting

Excess Returns in Backtests: Risk-Free vs Benchmark Baselines

Excess return is a strategy return minus a stated reference return over the same period. Relative to a risk-free proxy, it measures the return above cash. Relative to an investment benchmark, the difference is commonly called active return. A strategy can beat cash while underperforming its benchmark, so a number labeled excess return is incomplete without its baseline, dates and currency.

See the decision guide

Name the baseline before calculating excess return

Let p[t] be the strategy return, f[t] the risk-free proxy return and b[t] the investment benchmark return for the same interval. CFA Institute defines active return relative to a benchmark. Sharpe describes differential returns more generally as the difference between two investment returns. These naming conventions make the reference series part of the calculation, not an optional footnote.

A short-term government security in the reporting currency can be a cash proxy. Specify its maturity and return convention; a longer-duration bond fund carries price risk and is not automatically risk-free over a short test.
For an investable benchmark, identify the actual fund or replicable portfolio, its income treatment, fees and rebalancing rule. An index level alone does not establish an achievable investor return.
Choose the benchmark to match the mandate before inspecting results. A low-exposure or leveraged strategy may require additional exposure analysis even when the subtraction is correct.

Comparison	Formula	Question answered
Above cash	e[t] = p[t] - f[t]	Did the strategy beat the chosen cash alternative?
Active return	a[t] = p[t] - b[t]	Did the strategy beat the chosen investment alternative?
Reconciliation	p[t] - f[t] = (p[t] - b[t]) + (b[t] - f[t])	How much came from the benchmark premium and how much from outperforming it?

Subtract both baselines from the same monthly sequence

This hypothetical example covers three consecutive calendar months in USD, with no external deposits or withdrawals. Strategy returns are whole-account returns including idle cash and open positions, net of assumed trading costs. The benchmark is a hypothetical investable fund with distributions reinvested and fund expenses included. The cash proxy earns an assumed 0.30% each month. These are invented teaching inputs, not observed market results or current interest rates.

Month 3 earns 3%, which exceeds cash by 3% - 0.3% = 2.7 percentage points but trails the fund by 3% - 4% = -1 percentage point.
Month 2 loses money and underperforms both alternatives. A positive excess return would not by itself imply a positive absolute return: -1% against a -2% benchmark is +1 percentage point of active return.
The average of monthly differences describes a typical arithmetic observation. It is not the cumulative return earned over these three months.

Month	Strategy	Cash	Benchmark	Above cash (pp)	Active return (pp)
1	+2.00%	+0.30%	+1.50%	+1.70	+0.50
2	-1.00%	+0.30%	-0.50%	-1.30	-0.50
3	+3.00%	+0.30%	+4.00%	+2.70	-1.00
Arithmetic monthly average	+1.3333%	+0.3000%	+1.6667%	+1.0333	-0.3333

Compound the accounts, then compare the full period

For decimal returns, cumulative return R = product of (1 + r[t]) - 1. Apply that expression independently to the strategy, cash and benchmark. Start each hypothetical account at $10,000 so the dollar difference and percentage-point difference can be reconciled. Displayed results are rounded only after calculation.

Full-period excess above cash = 4.0094% - 0.9027027% = +3.1066973 percentage points, or $310.67 more ending wealth on the same $10,000 start.
Full-period active return = 4.0094% - 5.0322% = -1.0228 percentage points, or $102.28 less ending wealth than the benchmark.
Compounding monthly active differences gives 1.005 × 0.995 × 0.99 - 1 = -1.002475%. That is not the -1.0228 percentage-point difference between the two compounded accounts.
Relative wealth is another valid, differently labeled measure: 1.040094 / 1.050322 - 1 = -0.9738%. It uses benchmark ending wealth as its denominator. Do not silently substitute it for arithmetic active return.

Series	Three-month calculation	Cumulative return	Ending USD
Strategy	1.02 × 0.99 × 1.03 - 1	4.0094%	$10,400.94
Cash	1.003 × 1.003 × 1.003 - 1	0.9027%	$10,090.27
Benchmark	1.015 × 0.995 × 1.04 - 1	5.0322%	$10,503.22

Match frequency, currency and valuation boundaries

Build one dated row per evaluation interval and align all three series before subtracting them. Use the same opening and closing timestamps, valuation method and reporting currency. Preserve inactive strategy months; capital still has an opportunity cost while no trades are open.

An effective annual cash rate of 5% converts to an equivalent monthly rate of 1.05^(1/12) - 1 = 0.4074%, assuming a constant rate and monthly compounding. Subtracting 5% from each monthly strategy observation is a frequency error. A quoted yield may use a different day-count or discount convention, so identify it before conversion.
Use historical cash returns or a documented historical rate path for a historical comparison. Applying today's rate to the entire backtest creates a different hypothetical baseline.
If an asset earns 2% in EUR and EUR gains 1% against USD, its USD return is 1.02 × 1.01 - 1 = 3.02%. Convert both strategy and benchmark consistently; a hedged benchmark is a separate choice.
Include income consistently. Comparing a strategy with retained dividends against a price-only benchmark understates the benchmark return. State which taxes, transaction costs and fund fees are included on each side.
Missing benchmark observations are not zero returns. Resolve calendar and timestamp gaps or report the excluded periods. External cash flows require flow-adjusted portfolio returns before comparison.

Active return is not an information ratio or proof of alpha

Active return remains a return difference. An information ratio divides the mean periodic active return by the standard deviation of those active returns, called tracking error, using consistent frequency conventions. That extra denominator answers a risk-normalized question. This page compares the return differences themselves and does not rank their statistical reliability.

If tracking error is zero, the ratio has no ordinary finite interpretation; the active-return observations can still be reported.
A positive active return does not isolate manager skill. Different market exposure, leverage, sector weights or luck can produce it. Risk-model alpha requires an explicit model and estimation procedure.
Three monthly observations explain the arithmetic but cannot establish persistent outperformance. Retain costs, drawdowns, exposure and a separate evaluation period alongside the result.

Reconcile the TradingView export before comparing baselines

Backtest Deep Report accepts TradingView List of Trades CSV files and calculates supported trade-based return and risk results. Its closed-trade equity path does not supply the complete synchronized strategy, cash and benchmark series used here. Keep this excess-return calculation separate rather than assuming a report field already implements it.

Import the CSV and check parsed trades, initial capital, net profit and drawdown. Keep the original TradingView test dates and cost settings with the file.
For monthly comparisons, obtain account equity at each monthly boundary, including open-position valuations and idle cash. A list of closed trades alone may miss those marks and external funding.
Join the chosen cash and investable benchmark data to those same boundaries, calculate each return and reproduce the table above in a spreadsheet.
If the strategy needs a custom equity or benchmark output, give Pine Script AI Coding Agent the exact formula, dates, currency and missing-data rule. Review and validate the generated script, then reconcile its values with an independent calculation.

Where Pineify fits

Backtest Deep Report

Import your TradingView trade CSV to inspect supported return and risk metrics. Calculate the synchronized cash and benchmark comparisons separately with the method above.

Also useful: Pine Script AI Coding Agent. Request custom strategy measurements with explicit formulas and inputs. Validate the generated Pine Script and reconcile the output before interpreting it.

Explore Backtest Deep Report

Related resources

TradingView Backtesting Guides Backtest Date Ranges Audit Backtest Accuracy TradingView Strategy Tester Guide

Frequently asked questions

Educational information, not investment advice. All numerical examples are hypothetical. Beating a cash or investment benchmark in a backtest does not establish skill or guarantee future returns.

Sources and verification

Last verified: 2026-10-17

Published by Pineify. Pineify is an independent product and is not affiliated with TradingView. Sources support the technical explanations; examples do not establish trading performance.