We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
App or Spreadsheet to Track Investments

tekton23
Posts: 145 Forumite


Hi,
As the title really! I am starting to save money and have a mix of savings accounts, stocks and funds.
Each time I invest, I would like to record this and then also input valuations every now and then, so that I can get a sense of how things are going, performance, portfolio size etc.
It does not have to have real-time stock or fund data. It could be an app or a spreadsheet, where I manually update the data.
Does anyone have any ideas or recommendations?
Thanks,
T23
As the title really! I am starting to save money and have a mix of savings accounts, stocks and funds.
Each time I invest, I would like to record this and then also input valuations every now and then, so that I can get a sense of how things are going, performance, portfolio size etc.
It does not have to have real-time stock or fund data. It could be an app or a spreadsheet, where I manually update the data.
Does anyone have any ideas or recommendations?
Thanks,
T23
0
Comments
-
Can your platform not offer the tools you are after?I am an Independent Financial Adviser (IFA). The comments I make are just my opinion and are for discussion purposes only. They are not financial advice and you should not treat them as such. If you feel an area discussed may be relevant to you, then please seek advice from an Independent Financial Adviser local to you.0
-
No, as I have a mix of different accounts and investments with different platforms.0
-
Maybe so but there are platforms that let you enter 'virtual data' i.e. create your own portfolio records irrespective of where or what you have. II used to have an excellent one, but there are others. ....for free.
However, providing you can drive one a bit, a spreadsheet can do all you describe and for free if you have the right one!
More specialist apps tend to have some really good functions and analytics and can automatically link real time investment and account date but sound OTT for what you wish.0 -
I use trustnet to track all my investments. Just register and add your investments on there. It's easy.I wanted to thankyou a million times but its a shame that I can press the button just once :T0
-
Personally, I use a good old fashioned spreadsheet to track everything.
Stocks & shares ISA is unitised so I can track it!!!8217;s performance. P2P and cash isas/regular savers/saving accounts have their own section, and in final column there is an overall figure.
Nothing fancy, but it!!!8217;s easy to maintain."If you aren’t willing to own a stock for ten years, don’t even think about owning it for ten minutes” Warren Buffett
Save £12k in 2025 - #024 £1,450 / £15,000 (9%)0 -
I also do something really low tech - I have a note on my desktop which I update once a month (after bills/DDs) with the totals in my various pots then again at the end of the month to add to the running total:
28 May 2018 - £22,479
23 June 2018 - £23,419
30 July 2018 - £24,420
09 Aug 2018 - £
£00,531 - Santander 123
£01,200 - Santander eSaver
£01,000 - Flex Saver
£02,500 - Flex Direct
£10,466 - LISA AJ Bell (inc. £2,000 bonus)
£08,917 - ISA Vanguard
£01,002 - Gatehouse Bank/Raisin UK (23 Jun 2019)
£00,055 - C&V Credit Union
£25,671 - Total
That's enough information to see if I'm meeting my savings goal and how much discretionary spending I've got each month without getting neurotic - and if I need more information about how a specific pot has performed, I can go to the platform/account and use the tools there.That sounds like a classic case of premature extrapolation.
House Bought July 2020 - 19 years 0 months remaining on term
Next Step: Bathroom renovation booked for January 2021
Goal: Keep the bigger picture in mind...0 -
..for me it's spreadsheets all the way. Assuming you are reasonably excel savvy it quite easy to list all your "assets" and then update the spreadsheet every month. From this you can then generate performance data to suit your own needs. I have refined my spreadsheets over the last few years to reflect what I (think) I need to know. (Probably on version 100+ by now!) I don't think you have the same flexibility using a bespoke system......"It's everybody's fault but mine...."0
-
No, as I have a mix of different accounts and investments with different platforms.
How about consolidating onto a single platform that does?I am an Independent Financial Adviser (IFA). The comments I make are just my opinion and are for discussion purposes only. They are not financial advice and you should not treat them as such. If you feel an area discussed may be relevant to you, then please seek advice from an Independent Financial Adviser local to you.0 -
How about consolidating onto a single platform that does?
Different platforms are better for different products and investments and you would lose some FSCS protection.
I use a HL watchlist but I have holdings elsewhere that they cannot track which means I get an incomplete view. Still it doesn't really matter much as I put everything into a spreadsheet anyway.
Alex0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 349.7K Banking & Borrowing
- 252.6K Reduce Debt & Boost Income
- 452.9K Spending & Discounts
- 242.7K Work, Benefits & Business
- 619.4K Mortgages, Homes & Bills
- 176.3K Life & Family
- 255.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 15.1K Coronavirus Support Boards