Forex & Futures Prop Firm Risk Calculator + Challenge Tracker (Excel + Google Sheets)
Pass your prop firm challenge without guessing your numbers.
Type your firm's rules once and log each day in one row. The tracker shows the most you can lose today, how far you are from the drawdown floor, how close you are to the target, and whether you passed or failed. The calculator gives you the right size for every trade.
WHAT'S INSIDE
- Tracker: your rules and your status (in progress, passed or failed), balance, room to the floor, the most you can lose today, progress bars and a chart of balance vs drawdown floor vs target.
- Daily Log: 90 days. Daily loss level, drawdown floor, room to the floor and a status for every day.
- All 3 drawdown types: static, trailing end of day and trailing intraday, plus "stops trailing at" for firms that lock the floor.
- Your firm's other rules: daily loss limit (fail or stop for the day), minimum trading days, best-day consistency rule, max contracts or lots.
- Position Size calculator: 32 instruments ready (forex pairs, ES, MES, NQ, MNQ, YM, RTY, gold, oil, micro bitcoin, plus gold, index and crypto CFDs). It shows your lots or contracts, your real risk, reward to risk, and how many losses in a row you can take today. Add your own instruments.
- Rules Checklist: 12 questions to ask about your firm's rules, plus your own rules to check before every session.
- BONUS: a sample copy filled with 12 made-up days, so you can see how it works.
WORKS WITH
Microsoft Excel 2010 or newer (Windows and Mac) and Google Sheets (free).
Pairs well with the Prop Firm Playbook PDF.
Prop firm rules change often, so always confirm your firm's current rules. For education only. Not financial advice. Screenshots show sample data, not real trading results.