Hello,
I have come across a formula that will filter a dataset to find individual cash flows and associated dates to calculate XIRR for an individual Investment. Here is the formula
“Filterxirr(Investment = A8)*(CashFlow),(Investment = A8)*(Date),Guess )
Does anyone know how to create a custom function in VBA that will filter a dataset for specific investments and associated dates and values to calculate XIRR?
Please let me know. It would be a great help.
I have come across a formula that will filter a dataset to find individual cash flows and associated dates to calculate XIRR for an individual Investment. Here is the formula
“Filterxirr(Investment = A8)*(CashFlow),(Investment = A8)*(Date),Guess )
Does anyone know how to create a custom function in VBA that will filter a dataset for specific investments and associated dates and values to calculate XIRR?
Please let me know. It would be a great help.