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
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?
-
- Posts: 4
- Joined: October 12th, 2020, 4:52 pm
- Has thanked: 5 times
-
- 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?
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
-
- Posts: 4
- Joined: October 12th, 2020, 4:52 pm
- Has thanked: 5 times
Re: Portfoilio tracker/manager website/app that accounts for inflation?
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.
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.
-
- 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?
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