Portfolio Returns
%
%
Current 3-month T-bill or 10-year treasury yield
%
Standard deviation of annual returns
Benchmark optional
%
%
%
Std dev of (portfolio − benchmark) returns → for Information Ratio
Sharpe Ratio
(Portfolio Return − Risk-Free Rate) ÷ Volatility
Excess Return
Benchmark Sharpe
Sharpe Advantage
Information Ratio
Return / Risk Rating
Required Return for SR=1
Risk-Adjusted Metrics Comparison

What each tab calculates

01

Sharpe Ratio

Calculates the Sharpe ratio as (return − risk-free rate) ÷ volatility. Shows excess return, Information Ratio against a benchmark, the required return to achieve Sharpe = 1, and an automated performance rating from Poor to Exceptional with a grouped bar comparison chart.

02

Sortino & Calmar

Computes Sortino ratio using downside deviation only (penalizes only negative volatility), Calmar ratio using maximum drawdown, and Martin ratio using the Ulcer Index. Shows the Sortino/Sharpe ratio to assess return distribution asymmetry and all ratios side by side.

03

From Series

Calculates all ratios directly from a periodic return series. Auto-annualizes based on the selected period (daily/weekly/monthly). Computes max drawdown from the cumulative return path, alpha and Information Ratio vs benchmark, and displays a cumulative return chart.

04

Rolling Sharpe

Computes Sharpe ratio over a rolling window across a return series to show how risk-adjusted performance has evolved over time. Shows average, max, min rolling Sharpe, percentage of periods with positive Sharpe, and a rolling Sharpe time-series chart with zero reference line.

05

Compare

Side-by-side comparison of Sharpe, Sortino and Calmar ratios across up to 8 strategies. Identifies the best risk-adjusted performer and shows average, best and worst Sharpe. Grouped bar chart plots all three ratios together for each strategy.