Why Excel Stock Data Type Cannot Find the DWACW NASDAQ Warrant Symbol
Question details
The user wants to understand why the DWACW NASDAQ symbol cannot be found in Excel's Stocks data type.
- Product
- Microsoft Excel Stocks data type
- Device & OS
- not provided
- Scenario
- The user is searching for DWACW as a market symbol to import financial data into a spreadsheet.
- Observed behavior
- Excel does not recognize or return a Stocks data type match for DWACW.
Check that the symbol is entered as DWACW without extra spaces or exchange suffixes. Confirm the security's instrument type with a market reference source before assuming every traded symbol is supported by Excel's Stocks data type.
Use the underlying DWAC common-share symbol in Excel Stocks
Use this option when you need data for the underlying company and Excel does not provide data for the DWACW warrant.
DWACW is a warrant, not a common stock. Excel's Stocks data type may support the underlying DWAC share symbol while not listing the separate warrant instrument.
In an Excel worksheet cell, enter DWAC instead of DWACW.
Select the cell containing DWAC, then choose Data > Stocks on the Excel ribbon.
Select the converted cell and use the Insert Data button to add fields such as Price, Exchange, or Market cap when they are available.
Verify that DWACW is classified as a warrant
Use this option when you need to confirm whether the missing symbol is a stock, warrant, ETF, fund, or another instrument type.
Manage DWAC and Other Market Symbol Lists in WPS Spreadsheets
If you need a free, lightweight spreadsheet application for organizing market symbols and imported quote data, WPS Office provides a familiar spreadsheet interface and seamless migration from Microsoft Excel files. It does not change the availability of DWACW from an external market-data provider, but it can help you maintain, analyze, and share your symbol lists and data tables.
- 1. Open your spreadsheet in WPS Office: Launch WPS Spreadsheets and choose Open to select an existing .xlsx or .xls market-data workbook.
- 2. Organize symbols in a table: Enter symbols such as DWAC and DWACW in a column, then select the range and use Insert > Table to organize the list.
- 3. Analyze imported data: Use Data > Sort or Data > Filter to review securities, then use formulas or Insert > Chart to analyze the available quote data.
Frequently Asked Questions
Why does Excel recognize DWAC but not DWACW?
DWAC is the underlying common-share symbol, while DWACW is a warrant. Excel's Data > Stocks feature may support the common stock but not the separate warrant instrument.
Can I use Excel Stocks data type to retrieve a warrant price?
Only if that specific warrant is included in Excel's market-data coverage. If it does not appear after selecting the cell and choosing Data > Stocks, use a market-data source that supports warrant quotes.
How can I confirm whether a ticker is a warrant or a common stock?
Search the symbol in a market reference service such as the LSEG RIC Search tool and review its instrument classification, description, and exchange information.
Will entering DWACW:NASDAQ make Excel find the symbol?
Usually not. Adding an exchange suffix cannot make an unsupported instrument available. First verify the instrument type and then check whether Excel's Stocks data type covers it.
