FOR EDUCATIONAL PURPOSES ONLY
Position Sizer Excel Workbook*
Position Sizer PDF Guide*
WHAT IT IS
An Excel workbook that turns a Trend Tracker signal into a position: how many contracts to trade, where to add, and when to exit. Trend Tracker supplies the signal. The workbook supplies the size. The PDF guide gives the rules and the steps.
HOW IT SIZES
One unit risks 1% of the account over a move of 3 ATR (ATR length and smoothing are settings in the workbook). Contracts per unit = account x risk per unit / (3 x ATR x point value), rounded down. Add a unit every 1.5 ATR, up to 4 adds per market and 20 units in total. A change in the trend state is the stop; a 3-ATR price stop is optional.
LOADING TREND TRACKER DATA
Download the Sizer Export CSV, open it, select all and copy, then paste into the workbook's TT Data sheet at cell A1. That one paste updates the state, signal price, point value, margin, last close and ATR for every contract. Repeat each trading day.