Swing research directory Walkthroughs Evidence checks Approach Questions Swing research directory

Swing gap scenario worksheet

Compare an intended-stop price with a user-entered exit scenario, keeping fees and carrying costs explicit.

A price scenario, not a forecast

The worksheet compares two hypothetical exits using the same entry, quantity and costs. For a long, a lower exit is adverse; for a short, a higher exit is adverse. The entered stop must be on that adverse side. The scenario can be either adverse or favourable. None of the inputs asserts that the market will gap to a particular price or that a broker will execute there.

The default example

Ten long units at $100, an intended $95 stop and a $92 scenario exit produce gross outcomes of minus $50 and minus $80. With $5 of total fees and $3 of assumed carrying costs, the net values become minus $58 and minus $88. The $30 difference is the price-scenario effect, not another fee or a provider drawdown.

Instrument limits

These are linear USD units, not options, exchange futures or a complete short-sale model. There is no borrow, dividend, currency or margin engine. Enter costs appropriate to your illustrative comparison; an actual broker statement is needed for an account outcome. A stop-limit order might not fill, and the worksheet cannot determine queue priority or liquidity.

Journal and export

Keep the exported user-input scenario apart from original alerts and executed trades. It is useful for discussing an unclear loss assumption with a supplier, but does not certify the supplier's method. Blank, negative or invalid fields show an error and prevent exporting a result. Reset restores the illustrative inputs, not a recommendation about personal risk.

Sources

Extend the single-position question without replacing it

The original worksheet remains available for an entered stop, gap exit and linear unit quantity. The new basket tool adds a common scenario across several positions, an entered multiplier for each row and explicitly labelled cluster totals. Those cluster names are teaching labels rather than estimated correlations. Both tools distinguish a planned price from an actual execution claim. Keep the original worksheet for a compact single-position inspection and use the basket when the issue is overlapping exposure at the same assumed event.

Worked swing records and calculators