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.
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.
- Install Amigo Data extension in Google Sheets
- Choose the mutual fund and get the API URL
- 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.
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.
Search for the mutual fund of your interest, eg. ICICI Prudential US Bluechip Equity Fund – Direct Plan – Growth, and select the fund.
The API URL for the selected mutual fund will be found just below the search bar.
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.
Select Custom API from the list of sources.
Paste the mutual fund API endpoint URL in the API URL field.
Click the PREVIEW button to retrieve the mutual fund NAV to import to Google Sheets.
Flatten and expand the nested data points. Then click IMPORT.
The spreadsheet will be populated with the data of the mutual fund including the dates and other metadata.
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