Session calendars and bar ambiguity
Specify date, venue, timezone and information resolution before treating a same-day exit clock or OHLC bar as execution evidence.
Keep basis points, per-side charges, fixed cash fees and fill-embedded costs in a consistent short-horizon research budget.
Educational execution planning. Invented costs and clocks are assumptions, not forecasts, broker instructions or a measured strategy record. Check the exact venue, instrument and account rules.
A short-term cost study can use attempted orders, executed legs or completed round trips, but these populations are not interchangeable. Our worksheet uses a constant notional per completed round trip and a whole number of trips per day. That deliberately narrow choice makes its arithmetic inspectable. A real ledger may include rejected entries, partial exits and positions carried beyond the window. Keep those records before calculating a strategy statistic. A chart containing only completed winners is not an honest turnover population, and an assumed daily count is not evidence that the same opportunities or capacity will exist in a future month.
One basis point is 0.0001 times notional. On a notional of 10,000, eight basis points cost eight cash units per round trip. An additional fixed fee of two cash units is another two basis points at that notional. A per-side percentage is not a round-trip percentage; a fixed ticket charge is not a percentage at every position size. Write the units beside each input and state which charge applies once or twice. The worksheet assumes its variable cost already covers the whole round trip and asks for an additional fixed round-trip cost separately.
Assume four round trips per day, twenty days and the same 10,000 notional every time. There are eighty round trips. Twelve assumed gross basis points produce 960 cash units. Eight variable-cost basis points consume 640, and two extra fixed cash units per trip consume 160. Net arithmetic is 160. These values are invented to demonstrate accounting, not a fitted edge or strategy recommendation. Break-even gross is ten basis points under these inputs. A strategy with different fill prices, size, turnover or account constraints needs its own ledger rather than a copied worksheet result.
If a study starts from a reference or midpoint price, spread and slippage may need explicit modelling. If it starts from observed execution prices, those prices may already embody the effects. Charging the same disadvantage again would understate the result; ignoring charges not embedded in fills would overstate it. Preserve whether entry and exit fields are reference, simulated or actual. Separate commissions, financing and other account costs according to their applicable period. A generic line called fees hides too much. Reconcile one complete round trip before calculating a long list of aggregated outcomes.
Hold the fictional gross assumption fixed and vary the variable cost. Note where the arithmetic crosses zero, then state what you have not estimated: gross edge, fill distribution, opportunity count and available capacity. A single deterministic cost is not a tail-risk model. High turnover can magnify a small modelling error, especially when liquidity and urgency vary. A cost sensitivity exercise is useful for rejecting an implausibly fragile plan, but it does not supply a confidence interval or prove that costs in a particular instrument will follow the entered constant in live trading.
The journal should preserve order attempts, quantities, actual execution prices and explicit charges. Compare the planned cost convention with what those records can actually support. The worksheet does not compound returns, update equity, model leverage or annualize a result. Dividing its invented cash total by an imagined account would add assumptions absent from the tool. A completed research report should identify the evaluation population, execution contract and cost sources. Formula fixtures are software evidence only; independent strategy outcomes remain a separate task. Keep that boundary visible when turning a useful cost exercise into a public explanation.
Keep the default eighty round trips and 10,000 notional, but raise variable round-trip cost from eight to ten basis points. Gross cash remains the invented 960, variable cost becomes 800 and extra fixed cost remains 160, leaving zero net arithmetic. Now halve notional while retaining the fixed cash fee and explain why the fixed charge represents more basis points. Do not call this a market forecast: the gross movement and repeated notional remain assumptions chosen for the exercise.
Documentation establishes the stated mechanism, not tested trading performance. Checked 9 October 2026; a later version can differ.
Fixed-notional turnover friction budget
Specify date, venue, timezone and information resolution before treating a same-day exit clock or OHLC bar as execution evidence.
Reconcile intended actions, acknowledgements, cancellations and fills without silently treating an order message as a completed trade.
The retained eighty-trip default is non-compounded fixed-notional arithmetic. The new fragment lens uses original position quantity and actual-or-declared execution bases, with an explicit open mark and incurred cash fees. They answer different questions and should not be pooled into a performance curve. Real comparisons need the same eligible quantity population, price convention, period and fee inclusion. The complete teaching packets keep that boundary visible while authentic tariffs, funding, liquidity, account access and independent economic validation remain absent.