Home › Templates › Prop firm challenge tracker

Prop Firm Challenge Tracker

A free prop firm challenge tracker for Excel and Google Sheets: type your challenge rules once, add one row per trading day, and it shows how much of the daily loss limit you used, how far you are from the static or trailing drawdown floor, progress to the profit target, trading days, the consistency rule, and a status of OK, Warning, Breach or Target hit.

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no platform connection.

Day	Day P/L	End balance	Daily loss used	% of daily limit	Floor today	Room to next-day floor	Progress	Days	Status
Mon 5 Oct	+$1,194.00	$101,194.00	$380.00	8%	$90,000	$10,000.00	15%	1	OK
Tue 6 Oct	−$1,287.00	$99,907.00	$2,244.00	45%	$91,194	$8,713.00	-1%	2	OK
Wed 7 Oct	+$2,290.00	$102,197.00	$0.00	0%	$91,194	$10,000.00	27%	3	OK
Thu 8 Oct	−$4,734.00	$97,463.00	$4,734.00	95%	$92,197	$5,266.00	-32%	4	Warning
Fri 9 Oct	+$900.00	$98,363.00	$0.00	0%	$92,197	$6,166.00	-20%	5	OK
Mon 12 Oct	+$3,600.00	$101,963.00	$0.00	0%	$92,197	$9,766.00	25%	6	OK
Tue 13 Oct	−$600.00	$101,363.00	$2,553.00	51%	$92,197	$9,166.00	17%	7	OK
Wed 14 Oct	+$2,600.00	$103,963.00	$0.00	0%	$92,197	$10,000.00	50%	8	OK
Thu 15 Oct	+$1,500.00	$105,463.00	$0.00	0%	$93,963	$10,000.00	68%	9	OK
Fri 16 Oct	+$2,600.00	$108,063.00	$0.00	0%	$95,463	$10,000.00	101%	10	Target $ met, consistency fails
Mon 19 Oct	+$1,200.00	$109,263.00	$0.00	0%	$98,063	$10,000.00	116%	11	Target hit

Chart: end balance, the next-day overall floor and the pass level from the same tab. The workbook draws the same lines as a native chart on the Summary tab.

Generic by design. The tracker does not name, rate or recommend any firm. Rules differ between challenges and change over time, so copy the numbers and definitions from the terms of the challenge you bought. If your terms and this sheet disagree, your terms win.

What's inside the spreadsheet

The settings

How to use it

1. Open Settings and copy the rules from your challenge terms. Pay attention to two words: is the daily limit measured on balance or equity, and is the overall limit static or trailing?
2. After each session, add a row on Daily log: the date and the closed P/L. If your platform shows the lowest equity of the day, type it in column C. Open trades count toward many daily limits.
3. Prefer to log trades? Use Trade log and leave Daily log column B blank. The day's P/L is added up by date, and each trade shows whether its full stop was bigger than the room left that day.
4. Read the Status column. "Warning" means a day used 70% (your setting) of the daily limit or of the overall buffer. "After breach" marks every day after a breach.
5. Before the next session, read Summary: the floor, the room before a breach, and the max risk per trade. Size positions with the position size calculator or the position size spreadsheet.
6. Log every attempt, reset, refund and payout on Attempts. The Summary shows what the challenges cost in total, not only the latest fee.

Balance or equity, static or trailing

Two rules decide most failed challenges, and their wording varies. The tracker lets you pick the version in your terms.

The lowest point matters, not only the close. On day 4 of the example the day closed −$4,734 against a $5,000 limit. Had equity dipped to $97,197 or lower during the day (a $5,000 drop from the $102,197 start), the day would have been a breach even if trades recovered later. A spreadsheet only knows the numbers you type, so type the lowest equity when your rule counts open trades.

The formulas, explained

Exact formulas from the file, row 8 of Daily log (row 7 uses the account size instead of the row above). Settings cells: B4 account size, B6 daily loss %, B7 "% of", B8 "measured from", B10 overall loss type, B11 floor stops at, B12 minimum days, B13 consistency %, B15 warning %, B19 profit target $, B20 overall loss amount $.

The status checks run in a fixed order: an earlier breach first, then a breach today (daily loss used ≥ limit, or the lowest point at or below the floor), then the target (with minimum days and the consistency rule), then the warning threshold. A breach is permanent in the log because most challenges end at the first breach.

Worked example from the sample data

Day 4: a close call, and a trade that was too big

The day started at $102,197.00. With a fixed $5,000 daily limit, the floor for the day was $97,197.00. Three losing trades:

After two stops, the room left was $1,970.00. The third trade had a full stop of $2,000.00, so it is flagged: had it gone all the way to the stop, the day would have lost −$5,030.00 and breached the limit. It was cut early at −$1,704.00, and the day closed at −$4,734.00, using 94.7% of the limit: status Warning.

Days 10 and 11: target reached, consistency not yet

On day 10 profit reached $8,063.00, above the $8,000 target, after 10 trading days (4 needed). But the best day, $3,600.00, was 44.6% of total profit, above the 40% cap, so the status is Target $ met, consistency fails. The Summary works out the profit needed for the best day to fit: $3,600 / 0.40 = $9,000.00. Day 11 added $1,200.00, profit reached $9,263.00, the best day fell to 38.9%, and the status changed to Target hit.

The Summary after 11 days

The trailing floor rose with every new closing high, from $90,000 to $99,263.00, so the room to the floor stayed at $10,000. Had the account kept rising past $110,000, the floor would have stopped at $100,000, the "stops rising at" level in Settings.

What the attempts cost

Three $500 attempts mean $1,500.00 in fees, and no payout yet, so "payouts minus net fees" is −$1,500.00. Passing an evaluation is not a payout. Keep the full cost in view when you decide whether to buy another attempt.

The risk behind the challenge

Many challenges are traded on forex, CFDs or futures with leverage. Regulators publish loss figures for retail accounts in leveraged products. They are not pass rates for challenges, which no regulator publishes, but they show how hard short-term leveraged trading is:

• ESMA, the EU securities regulator, reported when it restricted CFDs (27 March 2018) that national regulators' analyses show "74-89% of retail accounts typically lose money on their investments, with average losses per client ranging from €1,600 to €29,000".
• The UK FCA made those restrictions permanent in 2019. One of them is a standardised risk warning that "requires firms to tell potential customers the percentage of their retail client accounts that make losses". That figure appears on CFD providers' websites.
• In the US, NFA's free BASIC database lets you "research the background of derivatives industry professionals". Use it to check whether a firm or person you deal with is registered and has any disciplinary history.

Use the fee and the rules as fixed costs in your own maths. The risk of ruin calculator shows how the chance of hitting a loss limit grows with the risk you take per trade.

Common mistakes

• Using the wrong reference for the daily limit. "5% daily loss" from start-of-day equity is not the same as 5% from balance if you hold trades overnight. Check the definition.
• Only logging closes. If your rule counts open trades, a day can breach intraday and still close green. Type the lowest equity.
• Forgetting that the trailing floor moves up. A good day raises the floor, so the room to it does not grow. See the example: $10,000 of room, every day, after new highs.
• Sizing on the full daily limit. One full stop at the whole room leaves no margin for slippage or a second trade. Divide by the stops you want to survive.
• Counting only the latest fee. Resets and repeat attempts add up. Log them all on Attempts.
• Typing limits as negative numbers. Enter 5%, not −5%. Day P/L is negative for a loss, but limits and fees are positive.
• Ignoring the reset time. Many challenges reset the "day" at a set time and time zone. Log days the way your terms define them.

FAQ

What is a prop firm challenge tracker?

It is a log that checks your trading against the rules of a funded-account evaluation: profit target, maximum daily loss, maximum overall (static or trailing) loss, minimum trading days and, if your challenge has one, a consistency rule. This template does it in Excel or Google Sheets: you type the rules once and one row per day, and each row gets a status of OK, Warning, Breach or Target hit.

How is the max daily loss calculated in a prop firm challenge?

It depends on the terms of your challenge. Usually the limit is a % of the account size or of the start-of-day value, and it is measured from the start-of-day balance, the start-of-day equity, or the higher of the two. The template supports all of these: daily loss used = the day's reference value minus the lowest point of the day (end balance, or the lowest equity you saw). It is a breach when that reaches the limit.

What is the difference between static and trailing drawdown?

With a static drawdown the floor stays at account size minus the allowed loss, for example $100,000 − $10,000 = $90,000. With a trailing drawdown the floor follows your high-water mark: after a close at $104,000 it rises to $94,000. End-of-day trailing uses closing balances; intraday trailing also uses the highest equity during the day. Many trailing rules stop rising at a set level, often the starting balance.

How does a consistency rule work?

A consistency rule caps how much of your total profit can come from one day. With a 40% rule and a best day of $3,600, total profit must be at least $3,600 / 0.40 = $9,000. In the example, the $8,000 target was reached on day 10 with $8,063 of profit, but the best day was 44.6% of it, so the status shows "Target $ met, consistency fails" until day 11.

How much should I risk per trade in a prop firm challenge?

There is no single right number. A useful ceiling is the room left before a breach: the smaller of today's daily loss limit and the distance to the overall floor. The Summary divides that room by the number of full stops you want to survive in one session. In the example the room is $5,000 and 2 stops gives $2,500 per trade, before slippage and gaps.

Are prop firm challenges regulated?

It depends on the country and on what is sold. Many challenges are sold as a fee-based evaluation, often on a demo or simulated account, and the firm selling it may not be a regulated broker. No CFTC or NFA customer advisory specifically about paid evaluation programs could be found as of 30 October 2026. Read the terms before you pay, and check registration with NFA BASIC.

Related tools and templates

• Position size calculatorSize a trade for a set dollar risk
• Position size spreadsheetStocks, forex lots, futures, crypto
• Risk of ruin calculatorOdds of hitting a loss limit
• Day trading journalTrades, sessions, daily loss limit
• Lot size calculatorForex lots from risk and stop
• Trading plan templateWrite the rules you trade by
• Why win rate alone doesn't matterWin rate and payoff together
• All templatesFree spreadsheets

Educational template only, not financial, tax or investment advice. BeCoin does not review, rate or recommend prop trading firms and has no affiliate links to them. Trading leveraged products carries a high risk of losing money, and a challenge fee is a cost whether or not you pass. Example data and example rules are fictional: symbols TKR-A, TKR-B and IDX-FUT and all prices, results and fees are made up. ESMA, FCA and NFA material was retrieved on 30 October 2026.