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.
- Install Amigo Data extension in Google Sheets
- Choose the mutual fund and get the API URL
- 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.
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. Choose the mutual fund for which to retrieve the data
To get the API URL, go to mfapi.in
Search for the mutual fund of your interest, eg. ICICI Prudential US Bluechip Equity Fund – Direct Plan – Growth.
Click on the fund. The API URL for the selected fund will be found just below the search bar. Copy the URL.
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.
Select Custom API from the list of sources.
Paste the API endpoint URL in the API URL field.
Click the PREVIEW button. The preview of the data will appear in a short while.
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. 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.