Skip to content
English - United States
  • There are no suggestions because the search field is empty.

Why Is Mutual Fund Data Not Appearing in Excel?

If you are trying to retrieve mutual fund data and are receiving and ERR: INVALID COMPANY error within your spreadsheet, this is most likely due to the ticker symbol not being entered correctly. You will want to add a M: prior to the ticker symbol, for example M:FXAIX.

You can quickly add the M: to a list of mutual funds by using the formula below, assuming that A1 is the ticker symbol:

=IF(AND(LEN(A1)=5,RIGHT(A1,1)="X"),"M:"&A1,A1)