Skip to content
Practical market worksheet

Open Trades Planned Stop-Risk Worksheet

Add your planned stop-loss amounts across open trades in one currency.

Your inputsBrowser calculationCSV export

Three hypothetical trades have planned losses of 50, 75 and 25 USD. Their combined planned risk is 150 USD. Against 5,000 USD of equity, that is 3%. The calculation adds the supplied plans; it does not offset one trade against another or promise execution at each stop.

What this helps you check

Several individually small planned losses can add up to a material share of account equity. This worksheet sums the planned loss amounts you have already calculated for each trade and expresses that sum as a percentage of supplied equity. It gives you a visible total for a review of concurrent plans.

The total is a planning amount, not a guaranteed loss cap. Gaps, slippage, fees and order behavior can make realized losses different. Changing equity changes the percentage even when the planned currency amounts remain the same.

Your worksheet

No account connection required

Inputs are processed in your browser by this calculator. There is no quote lookup or file upload for the calculation. Site measurement and consent are handled separately by the site's privacy and consent controls.

CSV schema: trade (text), planned_loss (number). Header required; comma delimiter. Numeric fields use decimal points. Timestamps require Z or a numeric UTC offset. The original input remains unchanged.

Unit: currency. Use a decimal point; do not use thousands separators.
Comma-separated CSV with a header. Maximum 500 rows and 200,000 characters.

Interactive calculation requires JavaScript. The method and hypothetical worked example below remain readable.

Hypothetical worked example

Check the example by hand

Three hypothetical trades have planned losses of 50, 75 and 25 USD. Their combined planned risk is 150 USD. Against 5,000 USD of equity, that is 3%. The calculation adds the supplied plans; it does not offset one trade against another or promise execution at each stop.

Total planned risk
150USD
Planned risk / equity
3%
Trades supplied
3
Exact example inputs
{
  "equity": "5000",
  "currency": "USD",
  "csv": "trade,planned_loss\nA,50\nB,75\nC,25"
}

The example is invented to demonstrate the method. It is not a current market quote, a provider's fee schedule or verified trading performance.

How the worksheet works

  1. Each planned_loss>=0 and is expressed in the one supplied currency.
  2. total_planned=sum(planned_loss); risk_pct=100*total_planned/equity.
  3. Do not net unrelated risks or estimate correlations.

The total is a planning amount, not a guaranteed loss cap. Gaps, slippage, fees and order behavior can make realized losses different. Changing equity changes the percentage even when the planned currency amounts remain the same.

Boundaries to keep in view

  • Planned stop risk is not a guaranteed maximum loss: gaps and execution costs may increase loss.
  • Costs should already be included in each planned amount if desired.
  • No recommendation for a suitable equity percentage.

Compare resources for this task

A concurrent-risk review combines your assumptions with trade records and knowledge of stop-order mechanics. The services below can support those pieces, but their documented roles do not establish that your aggregate plan is an enforceable risk limit.

10 Resources for Reviewing Open-Trade Risk

Official sources and scope

The sources document formats, mechanisms or record workflows. The arithmetic and editorial comparison on this page use the supplied worksheet definitions.

  • Kraken stop loss limit orders

    Trigger activates a limit order; execution is not guaranteed and the order may be independent of the position.

    Reference checked 2026-10-01. Consult the source for current product rules.
  • Coinbase Advanced order types

    Market, limit and stop-limit mechanisms, partial fills and execution uncertainty.

    Reference checked 2026-10-01. Consult the source for current product rules.
  • Microsoft Excel CSV import/export

    CSV import/export and explicit column interpretation; opening CSV applies default formats.

    Reference checked 2026-10-01. Consult the source for current product rules.