#1
|
|||
|
|||
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: 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 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 would love to find a way that "always works" when I need to enter new funds. Any help? Thanks! |
#2
|
||||
|
||||
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
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |