naveegator.in

Category: Google Sheets

Get historical share price for NSE listed companies using Google Sheets
AlphaVantage was my go to API to get the historical share price for NSE listed companies. But some time in Jun’2020, they removed the NSE data. The API works for US companies but does not give data for NSE listed companies. It was probably the simplest (and cheapest), in my opinion, API available.

I looked around for other alternatives, but they were simply too expensive for me. The best free alternative I could find was – Google Sheets.

Open Google Sheets and in the cell A1 enter the GOOGLEFINANCE formula as below. Replace the <SYMBOL> with NSE symbol, for e.g. NSE:HDFCBANK.
```
=GOOGLEFINANCE("<SYMBOL>", "price", DATE(2001,1,1), today(), "DAILY")
```
You can then save this file as CSV using the menu “File > Download > Comma-separated values”. There are a attributes like high, low, volume etc. that can be fetched. This is not the best solution, but hey it works. And its free!
October 10, 2020
Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets
Update 30-Jul-2023

I am not sure if this was already there, but when I wrote this blog I couldn’t find this option. The below post becomes excessive in light of this new information.

Go to https://www.google.com/finance/ and start searching for the mutual fund. The search results in the dropdown and page shows the MUTF_IN code. And that’s it!

I have been searching for a long time on how to get the MUTF_IN code for Indian mutual funds. It has been a hit-and-miss for me trying to search on Google. Finally, I think, I figured out a sure shot way to get the MUTF_IN code.

Go to Morning Star India. Search for your mutual fund in the search box and go to the search result page.

Get the name of the mutual fund as it appears in the Morning Star page. For some reason Morning Star does not allow you to copy text from its site so you will have to type it. For those who are aware about Inspect Element I don’t think I need to say anything else.

Type this name in Google search and you should get MUTF_IN code. You can then use the MUTF_IN code in the GOOGLEFINANCE in Google Sheets.

Additional points to note
1. This seems to work only for equity funds. Not debt or arbitrage funds (honestly, I don’t even know what an arbitrage fund is).
2. If there is an hyphen (-) in the name of mutual fund as per Morning Star India, add space before and after it when searching it on Google.
August 12, 2020

Category: Google Sheets

Get historical share price for NSE listed companies using Google Sheets

Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets

Update 30-Jul-2023

Additional points to note