Free trading journal template for Google Sheets
Google Sheets is a good free home for a trading journal: it's in your browser, syncs across devices and has no monthly fee. Here's how to build one, or skip ahead and copy a ready-made template.
Columns to track
| Column | Example | Why |
|---|---|---|
| Date | 2026-10-16 | Find weekday/time patterns |
| Symbol | ABCD | P&L by ticker |
| Side | Long / Short | Do you do better long or short? |
| Shares, entry, exit, fees | 1000, 4.10, 4.32, 0.60 | Net P&L |
| Stop | 3.95 | Risk and R-multiple |
| Setup | ORB, VWAP reclaim | Which setups pay |
| Mistake tag / notes | Chased, early exit | Fix behavior |
Formulas (paste into Google Sheets)
Assume net P&L in column J (rows 2–500).
Net P&L per trade: =IF(C2="Long",(F2-E2)*D2,(E2-F2)*D2)-G2 Win rate: =COUNTIF(J2:J500,">0")/COUNT(J2:J500) Profit factor: =SUMIF(J2:J500,">0")/ABS(SUMIF(J2:J500,"<0")) Average win: =AVERAGEIF(J2:J500,">0") Average loss: =AVERAGEIF(J2:J500,"<0") Expectancy: =AVERAGE(J2:J500) R-multiple: =J2/(ABS(E2-H2)*D2)
Free ready-made template
TapeLog Lite is a free .xlsx that opens in Google Sheets (File → Import, or upload to Drive and open with Sheets). It has these formulas built in for 500 trades, with no macros and no sign-up on the GitHub download page.
FAQ
Is there a free trading journal template for Google Sheets?
Yes. TapeLog Lite is a free .xlsx template that opens in Google Sheets and calculates net P&L, win rate, profit factor and expectancy.
How do I open an .xlsx in Google Sheets?
Upload it to Google Drive, then open it with Google Sheets, or use File, Import inside a blank sheet.
Do Google Sheets journals need scripts?
No. All the core stats can be done with standard formulas like COUNTIF, SUMIF and AVERAGEIF.
Educational content, not financial advice. Updated 2026-10-16.