Import Indian Mutual Funds Data To Google Sheets

Import Indian mutual funds data to Google Sheets
Reading Time: 4 minutes

If you are an investor looking for a mutual fund to invest in, one of the factors you may consider while choosing the fund is the net asset value (NAV), which is the market value of the securities held by the fund.

This article will guide you through how you can import India mutual funds data into Google Sheets–specifically, the NAV of any mutual fund: present as well historical data. You’ll then have a better understanding of the performance of the fund you’re looking to invest in. You’ll also learn how to automate the data retrieval process.

Importing mutual funds’ NAV data into Google Sheets is a pretty straightforward and quick process, and requires only two things: a tool and a URL–also called API endpoint; and three steps.

  1. Install Amigo Data extension in Google Sheets
  2. Choose the mutual fund and get the API URL
  3. Import the data using Amigo Data

How to import Indian mutual funds data to Google Sheets

1. Install Amigo Data extension in Google Sheets

Amigo Data is the tool we’re going to use to import India mutual funds data to Google Sheets. It’s a simple but versatile extension that we can use to retrieve data from various sources and import them into Google Sheets–quickly and, in most cases, easily.

You can get it from the Google Workspace Marketplace here.

Amigo Data in Google Workspace Marketplace

Alternatively, you can get it directly from Google Sheets.

Extensions→Add-ons→Get add-ons. Search for Amigo Data and install it.

Getting Amigo Data add-on from Google Sheets

Once the installation is complete, we can move on to the second step.

2. Choose the mutual fund for which to retrieve the data

To get the API URL, go to mfapi.in

Mutual Fund API homepage

Search for the mutual fund of your interest, eg. ICICI Prudential US Bluechip Equity Fund – Direct Plan – Growth.

Search for the fund to get the API URL

Click on the fund. The API URL for the selected fund will be found just below the search bar. Copy the URL.

The API URL for the selected fund

Copy the URL. This URL will be used to import Indian mutual funds data into Google Sheets.

We can now begin importing the mutual fund data to Google Sheets.

3. Import Indian mutual funds data to Google Sheets

Go back to Google Sheets and launch Amigo Data from the Extensions tab.

Connect to Amigo Data in Google Sheets

Select Custom API from the list of sources.

List of sources to connect to with Amigo Data

Paste the API endpoint URL in the API URL field.

Pasting the API URL in Amigo Data

Click the PREVIEW button. The preview of the data will appear in a short while.

Preview of the data to be imported

Flatten and expand the nested data points. Then click IMPORT.

Flatten and expand the data sets

The spreadsheet will be populated with the data of the mutual fund including the dates and other metadata.

Snippet of the imported data

You can likewise import the NAV historical data of any mutual fund. You can then compare the NAV for different funds, analyse the historical trends and visualise the data for easy comprehension.

You can use this endpoint to retrieve the list of all available mutual funds.

Once the data have been imported, you need not have to go through the process all over again. You can just set a refresh schedule so that the data are updated automatically periodically at the interval you set. Click this link to learn how to set a refresh schedule in Amigo Data and set up alerts to receive the latest data directly into your inbox or to Slack.

With Amigo Data, you can import several other kinds of data such as stock data, cryptocurrency prices, into Google Sheets and get real-time data anytime, anywhere. Data automation is cakewalk with Amigo. Leave the manual work to Amigo.

Some similar articles you may be interested in.

Import NSE Data to Google Sheets

Get Real-Time Stock Data In Google Sheets Using Marketstack API

Import Coinbase Data To Google Sheets