Last updated: 15 Oct 2026 · 9 min read
By Pulkit Mangal — F&O trader since 2017, founder of TradeDiary. Past trading experience across Zerodha, Kotak and Dhan; built TradeDiary after losing ₹14L in 2021 to mistakes a journal would have caught.
TL;DR: A free trading journal exists — several, in fact — but every free option trades away something: either your time (manual entry), your analytics (no pattern detection, no charge breakdown), or your data (locked inside one broker, or lost when you stop paying). The best free starting point for an Indian trader is an app with broker import and basic analytics on a free tier, not a blank spreadsheet you will abandon by week three.
You just closed your fifth losing trade this month on BANKNIFTY options. You know you should journal. You also know you are not going to spend ₹500 a month on yet another subscription. So you open Google and type "free trading journal".
What you find is a mix of spreadsheet templates, broker-built tools, mobile apps and web platforms — some genuinely free, some free-to-start, and some that use the word "free" until checkout. This guide sorts through them honestly, from the perspective of someone who has built a trading journal and used most of the alternatives.
Want the broader picture first? See our trading journal India guide →
What "free trading journal" actually means
There are four things people mean when they search for a free trading journal:
- A spreadsheet template — an Excel or Google Sheets file with columns for entry, exit, quantity, P&L, and maybe a few formulas. Cost: ₹0. Effort: all yours.
- A broker's built-in report — Zerodha Console, Groww's P&L, Angel One's Smart Money. You already have it if you trade there. It is a report, not a journal.
- A free tier on a journal app — a web or mobile app that lets you log trades at no cost, with limits on how many, how far back, or which analytics you see.
- A free trial — full features for 7 or 14 days, then a paywall. This is not free; it is a demo.
The distinction matters because each one breaks in a different place, and the break usually happens after you have invested weeks of data entry.
The spreadsheet: free until it costs you a Sunday
A Google Sheets trading journal is the most common starting point, and for good reason — it costs nothing, you control every column, and nobody can take your data away.
Here is what a basic spreadsheet journal needs:
| Column | Why |
|---|---|
| Date | When you entered |
| Symbol | What you traded |
| Segment | Equity, F&O, commodity, currency |
| Side | Buy or sell (or long/short for F&O) |
| Quantity / lots | Position size |
| Entry price | From the tradebook, not memory |
| Exit price | Including expiry settlements |
| Gross P&L | (Exit − Entry) × Qty, adjusted for direction |
| Charges | Brokerage + STT + exchange + GST + stamp |
| Net P&L | Gross minus charges |
| Notes | Why you took the trade, what you felt, what you learned |
You can download a ready-made template from our trading journal template page — it covers Indian charges, F&O lot sizes, and has a summary sheet.
Where spreadsheets break
The spreadsheet works until one of these happens, roughly in order of likelihood:
- You stop entering trades. Manual entry after a losing day is the last thing you want to do. Most traders who start with a spreadsheet stop within 4–6 weeks.
- F&O charges are wrong. STT on options is 0.15% of premium sold since 1 April 2026. Exchange fees, SEBI turnover fee, GST on brokerage, and stamp duty vary by state and segment. Getting this right in a formula takes an afternoon; getting it right for every trade takes discipline.
- Expiries vanish. An option that expires worthless has no exit trade. A spreadsheet that doesn't settle it shows a phantom open position forever — or worse, it silently inflates your P&L because the losing trade was never closed.
- You can't ask questions. "What is my win rate on Thursday expiry trades?" or "How does my P&L change when I hold past 2 PM?" require pivot tables, VLOOKUP chains, and a patience for debugging formulas that most traders do not have.
If you trade fewer than 20 times a month on one broker and you genuinely enjoy spreadsheets, a template is fine. For everyone else, it is a tax on your evenings that produces data you will not analyse. (Excel vs trading journal goes deeper on this comparison.)
Broker tools: free but not a journal
Every major Indian broker gives you some version of a P&L report:
- Zerodha Console shows a tax P&L, a tradebook and a Verified P&L link. It is accurate and free, but it is a report — there is no tagging, no notes, no strategy labels, and no way to see patterns across trades.
- Groww and Angel One show portfolio-level P&L. Their reports are segment-level, not trade-level.
- Kotak Neo and Dhan have back-office reports with contract-note-level detail but no journaling layer.
The broker tool answers "how much did I make?" It does not answer "why did I lose on Thursdays?" or "am I overtrading after a win?" — and it cannot, because it has no context beyond the fill.
If you use multiple brokers — and many Indian traders do, running Zerodha for equities and Kotak or Dhan for F&O — no single broker report shows your combined picture. You need something that pulls from all of them. (Kite and Console limitations covers the gaps in detail.)
Free journal apps for Indian traders
Several apps offer a free tier that goes beyond a blank sheet. Here is what to look for, and where each one draws its line:
What a useful free tier should include
- Broker import — CSV or API, so you are not typing trades by hand.
- Charges — at least STT and brokerage, ideally the full breakdown.
- Basic analytics — win rate, average win vs average loss, P&L by day/week/month.
- Notes and tags — the "why" behind each trade, searchable later.
- No data lock-in — you can export your data if you leave.
What free tiers usually limit
- Number of trades per month — 50 or 100 is common.
- History depth — some show only the last 30 or 90 days on the free plan.
- Advanced analytics — R-multiple, expectancy, streak analysis, behaviour patterns.
- AI features — automated review, pattern recognition, psychology tracking.
- Multiple brokers — often limited to one on the free plan.
The landscape in October 2026
The Indian trading journal space is small but growing:
- TradeDiary (this site) offers a free F&O and equity journal with Zerodha, Kotak, Dhan, Angel One and Upstox import, full charge breakdown, and basic analytics including win rate, day-of-week patterns and sector analysis. The free tier has no trade limit. Advanced features — AI-powered review, basket analysis, and verified P&L — sit on paid tiers. Export is always available.
- Spreadsheet templates remain the most popular free route, but as discussed above, they break under F&O complexity and manual-entry fatigue.
- Broker-specific tools (Console, Groww P&L) are free but limited to one broker's view with no journaling features.
- International tools (Tradervue, EdgeWonk, TradesViz) support Indian brokers to varying degrees, mostly through CSV. Pricing is in USD, and the free tiers tend to be tighter. (EdgeWonk alternative and Tradervue alternative compare these with Indian-specific options.)
The test is not which app is free today — it is which one will still have your data, with useful analytics on top, six months from now.
What "free" actually costs
Nothing is free. The question is what currency you are paying in:
| Option | Money | Time | Analytics | Data control |
|---|---|---|---|---|
| Google Sheets | ₹0 | High (manual entry, formula building) | Low (DIY only) | Full (your file) |
| Broker report | ₹0 | Low (auto-generated) | Minimal (no tagging, no patterns) | Locked to that broker |
| Free app tier | ₹0 | Low (import) | Medium (basic stats, limited advanced) | Depends on export policy |
| Paid journal | ₹200–500/mo | Low (import + auto) | High (full analytics, AI) | Depends on export policy |
The hidden cost of a spreadsheet is the Sunday evening you spend typing in trades and debugging a VLOOKUP that broke because you changed a column. The hidden cost of a broker report is the patterns it cannot show you. The hidden cost of a free app tier is the analytics you hit a wall on — but at least your data is entered and structured, so upgrading (or switching) does not mean starting over.
Five things to check before you commit
- Can it import from your broker? If you have to type trades by hand, you will stop. Look for Zerodha tradebook CSV import at minimum; API sync is better.
- Does it handle F&O correctly? Lot sizes, expiry settlements, STT at 0.15% on options sold — a journal that gets these wrong is worse than no journal, because it teaches you wrong numbers. (STT on F&O 2026 explains the current rates.)
- Can you export your data? If the app shuts down or you switch, you need a CSV or Excel export with every trade.
- Does it separate booked and unrealised P&L? A journal that quietly includes open positions in your "P&L" flatters you on good days and panics you on bad ones. The two should be clearly labelled. (How to verify P&L covers why this matters.)
- Is the free tier sustainable for the company? A free tier funded by a healthy paid tier is stable. A free app with no visible revenue model may not be around next year.
Common mistakes with free journals
- Starting with a spreadsheet "just for now" — you will not migrate 200 hand-entered trades later; start with import from day one.
- Logging only winning trades — the losses are the data. If entering a losing trade feels bad, that is exactly the habit a journal is meant to build.
- Tracking P&L but not the reason — a row that says NIFTY 24600 CE, −₹4,200 teaches you nothing. A row that adds "chased after seeing Telegram alert, no setup, FOMO" teaches you everything.
- Ignoring charges — on a high-turnover options strategy, charges can eat 15–30% of gross profit. A journal that shows gross P&L is lying to you about your edge. (Trading expectancy formula shows how charges change your numbers.)
- Not reviewing — a journal you never read is a diary, not a tool. Set a weekly review: 15 minutes, look at your worst three trades, write one sentence about what you would do differently.
How TradeDiary's free tier works
TradeDiary is built for Indian F&O and equity traders. The free tier includes:
- Unlimited trade imports from Zerodha, Kotak, Dhan, Angel One and Upstox (CSV and API).
- Full charge breakdown — brokerage, STT, exchange fees, SEBI fee, GST and stamp duty per trade, per contract note.
- Core analytics — win rate, average win/loss, P&L by day of week, by hour, by symbol, by strategy tag.
- Notes and tags on every trade — strategy, setup, emotion, mistake.
- F&O lot sizes and expiry settlements — auto-applied, including monthly and weekly expiry date corrections for holidays.
- Export — CSV and Excel, always available, no paywall on your own data.
What sits on paid tiers: AI-powered portfolio review, advanced analytics (R-multiple, streak analysis, basket tracking), verified P&L, and multi-workspace support.
Start your free trading journal →
You may also like: Excel vs trading journal · Trade journal templates · Best trading journal India 2026 · Trading diary example
Frequently asked questions
Is there a completely free trading journal for Indian traders? Yes. Google Sheets with a template is fully free. Several journal apps, including TradeDiary, offer a free tier with broker import and basic analytics at no cost. The trade-off is either manual entry (spreadsheets) or limited advanced features (apps). No free option gives you everything.
Can I use a free trading journal for F&O? You can, but check that it handles F&O lot sizes, expiry settlements, and STT at the correct rate (0.15% on options sold since 1 April 2026). A spreadsheet can do this with the right formulas, but most templates do not include them. A journal app built for Indian F&O handles this automatically.
What is the best free trading journal app in India? It depends on your broker and what you need. For Zerodha users, Console gives free P&L reports but no journaling. For a full journal with import, analytics and tags at no cost, TradeDiary's free tier covers Indian equity and F&O. See our comparison of trading journal apps for a detailed breakdown.
Should I pay for a trading journal? If you trade more than 20 times a month in F&O, a paid journal usually pays for itself by surfacing charge leaks and behaviour patterns a spreadsheet would miss. Start with a free tier, use it for a month, and upgrade only if you hit a wall on the analytics you need.
Can I switch from a spreadsheet to a journal app without losing my data? Most journal apps accept CSV imports, so you can upload your spreadsheet history. The cleaner your spreadsheet columns (date, symbol, side, quantity, price), the smoother the import. Some apps also import directly from your broker's tradebook, which is more reliable than a hand-maintained sheet.
Risk disclaimer
Trading in derivatives carries substantial risk. SEBI's January 2024 study found that 9 out of 10 individual traders in the equity F&O segment lost money, with average losses of ₹50,000 over FY22. (SEBI study, 25-Jan-2024)
TradeDiary is not a SEBI-registered investment adviser or research analyst. This article is general information, not investment or tax advice. App features and pricing described here are as of the publication date and may change.
Pulkit Mangal trades F&O on Indian markets and builds TradeDiary, a trading journal made for the Indian F&O trader.
Last updated: 15 Oct 2026.