'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Newly Listed BSE and NSE Stocks Missing in Excel
Question details
The user is unable to retrieve financial data for recently listed Indian shares using the built-in Stocks data type in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking newly listed stocks on the Bombay Stock Exchange (BSE) and National Stock Exchange (NSE) using Excel's financial data tracking tools.
- Observed behavior
- Newly listed BSE and NSE stock symbols return an error or are unrecognized by the Excel Stocks data type because the underlying Bing data provider has not yet updated its database.
Ensure you have a stable internet connection and an active Microsoft 365 subscription, as the Stocks data type requires online connectivity to fetch real-time financial data.
Refresh Data Connections and Verify Exchange Prefixes
Force Excel to pull the latest available financial data and ensure your stock ticker symbols use the correct formatting for Indian exchanges.
Excel relies on external data providers like Bing to power the Stocks data type. While existing stock data refreshes daily, newly listed IPOs may take additional time to be indexed.
You cannot force a stock into the system if the backend provider hasn't added it, but you can ensure your sheet is properly configured to catch the update as soon as it goes live.
Highlight the cells in your spreadsheet that contain the newly listed stock symbols you want to track.
Prefix your ticker symbols with the specific exchange code to ensure accuracy. Use 'XNSE:' for the National Stock Exchange (e.g., XNSE:BAJAJHFL) and 'XBOM:' for the Bombay Stock Exchange.
Navigate to the 'Data' tab on the top Excel ribbon. In the Queries & Connections group, click on 'Refresh' or 'Refresh All'.
If the correct symbol still fails to load after a few weeks post-listing, use Excel's 'Help' > 'Feedback' feature to report the missing securities directly to Microsoft.
Try WPS Office for Seamless Financial Data Management
While you wait for Microsoft's backend providers to update newly listed stock data, consider using WPS Office for your financial tracking. WPS Office provides a lightweight, highly compatible, and cost-free environment for building powerful financial models and managing extensive data exports.
Frequently Asked Questions
How long does it take for newly listed IPO stocks to appear in Excel?
The update frequency depends entirely on Excel's backend data provider (Bing). It can take anywhere from a few days to a couple of weeks after the official IPO listing for newly listed BSE and NSE stocks to be fully indexed in the Stocks data type.
Can I manually add a missing stock symbol to the Excel Stocks data type?
No. Because the Stocks data type relies on an external, live-updating database provided by Bing, users cannot manually inject unrecognized stock symbols into the connected data type feature. You must wait for the backend to update.
Why is my Indian stock symbol pulling data from the wrong global exchange?
This happens when the ticker symbol is shared with a company on an international exchange. To resolve this, always prefix Indian stocks with 'XNSE:' for the National Stock Exchange or 'XBOM:' for the Bombay Stock Exchange before converting them into the Stocks data type.
