Journal Template
Free Trading Journal Template (Google Sheets & Excel)
The manual foundation of trading success. Enter your email below to get our pre-coded templates delivered straight to your inbox.
Get Your Free Copy in Your Inbox
Enter your email address below. We'll instantly send you both the Google Sheets template and the offline Microsoft Excel (.xlsx) spreadsheet with pre-built automated formulas.
| Date | Symbol | Direction | Entry | Exit | Stop-Loss | Qty | P&L (₹) | P&L (%) | R-Multiple | Setup |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-08-01 | RELIANCE | Long | ₹2,500.00 | ₹2,550.00 | ₹2,480.00 | 50 | ₹2,500.00 | 2.0% | 1.67R | Support Bounce |
| 2026-08-03 | SBIN | Short | ₹600.00 | ₹588.00 | ₹606.00 | 200 | ₹2,400.00 | 2.0% | 2.00R | Double Top |
| 2026-08-04 | TCS | Long | ₹3,400.00 | ₹3,360.00 | ₹3,370.00 | 30 | -₹1,200.00 | -1.2% | -1.33R | Trend Break |
| --- | --- | --- | --- | --- | --- | --- | Auto (IF formula) | Auto (IF formula) | Auto (IF formula) | --- |
| --- | --- | --- | --- | --- | --- | --- | Auto (IF formula) | Auto (IF formula) | Auto (IF formula) | --- |
How to use this tool
- 01
Enter your valid email address in the box above to receive the free spreadsheet templates.
- 02
Open the confirmation email and click 'Make a copy' (for Google Sheets) or download the '.xlsx' file (for Microsoft Excel / Apple Numbers).
- 03
Enter your trades sequentially in the 'Trade Log' sheet. Keep Entry, Stop-Loss, and Quantity accurate.
- 04
Check the 'Summary Dashboard' tab to see your trading statistics, Win Rate, and expectancy calculate live.
Pre-loaded Formulas
The spreadsheet template implements automated formulas for mathematical calculations:
=IF(Direction="Long", (Exit-Entry)*Qty, (Entry-Exit)*Qty)=P&L (₹) / (Entry * Qty)=P&L (₹) / (ABS(Entry - Stop-Loss) * Qty)=Winning Trades / Total Trades * 100=(Win Rate * Avg Win) - (Loss Rate * Avg Loss)Frequently Asked Questions
How will I receive the trading journal template?
Once you enter your email address, our system will automatically email you the direct link to make a copy of the Google Sheets version as well as the downloadable Microsoft Excel (.xlsx) file within seconds.
Are both Google Sheets and offline Excel versions included?
Yes. The confirmation email includes both the Google Sheets cloud version and the offline Microsoft Excel (.xlsx) file, fully formatted with pre-built formulas.
Do I have to calculate P&L and R-multiples manually in the sheet?
No. The sheet contains pre-configured formulas. Once you input your Date, Symbol, Direction, Entry, Exit, Stop-Loss, and Quantity, the spreadsheet automatically calculates P&L in Rupees, P&L percentage, and R-multiples.
How do I save a copy of the Google Sheets template?
Clicking the 'Make a copy' link in the email opens Google Sheets and prompts you to save it directly to your private Google Drive. You do not need to request edit permission.
How do I sync trades automatically without spreadsheets?
Manual spreadsheet logging can be tedious and prone to typos. If you want automated syncing, WickLog connects directly with brokers like Zerodha, Dhan, and Groww, importing your trades, calculating all statistics, and providing AI-powered insights automatically.
Calculate Every Trade Automatically
Stop copying values manually. WickLog syncs your actual trades from Zerodha, Dhan, Groww and Angel One, and calculates win rate, profit factor, expectancy and net P&L after charges automatically.
Create Your Free AccountFree plan available · No credit card required