Nav History of Indian Mutual funds in google sheet.

[blkviper]

I am trying to find a forumla to fetch the Nav of a Mutual fund, If I enter the tricker in one column and dates in google sheets. I can fetch the histroy price of Stocks but the fourmula doesnot work for Mutual funds.

[Haluk]

=ArrayFormula(SPLIT(FILTER(IMPORTDATA("https://www.amfiindia.com/spages/NAVAll.txt"),isnumber(left(IMPORTDATA("https://www.amfiindia.com/spages/NAVAll.txt"),2)*1)=true,IMPORTDATA("https://www.amfiindia.com/spages/NAVAll.txt")<>""),";"))