Dynamically Calculating XIRR

[jtibrewala]

I'm trying to do an XIRR calculation in the MF tracker you created. Here is a sample set of data that I have. I want to be able to calculate the XIRR in the cells marked in green through a dynamic formula without having to manually enter the rows in the xirr formula every time I do a new trade for the new month in the particular fund. ex. if I add trades for new dates (ex rows 10-12), then the xirr should automatically recalculate for the new dates (i.e. new line entries). Could you help me with the right formula to do this?

 

[Excel Wizard]

Maybe try

=XIRR(FILTER($G$3:$G$20,$C$3:$C$20=C18),N(FILTER($E$3:$E$20,$C$3:$C$20=C18)))

 

[jtibrewala]

that worked. Brilliant. Thanks so much!!!