Prop Firm Challenge Spreadsheet Template

A challenge spreadsheet does one job that decides whether you pass: it shows you, at a glance, how close you are to a breach. Most traders fail because they lose track of their distance to the drawdown or daily limit mid-session. A simple tracker removes that blind spot entirely.

Here's what to build (or copy), and exactly which columns matter.

The columns that keep you funded

You don't need anything fancy. A single sheet with these columns covers everything that ends accounts:

The two that save accounts are distance to floor and distance to target. They turn abstract rules into one number you can read in a glance.

What to actually log after every session

After each trading day, fill in your daily P/L and let the sheet calculate the rest. The discipline of logging is half the value, it forces you to confront a bad day instead of denying it.

Add two manual checks the sheet should flag:

• Did any single day exceed your consistency limit? If one day is more than 30% of your total profit, you're at risk of a held payout. Our consistency rule guide explains the math.
• Did the daily loss come within range of the limit? A near-miss is a warning to size down tomorrow.

How to set up the formulas

Two formulas do the heavy lifting. For a static-drawdown account:

• Distance to floor = Running balance − (Starting balance − Max drawdown)
• Distance to target = (Starting balance + Target) − Running balance

For a trailing drawdown, the floor follows your peak, so swap in your highest balance reached. Our drawdown formula guide has both versions worked out with numbers.

Colour the "distance to floor" cell red when it drops below your daily risk amount. That single visual cue stops more breaches than any rule you'll memorize.

Using the tracker to size correctly

The spreadsheet isn't just a record, it's a sizing tool. Take your "distance to floor" and divide by ten. That's your maximum risk per trade if you want ten losing trades of room. As the floor gets closer, your per-trade size should shrink with it.

This is how disciplined funded traders stay funded: their size is a function of their remaining room, not their confidence. The sheet makes that calculation automatic. See how to calculate max drawdown for the full sizing logic.

How TradersYard makes tracking simple

A static drawdown, which TradersYard uses, makes your spreadsheet far simpler, the floor is one fixed number you set once, with no trailing recalculation every time you hit a new peak. One formula, true for the whole evaluation.

Entry starts at £31 with a 14-day money-back guarantee, and the rules give you the exact figures to plug into your tracker. Start your evaluation, then read the 10 evaluation tips to put the tracker to work. For free spreadsheet basics, Google Sheets handles all of this with no software to buy.