Guides to NSE historical data
Downloading the file is the easy part. These notes cover the parts of this dataset that reliably cost people time, written against the exact columns the export produces.
- Provenance6 min read
Verify this data against NSE yourself
Don't take our word for it. NSE publishes a free end-of-day file for every trading day. Here is how to download it and reconcile it against your export, row by row.
- Data reference8 min read
Every column in your NSE export, explained
What OPEN, HIGH, LOW, PREV. CLOSE, LTP, CLOSE, VWAP, VOLUME, VALUE, NO OF TRADES, DELIVERY QTY and DELIVERY % actually mean in an NSE historical data file, and where people misread them.
- Data reference6 min read
NSE series codes: EQ, BE, BZ, SM and ST
Why your export sometimes has two rows for the same date, what each NSE series code means for how a stock trades, and which rows you probably want to keep.
- Analysis7 min read
Delivery percentage: how to read it, and its limits
How NSE delivery quantity and delivery percentage are calculated, what high and low readings suggest about participation, and the cases where the number misleads.
- How-to9 min read
Working with your NSE export in Excel or Google Sheets
Ready-to-paste formulas for daily returns, moving averages, volatility and drawdown, written against the exact column layout this tool produces.
- Caveats8 min read
Corporate actions: why old prices look wrong
Splits, bonus issues and dividends leave visible cliffs in raw NSE price history. Why this data is unadjusted, how to spot an artificial gap, and how to adjust it yourself.
- Caveats5 min read
What this data covers, and what it doesn't
An honest scope note: end-of-day only, unadjusted, equity segment, subject to NSE's own availability. Read this before relying on the output for anything that matters.
- Analysis8 min read
Reading an NSE price chart: gaps, circuits and price bands
Why a stock sits at the same price for days, what a flat line at the top of a range means, and how price bands and market-wide halts shape the chart you are looking at.
- How-to9 min read
Comparing a stock against a Nifty benchmark
Align two exports on date, then compute relative performance, correlation and beta, with the alignment mistakes that silently produce wrong numbers.
- How-to10 min read
Building a portfolio tracker from several exports
Combine downloads for multiple stocks into one dated price matrix, then track portfolio value, weights and contribution, including how to handle stocks that did not trade on the same days.
- Caveats7 min read
Trading holidays, settlement and missing dates
Why your export has gaps, why row counts differ between two stocks over the same range, and why the newest rows are missing delivery figures.
Ready to pull a file? Open the download console.