Data Import & Export

Fix Missing ARKB or IBIT in Excel Stock Data Type

Ayan MasoodAyan Masood Nov 12, 2026 868 views

Question details

The user needs Excel Stock Data Types to recognize the ARKB and IBIT cryptocurrency ETF ticker symbols.

Fix Missing ARKB or IBIT in Excel Stock Data Type
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.
Before you start

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.

Solution 1Recommended

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.

1
Confirm the ticker and fund name

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.

2
Convert the cell to the Stocks data type

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.

3
Refresh linked data

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.

4
Install Office updates

In Excel, go to File > Account > Update Options > Update Now, then restart Excel and try Data > Data Types > Stocks again.

Verify the ETF identity and refresh Excel Stock Data Types
Provider coverage may be delayed: If neither the ticker nor the full ETF name appears after refreshing, the security is not currently available through the Microsoft-linked data source. Excel cannot manually add an unsupported Stock Data Type record.
Free Microsoft Office alternative

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. 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. 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. 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.
Import ARKB and IBIT price data from CSV files into WPS Spreadsheets.Open, edit, and save Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface for tables, formulas, sorting, and charts.Keep market-data workbooks lightweight and easy to share.
microsoft office alternative - wps office

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.