XIRR (EXTENDED INTERNAL RATE OF RETURN)

XIRR (EXTENDED INTERNAL RATE OF RETURN)

Computes returns on investment where multiple transactions happen at different times.  XIRR gives the current rate of return of an instrument where cash flows are spread across time periods.