Excel cannot find these Canadian Mutual Funds using the Stock datatype

spimcom · #1 05-28-2023, 04:16 PM

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:

Code:

[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!

Code:

[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.
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!

Pecoflyer · #2 05-28-2023, 11:34 PM

Cross posted at Excel cannot find these Canadian Mutual Funds using the Stock datatype
and
Excel cannot find these Canadian Mutual Funds using the Stock datatype | MrExcel Message Board

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you use the find and replace tool to find dates and times in Excel 2013?	Jules90	Excel	3	04-14-2020 07:40 PM
Help with CompareDocuments / datatype DOCUMENT	blbrand165	Word VBA	0	08-29-2017 08:42 AM
MS Excel Investing Formula for calculating stock return HELP pls	doug6388	Excel	0	09-05-2014 08:48 PM
Canadian multilingual English	Hassan Eltaher	Word	0	03-01-2014 04:23 PM
Stock levels	RobertH	Excel	5	01-24-2011 01:02 PM