Data Import & Export

How to Fix Missing Indian Stock ABDL in Excel Stocks Data

Elise WilliamsElise Williams Nov 11, 2026 870 views

Question details

The user is unable to retrieve financial data for Allied Blenders and Distillers Ltd. using the Excel Stocks data type with NSE ticker ABDL or BSE code 544203.

How to Fix Missing Indian Stock ABDL in Excel Stocks Data
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to use the built-in Stocks data type in Excel to automatically fetch and track market data for a specific Indian stock listing.
Observed behavior
The Excel Stocks feature returns no results or fails to recognize the NSE ticker ABDL and BSE code 544203.
Before you start

Ensure you have an active internet connection and a Microsoft 365 subscription, as the built-in Stocks data type requires these to query real-time financial data servers.

Solution 1Recommended

Search Using the Full Company Name

Data providers may sometimes register the full company name before the specific regional tickers are fully indexed.

Excel relies on a third-party financial data provider. Newly listed securities like Allied Blenders and Distillers Ltd. might not immediately map to their NSE or BSE tickers in the backend database.

1
Enter the full name

Select the cell containing the ticker (ABDL) and replace it by typing 'Allied Blenders and Distillers Ltd'.

2
Apply Stocks data type

Go to the 'Data' tab on the ribbon and click on 'Stocks' in the Data Types group.

3
Use the Data Selector

If a question mark icon appears, click it to open the Data Selector pane. Browse the results for the correct Indian exchange identifier and click 'Select'.

Data Provider Limitations: If the stock still does not appear, it means Microsoft's data provider has not yet added this newly listed security to their database.
Free Microsoft Office alternative

Manage Your Financial Data Seamlessly with WPS Office

If you are tired of troubleshooting missing features and data types in Microsoft Excel, try WPS Office. It is a completely free, highly compatible alternative that makes managing large financial spreadsheets and external data imports effortless.

  1. 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing .xlsx financial tracking files without formatting loss.
  3. 3. Import Financial Data: Use the 'Data' tab to smoothly import downloaded CSV stock data or external text files into your workbook.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Easily import external market data and CSV files for stock analysisFree and lightweight office suite with fast startup timesFamiliar tabbed user interface requiring zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why do some newly listed Indian stocks not show up in Excel?

Excel's Stocks data type relies on third-party financial data providers. When a company is newly listed on an exchange (like an IPO), it can take weeks or months for the external provider to verify and add the new ticker to the database that Microsoft queries.

Does Excel support both NSE and BSE exchanges?

Yes, Microsoft's data provider supports major global exchanges including the National Stock Exchange of India (NSE) and Bombay Stock Exchange (BSE). However, coverage of every single small-cap or newly listed stock is not guaranteed.

How can I manually import Indian stock data if the feature fails?

You can download your portfolio's historical data or current market quotes as a CSV file from your broker's portal or financial websites. Then, use the 'Data' > 'From Text/CSV' import feature to load that data directly into your spreadsheet.