Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets

Update 30-Jul-2023

I am not sure if this was already there, but when I wrote this blog I couldn’t find this option. The below post becomes excessive in light of this new information.

Go to https://www.google.com/finance/ and start searching for the mutual fund. The search results in the dropdown and page shows the MUTF_IN code. And that’s it!

I have been searching for a long time on how to get the MUTF_IN code for Indian mutual funds. It has been a hit-and-miss for me trying to search on Google. Finally, I think, I figured out a sure shot way to get the MUTF_IN code.

Go to Morning Star India. Search for your mutual fund in the search box and go to the search result page.

Get the name of the mutual fund as it appears in the Morning Star page. For some reason Morning Star does not allow you to copy text from its site so you will have to type it. For those who are aware about Inspect Element I don’t think I need to say anything else.

Type this name in Google search and you should get MUTF_IN code. You can then use the MUTF_IN code in the GOOGLEFINANCE in Google Sheets.

Additional points to note

  1. This seems to work only for equity funds. Not debt or arbitrage funds (honestly, I don’t even know what an arbitrage fund is).
  2. If there is an hyphen (-) in the name of mutual fund as per Morning Star India, add space before and after it when searching it on Google.

Leave a Comment

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply