• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mutual Fund XIRR - Different Mutual Fuds SIP XIRR Daily Automatic Calculation

A

anilmehtas

New Member
hi, i am attaching herwrith a file with investment in mutual fund through sip. investing regulary in different funds. i need to know how i can have updated XIRR on each mutual fund in this file on daily basis. your advice and guidance will help me immensely. the nav is changing on daily basis.
 

Attachments

  • multiple mutual funds sip xirr sample.xlsx
    21.3 KB · Views: 7
I suppose the simplest answer is this: Each day 1) look up the new XIRR on each fund, and 2) enter the new data in the worksheet.

I realize I'm being a little facetious here. But you haven't really said anything yet. "How do I update my data on a daily basis?" Answer: Update it every day. If you have a more detailed question than that, you have to ask it.
 
You must log in or register to reply here.
Back
Top