Finding Old Stock Prices by Date: Sources, Adjustments, and Exports
Retrieving a company’s stock price for a particular calendar date means checking a date-stamped record of trade activity or official closing quotes. This topic covers where those records live, how providers report them, how corporate actions change the numbers, and practical steps to get a reliable value for a single date. It also covers how to export the data for spreadsheets or analysis and what common discrepancies to watch for when comparing sources.
Why date-specific historical prices are used
Date-specific prices are the core inputs for many tasks: reconciling past performance in reporting, reconstructing a portfolio’s value on a fiscal date, checking a quote cited in a news story, or testing a trading rule against a past market day. Journalists and researchers often need the exact closing figure on one date. Individual investors and analysts use the same figure to calculate returns, tax lots, or event-driven changes. In practice, people want the number and enough context to know whether it is raw trade data or a price adjusted for later events.
Where historical stock prices are stored
Primary records come from exchanges and market data feeds. Secondary copies exist at data vendors, regulator filings, public archives, and finance websites. Exchanges hold the official trade and quote tapes for each listed security. Regulators keep company filings that report key dates and corporate action details. Data vendors repackage exchange records, sometimes with added cleaning and adjustment routines. Public websites and academic datasets give convenient access but vary in depth and licensing.
| Source | Typical coverage | Common data provided |
|---|---|---|
| Exchange records | From listing date forward | Trades, quotes, daily open/high/low/close, volume |
| Regulatory filings | Company history and action dates | Splits, dividends, name or ticker changes |
| Commercial data vendors | Often decades; varies by vendor | Adjusted and raw prices, corporate action flags, APIs |
| Public finance websites | Varies; generally many years | Daily prices, charts, downloadable CSV |
| Academic and archive datasets | Selected historical ranges | Cleaned series for research, sometimes limited set of securities |
How to retrieve a price for a specific date
Start by identifying the correct ticker and the market calendar for the date. Use an exchange or trusted vendor query to pull the closing quote for that calendar day. Many public sites let you pick a date on a chart and show the closing price; data vendors provide programmatic access via an API and let you download a CSV. If the target date falls on a weekend or holiday, use the prior trading day’s close unless you need an interpolated value. When comparing providers, check whether they show the raw trade close or a version adjusted for later corporate actions.
How corporate actions change historical numbers
Corporate splits and cash dividends change per-share values, so many sources provide an adjusted figure to reflect those events. The adjusted close incorporates adjustments so a historical sequence of prices yields correct percentage returns over time. Providers differ in methodology: some adjust only for splits, some include dividends, and some adjust for spin-offs or rights issues. Always note whether the figure you use is raw or adjusted and consult company filings for the exact action dates and ratios where precision is needed.
Formatting and exporting price records for analysis
Export options typically include CSV and spreadsheet formats. A workable export contains a clear date column, the price column you need (open, close, or adjusted close), and a volume or flag column if available. Use a single, standard date format and confirm the time zone or market calendar that applies. Intraday records require timestamps and are larger in size. When preparing data for returns or backtests, align the series by market days and handle missing entries caused by suspensions or delistings.
Practical trade-offs and data constraints
Coverage and consistency are the main trade-offs. Free public sites are easy to access but may cut off historical depth or lack full corporate-action adjustments. Commercial vendors provide deeper archives and cleaner adjustment routines but charge for access and impose licensing restrictions. Different vendors may apply adjustments differently, producing divergent historical levels. Exchanges provide the most authoritative raw records, but they require filtering and interpretation. Time-stamp conventions and reporting delays cause small discrepancies between sources on the same date. Finally, historical datasets can omit securities that no longer trade, a gap known as survivorship bias, which matters for broad historical studies.
Where to find historical stock prices
How to export stock price data
Can I get adjusted historical prices
Choosing and verifying date-specific prices
When a single date matters, verify the number against at least two independent sources: the exchange record, a reputable vendor, or the company’s filings for corporate actions. Record the exact field used (raw close or adjusted close), the data source, the download timestamp, and any adjustment notes. For published work, include the source and the adjustment convention so others can reproduce the figure. For larger analysis, prefer vendor data or exchange tapes that include corporate action metadata, and document any cleaning steps applied to the series.
Finance Disclaimer: This article provides general educational information only and is not financial, tax, or investment advice. Financial decisions should be made with qualified professionals who understand individual financial circumstances.
This text was generated using a large language model, and select text has been reviewed and moderated for purposes such as readability.
