Data Import & Export

How to Find Stock Split and Dividend History in Excel

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to find stock split and dividend history data in Excel, as the built-in STOCKHISTORY function only provides historical market prices without adjusting for splits or dividends.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Tracking comprehensive financial data to calculate split-adjusted and dividend-adjusted stock prices.
Observed behavior: The STOCKHISTORY function returns historical market prices but entirely excludes stock split or dividend records, requiring external data sources or alternative calculation methods.

Before you start

Before proceeding, ensure you have a list of the stock tickers you want to analyze and an active internet connection to retrieve external financial data.

Solution 1Recommended

Import Stock Split and Dividend Data from External Sources

Since Excel's native functions lack this specific data, downloading historical CSV data from a reliable financial website like Yahoo Finance is the most straightforward approach.

Financial platforms typically provide comprehensive historical data that includes splits and dividends, which can be easily downloaded and imported into your spreadsheet.

Search for the Stock

Open your web browser, navigate to Yahoo Finance (or a similar financial data provider), and search for your desired stock ticker.

Access Historical Data

Click on the 'Historical Data' tab located under the stock's performance chart.

Filter for Splits and Dividends

Open the 'Show' dropdown filter and change it from 'Historical Prices' to 'Dividends Only' or 'Stock Splits', then click 'Apply'.

Download and Import to Excel

Click the 'Download' button to save a CSV file to your computer. Open Excel, go to 'File' > 'Open', and select the downloaded CSV file to view your data.

Solution 2

Use Financial Data Excel Add-ins

Install a third-party Excel add-in to pull expanded market history data, including dividends and splits, directly into your spreadsheets without manual downloading.

Solution 3

Manually Combine and Calculate Adjusted Prices

If you have the raw historical data, you can manually calculate the split-adjusted and dividend-adjusted prices using standard Excel formulas.

Free Microsoft Office alternative

Manage Your Financial Data Efficiently with WPS Office

While specialized functions like STOCKHISTORY are limited to specific software versions, WPS Spreadsheet provides robust CSV data import capabilities and powerful formula functions to track stock splits and dividends effortlessly. It is a free, lightweight, and highly compatible alternative to Microsoft Office.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Financial Data: Launch WPS Spreadsheet and open your downloaded CSV or Excel workbook containing stock data.
3. Calculate and Analyze: Use standard spreadsheet formulas to combine historical prices, splits, and dividend data seamlessly.

Fully compatible with Microsoft Excel (.xlsx) and CSV formatsSeamlessly import and manipulate data from financial websitesPowerful built-in formulas for manual price adjustmentsFree and lightweight with a familiar user interface

Frequently Asked Questions

Does Excel's STOCKHISTORY function include dividends?

No, the STOCKHISTORY function only retrieves historical market prices. It does not account for or display stock splits and dividend payments.

Where can I find free stock split data to import into Excel?

Financial websites like Yahoo Finance or Google Finance allow you to view and download historical stock split and dividend data as CSV files, which can be easily opened or imported into Excel.

Can I automate importing dividend history into my spreadsheet?

Yes, you can automate this process by using Excel's Power Query to fetch web data directly from financial sites, or by installing dedicated financial add-ins that offer custom formulas for dividend tracking.

Excel & Data Problems