'%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 Jio Financial Services (JIOFIN) Missing from Excel Stocks Data
Question details
The user is unable to find and retrieve data for the newly listed Jio Financial Services stock using the built-in Excel Stocks data type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to pull real-time market data for Jio Financial Services Limited (NSE symbol JIOFIN) into an Excel spreadsheet for portfolio tracking.
- Observed behavior
- Entering JIOFIN.XNSE returns no matching results in the Stocks data type, preventing the user from accessing automated financial metrics for this specific stock.
Ensure you have an active internet connection and are signed into a Microsoft 365 subscription, as the Stocks data type requires a premium account and live connectivity to function.
Submit Missing Stock Feedback to Microsoft
Report the missing stock symbol directly to Microsoft to accelerate its addition to their third-party market data provider's database.
Microsoft relies on external financial data providers to populate the Excel Stocks feature. New listings may experience a delay before synchronizing with Excel. Submitting detailed feedback alerts the development team to update the database.
Launch Microsoft Excel, open any workbook, and navigate to the 'Help' tab on the top ribbon.
Click on the 'Feedback' icon, then select 'I have a suggestion' or 'Report a problem' from the sidebar panel.
In the description box, specify that the stock is missing. Include the company name (Jio Financial Services Limited), the exchange symbol (JIOFIN), and the listing date (August 25, 2023).
Check the box to include a screenshot showing that 'JIOFIN.XNSE' yields no results, allow Microsoft to contact you for follow-up, and click 'Submit'.
Import Stock Data Manually via Web Query
Use the 'Get Data from Web' feature as a temporary workaround to pull live pricing from financial news websites until the stock is officially added.
Use WPS Office Spreadsheet for Flexible Financial Data Management
If you are experiencing persistent data import limitations or need a lightweight, cost-effective tool for your daily spreadsheet tasks, WPS Office offers a comprehensive and free alternative to Microsoft Office. With a familiar interface and excellent format compatibility, you can manage your portfolios with ease.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, follow the on-screen instructions, and launch WPS Spreadsheets.
- 3. Open Your Existing Portfolios: Directly open your existing Microsoft Excel financial trackers; no format conversion is required.
Frequently Asked Questions
Why are new stocks missing from Excel's Stocks data type?
Excel pulls its financial data from third-party market providers (such as Refinitiv). Newly listed companies, like Jio Financial Services, may experience a delay before being added to these external databases and successfully synchronized with Microsoft 365.
How long does it take for Microsoft to add a new stock symbol?
There is no guaranteed timeline. Updates depend on the synchronization schedules of Microsoft's external data partners. Submitting feedback through the Excel app can help flag the missing ticker to their engineering team.
Can I manually add a missing stock to the Excel Stocks data type?
No, the built-in Stocks data type relies on an automated, locked database. You cannot manually force a ticker into the official data type, but you can use the 'Get Data from Web' feature to import its pricing as a workaround.
Are international exchanges like NSE supported in Excel stock data?
Yes, Excel supports many international exchanges, including the National Stock Exchange of India (NSE). To locate specific regional stocks, you typically append the exchange suffix to the ticker, such as JIOFIN.XNSE.
