Data Import & Export

How to Fix Missing Stock Symbols for Bajaj Housing Finance in Excel

Maira Mehtab Sep 21, 2026 868 views

Question details

The user is unable to find or insert new stock symbols for Bajaj Housing Finance Ltd using the Excel Stock data type.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to pull real-time financial market data for a newly listed company using Excel's built-in data types.
Observed behavior: The stock symbol for Bajaj Housing Finance Ltd is missing or unrecognized by the financial data provider, preventing data import.

Before you start

Ensure you have an active internet connection and are signed in to a Microsoft 365 subscription, as the Stocks data type requires both to fetch real-time financial market data.

Solution 1Recommended

Verify Search Terms and Excel Data Type Availability

Ensure you are using the correct ticker format and check if the data provider has updated its database for the newly listed stock.

Excel relies on a third-party financial data provider to populate its Stock data types. Newly listed companies like Bajaj Housing Finance Ltd might experience a delay before their ticker symbols become searchable.

Enter the exact company name or ticker

Type the full company name 'Bajaj Housing Finance Ltd' or its specific ticker symbol along with the exchange prefix (e.g., NSE:BAJAJHFL) into an empty cell.

Apply the Stock data type

Select the cell, go to the 'Data' tab on the Excel ribbon, and click on 'Stocks' within the Data Types group.

Use the Data Selector pane

If a question mark icon appears in the cell, click it to open the Data Selector pane on the right side of your screen. Use the search bar to manually look for the company name or alternative exchange listings.

Verify Excel version

Go to File > Account (or Excel > About Excel on Mac) to confirm you are using a supported Microsoft 365 version. Standalone versions like Office 2019 or 2021 do not support this feature.

Data Provider Delay: If the stock recently had its IPO, it may take a few weeks for the financial data provider to add the symbol to Excel's database. Consider using alternative web sources in the meantime.

Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet Needs

If you are experiencing issues with Excel features or delayed data providers, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that easily handles your financial datasets without expensive subscriptions.

1. Download historical stock data: Go to a reliable financial portal (such as Yahoo Finance or Google Finance) and download the historical data for Bajaj Housing Finance as a CSV file.
2. Import data into WPS Spreadsheets: Open WPS Spreadsheets, click on the 'Data' tab, and select 'Import Data' to load your downloaded CSV file.
3. Track your portfolio: Use WPS Office's built-in formulas, pivot tables, and charting tools to organize and analyze your stock portfolio performance.

Free to use with a familiar, easy-to-navigate interface.Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Lightweight software ensuring fast performance even on older devices.Robust data sorting, filtering, and formula capabilities for managing financial portfolios.

microsoft office alternative - wps office

Frequently Asked Questions

Why are newly listed stock symbols missing in Excel?

Excel pulls stock data from third-party providers. When a company recently goes public, there is often a delay of a few days or weeks before the provider updates their database and pushes the new ticker symbols to Excel.

Which versions of Excel support the Stock data type?

The Stocks data type is exclusively available to Microsoft 365 subscribers and users of Excel for the Web. It is not supported in perpetual, standalone versions like Office 2019 or Office 2021.

How can I manually refresh my stock data in Excel?

You can update your financial data by navigating to the Data tab and clicking 'Refresh All', or by right-clicking the specific cell containing the stock data and selecting 'Data Type' > 'Refresh'.

What should I do if the stock symbol never appears in Excel?

If the symbol remains unavailable after an extended period, you can submit feedback directly to Microsoft by navigating to Help > Feedback. Alternatively, you can use the 'From Web' data import feature to pull live pricing from a financial website.

Excel & Data Problems