Google Sheets Trading Journal
Successful prop trading requires recording every execution. Our free, pre-configured trading journal spreadsheet simplifies this process by calculating critical performance and consistency metrics automatically.
Core Sheet Features
- Discipline Score: Automatically tracks your compliance percentage across predefined rules.
- Risk Estimator: Input account size and stop-loss to get the exact position size in lots.
- Mistakes Log: Tag trade mistakes (e.g., FOMO, overtrading) to identify psychological patterns.
- Session Classification: Filter performance by US, London, and Asian sessions.
Discipline Journal Template
Opens in a new window. Safe copy to your Google Drive.
Spreadsheet FAQ
Got questions about copying or using the trading journal spreadsheet?
How do I copy the journal to my Google Drive?
Simply click the "Copy Google Sheets Template" button. This will open a link asking you to make a copy. Once copied, it is saved securely to your personal Google Drive and only you have access to it.
Can I use this template in Microsoft Excel?
Yes. Once you open the Google Sheets template, you can go to File > Download > Microsoft Excel (.xlsx) to run it locally on your computer.
How does the daily Discipline Score calculate?
The journal checklist contains checkboxes for rules (e.g., "Followed Risk Limit", "Waited for MSS", "Closed before rollover"). The Sheet computes the percentage of compliance across your weekly logs to output your final Discipline Score.