Open Trades Planned Stop-Risk Worksheet
Add your planned stop-loss amounts across open trades in one currency.
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 requiredInputs 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.
Interactive calculation requires JavaScript. The method and hypothetical worked example below remain readable.
Your result
Calculated from supplied values. See the notes and boundaries before interpreting the result.
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
- Each planned_loss>=0 and is expressed in the one supplied currency.
- total_planned=sum(planned_loss); risk_pct=100*total_planned/equity.
- 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.
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.