Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Portfoilio tracker/manager website/app that accounts for inflation?

A helpful place to also put any annual reports etc, of your own portfolios
UncleWibble
Posts: 4
Joined: October 12th, 2020, 4:52 pm
Has thanked: 5 times

Portfoilio tracker/manager website/app that accounts for inflation?

#360876

Postby UncleWibble » November 28th, 2020, 2:11 pm

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 :)

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Portfoilio tracker/manager website/app that accounts for inflation?

#360882

Postby Itsallaguess » November 28th, 2020, 2:46 pm

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.php?f=27&t=19975#p258874

Cheers,

Itsallaguess

UncleWibble
Posts: 4
Joined: October 12th, 2020, 4:52 pm
Has thanked: 5 times

Re: Portfoilio tracker/manager website/app that accounts for inflation?

#360918

Postby UncleWibble » November 28th, 2020, 4:26 pm

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.

tjh290633
Lemon Half
Posts: 8209
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4097 times

Re: Portfoilio tracker/manager website/app that accounts for inflation?

#361054

Postby tjh290633 » November 28th, 2020, 11:26 pm

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


Return to “Portfolio Management & Review”

Who is online

Users browsing this forum: No registered users and 8 guests