title: How to track Indian Mutual Funds using Google Sheets and update the price automatically
body: <p>Looking to manage the mutual fund portfolio, and automatically update the price so the portfolio always shows the correct information.</p>
  
  <p>I have tried to use Google sheet functions like </p>
  
  <pre><code>INDEX
  SPLIT
  VLOOKUP
  IMPORTDATA
  </code></pre>
  
  <hr>
  
  <pre><code>=IMPORTDATA("https://www.amfiindia.com/spages/NAVAll.txt")
  =INDEX(SPLIT(VLOOKUP(A2&amp;amp;"*",NAV!$A$1:$A$20501,1,false),";"),,5)
  </code></pre>
  
  <p>The outcome of this is to create a portfolio with an automated price update.</p>