![]() For more information see fuzzy text search using excel. I have used fuzzyText UDF (user defined formula) so that we can search against this list even when you have a spelling mistake in the fund name.The data is delimited using as a separator, I have used some formulas (mainly FIND, MID and LEFT formulas) to split the text in to fund name and latest NAV.The list of funds along with their latest NAVs is published everyday at AMFI (The Association of Mutual Funds in India) at ![]() ![]() We use Excel Web Queries (a powerful external data feature in excel) to get latest Mutual Fund NAVs for all the MFs in India.How the Mutual Fund Portfolio Tracker Works? Today we are going to release an upgrade for that file.ĭownload the mutual fund portfolio tracker excel workbook now. A while back we have posted a file on tracking mutual funds using excel. Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the latest NAVs (Net Asset Values) to see how your investments are doing. Excel apps, personal finance - 88 commentsĮxcel is very good for keeping track of your investments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |