BSE·histdataOpen console

ABOUT

About this site

Who builds BSE Historical Data, why it exists, and exactly how it turns a BSE scrip and a date range into a spreadsheet.

Why this exists

Getting a clean run of historical prices for a BSE-listed stock is more annoying than it should be. The exchange publishes the data, but pulling a multi-year range means repeated queries, short date windows, and a lot of copying between a browser and a spreadsheet. BSE also identifies securities by six-digit scrip code rather than by ticker, so before you can query anything you often have to go and look up a number. Paid data vendors solve all this, at a price that makes no sense if you just want to look at one stock for a college project or check a hunch.

This site removes that friction. Type a symbol, a scrip code, or a company name, pick two dates, get one Excel file. No account, no export limit, no charge.

How it actually works

There is no database here and no stored copy of the market. Every download is fetched live, on demand:

  1. Your input is resolved to a scrip code. A list of active BSE equity scrips ships with the page, so what you type is matched against symbols, codes, and company names right in your browser — which is why suggestions appear instantly and why 500325and “RELIANCE” both work. BSE’s API only speaks scrip codes, so that is what actually gets sent.
  2. The date range is requested from BSE. Long ranges go out as large windows rather than many small ones. If BSE times out on a window — which it does on very long histories — the range is split in half and each half retried, recursively, until the pieces are small enough to come back.
  3. Short ranges have a fallback.If the historical endpoint returns nothing for a range of a month or less, the tool reassembles those days from BSE’s daily bhavcopy and delivery files instead, including the older zipped formats for historical dates.
  4. A workbook is built and handed straight to your browser. Rows are sorted by date, dates are written as real spreadsheet dates rather than text so sorting and charting work immediately, the header row is frozen, and filters are switched on. The file is generated in memory.

What it deliberately does not do

  • No corporate-action adjustment. Prices come through exactly as reported, so a stock split shows up as a cliff. Adjusting silently would hide information; the guide on corporate actions explains how to handle it yourself.
  • No intraday or tick data. End-of-day only.
  • No predictions, signals, or recommendations. This is a data pipe, not an advisory service. See the disclaimer.
  • No accounts and no data collection beyond the basics. Detailed in the privacy policy.

The guides

Exporting the data is the easy half. Knowing what WAP means, why a scrip sits in group T and what that does to its price action, or why a price halved overnight is the half that actually costs people time. The guides section documents the parts of this dataset that reliably confuse people, written against the exact column layout this tool produces.

Who builds it

BSE Historical Data is built and maintained by Dhruv Bhartiya, a developer working on trading and market-data tooling. It began as a personal script for pulling price history and grew into a public tool once it became clear other people wanted the same thing. Related tools from the same author cover NSE-listed stocks, NSE indices, and international equities — all linked from the download console.

More about the author’s work is at dhruvbhartiya.com.

Feedback and corrections

If a scrip will not resolve, a figure looks wrong, or a guide contains an error, please say so — reports like that are how the tool improves. Reach me at dhruvbhartiya2420@gmail.com or via the contact page.