Investors increasingly manage their own stock portfolios using a wealth of stock and mutual fund research and guidance from brokerage websites. manually its task to delete the row.Think twice thrice before investing blindly without backed by technical and fundamental research.Thank you very much for the tool.AMFI has made some changes in their file 'nav.txt'.
What I do (for the ones I have) for my SIPs if list of the SIPs dates and amounts, use the index values for those same dates to calculate and compare bench mark returns.I would like to request you to kindly update your lists.How to acheive the correct NAV in the "Portfolio Sheet" if the Scheme is from CELL greater than 6518 in 'Latest NAV Data" ?I am also not sure which one will be best.Thanks a lot for your effort to make our life easier. So, my donut and coffee??? Hope it will be beneficial for all the users. Looking for a way to track stock / MF performance from excel, read this. now u can use this raw data to make yr excel sheet.[...] and example is: HL Multi-Manager Equity & Bond Trust. That is why it is failing. Meanwhile if you come across an interesting way of doing this without lot of VBA / UDFs feel free to share it with me and other readers @ramhesh , this should work for you , if it doesn't let me know. Can I insert a column near NOW NAV which also shows the NOW NAV DATE ?Ensure that you save the sheet after you are done with the changes so next time when you open, it will work correctly.Copy paste the formula till the end of the column.
read: Create stock / mutual fund portfolio tracker in excel using web lookup queries Tags: america, Analytics, business, excel, how to, microsoft, personal finance, portfolio tracker, [...]I don't understand why you put the Avg unit value, What is the significance in different type of funds, kindly explain.The other way of doing this is enter the total value of SIP amount invested till date and the current value of it in a seperate excel sheet and use the rate formula to know the growth %. Also check if your formulas are consistent from the top cell to the lat one.Your website is awesome for EXCEL .Is there a way to pull the market indicies for the various MF benchmarks. The fund that had a great year is not the same fund it once was and should not be expected to perform the same in the future. All free, fun and fantastic.I have a question though. Mutual Fund & Investment Tracker [...]You best bet is to use google spreasheets and use the google functions to query google finance (oof! Thanks for this wonderful tracker once again.Is it possible to repost/resend the excel file link.Hi, it seems in the latest version (MF Portfolio Tracker- India v3.0.xlsx) web query need to be updated to . I am finding that Moneycontrol does not have all of them. [...]@Ajay... You may have to visit individual fund sites to get historical NAVs. ⇒How to calculate mutual fund returns in excel using “Compounded Annual Growth Rate or CAGR concept”. This drill-down gantt chart in Excel is useful for seeing activities by module or team. The sheet assumes there are no more than 6518 funds. Let me know if you are not able to do it.The NAV tracker for Mutual fund is very good. i enables the external content nd dowloaded PQ files. I will update this post with new instructions and workbook soon. MF Portfolio tracker is awesome. Original post by Chandoo [...]Hey Uday, What do you hope to gain by getting your portfolio value at 330pm vs say 930pm? It was created more than an year ago and in the last 16 months there are few hundred new funds.