Zerodha Trading Journal: CSV Import Today, Kite API Sync in Testing
Import your Zerodha tradebook CSV into CernoQuant; Kite Connect API sync is in testing. NSE F&O, equity, currency, 50+ analytics, Atlas AI. Free to start.
Last updated
Before you import: see what Zerodha trading is costing you
Paste your tradebook: free, no sign-up, data stays in your browser.
Today
CSV import
In testing (not live)
API sync: OAuth 2.0 (Kite Connect)
Region
india
Segments
NSE Equity, BSE Equity +more
How to import Zerodha trades to CernoQuant today
- 1
Create CernoQuant account
Sign up free, no credit card required.
- 2
Export your Console tradebook
Console → Reports → Tradebook → choose the date range → download CSV.
- 3
Upload it in Smart Import
Drop the CSV into Smart Import. The Zerodha format is auto-detected.
In testing: direct Zerodha sync
Not available to users yet. Today, use the CSV import above. This is how the OAuth 2.0 (Kite Connect) connection is built to work once it is live:
- 1.Create a Kite Connect app (one-time): At developers.kite.trade, create a Personal app (free) to get an API key and secret.
- 2.Settings → Brokers → Zerodha: Enter the API key and secret, then authorise with your Zerodha login. Read-only: CernoQuant never places orders.
Two real ways to get Zerodha trades into a journal
Zerodha does not push your trades anywhere on its own, so every journal — CernoQuant included — gets them one of two ways: through the Kite Connect API, or through the tradebook file that Console exports. Both end in the same fills; they differ in effort and freshness.
The API route: Kite Connect is Zerodha's official developer API. You create an app once at developers.kite.trade — the Personal tier is free and covers exactly what a journal needs (your orders, trades, positions and holdings; no market data). The app gives you an API key and secret, which you paste into CernoQuant. CernoQuant's Kite Connect sync is in testing; once it is live, you authorise with your normal Zerodha login and trades sync without exports. One honest caveat from Zerodha's own documentation: the access token expires at 6 AM the next day as a regulatory requirement, so a connected tool re-authorises every trading day — this is a Zerodha-side rule, not a CernoQuant limitation.
The CSV route: Console (console.zerodha.com) → Reports → Tradebook lets you filter by segment and export up to one year of trades at a time as CSV or XLSX. CernoQuant's Smart Import recognises the Zerodha tradebook format by its headers and filename, so there is no column-mapping to do. If creating a developer app feels like overkill, this is the two-minute path — most traders backfill history with one CSV and then decide whether the daily-sync convenience is worth setting up the API.
Where your data lives in Zerodha (and what each report is for)
- •Tradebook (Console → Reports → Tradebook) — every executed fill with timestamp, price and quantity. This is the file a journal wants. Downloads cover up to one year per request.
- •P&L statement (Console → Reports → P&L) — realised profit by scrip with charges included. Good for tax work, wrong shape for journaling: it has no per-trade timestamps, so behaviour analysis is impossible from it.
- •Contract notes (emailed daily) — the legal record of each day's trades with exact charges. Useful to cross-check what a trade really cost; too fragmented to build a journal from.
- •Kite orders page — shows today's orders only. History lives in Console, not Kite.
What Zerodha actually charges (as of 30 Oct 2026)
Per zerodha.com/charges: equity delivery is ₹0 brokerage; equity intraday and futures are 0.03% or ₹20 per executed order, whichever is lower; options are a flat ₹20 per executed order. Selling delivery holdings also incurs a DP charge of ₹15.34 per scrip per day. On top of brokerage sit the statutory costs — STT, exchange transaction charges, SEBI fees, stamp duty and GST — which CernoQuant decomposes per trade so your P&L is net of everything, not just net of ₹20.
The Kite Connect API itself: the Personal plan is free; the ₹500/month Connect plan exists for apps that need live and historical market data, which journaling does not. (Both per Zerodha's support pages, re-verified 30 Oct 2026.)
Full breakdown: Zerodha Kite API charges — free Personal vs ₹500 Connect →
Zerodha-specific journaling pitfalls
- •The tradebook has no charges in it. It records fills, not costs. If your journal computes P&L from the tradebook alone, every profit is overstated — options round trips cost real money in STT and exchange fees. CernoQuant recalculates the full charge stack per trade instead of trusting the file.
- •Console P&L and your journal will disagree by design. Console nets by scrip and includes corporate-action adjustments; a journal pairs entries to exits per trade. Both are "right" — compare totals per expiry or per month, not per row.
- •F&O trading symbols encode everything. NIFTY25SEP24800CE carries instrument, expiry, strike and option type in one string. A generic CSV tool that fails to parse this loses the ability to compute Greeks or group by expiry — check that whatever imports your file actually splits it.
- •One year per tradebook download. Backfilling three years of history means three exports. Do it once; after that the API keeps you current.
- •The 6 AM token expiry is not optional. Any tool promising "connect once, never think about it again" on Kite Connect is overpromising — re-authorisation each trading day is how Zerodha built it.
What you get with Zerodha + CernoQuant
- Tradebook CSV import today; Kite Connect API sync (your own free Personal app) in testing
- NSE F&O Greeks at entry: Delta, Gamma, Theta, Vega
- Auto P&L: STT, NSE exchange fee, GST, SEBI fee, stamp duty
- Intraday vs positional vs overnight segmentation
- Atlas AI behavioural coaching on your Zerodha trade history
Charges & P&L Accuracy
Zerodha charges ₹20 flat per F&O order. CernoQuant auto-calculates STT, NSE exchange fee, GST, SEBI fee, and stamp duty — showing true net P&L after all costs.
Frequently asked questions about Zerodha + CernoQuant
Does CernoQuant sync with Zerodha automatically?
Not yet. Today you import your Zerodha trades by CSV upload. Direct Zerodha API sync is in testing and is not available to users yet.
Does CernoQuant support Zerodha Kite API sync?
Kite Connect API sync is in testing. It uses the official Kite Connect API: you create your own (free) Kite Connect Personal app, enter its API key and secret in CernoQuant, and authorise with your Zerodha login. Access is read-only; CernoQuant cannot place orders. Today, the Console tradebook CSV imports in a couple of clicks.
Does the Zerodha Kite access token expire every day?
Yes. Per the Kite Connect documentation, the access token expires at 6 AM the next day (a regulatory requirement), unless invalidated earlier by a logout. Any connected tool therefore re-authorises each trading day — CernoQuant prompts you rather than silently going stale.
Do I need the paid ₹500 Kite Connect plan to journal my trades?
No. Reading your order book and portfolio is covered by the free Personal plan. The ₹500/month Connect plan only adds live and historical market data, which a journal neither needs nor redistributes. (Verified against Zerodha support, October 2026.)
How do I download my Zerodha tradebook?
Log in to console.zerodha.com → Reports → Tradebook, pick the segment and a date range (up to one year per download), and export CSV or XLSX. Upload that file to CernoQuant's Smart Import — the Zerodha format is detected automatically.
Is Zerodha Console P&L the same as my real P&L?
Close, but Console reports realised P&L by scrip and does not attribute results to strategy, holding time or the behaviour behind the trade. Charges are included, but the question of which setups actually make money is left to you.
Can a connected journal place orders on my Zerodha account?
Not in CernoQuant's case. The integration reads orders, positions and holdings and can never place, modify or cancel an order. Revoke access any time from your Kite account.
Also supported
Start your Zerodha trading journal today
Free during beta, invite-based access. CSV import today; API sync in testing.
Import Zerodha trades freeCernoQuant is a trading journal and analytics platform only. Not a SEBI-registered investment advisor. All information is for educational purposes. Trading decisions are your sole responsibility. Past performance is not indicative of future results.