Under a minute a day
No terminal integration to install, no API keys to beg from the broker, no change to how your dealers trade. The desk already exports those files. This reads them.
- 01
Export
Your dealers finish the session. The terminal produces its trade file, exactly as it does today. Nothing changes on the desk, and nothing is installed where you trade.
- 02
Upload
Someone drops the file into the ingest screen and names the session date. Ten seconds. Both modern and pre-2007 Excel are accepted, because they tend to arrive on alternating days.
- 03
Price
The official settlement data for that day is pulled from the NSE and BSE archives, parsed at contract level, and every position takes its mark. A settled day is cached, because its file never changes again.
- 04
Read and bill
Every screen is live: P&L, positions, dealer performance, interest and the invoice. Filter it any way you need, and print any screen — the print layout is built in, with a header naming the book and the window.
Four attempts an evening, because the exchange does not publish at a predictable minute
A scheduled job re-fetches closing prices four times between 18:30 and 23:00, Monday to Friday. By morning the book is priced without anyone having waited up for it.
A day the exchange has not published is recorded as a gap rather than filled with a guess, and it resolves itself the moment the file appears.
Three things happen quietly that matter
Drop the day’s trade export in, name the session date, done. What the screen does not make a fuss about is what keeps the book honest.
The sheet is picked, not demanded
Hand-built workbooks with a tab per book and the terminal’s single-sheet daily export both work. The name is tried three ways and every fallback is recorded in the warnings, so you can see which sheet was actually read.
A re-upload supersedes; it never duplicates
Upload today’s file twice and you get today’s P&L once. The audit log records who replaced what.
The archived file is the file you uploaded
An .xls is stored and handed back as an .xls, openable in whatever produced it.
Two sources, and one of them is optional
NSE and BSE Required
The authoritative source for every closing price in the system. Contract-level settlement data taken directly from the exchange archives, parsed, and cached once the day is final. Settlement price, closing price and underlying price, per contract, per day.
Angel One SmartAPI Optional
Adds a live traded price during market hours. Honestly scoped: it is a live feed, not a source of truth. Its instrument list carries only contracts listed today, so expired series cannot be resolved at all, and what it returns is a traded close rather than a settlement price. What it supplies is stored as a placeholder a real settlement price may overwrite without asking. Leave it unconfigured and everything else is unaffected.
Your terminal, by its own exports No install
Not a network integration, and deliberately so. The desk exports the two files it already exports and uploads them. Both modern and pre-2007 Excel are accepted and converted in memory, because they tend to arrive on alternating days.
Curious whether it agrees with your book?
Send us one session’s export and we will show you the book it produces.