Find Canadian Mutual Funds When Excel Stock Data Types Do Not Recognize Them
Question details
The user needs to know why Excel's Stock data type may not recognize certain Canadian mutual funds and ETFs, and what information to try when a ticker search fails.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is researching Canadian mutual funds and ETFs in Excel and wants to use the Stock data type for financial information.
- Observed behavior
- Excel's Stock data type returns no match for certain Canadian mutual fund or ETF tickers, even when the funds exist.
Before starting, collect the exact ticker, exchange or market identifier, full legal fund name, and any alternate security names. Keep a supported financial-data source URL or CSV export ready for funds that are not covered by Excel's data provider.
Try exact ticker, exchange suffix, and full fund name in Excel
Use this first when a Canadian mutual fund or ETF ticker does not resolve; adding the exchange or alternate name often improves recognition.
Excel's Stock data type depends on Microsoft's financial data provider. It covers many exchange-traded securities but not every Canadian mutual fund or ETF, so a failed ticker search does not mean the fund does not exist.
Select an empty cell, type the exact ticker such as XIC or VGRO, and press Enter.
With the cell selected, go to the Data tab and click Stocks. If Excel does not convert it, the ticker was not recognized as-is.
Edit the cell to include identifiers like TSE:XIC, TSX:XIC, the full legal fund name, or an alternate security name, then click Data > Stocks again.
If none of the identifiers resolve, the instrument is not included in Microsoft's current financial data provider; use a supported source or import the data separately.

Import Canadian mutual fund data from a supported financial source into WPS Office
Use this fallback when the security is not covered by Excel's Stock data type and you still need the fund data in a spreadsheet.
Import Canadian Mutual Fund Data Without Excel Stock Data Limits in WPS Office
Excel's Stock data type is limited by Microsoft's financial data provider and does not cover every Canadian mutual fund or ETF. WPS Office is a free, lightweight Excel alternative that opens .xlsx workbooks, supports CSV and web data imports, and offers a familiar ribbon UI for a seamless move.
- 1. Download and install WPS Office: Get WPS Office from the official WPS website, run the installer, and open WPS Spreadsheets.
- 2. Open your existing Excel workbook: In WPS Spreadsheets, click Menu > Open and choose the .xlsx workbook that contains your Canadian mutual fund watchlist.
- 3. Import fund data from a CSV or web source: Click Data > Import External Data > From Text/CSV and select the fund data file downloaded from the provider, or use a web import tool if available.
- 4. Organize and refresh the imported data: Confirm the import mapping, click OK, then adjust table columns and refresh the connection when the provider updates data.

Frequently Asked Questions
Why doesn't Excel recognize my Canadian mutual fund ticker in the Stock data type?
Excel's Stock data type is linked to Microsoft's financial data provider, which does not include every Canadian mutual fund or ETF. If the provider lacks the instrument, the ticker will not resolve even if the fund is valid.
What should I enter when a Canadian fund ticker search fails?
Try the exact ticker plus the exchange or market identifier, such as TSE:XIC or TSX:XIC, then the full legal fund name and any alternate security names. In Excel, select the cell and click Data > Stocks after each attempt.
Does WPS Office have the same Excel Stock data type?
WPS Office does not rely on Excel's linked Stock data type provider. It can open Excel workbooks and import Canadian mutual fund data from CSV or supported external sources, but it does not provide the same built-in Stocks data type coverage.
How can I get Canadian mutual fund data into WPS Spreadsheets?
Download a CSV or Excel file from the fund provider or a supported financial-data source, open WPS Spreadsheets, and click Data > Import External Data > From Text/CSV to import it.
Are Canadian ETFs affected by missing Excel Stock data type coverage too?
Yes. Some Canadian ETFs may not be in Microsoft's data provider. Use the same troubleshooting steps, including exchange suffix, full name, and alternate identifiers, or import the ETF data from a supported source.




