It’s my first (real) post on the community forum! Yay!
I have been a Freetrade user for 1.5 year and have my 2020 ISA on Freetrade .
I have been investing on multiple platforms over the last 2-3 years and it is starting to be a nightmare to keep track of everything. I have investments on the 2 Freetrade account types (basic and ISA). Investments with another broker (I don’t know if I can name it here?) and some cryptocurrencies on another platform.
I recently built a spreadsheet to keep track of everything but it isn’t great. I mean it works well to see an overview, but it falls apart to see my asset allocation per platform (eg, how much UK Gilts do I have on Freetrade ISA), and therefore makes it hard when I need to re-balance my portfolio (eg. do I need to move money from “other broker” to Freetrade).
I used an online tool last year (can I name it here as well?) but it was only working with ETFs. So crypto, stocks couldn’t be tracked there.
Do you have any advises?
Just to be 100% transparent and honest, I shared a prototype app I built earlier today that got hidden from the forum . I apologise for that and I want to get off to a good start and introduce myself and ask for help about my pain point.
I am a software engineer and I consider building a webapp to track my portfolio but I wonder if it is worth the effort (and how complicated it is to get asset quotes in real-time).
I still use a multitude (actually its only 3) of excel sheets after many many years. Yahoo finance is a good alternative for a lot of people but doesn’t handle dividends very nicely so becomes a problem as a lot of amateur investors do so for the dividends.
I find a pencil and paper work well! I have 3 platforms containing unit trusts and share portfolio. About 30 company shares and 5-6 unit trusts (if I include Woodford) A hardback notebook for research, a birthday / address book for ex div dates and company info and a post it note for my buy/sells stuck to my phone
Sure - anything I can’t get from FT and SWS. The great thing about SWS is that you can export to CSV, and it includes dividends received, whereas FT stock % gain / loss assumes each share is a purchase rather than dividend reinvestment.
Breaking Portfolio in to 3 - Dividend / Growth / Speculative to ensure balance.
Better breakdown by sector.
Highly visual way of glancing at the above, and seeing which ones are growing / losing
Anything else I think of adding!
Only created it last week, but it’s bought up some interesting trends. As stated above I split my stocks in to three pools - Dividend, Growth and Speculative. Was aiming for a 40 / 40 / 20 split but this showed me I was heavy on the growth stocks. Also showed growth stocks were growing nicely (25% up) whereas “Dividend” stocks were receiving very few actual dividends.
It just works for me, as it’s highly visual and takes about 30 seconds to import latest data from SWS.
That’s super interesting.
Something similar happened to me before I used Freetrade. I tried to maintain a 30/70 allocation between debt/stocks and it slowly drifted to 20/80. I was getting enthousiastic about stocks and increase my level of risks.
I have started working on the prototype @NorthernMoney and I am focusing right now on the “overview” of the portfolio. I can already inputs my transactions in the app. I’d like to create an overview that makes sense so in a quick look I can:
Understand if my investment allocation is on target
Understand if any breakdown of my allocation is on target (eg. debt VS stocks VS commodities)
Understand the performance of growth investments (no focus on dividend investing right now)
I think my post was promoting my webapp prototype “too much”, so it got removed. Which is also surprising when you think about the number of posts on the forum from other folks that promotes their owne business. This violates rule #5 from the community rules.
I managed to get some feedback from folks recently. It’s been great so far!
I am now using the prototype to track my investment with Freetrade, I have ditched my old spreadsheet. Still not perfect, but it’s getting there.
It’s great that you use your technical capabilities to make your life easier, continue doing that, its things like that that will make you a better developer. I also had the idea of doing something similar, I actually wanted to create an app extension that would automatically reinvest my dividend income, but I’m swamped with many things to do at the moment
Small update from me. I managed to publish the prototype online (won’t share the link here so I don’t self-promote my website ) but I think I am now hitting a wall in terms of what to build next.
@scudulike, as I told you, I have to enter all my transactions so far (only ~300 so far! haha), which is annoying if you invest daily/weekly, the bad news is that Freetrade don’t have an API, and it doesn’t seem to be on the roadmap anymore? I wonder if there is a world where the same thing could be achieved without entering each transaction, eg. by taking the average price at which you bought your assets (but it might mess the computation with approximations).
Anyway, if anyone has an idea/feedback, I’d be very glad to hear it! Thanks in advance!