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 as historical data using a free mutual fund API. 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 automatically pull NAV of mutual funds to Google Sheets.

Mutual fund NAV in Google Sheets
Snippet of mutual fund NAV in Google Sheets

Getting the NAV of mutual funds in Google Sheets is a pretty straightforward and quick process, and requires only two things: a tool and a mutual fund API URL; and three steps.

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

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 Indian 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 by following the link below.

Amigo installation link

Install Amigo to import Indian mutual funds data to Google Sheets

Alternatively, you can get it directly from Google Sheets.

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

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

2. Get the mutual fund API endpoint URL

To get the mutual fund API URL, go to mfapi.in. This is a free mutual fund API that provides the NAV data for hundreds of Indian mutual funds.

Mutual Fund API homepage

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

Search for the fund to get the mutual fund API URL

The API URL for the selected mutual fund will be found just below the search bar.

The API URL for the selected fund

Copy the API 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 to import the mutual fund data to Google Sheets.

Launch Amigo to import mutual funds data to Google Sheets

Select Custom API from the list of sources.

List of sources to connect to with Amigo Data

Paste the mutual fund API endpoint URL in the API URL field.

Pasting the mutula fund API URL in Amigo Data

Click the PREVIEW button to retrieve the mutual fund NAV to import to Google Sheets.

Preview of the data to be imported

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

Flatten the mutual fund data to import to Google Sheets

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 using the mutual fund API. You can then compare the NAV for different funds, analyse the historical trends and visualise the data using Google Sheets for easy comprehension.

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

Automatically retrieve mutual funds NAV data

Once the mutual fund API 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, and cryptocurrency prices, into Google Sheets and get real-time data anytime, anywhere. Data automation is a 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

Leave a Reply