QUOTE(Pink Spider @ Jan 25 2015, 12:47 PM)
Wanna be lazy try tipu u also susah
Nah, here's how I treat disposed funds (see attached screenshot)
1. All the historical transactions are still there <- this is an ABSOLUTE MUST!
2. Last "summary" row for the fund, "total units" cell is zero because I've fully switched out
3. No more date, no more amount.
4. XIRR for that fund, covers rows 438 to 446
5. Profit/(loss) for that fund, also covers rows 438 to 446
I kept this fund's transactions totally hidden away from sight, but they're all there, covered by portfolio XIRR calculation and profit/(loss) calculation.
U cannot just keep 1 row with the profit/(loss) from that fund, portfolio XIRR calculation needs each and every transaction details (value + date).
Nah, here's how I treat disposed funds (see attached screenshot)
1. All the historical transactions are still there <- this is an ABSOLUTE MUST!
2. Last "summary" row for the fund, "total units" cell is zero because I've fully switched out
3. No more date, no more amount.
4. XIRR for that fund, covers rows 438 to 446
5. Profit/(loss) for that fund, also covers rows 438 to 446
I kept this fund's transactions totally hidden away from sight, but they're all there, covered by portfolio XIRR calculation and profit/(loss) calculation.
U cannot just keep 1 row with the profit/(loss) from that fund, portfolio XIRR calculation needs each and every transaction details (value + date).
Jan 25 2015, 01:41 PM

Quote
0.0529sec
0.59
7 queries
GZIP Disabled