CSV Import Zerodha Nifty & BankNifty F&O Kite · Console

Zerodha Trading Journal
Import Tradebook. Get Insights.

Download your Zerodha tradebook CSV from Console and upload it to FnoDiary in under 2 minutes. Get discipline scoring, psychology journaling, trade calendar, and F&O analytics — purpose-built for Nifty and BankNifty traders.

No credit card · 2-minute import · Free with referral

Zerodha tradebook CSV support Nifty & BankNifty F&O Discipline score per session Psychology journal Free with referral

How to import Zerodha trades into FnoDiary

Takes under 2 minutes. Works for equity, intraday, and all F&O instruments traded on Zerodha Kite.

1

Download tradebook from Zerodha Console

Log into console.zerodha.com → go to Reports → Tradebook → select the date range → click Download to get your CSV.

console.zerodha.com
→ Reports
→ Tradebook
→ Select dates → Download CSV
2

Upload to FnoDiary

In FnoDiary go to Broker Settings → Zerodha → Upload Tradebook CSV. Select the file you downloaded and click Import.

3

Review your analytics

Your trades appear instantly with full metadata. Your discipline score, trade calendar, and analytics dashboard populate automatically.

Tip: Download the tradebook monthly and reimport to keep your journal up to date. FnoDiary deduplicates trades automatically so you can safely re-upload overlapping date ranges.
Note: Zerodha CSV import is a manual process — you download and upload the file periodically. If you want fully automatic trade sync with no CSV step, FnoDiary also supports Dhan and Upstox via live API.

What FnoDiary reads from your Zerodha tradebook

All the fields you need to analyse your F&O performance — automatically parsed from the standard Zerodha CSV format.

📋

Trade metadata

Symbol, CE/PE type, strike price, expiry date, entry & exit price, lot size, buy/sell direction, timestamps, and realised P&L per trade.

📈

All F&O instruments

Nifty 50 options, BankNifty options, Finnifty, Midcap Nifty, weekly and monthly contracts, and stock options — all parsed from the standard Zerodha format.

🕐

Timestamps

Entry and exit times to the minute — used to group trades into sessions and calculate per-session discipline scores and P&L.

💰

P&L per session

Net P&L per trade and per session, aggregated into monthly and weekly views in your trade calendar and analytics dashboard.


What you get after importing

A complete journaling and analytics system for Zerodha F&O traders — far beyond what Excel can show.

🎯

Discipline score

Each session is scored out of 100. FnoDiary detects revenge trading, overtrading, and quantity doubling after losses — the patterns that silently destroy F&O accounts even when strategy is sound.

🧠

Psychology journal

Write your mindset, mood, and lesson after each session. Entries are linked to that day's trades so future-you can revisit the emotional context of every decision.

📅

Trade calendar

Monthly P&L heatmap. See your best and worst Nifty expiry days, FOMC reaction sessions, and budget day performance at a glance.

📉

Analytics dashboard

Win rate, average loss size, best trading hours, worst days, streak analysis. Patterns that are invisible when you only look at P&L become clear across 30+ sessions.

📊

Session grouping

Trades are automatically grouped into sessions by date so you can review a full trading day as a unit — not as isolated individual trades.

🔗

Chart sharing

Generate a public link for any trade or session. Share your analysis with a mentor or trading group for feedback.


Why Zerodha traders switch from Excel to FnoDiary

Most Zerodha F&O traders start with Excel — paste the tradebook, add some formulas, calculate win rate. It works for a while. Then it fails, consistently, for three reasons:

⏱️

Friction kills consistency

A manual Excel process takes 20–40 minutes per session. Studies on habit formation show that reducing even small friction doubles follow-through rates. Most traders quit Excel journaling within 3 weeks.

🔍

No discipline metrics

Excel calculates P&L. It cannot detect that you re-entered immediately after a loss 14 out of your last 20 sessions. Discipline patterns are invisible in a spreadsheet.

🧠

No psychology layer

The emotional memory of a bad trade — the FOMO, the panic exit, the revenge re-entry — fades within hours. Without a structured psychology entry written immediately after the session, you lose the real lesson.

📊

No session-level view

Excel shows individual trades. FnoDiary groups them into sessions and scores each session as a whole — giving you the unit of analysis that actually matters for behavioural improvement.


FnoDiary vs other trading journals for Zerodha

FeatureFnoDiaryTradesVizSyncTradeExcel
Zerodha import Tradebook CSV CSV CSV~ Manual paste
Discipline score Auto, per session No No No
Psychology journal Linked to trades~ Basic notes~ Basic No
Trade calendar heatmap Monthly P&L Yes~ Limited No
Session grouping Auto by date Yes~ Basic Manual
Chart sharing Public link No No No
Price (India)₹0 (referral) / ₹199/mo₹1,999–₹5,999/yr₹499–₹999/moFree

Zerodha trading journal — common questions

How do I import Zerodha trades into FnoDiary?
  1. Log into console.zerodha.com
  2. Go to Reports → Tradebook
  3. Select your date range and click Download
  4. In FnoDiary: Broker Settings → Zerodha → Upload Tradebook CSV

Your trades appear in seconds. The whole process takes under 2 minutes.

Is FnoDiary free for Zerodha users?

Yes — free forever if you sign up through a referral link. Every FnoDiary user gets their own referral link. Without a referral, the Standard plan is ₹199/month with full access to all features.

What format is the Zerodha tradebook CSV?

Zerodha's tradebook CSV is downloaded from console.zerodha.com → Reports → Tradebook. It includes trade date, time, symbol, exchange, trade type, quantity, price, and order ID. FnoDiary automatically parses this standard Zerodha format — no reformatting needed.

What F&O data does FnoDiary read from the Zerodha tradebook?

FnoDiary imports all your F&O trades from the Zerodha tradebook: symbol, CE/PE type, strike price, expiry, entry & exit price, lot size, timestamps, and P&L. This covers Nifty 50 options, BankNifty options, Finnifty, Midcap Nifty, and stock options.

How often do I need to upload my Zerodha tradebook?

You can upload as often as you like — daily, weekly, or monthly. FnoDiary automatically deduplicates trades, so you can safely re-upload overlapping date ranges without getting duplicate entries. Most traders find weekly imports a good balance.

How does FnoDiary compare to TradesViz for Zerodha traders?

Both support Zerodha via CSV import from Console. FnoDiary differentiates with per-session discipline scoring (automatically detecting revenge trading, overtrading, quantity doubling), chart-linked psychology journaling, and session-level grouping and analytics.

FnoDiary starts at ₹0 (with referral) vs TradesViz at ₹1,999–₹5,999/year.

Can I use FnoDiary for Zerodha equity and intraday trades too?

Yes. FnoDiary imports all trade types from the Zerodha tradebook — equity delivery, intraday (MIS/BO/CO), and F&O. Analytics and discipline scoring work across all trade types.

Start your Zerodha trading journal — free

Download your Zerodha tradebook CSV and import it to FnoDiary in under 2 minutes. Get discipline scoring, analytics, and psychology journaling instantly.

Get started free →

Sign up through a referral link and it's free forever.

Also supports: