Excel cannot find these Canadian Mutual Funds using the Stock datatype

The Stock data type in Excel is amazing, however, it's often a hit and miss when trying to use it with Canadian mutual funds or ETFs.

These were recognized just by entering their symbol name:

Please Login or Register  to view this content.

But with these, it didn't work!

Please Login or Register  to view this content.

I tried:

• Entering the ticker
• Entering the fund name
• Finding similar funds that Excel detects and changing them to match the new fund. This has been somewhat successful, but far from perfect.
• Entering multiple names found when Googling the ticker.
• Googling "Refinitiv" that seems to be the provider for Excel's stock data...

I would love to find a way that "always works" when I need to enter new funds.

Any help?

Thanks!

See if this helps you

https://www.youtube.com/watch?v=Je0IO5W2Iqk

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.msofficeforums.com/excel...ual-funds.html and https://www.mrexcel.com/board/thread...atype.1238079/)