Whilst looking at a spreadsheet monitoring the investment performance of the OCD tipsheet, the XIRR function gave a return of 20% over 378 days.
My version of Excel hasn't got this function and having looked at the trades, I'm surprised at the result, please could someone who knows more about it than me check the working ?
The zipped spreadsheet is here
Cell I1
=XIRR(F2:F500,A2:A500)
Column A2:A500
31/12/04
31/12/04
31/12/04
31/12/04
31/01/05
31/01/05
31/01/05
31/01/05
31/01/05
31/01/05
03/03/05
03/03/05
03/03/05
03/03/05
03/03/05
03/03/05
05/04/05
05/04/05
05/04/05
05/04/05
05/04/05
05/04/05
05/05/05
05/05/05
05/05/05
05/05/05
02/06/05
02/06/05
02/06/05
02/06/05
02/09/2005
02/09/2005
02/09/2005
02/09/2005
02/09/2005
23/09/2005
23/09/2005
23/09/2005
23/09/2005
23/09/2005
23/09/2005
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
21/10/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
18/11/05
14/12/05
14/12/05
14/12/05
14/12/05
14/12/05
14/12/05
14/12/05
14/12/05
13/01/06
Column F2:F500
-1,015
-1,016
-1,015
-1,015
-1,014
-1,016
-1,015
-1,016
-1,015
-1,016
-1,015
-1,015
-1,015
-1,014
-1,014
-1,016
-1,015
-1,015
-1,015
-1,015
-1,016
-1,015
-1,015
-1,015
-1,014
-1,014
-1,013
-1,014
-1,015
6,251
-1,015
-1,015
-1,015
-1,016
-1,015
-1,014
-1,015
-1,016
-1,016
-1,014
-1,015
-1,015
-1,015
-1,014
-1,015
-1,016
-1,020
-1,014
-1,015
-1,015
-1,013
-1,015
-1,016
-1,015
-1,016
-1,015
-1,014
-1,013
-1,016
-1,015
-1,015
-1,016
-1,016
-1,014
-1,016
-1,016
-1,015
-1,016
-1,020
-1,016
-1,016
70,564.22