Mac Numbers mutual fund info
I am the trying to get Canadian mutual fund information using the STOCK function as a formula. I can get stock info by using the stock name of XXX.TO if it is on the Toronto Stock Exchange (TSE or TSX). For example, Enbridge is ENB.TO for the Canadian stock and just ENB for the Amerrican stock. If I try to get get a Canadian Mutual fund (for Example TDB900) it will not work. I have tried the following combinations:
TDB900.TO
TDB900.TSE
TDB900.TSX
TO.TDB900
TSE.TDB900
CMF.TDB900 (Canadian Mutual Fund)
TDB900.CMF
CMF-TO.TDB900
TDB900.CMF-TO
I can go to the TSX and just type in TDB900 to get a fund details. Where does Numbers get it financial data from?
Any suggestions???
Has anybody tried it with Canadian ETFs?
MacBook Air 13″, macOS 10.15