Fix Russell 2000 Index Missing from Excel Stocks Data
Question details
Users are unable to retrieve data for the Russell 2000 index using the built-in Stocks data type in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve market index data by searching for Russell 2000 ticker symbols.
- Observed behavior
- Excel returns no results when searching for standard Russell 2000 index symbols such as ^RUT, .RUT, or RTY.
Verify that your internet connection is stable and that you have an active Microsoft 365 subscription, as the Stocks data type requires a live connection to fetch data.
Contact Refinitiv Support for Symbol Mapping
Since Excel's financial data is supplied directly by Refinitiv, reaching out to their support can clarify if the index uses a different symbol or if it can be added.
Microsoft Excel relies on Refinitiv to supply fundamental company data, real-time prices, and historical market index information.
If standard symbols like ^RUT or RTY are not recognized, Refinitiv might be using a proprietary identifier for the Russell 2000 index or currently lacking the licensing to display it through Excel.
Navigate to the official Refinitiv customer support portal through your web browser.
Open a support ticket or use the live chat feature to inquire about the exact ticker symbol used for the Russell 2000 index in the Microsoft Excel integration.
If the representative confirms the index is missing, submit a formal request to have the Russell 2000 added to the Excel Stocks data feed.
Import Index Data from a Web Source
Use Excel's Get Data feature to manually import live Russell 2000 index data from a trusted financial website.
Try WPS Office for Powerful Data Management
If you are encountering limitations with Microsoft Excel's built-in data types or need a more cost-effective spreadsheet solution, WPS Office provides a robust, lightweight, and completely free alternative for handling large datasets and complex financial analysis.
Frequently Asked Questions
Where does Excel get its Stocks data?
Excel's Stocks data type pulls fundamental company information, historical metrics, and market pricing directly from Refinitiv, a global provider of financial market data.
Why do some standard stock ticker symbols not work in Excel?
Ticker symbols can vary between different data providers. If a standard symbol like ^RUT does not work, the data provider (Refinitiv) may map that specific index to a proprietary symbol or lack the distribution rights.
Can I manually add a missing stock or index to the Excel Stocks data type?
No, users cannot manually add custom symbols directly into the built-in Stocks data type database. You must either wait for the data provider to add it or use the 'Get Data from Web' feature as a workaround.
