ICICI Direct Trading Journal: CSV Import & Full NSE Analytics (2026)
Turn your ICICI Direct trade book into a real trading journal. 2-minute CSV import, auto-mapped columns, charge decomposition, and 50+ analytics.
By CernoQuant Team
ICICI Direct is one of India's largest bank-backed brokers — and for many traders, the 3-in-1 account that came with their ICICI savings account is where they placed their first trade. But the platform's reports are built for investors, not active traders: you get a P&L statement, not an answer to whyyou keep giving back Tuesday's profits on Thursday. This guide shows how to turn your ICICI Direct trade history into a real trading journal in about two minutes.
Import ICICI Direct Trades into CernoQuant
ICICI Direct does not offer a public trading API, so the route is a CSV export — and CernoQuant's Smart Import recognises the ICICI Direct trade book format automatically, including its Script Name, Buy/Sell, and Trade Price columns.
- 1
Export from ICICI Direct
Log in → Portfolio → Trade Book → select your date range → Export CSV.
- 2
Open CernoQuant Smart Import
Settings → Import Trades → select ICICI Direct → upload the file.
- 3
Columns map automatically
Trade Date, Script Name, Buy/Sell, Qty, Trade Price, Exchange, and Segment are auto-detected — no manual mapping.
- 4
Analytics unlock
Your full NSE/BSE equity, F&O, and currency history appears with 50+ metrics computed.
What Your ICICI Direct History Reveals
- True cost per trade — ICICI Direct's ₹20 flat F&O or 0.275% intraday equity brokerage is only part of the bill. CernoQuant decomposes STT, exchange fees, GST, SEBI charges, and stamp duty per trade, so you see the real breakeven.
- Win rate by segment — Many 3-in-1 account holders trade equity delivery well but bleed in F&O. Segment-level stats make that split visible instead of hidden in one blended P&L.
- Time-of-day heatmap — See whether your edge lives in the opening hour or dies there.
- R-multiples and expectancy — The two numbers that tell you if your system makes money, independent of any single week's luck.
- Behavioral patterns — Atlas AI reads your sequence of trades and flags loss-chasing, size creep after wins, and overtrading days.
A Realistic Routine for CSV Brokers
Without an API, the discipline is a weekly export: every Friday after close (or Saturday morning), download the week's trade book and drop it into CernoQuant. Import takes under a minute and duplicates are detected automatically, so overlapping date ranges are safe. If you also trade on an API-connected broker like Zerodha or Dhan, connect both — CernoQuant merges accounts into one journal with cross-broker analytics.
Frequently Asked Questions
How do I import ICICI Direct trades into CernoQuant?
ICICI Direct → Portfolio → Trade Book → date range → Export CSV. Then CernoQuant → Import → ICICI Direct → upload. All columns are auto-mapped.
Does CernoQuant support ICICI Direct F&O trades?
Yes — equity, NSE F&O, and currency trades all import via CSV. Options trades get full charge decomposition and analytics.
Is there an ICICI Direct API connection?
ICICI Direct does not provide a public retail trading API, so CSV import is the reliable route. A weekly export keeps your journal current.
Import Your ICICI Direct Trades — Free
No credit card. Smart Import auto-detects the ICICI Direct format.
Start Importing Free →CernoQuant is a trading journal and analytics platform. Not a SEBI-registered investment advisor. All analytics are for educational purposes only. Trading decisions are your sole responsibility.
Start journaling your trades today
India's smartest AI trading journal. Auto-sync Zerodha, Dhan, Angel One, Fyers & Upstox. Free to start.
Create free account