Chandoo created this excellent Mutual Fund excel sheet that act as a simple Mutual Fund tracker. The USP of the excel sheet is that it fetches the MF NAVs from the website and uses that to track your funds. The problem with the excel sheet is that if you have subscribed to MF Systematic Investment Plan (SIP) then it is difficult to use the mutual fund excel sheet. So I modified the excel sheet to add your SIP investment tracking too. Here is the modified excel sheet. Here is a screenshot :
Here are the steps to use the excel sheet:
- Select the name of MF from the drop down list
- Enter the start date of MF SIP
- Enter the starting units (as of held today)
- Enter the amount per month
This will immediately give you the results for your portfolio. (Make sure to refresh the NAV sheet for latest NAVs).
You just need to open the excel sheet everyday. It will compare the today’s date with the MF SIP start date. If the date matches, it will automatically update the Units field (by using the today’s NAV and amount per month).
Thank you, Could you add end date for SIP and also new feature for STP and SWP. if possioble try to add for Dividend payout/reinvest as well.
ReplyDeleteThanks for visiting the blog. It might help if you put your name. i will keep your recommendations in mind. Thank you.
ReplyDeleteKM
Thank you.. but looks like the web refresh has some problems.... it goes to a page not found.... not sure how to fix this.... could you plz check
ReplyDeleteThanks Young@Market for visiting the blog.
ReplyDeleteThe problem is that the website from where it pulls data has changed the path.
Here is the fix:
1) Open the Latest Nav WorkSheet.
2) Go to the menu Data->Import External Data-> Edit Query
3) Change the website mentioned to the following http://amfiindia.com/spages/NAV0.txt
4) Press OK
This will fix it.
Hi,
ReplyDeleteThe Edit Query Option is not highlighted.
Tanks for the excel sheet , can u add how long investment is liyng in DAYS second if some one sold some of his mutual fund uints acoordg to FIFO whats is his gain or loss and same be refelected in STCG or LTCG col.acoording if investment holing is more or less than a year.
ReplyDeleteThanks LA... I will try to accommodate all the requests..it may take some time though.
ReplyDeleteHi
ReplyDeletehave downloaded ur excel but after editing the link getting error on porfotlio page Nav not found how to rectify it
Thanks Mihir for visiting the blog. can you try this fix?
ReplyDeleteHere is the fix:
1) Open the Latest Nav WorkSheet.
2) Go to the menu Data->Import External Data-> Edit Query
3) Change the website mentioned to the following http://amfiindia.com/spages/NAV0.txt
4) Press OK