UncleWibble wrote:Really as per subject: Can anyone recommend a good portfolio tracker/management website or app that can account for inflation - that is indicate "real" (CPI corrected) profits based on buy/sell dates? Will need to allow manual entry of funds that don't appear on common data feeds.
What I do is to take the RPI (because I'm old-fashioned and these new fangled indices were not around when I started) and rebase that to my unit price at the starting date. It does just so happen that the RPI was rebased in 1987, so the adjustment is small. Here is an example of a table with the RPI, FT30 and FTSE100 all rebased to unity at the outset:
. Income Units Accumulation April
Year to Unit Value Div/Unit Unit Value FT30 FT100 RPI RPI
21-Apr-87 1.00 0.00 1.00 1.00 1.00 1.018 1.00
05-Apr-88 0.91 2.86 0.94 0.92 0.91 1.058 1.04
05-Apr-89 1.18 2.72 1.28 1.10 1.05 1.143 1.12
05-Apr-90 1.21 4.24 1.40 1.13 1.14 1.251 1.23
05-Apr-91 1.34 5.42 1.69 1.28 1.26 1.331 1.31
05-Apr-92 1.30 7.52 1.75 1.24 1.26 1.388 1.36
05-Apr-93 1.51 6.91 2.13 1.44 1.46 1.406 1.38
05-Apr-94 1.70 6.27 2.50 1.65 1.65 1.442 1.42
05-Apr-95 1.66 7.48 2.55 1.57 1.62 1.490 1.46
05-Apr-96 1.95 7.38 3.13 1.80 1.90 1.526 1.50
05-Apr-97 2.16 8.40 3.62 1.85 2.21 1.563 1.54
05-Apr-98 3.31 10.00 5.72 2.45 3.05 1.626 1.60
05-Apr-99 3.44 8.46 6.12 2.47 3.21 1.652 1.62
05-Apr-00 3.32 11.33 6.13 2.42 3.35 1.701 1.67
05-Apr-01 3.29 12.42 6.32 2.05 2.89 1.731 1.70
05-Apr-02 3.37 13.02 6.76 1.65 2.69 1.757 1.73
05-Apr-03 2.29 12.10 4.85 0.85 1.85 1.812 1.78
05-Apr-04 2.92 13.38 6.56 1.22 2.25 1.857 1.82
05-Apr-05 3.46 13.06 8.10 1.33 2.51 1.916 1.88
05-Apr-06 4.30 17.42 10.57 1.68 3.06 1.965 1.93
05-Apr-07 4.91 19.42 12.63 1.90 3.31 2.054 2.02
05-Apr-08 4.14 24.32 11.21 1.58 2.93 2.140 2.10
05-Apr-09 2.28 21.17 6.46 0.87 2.01 2.115 2.08
05-Apr-10 3.69 11.06 10.86 1.33 2.91 2.228 2.19
05-Apr-11 4.16 16.71 12.76 1.43 3.03 2.344 2.30
05-Apr-12 4.40 17.73 14.19 1.33 2.96 2.408 2.37
05-Apr-13 5.27 21.83 17.01 1.54 3.29 2.476 2.43
05-Apr-14 5.34 23.05 18.88 1.75 3.38 2.557 2.51
05-Apr-15 5.91 24.98 21.84 1.91 3.47 2.580 2.53
05-Apr-16 5.92 22.67 21.72 1.79 3.17 2.614 2.57
05-Apr-17 6.62 26.21 25.47 2.10 3.76 2.706 2.66
05-Apr-18 6.12 33.19 24.66 1.79 3.62 2.797 2.75
05-Apr-19 6.35 31.25 27.04 2.10 3.82 2.856 2.81
05-Apr-20 4.50 31.57 20.59 2.10 2.77 2.895 2.84
The values for the end of the financial year in April each yearare used as a comparison.
Because of the lag in announcements of the RPI, you can only do it about 6 weeks behind.
It is dead simple as a spreadsheet, if you keep sensible records and unitise your portfolio.
TJH