Retrieving a Historical Stock Price for a Specific Date
Retrieving a historical equity price for a particular trading day means locating the official quoted price that applied to a stock at a defined timestamp. This write-up explains why people pull past prices, what the numbers represent, where to look, and how to verify what you download. It covers exchange feeds, regulatory filings, commercial data vendors, broker portals, API and CSV methods, corporate-action adjustments, and documentation practices for tax or audit use.
Why you might need a past quoted price
People check older prices for valuation checks, tax reporting, backtesting, or compliance records. An accountant preparing a capital gains report needs the price on the trade date. An analyst testing a model will compare entry and exit prices. A compliance officer may need an exact quote to document a corporate filing. Each use has different tolerance for errors and different needs for provenance, so the source you pick matters.
What a historical quote contains
A typical historical record lists the trading day’s open, high, low, and close and the trade volume. The closing amount is often the figure cited for valuation. Data providers may give both an unadjusted closing price and an adjusted closing price that accounts for corporate actions. Adjusted figures change past prices so they reflect splits and some distributions when comparing returns over time.
| Field | What it means | When to use it |
|---|---|---|
| Raw close (unadjusted) | The last trade price reported at market close on that date | Legal records, exact trade reconciliation |
| Adjusted close | Close price modified to reflect splits and some payouts | Performance comparisons and return calculations |
| Volume | Number of shares traded during that session | Liquidity checks and anomaly spotting |
Primary and secondary sources to consider
Primary sources carry the strongest provenance. Exchange feeds publish official trade and quote records. Regulatory filings can include price references for corporate events. Commercial archives aggregate exchange data and add search tools. Secondary sources are convenient for quick lookups: brokerage account history, mainstream finance websites, and CSV downloads from API providers. Secondary sources often repackage primary feed data and may apply their own adjustments.
Step-by-step retrieval methods by source
From an exchange or regulator, request an official historical file or query their archive. Exchanges typically offer end-of-day files and certified reports but may require a subscription. For vendor archives, search by ticker and date in the provider’s portal. Vendors often offer both web access and downloadable CSV files for single dates or ranges.
APIs let you script repeated queries. A typical API call asks for symbol, date, and the field you want, and returns JSON or CSV. Check the API’s date conventions and whether it returns adjusted values. For CSV exports from brokers or data portals, locate the account activity or historical prices section, set the date, and download. Keep the original file name and metadata when saving.
How corporate actions affect historical numbers
Corporate actions change the effective price history. When a company splits shares, earlier prices are divided so charts and returns match current share counts. Cash dividends sometimes trigger an adjusted price for return calculations. Mergers and spin-offs can remove or reassign historical entries. If you rely on adjusted prices, understand the provider’s method so you can explain how a past price was transformed.
Documenting sources for tax and compliance
Good documentation includes the exact symbol, exchange, timestamp, dataset name, and the provider’s statement of whether prices are adjusted. Save the original download and a screenshot showing the query parameters. Note the timezone and the dataset version or file date. For formal filings, cite the exchange identifier or the vendor report and include a checksum or file hash when possible. These steps make it easier for a reviewer to reproduce the same quote later.
Practical constraints and trade-offs
Access often depends on subscription level and how far back you need data. Exchanges and high-quality vendors may charge for certified historical feeds. Free sources may have shallow archives or patchy coverage for smaller listings. APIs impose rate limits that affect large downloads. Timezone differences change which day a trade maps to when markets overlap, so clarify whether a date is local exchange time or your reporting timezone. Adjusted prices simplify return math but hide the raw traded numbers, which matters for reconciliation. Finally, accessibility matters; some sources require institutional access or manual requests for archived files.
Verification and cross-checking strategies
Start by comparing at least two independent sources for the target date. Match symbol, exchange, and timezone first. If numbers differ, check whether one source returned an adjusted figure. Spot-check volume and adjacent days to detect off-by-one date errors around holidays. For audit-grade work, prefer an exchange record or a vendor certified for compliance. Keep notes on any discrepancies and how you resolved them so reviewers can follow your reasoning.
How to access historical stock price API
Which data provider offers deep archives
Can brokerages export historical CSV data
Retrieving a past stock price is a mix of choosing the right source and documenting the steps you took. For quick checks, broker portals and mainstream websites often suffice. For valuation, tax, or compliance, prefer exchange files or certified vendor exports and keep a clear record of whether values were adjusted. Always confirm the timezone and dataset version when you cite a past price.
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.