?????????????? ?? ????????????
SQsuperquant.???????????? $STONKB ?????????????? ?????????????????????????????????? ??????????????????????
?????????????? › Calculator + worksheetБэктест и доказательства

Рабочий лист для проверки метрик результативности криптобэктеста

Фиксируйте интервалы доходности, методики расчёта метрик, реестр сделок, отметки капитала и историю испытаний, стоящие за смоделированными значениями Sharpe, Sortino, профит-фактора или просадки.

Use the free tool
FREE CALCULATOR · RUNS IN YOUR BROWSER

Sharpe, Sortino, drawdown, CAGR and profit factor

Paste one periodic series (returns or equity marks) and, separately, closed-trade results. Periodic metrics use the periodic ledger; profit factor uses the trade ledger, as the worksheet below requires.

One value per line or separated by commas. Leave missing periods out; never type 0 for a missing observation.
One trade per line, after the same cost convention for every trade.
Result

Turn on JavaScript to calculate. Nothing you type is sent to SuperQuant.

Conventions used. Sharpe = mean(r − rf) ÷ sample standard deviation (n − 1). Sortino = mean(r − target) ÷ √mean(min(0, r − target)²) over all periods, including zero shortfalls, as in the Crypto Backtest Metrics guide. Annualized ratios multiply by √(periods per year), which assumes independent returns; check the autocorrelation line before trusting them. Maximum drawdown compounds the series from a starting value of 1. CAGR = ending value(periods per year ÷ periods) − 1. Profit factor = gross wins ÷ |gross losses|.

INTERACTIVE WORKSHEET

???????? ?????????????? ??????????????

Type straight into the page. Answers save automatically in this browser only, and a share link carries them in the link itself, never through our servers. Keep account IDs, wallet addresses and keys out of shared links.

Nothing filled in yet

Blank research template. It records inputs and conventions; it does not calculate a metric, verify a market edge or recommend a trade.

1. Identify the run

2. Choose the correct observation ledger

Use one row per fixed observation interval for periodic account-return measures. State whether each return is time-weighted, how open positions are marked, how deposits and withdrawals are handled, and whether flat periods remain in the series. Do not replace missing observations with zero.

UTC interval endEquity / NAVExternal cash flowNet period returnRisk-free returnSortino targetMark / missing-data note
Total–

Keep a separate row per completed trade for profit factor. Include every winner and loser under one declared gross or net convention; do not mix period returns with trade P&L.

Trade IDEntry UTCExit UTCGross winning P&LGross losing P&LFeesOther costsNet resultPartial / open / excluded note
Total–––––

3. Write each metric convention before comparison

MeasureState the calculation inputs and conventionResult / unit
SharpePeriodic excess-return series; mean convention; standard-deviation convention; risk-free input
SortinoPeriodic return series; target; downside-deviation denominator and treatment of zero shortfalls
Profit factorGross or net trade P&L; treatment of open trades, costs and a zero-loss denominator
Maximum drawdownEquity-mark frequency; cash-flow adjustment; peak and trough timestamps; dollar and percentage depth
Annualized statisticPeriod conversion and dependence assumptions; any autocorrelation treatment

For the Sortino example in the related guide, the stated convention is the mean of return minus target divided by the square root of the mean squared shortfalls, including zero shortfalls across all observations. Other implementations can use different targets or denominators. Record the actual formula used by the software.

If periods are monthly, do not assume multiplying a monthly Sharpe by the square root of 12 is valid when returns are dependent. State the assumptions and inspect serial dependence. A ratio based on a short or selected sample is especially uncertain.

4. Preserve the search and validation record

Candidate / versionParameter or asset choices triedWhy retained or rejectedDate / data window inspectedHoldout touched?

Record the full number and scope of trials, discarded variants and any later-period data opened during selection. A selection-adjusted statistic still cannot repair look-ahead bias, unreliable data, unrealistic fills or an unsuitable return series.

5. Reconcile and state limits

Read the Crypto Backtest Metrics guide for worked fictional calculations. Keep this worksheet with the source data and software version. A metric summarizes a chosen sample; it does not predict a future result.

?????? ???????????????????????? ??????????????

???????????? ?????????????????????????? ???????????????????? ??????????, PnL ???????????????? ???????????? ?? ???????????? ???? ????????-???????? ?? ???????????????????? ????????????????. ???????????????????? ???????? ??????????????, ????????, ??????????????????, ???????????????? ?? ?????????????? ?????? ?????????????? ?????????? ???? ?????????????????????????????? ??????????????????.

What does the worksheet include?

Blank input ledgers for periodic returns and trades, a convention table for Sharpe, Sortino, profit factor and drawdown, plus trial-history and evidence-boundary checks. The calculator above computes the ratios from your own inputs; it contains no preset performance results.

???????? ???????????? ?????????? ?????????????????????????????? ???????????????? ?? ???? ???????????????? ???????????????????????????? ???????????????????? ??????????????. ???????????? ???????????????????????? ???????????????? ?? ?????????? ????????????????. ???????????????????? ?????????????????? ????????????????????, ?????????? ?? ???????????????? ???? ?????????? ????????????????.