jo
Member of DD Central
Posts: 727 
Likes: 492
|
Post by jo on May 25, 2015 16:45:53 GMT
It's my first anniversary in Fondling Cynics and I was just trying to run some XIRR on my history. However, the format of the transaction statements is quite useless (no surprises here). I wonder if anyone has created an Excel spreadsheet capable of parsing the csv output files and get a proper ledger that can be used? Do you actually need that (unless you want to calculate XIRR at an historic date)? Usually dates and amounts of deposits and account value at today's date will suffice - using the excel function.
|
|
TitoPuente
Member of DD Central
Posts: 623
Likes: 655
|
Post by TitoPuente on May 26, 2015 14:37:30 GMT
It's my first anniversary in Fondling Cynics and I was just trying to run some XIRR on my history. However, the format of the transaction statements is quite useless (no surprises here). I wonder if anyone has created an Excel spreadsheet capable of parsing the csv output files and get a proper ledger that can be used? Do you actually need that (unless you want to calculate XIRR at an historic date)? Usually dates and amounts of deposits and account value at today's date will suffice - using the excel function. It would be interesting to see the yield variation through time. It would also be interesting to test their formulas that exclude idle cash.
|
|
jo
Member of DD Central
Posts: 727
Likes: 492
|
Post by jo on May 27, 2015 6:26:39 GMT
Do you actually need that (unless you want to calculate XIRR at an historic date)? Usually dates and amounts of deposits and account value at today's date will suffice - using the excel function. It would be interesting to see the yield variation through time. It would also be interesting to test their formulas that exclude idle cash. Perhaps 1st anniversary is the appropriate time to start monitoring your own XIRR. After 3 years, the effect of idle cash on my XIRR is to depress my reported FC 'Annualised Return' (the middle one) by about a half per cent.
|
|
