Fix Missing ARKB or IBIT in Excel Stock Data Type
Question details
The user needs Excel Stock Data Types to recognize the ARKB and IBIT cryptocurrency ETF ticker symbols.

- Product
- Microsoft Excel Stock Data Types
- Device & OS
- not provided
- Scenario
- The user is converting ticker cells to the linked Stocks data type or searching for a security in Excel.
- Observed behavior
- Excel's Stock Data Type selector does not find ARKB, IBIT, or the corresponding cryptocurrency ETF names.
Confirm the ticker and full fund name from the ETF issuer or exchange before searching. Excel Stock Data Types use Microsoft's market-data provider, so coverage and recognition of recently launched securities can vary.
Verify the ETF identity and refresh Excel Stock Data Types
Use this first when ARKB or IBIT is not returned by the Stocks data-type selector.
The Stocks data type can only return securities currently supported by Microsoft's data provider. A correct ticker may still be unavailable until the provider adds or updates its coverage.
Verify that ARKB is ARK 21Shares Bitcoin ETF and IBIT is iShares Bitcoin Trust ETF. In Excel, enter the confirmed ticker or full security name in a separate cell.
Select the ticker cell, then choose Data > Data Types > Stocks. If Excel shows a data selector, search using the full fund name as well as the ticker.
Select the linked Stock Data Type cell, then choose Data > Refresh All. You can also right-click the cell and select Data Type > Refresh when that option is available.
In Excel, go to File > Account > Update Options > Update Now, then restart Excel and try Data > Data Types > Stocks again.

Import ARKB or IBIT prices from a reliable market-data source
Use this option when you need the ETF data now and Excel's linked Stocks data type still does not support the symbol.
Import Cryptocurrency ETF Data in WPS Spreadsheets
If Microsoft Excel Stock Data Types do not cover ARKB or IBIT, use WPS Spreadsheets to import a CSV export from a trusted market-data source. WPS Office is free, lightweight, and familiar for Excel users, with strong compatibility for opening, editing, and sharing Excel workbooks during a seamless migration.
- 1. Open the market-data file: Launch WPS Spreadsheets and select Menu > Open to open an XLSX workbook or a CSV file containing ARKB or IBIT data.
- 2. Import a CSV file: Select Data > Text to Columns or use the CSV import prompt to set the delimiter and place the ticker, date, price, and volume fields in columns.
- 3. Analyze the ETF data: Select the imported range and use Insert > Chart to create a price chart, or use Data > Sort and Filter to review the records.

Frequently Asked Questions
Why does Excel recognize some stock tickers but not ARKB or IBIT?
Excel Stock Data Types rely on Microsoft's third-party market-data coverage. A ticker can be valid on its exchange but unavailable in the linked data provider's current security list.
Can I manually add ARKB or IBIT to Excel's Stocks data type?
No. Excel does not provide a way to manually create a linked Stocks data type record. You can instead import the ETF's market data from a CSV or another supported source.
Should I search by ticker or by the full ETF name in Excel?
Try both. Enter ARKB or IBIT first, then use the full names ARK 21Shares Bitcoin ETF and iShares Bitcoin Trust in the Data > Data Types > Stocks selector.
How do I refresh stock data in Excel?
Select Data > Refresh All to refresh available linked data and imported queries. For a linked data-type cell, you may also be able to right-click it and choose Data Type > Refresh.
Will updating Excel make ARKB and IBIT appear in Stocks data types?
Updating Excel can ensure you have current data-type functionality, but it cannot guarantee that a symbol is supported. Availability ultimately depends on Microsoft's market-data provider.




