Data Import & Export

How to Fix Missing Company in Excel Stocks Data Type

Ayan Masood Oct 10, 2026 869 views

Question details

The user needs to add or track a missing company (such as DBI.AX) that does not appear in Excel's built-in Stocks data type.

How to Add a Missing Company to Excel Stocks Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to retrieve automated financial data for specific companies using the Stocks feature in Excel.
Observed behavior: The company ticker is not recognized and cannot be linked because it is not included in Microsoft's market data provider database.

Before you start

Ensure you have an active Microsoft 365 subscription and a stable internet connection, as the Stocks data type relies entirely on online services to fetch market data.

Solution 1Recommended

Use a Financial Add-in or API

Since Excel does not allow direct manual additions to its built-in data provider, using a third-party financial API or add-in is the most reliable workaround.

Microsoft partners with specific third-party data providers. If a company is missing from their database, you must source the data from an external provider using an Excel Add-in or the WEBSERVICE function.

Install a Financial Add-in

Go to the 'Insert' tab on the Excel ribbon, click on 'Get Add-ins', and search for a stock market tool like 'Stock Connector'. Click 'Add' to install it.

Search for Your Company

Open the newly installed add-in from the ribbon, search for your missing company's ticker (e.g., DBI.AX), and configure it to push live data to your selected cell.

Use the WEBSERVICE Formula

Alternatively, if you have a URL for a free financial API, type =WEBSERVICE("API_URL_HERE") into a cell to pull live stock data directly from the web into your spreadsheet.

API Usage: Using a financial API may require registering for a free API key on the provider's website and basic knowledge of JSON or XML parsing in Excel.

Solution 2

Verify the Ticker Symbol and Exchange Code

Ensure you are using the precise ticker symbol and exchange prefix required by Microsoft's data provider to correctly identify the stock.

Free Microsoft Office alternative

Switch to WPS Office for Versatile Financial Spreadsheets

If you are frustrated by Microsoft Excel's built-in data limitations or expensive subscription costs, consider switching to WPS Office. It provides a lightweight, entirely free spreadsheet tool with high compatibility and a familiar interface for managing all your financial documents seamlessly.

1. Download and Install: Visit the official WPS Office website and download the free installation package tailored for your operating system.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel financial tracking files without losing any formatting or formulas.
3. Manage Financial Data: Utilize built-in advanced formulas, pivot tables, and comprehensive charting tools to track stocks and analyze your portfolio effortlessly.

100% compatible with Microsoft Excel (.xlsx, .csv) formatsCompletely free alternative to costly Microsoft 365 subscriptionsLightweight design ensures smooth performance even with large financial datasetsFamiliar user interface with absolutely no learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Stocks say no results found for my company?

Excel relies on a specific third-party market data provider. If the company is newly listed, trades on an unsupported local exchange, or simply isn't indexed by the provider, Excel will return a 'no results found' error.

Can I manually add a new company to the Stocks data type database?

No, Microsoft Excel does not provide any direct way to manually add missing companies or update the built-in Stocks selector database yourself.

Are there alternative ways to track live stock prices in Excel?

Yes, you can use the Power Query feature (Get Data > From Web) to pull data from public financial websites, install third-party Excel add-ins from the Microsoft Store, or use the WEBSERVICE function paired with external APIs.

Excel & Data Problems