Sizing, drawdown and cash-flow denominators
Keep account currency, position increments, original risk, recovery percentages and deposits separate before drawing conclusions from a risk statistic.
Compare planned stop loss with disclosed hypothetical account shocks without pretending to estimate correlation, tail probability or a guaranteed maximum.
Educational risk arithmetic, not personal sizing advice. Stops do not guarantee fills. Stress inputs are invented assumptions without assigned probabilities; margin, shorts and derivatives need their own contracts.
A stop budget typically begins with quantity, distance between entry and intended stop, instrument value per unit and applicable costs. It describes the loss under that intended exit assumption. Calling it the maximum possible loss changes the claim. A stop instruction may be triggered while the available fill price differs, and charges can add to the outcome. Preserve the planned number because it is useful, but label it as planned. A portfolio study should also state which positions, open orders and account resources are inside its boundary rather than relying on an isolated attractive percentage per trade.
In the invented worksheet, position A has fifty long shares at 100, planned stop 98, assumed exit 94 and additional cost 0.10 per share. Its planned loss is 105 and scenario loss is 305. Position B has thirty shares at 80, stop 77, assumed exit 72 and the same extra per-share cost. Its planned loss is 93 and scenario loss is 243. The joint figures are therefore 198 and 548. These are exact arithmetic assumptions, not historical prices, observed fills or a statement about any named stock or provider.
The example uses 10,000 starting cash. Entry notional is 7,400 and additional round-trip costs total 8, so the conservative funding requirement is 7,408. The tool rejects a requirement above entered cash and accepts only whole long shares. This is a narrow educational lane, not a broker account simulator. It does not resolve settlement eligibility, currency conversion or every permitted trading action. Margin, options, futures and shorts need their own identity and funding contracts. Reusing the same fields while silently changing the financial instrument would make a tidy spreadsheet materially misleading.
Different tickers can share a common driver, venue or funding condition, but this worksheet does not estimate their dependence. It simply adds the chosen position outcomes. A larger catalogue of tickers does not guarantee diversification. A probability model would need data, a declared dependence method, sampling assumptions and independent evaluation. An assumed price shock has none of those automatically. Do not call the displayed loss a value-at-risk estimate or a worst possible outcome. The scenario can be useful for understanding a control boundary without supplying a probability that the account will experience it.
One scenario position can gain while another loses. Show both before the joint sum, so an offset does not conceal how much each position could demand in attention or capital. An account policy may restrict gross exposure, common drivers or open-order quantity even when a chosen scenario nets to a small loss. Those limits must be declared rather than retrofitted to the displayed total. If charges are already represented in the supplied prices, do not add them twice. Preserve how costs were estimated and whether the prices represent reference, hypothetical execution or actual fills.
A stress worksheet becomes more useful when linked to a written operating policy: who observes exposure, what information is available, which actions are permitted and how exceptions are retained. An emergency action can itself face unavailable liquidity or broker conditions. The calculation does not guarantee that a policy can avoid the scenario. Save the assumptions, model lane, individual losses and joint result with the export. Software fixtures verify this arithmetic; they are not independent strategy outcomes. The honest conclusion is how a declared hypothetical shock differs from the declared planned stop budget, not that the account is certified safe.
Keep the two default positions but reduce entered cash from 10,000 to 7,407. The worksheet must reject the scenario because entry notional plus the declared extra costs totals 7,408. Restore cash and set one assumed exit above its entry; inspect both individual losses before reading the net joint result. These are software boundary examples. They do not establish settled funds, broker permissions or the probability of either price, and they must remain labelled as invented scenarios in any saved export.
Documentation establishes the stated mechanism, not tested trading performance. Checked 9 October 2026; a later version can differ.
Two-position cash-funded gap stress
Keep account currency, position increments, original risk, recovery percentages and deposits separate before drawing conclusions from a risk statistic.
Turn a risk formula into a versioned policy with ownership, funding checks, monitoring, exceptions and durable cloud evidence.
The two-position form and its earlier 198/548 example are retained. A separate three-position specimen adds C and evaluates a five-row scenario register. The original two-position numbers do not disappear or become a new measured history. Both examples are intentionally cash-funded long-share assumptions. Isolated price shocks, joint planned-stop exits and deeper joint gaps are not estimates of independence, correlation or occurrence probability. This preserves a useful narrow baseline while giving the reader a more complete multi-position exercise.
The workbook's joint cases change several prices while quantities and additional costs remain fixed. A real common-event analysis would need relevant factor definitions, time intervals and account exposures. The fictional labels alone cannot establish a market relationship. The useful output is the hypothetical loss and its account denominator, with source gaps visible. Neither the source PNG nor an exact CSV row certifies a future liquidity path, portfolio allocation or expected loss.