Free download · Excel and Google Sheets

Free futures trading journal template

A one-tab trade log with a "Followed rules?" column on every trade. Built for prop firm traders. Free.

Get the free trade log

Type your email and the download link appears right away. You also join our email list about prop firm rules; unsubscribe in one click.

Here it is: download the free trade log (.xlsx).

Privacy Policy. No spam.

What's in it

  • One row per trade, 500 rows. Date, setup, long or short, contract, contracts, entry, stop, exit, result, notes.
  • Planned risk worked out for you from your entry, stop and contracts. Dollars per point are built in for 12 contracts: MNQ, NQ, MES, ES, MYM, YM, M2K, RTY, MGC, GC, MCL and CL.
  • Result in R (the result divided by the risk you planned) and a running total.
  • "Followed rules?" Yes or No on every trade, and which rule broke when it's No.
  • A check on each row that flags a stop on the wrong side, or a result that doesn't match your entry and exit.
  • A small summary: trades logged, total result, and how many trades followed your rules.

Why a "Followed rules?" column

A trade can win and still break your rules. Marked Yes or No against the rules you wrote down before the trade, not by whether it won, your log shows how often you trade your plan. That's the one number you can change directly.

When you want more

The Journal & Workbook ($39) uses the same Trade Log columns, so your rows move across in one paste. It adds your win-rate range (not just one number), the win rate you need to break even, what breaking your rules did to your results in dollars, results by setup, drawdown runway, a dashboard and a calendar, plus an 18-page printable workbook.

Is it really free?

Yes. No card, no trial. It's yours to use for your own trading.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets, or open it in Excel. It uses formulas only, no macros.

Is the planned risk right for my contract?

It uses the exchange's dollars per point for the 12 contracts listed. For other contracts, see the futures tick value calculator, and confirm with your broker.

Does it tell me what to trade?

No. It keeps score of what you did. It has no market data and no opinion on any trade.

Educational material only. Not investment advice. Trading futures involves substantial risk of loss and many people who try it lose money. Check your account rules with your firm; they change.

Free · one page

Prop firm rules checklist

The questions to answer from a firm’s own rules page before you buy an evaluation. Drawdown type, daily limit, consistency, payouts, every fee.

Here it is: download the checklist (PDF). Three short emails follow; unsubscribe any time.

You get the PDF right away, then three short emails over ten days. No spam, unsubscribe in one click. Privacy Policy.

The other free tools — no signup, nothing sent anywhere

The DeskWrite your rules once, then check each trade against them. Yes or no, with the reason.What it has cost you so farEvery evaluation, reset and monthly fee against every withdrawal. The net.Evaluation simulatorTen thousand simulated evaluations on your numbers. How often do you pass?Consistency rule calculatorYour best day is too big a share. How much more, and the day size to stay under.Payout-day checkCan you request a payout yet? Qualifying days, consistency, buffer and limits.Prop firm rule decoderWhere the line that closes your account actually sits, and what open profit costs you.Am I ready to size up?Four checks on your own record. Not yet, hold, or one step up.The one-page rulebookRules specific enough that a trade either followed them or it didn't.Position size calculatorContracts, dollar risk, and the copied-account multiplier.MNQ calculatorPoints to dollars on MNQ or NQ, with fees. Or dollars to points.Futures tick value calculatorTick and point values for 12 contracts, and your dollar rule in points.Drawdown runway calculatorHow many maximum-loss days your account can survive.What do your trades actually prove?Your win rate over a small sample is mostly noise. Find out how much.

Nobody pays us to send you anywhere.

We take no referral fee, affiliate commission or rebate from any prop firm, broker or platform. So we never rank firms, and the tools are free to give you the unflattering answer.

Every result here is arithmetic on the numbers you type, not a prediction. How we check the math. Futures trading carries real risk of loss: read the Risk Disclosure.

Rules Desk Journal and Workbook cover

Where these numbers live the rest of the week · $39

Journal & Workbook

The same arithmetic in a 500-row trade log that keeps score: your win-rate range, break-even, average result per trade, results by setup, and what rule breaks cost you. Plus an 18-page printable workbook.

One spreadsheet, one PDF. Instant download, no subscription.

See what’s in it

The whole method · $79

The Rules Desk Course

Ten short lessons that turn these numbers into a weekly routine: rules you can check, a full trade log, checking a payout request against your firm’s rules, and a review that changes a rule only on evidence. Includes the $39 Journal & Workbook. Lessons 1 to 3 and 7 are free to read first.

Self-study. Full refund within 7 days.

See the course