📥 Worksheets and Templates

A candle keeps five numbers and throws away everything else that happened in its interval. Two intervals that behaved nothing alike can produce the same five numbers, pixel for pixel. This worksheet finds out how much your own chart is discarding, and which of your questions the discarded part was carrying the answer to.

Markdown source

Every position opens at a loss, and one of the four charges keeps deepening it for as long as you hold. The spread, the commission, the slippage and the financing are all taken for reasons that have nothing to do with whether the trade works. This worksheet puts your own four on one page and turns them into the one number a breakeven formula is actually asking for.

Markdown source

Two bars can share their open, high, low, close, total volume and even the volume at every price and still carry deltas of +2,820 and −1,680, one read as absorption and the other as exhaustion. Before any of that is worth arguing about, three things have to be established about your own data. This worksheet establishes them.

Markdown source

A divergence is price disagreeing with a number computed from price. Two settings decide whether one exists at all, and before either of them looks at an indicator, the swing rule alone decides whether there are thirty-three places to look or five.

Markdown source

A sweep is price trading past a level and coming back. Three settings decide whether one happened at all, and on the lesson’s sixty bars ordinary values of those three find four sweeps, or fifteen, or forty-six.

Markdown source

Finding where a finished series changed and deciding that it has just changed are two different problems, and the one you have is the second. On the lesson’s sixty closes, one bar of confirmation halves the declared changes from eight to four and five bars halves it again to two. And how much of the move you end up inside does not fall as you add confirmation.

Markdown source

The standard advice is to read three charts and act only when they agree. On the lesson’s sixty bars, three widths of the same tape agree on nine bars in forty and all three call a trend on seven. Whether that exchange is worth making is arithmetic with two break-even points rather than one.

Markdown source

An off-exchange trade is hidden while it works and public the moment it is done, and the one field the tape never carries is the side. The rule the folklore uses to fill it in (above the volume-weighted average is accumulation, below it is distribution) fills it in with the day’s price path instead. On the curriculum’s sixty closes the accumulation share tracks the session return at a correlation of 0.93.

Markdown source

Two rules on one instrument look like two positions. They are not two bets. This worksheet turns your own book into the number of independent bets it is actually carrying, which is the number every risk figure downstream depends on.

Markdown source

Lesson 65 turned a trade count into a wait by assuming forty trades a month, and said in the same breath that the forty was stated rather than derived. This worksheet derives yours. Everything downstream (how long a verdict takes, what a month earns, what a year of costs comes to) is that one number multiplied by something.

Markdown source

Four habits, each measurable alone on the same trades. On the lesson's seven, taking the profit at the first green close costs 2.20 a share and a stop at a quarter of an R costs 5.90. Add those and the pair should leave 1.74. Run both at once and the record is 4.44, which is 2.70 better than the addition predicts. This worksheet runs the same test on your own trades.

Markdown source

A book of rules is easy to admire and hard to justify. The test is not whether the book beats one of its members; it is whether every member earns its place. On the lesson's four-rule book, three of the four deletions improve it. This worksheet runs the same test on yours.

Markdown source

Five numbers describe a trading business and they fail in a fixed order. The card below is the lesson's, filled in with its own figures on the right so yours has something to disagree with. Read down it and stop at the first row that binds.

Markdown source

Work top to bottom. Every line is arithmetic on numbers you supply; nothing here decides whether to take a trade.

Markdown source

Copy one **Trade Record** block per trade. Fill the pre-trade section **before** you enter; if you cannot complete it, that is the signal to skip the trade rather than to guess.

Markdown source

It is a record of which tools you find readable in which conditions. It is not a set of rules that fire, and no cell in it says buy or sell. Every entry is a judgement you should replace with your own once you have watched enough of your own instrument.

Markdown source

A backtest is a hypothesis about a set of rules. This template is for attacking that hypothesis before you trust it.

Markdown source