How to Fix Missing Indian Stock ABDL in Excel Stocks Data
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.

- 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.
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.
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.
Select the cell containing the ticker (ABDL) and replace it by typing 'Allied Blenders and Distillers Ltd'.
Go to the 'Data' tab on the ribbon and click on 'Stocks' in the Data Types group.
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'.
Fetch Stock Data Using Power Query (From Web)
Use Power Query to extract stock data from an external financial website when the built-in Stocks data type fails.
Update Office and Report the Missing Ticker
Force an Office update to fetch the latest background feature catalogs and notify Microsoft Support of the missing asset.
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. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing .xlsx financial tracking files without formatting loss.
- 3. Import Financial Data: Use the 'Data' tab to smoothly import downloaded CSV stock data or external text files into your workbook.

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.




