How to get free excel download
![how to get free excel download how to get free excel download](https://www.ag5.com/wp-content/uploads/2019/01/Skills_matrix_groter_transparant-1000x546.png)
Once you learn how to do this, you can add more columns depending on what / how you want to track your MF portfolio.When you finish creating the table, it would look something like this:
![how to get free excel download how to get free excel download](https://getintopc.com/wp-content/uploads/2021/07/Professor-Excel-Tools-Free-Download-GetintoPC.com_.jpg)
We will use 3 simple excel features to achieve this – Power Query, Cascading Drop downs and vlookup() When you want to see updated value of your portfolio, simply refresh the tracker (Data > Refresh All or press CTRL+ALT+F5).The tracker will calculate your return, CAGR (Compounded annual growth rate of funds) and simple return of your portfolio and display it.On the My Funds page, specify the funds you own, units, purchase price and purchase date.This will fetch updated funds list and latest NAV (Net Asset Value) from AMFI India website.If prompted, enable “External connections”.If you are using older version of Excel, you need free Power Query add-in) Open the file in Excel (you need Excel 2016 / Office 365 to use this file.Download and save the file to a folder on your computer (do not leave it in the downloads folder).How to use this mutual fund tracker Excel workbook?
![how to get free excel download how to get free excel download](https://cdn.vertex42.com/ExcelTemplates/Images/checkbook-register-template.png)
NOTE: File updated on 7 July 2018 to fix errors. Would you like to spend next 5 minutes learning how to create an mutual fund tracker excel sheet? Make a live, updatable mutual fund portfolio tracker for Indian markets to keep track of your investments using this example.ĭownload the mutual fund tracker – India now.