The Lemon Fool

Hi,

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.
Yahoo Finance doesn't seem to do this, unless I can't find the feature.

I'm having a go at doing a Google Sheet, but it's not going to be terribly pretty.

Don't mind if free or sensible fee.

Priority is "overall profit/loss estimation", less bothered about deep research and data as I can go elsewhere for that.

Thanks folks

UncleWibble wrote:
Will need to allow manual entry of funds that don't appear on common data feeds.

If you're happy to have a play with Excel then the following post might help get you some automatic fund-prices into a spreadsheet, to then help get you going with a manual solution to the portfolio/inflation-tracking aspect -

https://www.lemonfool.co.uk/viewtopic.p ... 75#p258874

Cheers,

Itsallaguess

Thank you. It's less the scrape I'm after and more the "overall view" (with inflation correction).

I've hacked a Google Sheet together that uses ONS CPI monthly data to scale up previous cash inputs to my funds to "today's money" and compares to the headline valuation in the Hargreaves&Landdown app.

I'm just surprised that things like Yahoo Finance don't do this - it may not matter quite so much now, but if the CoronaVirus spending sends us into the inflation figures last seen in the 70s, it's going to become quite important to factor this in.

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