Track Live Mutual Fund Rates in Google Sheets | Build Your Own MF Dashboard (Easy Guide)

📊 Learn how to track real-time mutual fund prices in Google Sheets! In this tutorial, I’ll show you a simple and effective way to build your own live Mutual Fund Dashboard, especially useful if you're managing multiple Demat accounts like I do for my family. 💡 What you'll learn: How to fetch live NAVs using AMFI's website Use of IMPORTDATA, ARRAYFORMULA, and QUERY in Google Sheets Automatically track current NAV, last update date, buy price, and profit/loss Manage mutual funds across different accounts (mom, dad, brother… everyone!) 🔧 Formulas Used in Video =IMPORTDATA("www.amfiindia.com/spages/NAVAll.txt") =ARRAYFORMULA(IF(A2:A="", "", SPLIT(A2:A, ";"))) =IFERROR(QUERY(ALLMF!F:H, "SELECT H,G WHERE F = '" & A3 & "'", 0), "") 📣 Why You Should Watch: Most investors can easily track stocks, but struggle to monitor mutual funds across multiple platforms. This dashboard helps you consolidate and automate your MF portfolio tracking. 🙋‍♂️ Got questions or want help building your dashboard? Drop a comment below – I reply to everyone! ✅ Subscribe for more finance and automation tips: [🔔 Your Channel Link] 👍 Like | 💬 Comment | 🔁 Share 🔖 Chapters (Add these as timestamps) 0:00 Introduction 0:30 Why You Need a Dashboard 1:10 Getting Live Data from AMFI 2:00 Writing Google Sheets Formulas 3:00 Building the Dashboard 4:20 Tracking Profit & Loss 5:00 Final Thoughts & Download Link' #MutualFunds #GoogleSheets #InvestSmart #PersonalFinance #FinanceTips #LiveNAV #MFPortfolio #StockMarketIndia #MoneyManagement #AMFIIndia #PortfolioTracker