Excel cannot find these Canadian Mutual Funds using the Stock datatype

[spimcom]

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:

[CIG2359]   CI Alternative Diversified Opportunities Fund A
[FID231]    Fidelity Canadian Large Cap Fund Series B - FE
[MFC4768]   Mackenzie Unconstrained Fixed Income Fund SC - FE
[RBF270]    RBC Bond Fund Series A - NL

But with these, it didn't work!

[CIG11112]  CI Canadian Dividend Fund Class A
[MFC4732]   Mackenzie US Dividend Fund Series A - FE
[MMF4529]   Manulife Dividend Income Fund Advisor Ser - E3 FE
[SUN104]    Sun Life MFS International Value Fund A - FE
[TDB2581]   TD Tactical Monthly Income Fund Adv-ISC

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.
• Trying to Google "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!

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Excel cannot find these Canadian Mutual Funds using the Stock datatype
Excel cannot find these Canadian Mutual Funds using the Stock datatype
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.