Function Problems

Why Excel Stocks Does Not Show Dividend or Yield Data

WPS Editor Oct 10, 2026 868 views

Question details

Users are unable to view dividend or yield details when using the built-in Stocks data type for financial tracking.

Why Excel Stocks Does Not Show Dividend or Yield Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pulling financial market data and stock metrics into a spreadsheet for investment tracking.
Observed behavior: The Excel Stocks data type successfully retrieves prices and general market information but fails to display dividend or yield details for many or all companies.

Before you start

Verify that the specific company you are researching actually pays dividends, as many growth-focused stocks do not offer dividend payouts regardless of the data provider.

Solution 1Recommended

Manually Look Up and Enter Dividend Data

Since Excel's default data sources may omit yield fields, manually fetching the data from dedicated financial platforms is the most reliable workaround.

Excel retrieves stock information from third-party financial data sources. Because not all companies pay dividends and data source agreements vary, dividend and yield metrics are frequently omitted or unsupported in the default Stocks data type.

Check a dedicated financial website

Open a web browser and navigate to a trusted financial data provider, such as Yahoo Finance, Bloomberg, or Google Finance.

Search for your stock

Enter the stock ticker symbol in the platform's search bar to pull up the company's financial summary.

Locate the dividend yield

Find the 'Forward Dividend & Yield' or 'Trailing Annual Dividend Yield' metric on the stock's profile page.

Update your spreadsheet

Create a new column in your Excel workbook next to your Stocks data and manually enter the yield information.

Manually Look Up and Enter Dividend Data

Data Accuracy: Keep in mind that manually entered dividend yields will not automatically update as the stock price fluctuates. You will need to refresh this data periodically.

Solution 2

Use a Third-Party Financial Data Add-in

Install an Excel add-in specifically designed for investment tracking to access comprehensive metrics, including dividends.

Free Microsoft Office alternative

Manage Your Financial Spreadsheets with WPS Office

While Microsoft Excel's connected data types have specific limitations regarding dividend data, WPS Office provides a fast, highly compatible alternative for building custom financial trackers, analyzing market data, and managing complex spreadsheets without a premium subscription.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Open your tracker: Launch WPS Spreadsheets and open your existing .xlsx financial tracking file.
3. Analyze your data: Continue using familiar formulas, charts, and custom columns to track your stock portfolio's performance.

Fully compatible with Microsoft Excel (.xlsx) formats and formulasLightweight and fast for managing large financial datasetsFamiliar user interface ensuring seamless migration and zero learning curveCompletely free to use for everyday spreadsheet and data analysis tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can I automatically update my manual dividend entries in Excel?

Without using a specialized add-in or writing a custom VBA script (or Power Query) to scrape web data, manually entered dividend yields cannot be automatically updated in standard Excel.

Why do some stocks show 'N/A' for certain data fields in Excel?

The 'N/A' error appears when Excel's third-party data provider does not have the specific metric for that particular company, or if the company simply does not report that metric (such as a company that pays zero dividends).

Is the STOCKHISTORY function related to the Stocks data type?

Yes, STOCKHISTORY is a dynamic array function in Microsoft 365 that retrieves historical price and volume data. However, like the Stocks data type, it does not provide historical dividend payout records.

Excel & Data Problems