If you are doing financial analysis and wish to get mutual fund holdings in a Google Sheet, this article will help you do that without any coding.
Approach
Google sheets has a lot of convenience tools. 1 such tool is IMPORTHTML()
Using IMPORTHTML, you can parse a table in a given HTML and store it in GSheets.
We will fetch the data from https://www.moneycontrol.com
IMPORTHTML
ImportHTML function in GSheets takes 3 parameters
URL
The URL of the page from where the data has to be parsed
Element to be parsed
In this case we will use table as a value as we want to parse a table
Element # on the page
What number element of the given type do you want to parse
Getting data for Axis Blue Chip Fund
The money control link to get the portfolio for Axis Blue Chip Fund is https://www.moneycontrol.com/mutual-funds/axis-bluechip-fund-regular-plan/portfolio-holdings/MAA009. If you scroll down you will find the portfolio in the form of a table. We will be parsing this table and getting this data into a GSheet.
To get the data in a GSheet, we will open a new sheet. We will then use the following formula and paste it in cell A1.
=IMPORTHTML(“https://www.moneycontrol.com/mutual-funds/axis-bluechip-fund-regular-plan/portfolio-holdings/MAA009″,”table”,5)
Voila! GSheets does the heavy-lifting of parsing the portfolio data and showing it in the sheet.
