Upstox Trading Journal: CSV Import Today, API Sync in Testing
Link Upstox to CernoQuant via its free API (OAuth); trades are only read. NSE equity and F&O analytics, 50+ metrics, Atlas AI. Free to start.
Last updated
Before you import: see what Upstox 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: Upstox API (OAuth 2.0)
Region
india
Segments
NSE Equity, BSE Equity +more
How to import Upstox trades to CernoQuant today
- 1
Create CernoQuant account
Sign up free.
- 2
Download an Upstox trade report
Download a trade report from the Reports section for your date range.
- 3
Upload it in Smart Import
Drop the file into Smart Import. CernoQuant's column mapper walks you through the format.
In testing: direct Upstox sync
Not available to users yet. Today, use the CSV import above. This is how the Upstox API (OAuth 2.0) connection is built to work once it is live:
- 1.Create an Upstox app (one-time, free): account.upstox.com/developer/apps → new app → copy the API key and secret.
- 2.Settings → Brokers → Upstox: Enter the key and secret, then authorise with your Upstox login. Read-only: CernoQuant never places orders.
Connecting Upstox by API (in testing): what the setup involves
Upstox's API is free and well documented, but — like Zerodha and unlike Dhan — it is app-based: before anything syncs, you create an app of your own at account.upstox.com/developer/apps. Upstox's authentication docs are explicit that the app yields the API key (client_id) and API secret (client_secret); those two values are what you paste into CernoQuant. After that, connecting is a normal OAuth authorisation with your Upstox login, and the access CernoQuant receives is read-only: trade history in, nothing out.
Token reality, from Upstox's own developer documentation and community answers: the OAuth access token expires at 3:30 AM IST the next day no matter when it was generated. So daily sync means daily re-authorisation — the same regulatory pattern as Zerodha's 6 AM expiry. Upstox is unusual in also documenting an Analytics token: a read-only credential valid up to a year, built precisely for tools that analyse an account rather than trade it. For journaling, that is the better fit where available.
The file route: CernoQuant has no dedicated Upstox CSV parser (Zerodha, Angel One and Dhan have one; Upstox does not yet). Upstox report files still import — the Smart Import column mapper matches headers deterministically and asks you to confirm — it is simply a one-extra-step import rather than a fully automatic one. If you only need a backfill before switching on the API sync, that one mapping pass is all it takes.
Upstox access tokens explained — daily expiry & the 1-year Analytics token →
What is the Upstox Analytics Token?
Alongside the daily OAuth token, Upstox documents an Analytics Token: a long-lived, read-only credential valid for up to one year, issued for tools that analyse an account rather than trade it. It cannot place orders at all — which is exactly the permission shape a journal should want — and because it survives the 3:30 AM daily cycle, a connection built on it does not ask you to re-authorise every morning. If you connect Upstox to any analytics tool, this token is the right kind to reach for where the integration supports it.
Where your data lives in Upstox
- •Reports (upstox.com profile menu, and in the app) — P&L and Tax P&L by financial year, downloadable as a spreadsheet. The Tax P&L covers delivery, intraday, F&O and currency/commodity in one file.
- •Trade report — the per-fill view a journal wants; prefer it over the per-scrip Tax P&L for imports.
- •Developer console (account.upstox.com/developer/apps) — where your API app, key and secret live; also where you revoke access.
What Upstox actually charges (as of 30 Oct 2026)
Per upstox.com/brokerage-charges: equity delivery is ₹20 per executed order; equity intraday is ₹20 or 0.1% whichever is lower; equity futures ₹20 or 0.05% whichever is lower; options a flat ₹20 per executed order. Statutory charges apply on top, and CernoQuant decomposes them per trade.
API orders: the charges page lists a discounted ₹10 per API order, while noting a promotional validity date that has already passed (it still read "valid till 31 Dec 2025" when checked on 30 Oct 2026), so treat the current rate as subject to change and confirm with Upstox if you trade through the API. None of this touches journaling: reading your trade history costs nothing.
Full breakdown: Upstox API charges — the per-order fee explained →
Upstox-specific journaling pitfalls
- •Tax P&L is the wrong file for a journal. It aggregates realised P&L by scrip for a financial year — no timestamps, no per-trade rows. Import the trade-level report; keep the Tax P&L for your accountant.
- •The 3:30 AM token cut-off catches early birds. A token generated at 2:30 AM dies at 3:30 AM the same morning. If a sync mysteriously fails pre-market, re-authorise first.
- •v2 vs v3 confusion. Upstox has two API generations. CernoQuant uses the documented /v2 login and trade endpoints; if you follow a third-party tutorial to build your own tools, check which version it assumes.
- •No dedicated CSV parser means headers matter. Export the standard report from Upstox without editing columns in Excel first; renamed headers defeat the automatic mapping and turn a one-confirm import into manual work.
What you get with Upstox + CernoQuant
- CSV import today; Upstox API sync (your own free app) in testing; CernoQuant never places orders
- NSE/BSE equity and F&O with Greeks at entry
- R-Multiple, expectancy, drawdown, Sharpe ratio
- Auto charge calculation: STT, exchange fees, GST
- Tilt detection from Upstox trade history
Charges & P&L Accuracy
Upstox charges ₹20 flat per F&O options order. CernoQuant auto-calculates STT, NSE/BSE exchange charges, GST, and stamp duty per trade.
Frequently asked questions about Upstox + CernoQuant
Does CernoQuant sync with Upstox automatically?
Not yet. Today you import your Upstox trades by CSV upload. Direct Upstox API sync is in testing and is not available to users yet.
Does CernoQuant support the Upstox API?
Upstox API sync is in testing; CSV import works today. For the API, you create a (free) app in the Upstox developer console once, enter its API key and secret in CernoQuant, and authorise with your Upstox login. Read-only access to trade history; no order placement.
How do I create an Upstox API app?
At account.upstox.com/developer/apps — Upstox's own documentation calls it "create an app on Upstox Developer Apps". The app gives you the API key (client_id) and API secret (client_secret) a connected tool needs. It is free and takes a few minutes.
When does the Upstox API access token expire?
The OAuth access token expires at 3:30 AM IST the following day, regardless of when it was issued — a token generated at 8 PM Tuesday dies at 3:30 AM Wednesday. Upstox also documents a long-lived read-only Analytics token (up to one year), which suits analytics tools because it survives the daily cycle.
Is the Upstox API free?
API access carries no monthly subscription. The one charge Upstox lists is a discounted per-order fee on orders placed through the API (shown as ₹10/order on its charges page). A journal only reads existing trades — it never places orders, so that fee never applies to journaling.
How do I download Upstox trade history?
On upstox.com, the profile menu → Reports section holds P&L and tax reports by financial year, downloadable as a spreadsheet; the app offers the same reports. For journaling, prefer the trade-level report over the Tax P&L (which aggregates by scrip) and upload it to CernoQuant's Smart Import.
Can I track NSE F&O options from Upstox in CernoQuant?
Yes. Every options trade gets Black-Scholes Greeks at entry, P&L attribution by Greek, and STT charge breakdown.
Also supported
Start your Upstox trading journal today
Free during beta, invite-based access. CSV import today; API sync in testing.
Import Upstox 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.