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
Portfoilio tracker/manager website/app that accounts for inflation?
-
- Posts: 4
- Joined: October 12th, 2020, 4:52 pm
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: Portfoilio tracker/manager website/app that accounts for inflation?
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 -UncleWibble wrote:
Will need to allow manual entry of funds that don't appear on common data feeds.
https://www.lemonfool.co.uk/viewtopic.p ... 75#p258874
Cheers,
Itsallaguess
-
- Posts: 4
- Joined: October 12th, 2020, 4:52 pm
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: 7675
- Joined: November 4th, 2016, 11:20 am
Re: Portfoilio tracker/manager website/app that accounts for inflation?
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: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.
. 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.84The 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