'%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)
Fix Excel Stocks Data Type Not Updating BSE and NSE Listings
Question details
Users are unable to retrieve data for newly listed stocks on India's BSE and NSE exchanges using the Excel Stocks data type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to track and update newly listed Indian stocks (BSE/NSE) using Excel's built-in Stocks data type functionality.
- Observed behavior
- Older securities update correctly, but newly listed stocks are missing, or their data updates are significantly delayed and occasionally rolled back by the provider.
Ensure that you have a stable internet connection and an active Microsoft 365 subscription, as the Stocks data type requires cloud connectivity to fetch real-time financial data.
Update Microsoft 365 and Manually Refresh the Data
Installing the latest updates ensures Excel has the most recent fixes for data retrieval, while a manual refresh forces the app to ping the Refinitiv servers.
Microsoft occasionally releases patch updates that fix synchronization issues with the underlying Refinitiv database. Keeping your client updated is the first step to ensuring you can access newly added securities.
Open Excel, go to 'File' > 'Account', click on 'Update Options' under Product Information, and select 'Update Now'.
Navigate to the 'Data' tab on the top ribbon and click 'Refresh All' to force Excel to pull the latest available stock data.
Try typing the stock with the exact exchange prefix (e.g., XNSE:BAJAJHFL or XBOM:RBS) to ensure Excel queries the correct regional database.
Report Missing Symbols to Microsoft
If the issue persists after updating, the Refinitiv database provider may need to manually update their backend. Reporting it escalates the request.
Try WPS Office for Your Spreadsheet Needs
If Microsoft Excel's proprietary data types are causing delays due to server issues, consider using WPS Spreadsheet. It offers a lightweight, highly compatible alternative for organizing financial data, allowing you to seamlessly import external CSVs and stock data from other reliable sources without subscription fees.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Open Your Financial Spreadsheets: Launch WPS Spreadsheet and directly open your existing .xlsx files without worrying about formatting or compatibility issues.
- 3. Import Stock Data Manually: Go to the 'Data' tab and select 'Import Data' to securely pull in up-to-date CSV stock exports from your preferred financial websites.
Frequently Asked Questions
Why are older BSE and NSE stocks updating but not newly listed ones?
Older stocks are already cached and established in Excel's Refinitiv database. Newly listed stocks require a backend provider update, which can sometimes be delayed or temporarily rolled back due to synchronization errors.
How do I correctly format Indian stock tickers in Excel?
To ensure Excel searches the correct exchange, prefix your ticker with the exchange code. Use 'XBOM:' for the Bombay Stock Exchange (BSE) and 'XNSE:' for the National Stock Exchange (NSE).
Can I fix the provider-side Refinitiv data rollback myself?
No, a data rollback is a server-side issue between Microsoft and Refinitiv. You can only ensure your Excel application is fully updated and report the missing specific tickers via the Feedback tool to expedite their fix.
