'%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 Ola Electric Mobility (OLAELEC) Missing in Excel Stock Data
Question details
The user is unable to find or load financial data for Ola Electric Mobility Ltd. (OLAELEC:NSI) using the Stock data type lookup feature in Microsoft Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve automated financial metrics and stock prices for Ola Electric Mobility within a spreadsheet.
- Observed behavior
- The stock ticker OLAELEC:NSI is not recognized, and the Stock data type feature fails to populate the requested company information.
Ensure your internet connection is stable and verify that you are using the correct ticker format (e.g., XNSE:OLAELEC) before determining that the stock is completely unavailable.
Request Data Addition from Refinitiv Support
Excel's stock metrics are supplied by a third-party data provider (Refinitiv/LSEG). To resolve missing stocks, you must submit a request to the provider directly.
Microsoft Excel does not maintain its own internal stock database. Instead, it relies on Refinitiv (now part of the London Stock Exchange Group - LSEG) to supply all financial metrics for the Stocks data type.
If a specific newly listed security like Ola Electric Mobility (OLAELEC:NSI) is missing, it means the data provider has not yet indexed it or mapped it to Microsoft's service. Microsoft cannot manually add this stock for you.
Double-check that you are using the correct exchange prefix and ticker symbol in your Excel cell. Sometimes trying alternate formats like XNSE:OLAELEC can resolve lookup errors.
Open your web browser and visit the official Refinitiv or LSEG customer support website.
Open a support ticket or fill out their data feedback form, explicitly requesting the addition of Ola Electric Mobility Ltd. (OLAELEC:NSI) to the financial data feeds utilized by Microsoft Office.
Try WPS Office for Your Spreadsheet Needs
If you are frustrated by third-party data limitations or high subscription costs in Microsoft Office, consider WPS Office. It is a lightweight, powerful, and free alternative that handles complex spreadsheets effortlessly.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and seamlessly open your existing .xlsx financial tracking files.
- 3. Import Financial Data: Use the 'Import Data' tools to connect to external web sources and track your custom stock portfolios.
Frequently Asked Questions
Why doesn't Excel recognize certain newly listed stock tickers?
Excel relies on Refinitiv for stock data. If a newly listed company like Ola Electric Mobility is not yet updated in Refinitiv's database, Excel's Stock data type will not be able to recognize or retrieve it.
Can I manually add a custom stock to Excel's Stocks data type?
No, you cannot directly add custom stocks to the built-in Stocks data type. You must wait for the data provider to update their feeds or use external web data queries to import the pricing yourself.
How do I import stock prices if the Stocks data type fails?
You can navigate to the Data tab, select 'From Web', and enter the URL of a financial site. This allows you to select and import pricing tables from the webpage directly into your spreadsheet.
