Historical Stock Split Adjuster

What is Stock Split Adjustment?

Stock split adjustment is the process of recalculating historical share quantities and prices to account for stock splits that occurred after the original transactions. When a company executes a stock split, the number of outstanding shares changes while the total market value remains the same. For accurate portfolio analysis and performance tracking, historical data must be adjusted to reflect these corporate actions.

For example, if you bought 100 shares of a company at $400 per share, and the company later executed a 4-for-1 stock split, your position would become 400 shares at $100 per share. The total value remains $40,000, but the share count and price per share have changed. Without proper adjustment, comparing historical prices to current prices would be misleading.

How to Use This Historical Stock Split Adjuster

1. Add Your Transactions: Enter your historical stock trades manually or import them from a CSV or JSON file. Each transaction needs a date, symbol, type (buy/sell), quantity, and price.
2. Define Stock Splits: Add the stock splits that occurred for the symbols in your portfolio. You can enter them manually or import from a CSV file. Common split ratios like 2:1, 4:1, and reverse splits are supported.
3. Set the As-Of Date: Choose the date up to which splits should be applied. Only splits occurring between the transaction date and the as-of date will affect the adjustment.
4. Review Adjusted Data: The tool automatically calculates split-adjusted quantities and prices. Transactions affected by splits are highlighted in the results table.
5. Export Results: Download your split-adjusted transaction history as CSV or JSON for use in spreadsheets, portfolio trackers, or tax software.

Understanding Stock Split Ratios

Stock splits are expressed as ratios that indicate how many new shares you receive for each old share:

• Forward Splits (e.g., 4:1): You receive 4 new shares for every 1 old share. The price per share is divided by 4. A 100-share position at $400 becomes 400 shares at $100.
• 2-for-1 Split (2:1): The most common type. Shares double, price halves.
• Reverse Splits (e.g., 1:10): You receive 1 new share for every 10 old shares. The price per share is multiplied by 10. Often used by companies to meet exchange listing requirements.

Why Split-Adjusted Data Matters

Using split-adjusted historical data is essential for several reasons:

• Accurate Cost Basis: For tax reporting, you need to know your actual cost basis per share after accounting for all splits.
• Performance Analysis: Comparing historical returns requires consistent data. Unadjusted prices would show false drops on split dates.
• Technical Analysis: Chart patterns and indicators only make sense with split-adjusted prices.
• Portfolio Tracking: Accurate share counts are needed to calculate current position values and weights.
• Dividend Calculations: Per-share dividend amounts must be adjusted for splits to calculate accurate yield history.

CSV File Format

When importing data, use these CSV formats for best results:

Transactions CSV

Date,Symbol,Type,Quantity,Price
2020-01-15,AAPL,BUY,100,75.50
2020-06-20,TSLA,BUY,50,200.00
2021-03-10,AAPL,SELL,25,125.00

Stock Splits CSV

Symbol,Date,Ratio
AAPL,2020-08-31,4:1
TSLA,2020-08-31,5:1
TSLA,2022-08-25,3:1

Notable Stock Splits in Recent History

Several major companies have executed significant stock splits in recent years:

• Apple (AAPL): 4-for-1 split on August 31, 2020
• Tesla (TSLA): 5-for-1 split on August 31, 2020, and 3-for-1 split on August 25, 2022
• Amazon (AMZN): 20-for-1 split on June 6, 2022
• Alphabet (GOOGL): 20-for-1 split on July 18, 2022
• NVIDIA (NVDA): 4-for-1 split on July 20, 2021, and 10-for-1 split on June 10, 2024

Frequently Asked Questions

How do I handle multiple splits for the same stock?

Simply add each split separately with its respective date. The tool automatically applies all applicable splits in chronological order. For example, if you held Tesla shares before both the 5-for-1 (2020) and 3-for-1 (2022) splits, both adjustments will be applied, resulting in a cumulative 15x increase in share count.

What about fractional shares from splits?

This tool calculates exact fractional shares. In practice, brokers may handle fractional shares differently—some pay cash in lieu of fractional shares, while others support fractional share ownership. Check with your broker for their specific policy.

Does this tool account for spin-offs or stock dividends?

This tool is specifically designed for stock splits. Spin-offs and stock dividends involve different calculations and cost basis allocations. For those corporate actions, consult your broker statements or a tax professional.

Is my data secure?

Yes. All calculations are performed entirely in your browser using JavaScript. Your transaction data and split information are never sent to any server. The tool works completely offline once the page is loaded.

Can I use this for tax reporting?

This tool helps you calculate split-adjusted cost basis, which is useful for tax reporting. However, always verify calculations with your broker statements and consult a tax professional for official tax filings. Different jurisdictions may have specific rules about cost basis calculations.