Top_Banner

May 6, 2018

Daily updates for Net Assets Values (NAVs) of mutual fund schemes directly from AMFI website . .

Mutual Funds Portfolio using [=Importdata] function in Google Sheets


Download link :
AMFI_Auto-updated Mutual Funds Portfolio Spreadsheet | Google Sheet

 To get an automatic update for daily NAVs directly imported from AMFI data, follow the steps given in video tutorial. 
  • Google Sheet Functions 
=IMPORTDATA("https://www.amfiindia.com/spages/NAVAll.txt")


=SPLIT(A1,";",TRUE,FALSE)


=VLOOKUP(B2,amfi_import!D:J,3, FALSE)

  • Also, It can be combined in same worksheet as : 
      Posted by on
      Labels: , ,

      3 comments:

      1. Jay ShuklaDecember 1, 2018 at 9:50 PM

        Hi How to do same thing in Microsoft Excel?

        ReplyDelete
      2. RamheshDecember 28, 2021 at 6:11 AM

        This Google sheet is not working now noticed NA in latest_nav-amfi page after some time.
        Can you check this and let me know how to correct it.

        ReplyDelete
      3. RamheshJanuary 3, 2022 at 3:50 AM

        Noticed AMFI changed the NAV file name now it's https://www.amfiindia.com/spages/navall.txt

        ReplyDelete

      Subscribe to: Post Comments (Atom)