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?
Edit:
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.
Should your app be written in JavaScript (perhaps Python too) Iād be keen to discuss more & collaborate. Iāve been working on a JS/DynamoDB app for a few weeks now as a replacement for my excel sheets.
Thanks for you reply.
My āmegaā spreadsheet is built on top of =GOOGLEFINANCE and it worked okay. My new prototype is built using Elixir Phoenix.
Iād love to understand the core needs for a portfolio tracker. I have to say that I am not a dividend investor but Iād love to understand that case more.
The usages I have identified (as a spreadsheet user myself ):
See my portfolio performance globally across platforms
(Less useful) See my portfolio performance per platform (you can usually see that in the paltform itself)
Track my investments allocation (how much MSCI All-worlds do I have compare to US treasury for instance) globally across platforms
And therefore, understand if I need to rebalance my portfolio (eg. buy 5 MSCI all-worlds and sell 20 US treasury so that my PF sticks to my target allocation)
Also I like having a big red cell in my spreadsheet if my investments diverge too much from my allocation, so I can rebalance and take advantage of the market.
I think something important as well is to understand how much asset type do you have: How much stocks VS bonds VS fund VS crypto etc.
For dividend investor, I assume we should have a a way of tracking incomes. Iāll document myself on dividend investing for a bit
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.
XLS shows:
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)
@hourliert, others, thanks for your efforts. I have been trying to find an open source self-hosted portfolio tracker, but have come up short in my albeit limited searching.
Will be interesting to have something akin to Firefly III, but for portfolio tracking.
Unfortunately, you have to. But I am working on importing transactions from CSV (I have 350 transactions from last years).
Also, Iād love to connect it with Freetrade API (once released)
@nishark, I canāt wait to share the prototype/app and start collecting feedback from users. I am building it based on my usage and my needs but it would be awesome to make it available to more people.
I wish you well with the project. Elixir is a little bit too hipster for me (Iām very much an amateur developer), sorry to say Iāve heard good things though!
Do you know why your prototype web app was removed? Iāve seen some other guy that made a Freetrade web app prototype on here and his thread hasnāt been removed.
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!
.
to Freetrade).
. 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āve heard good things though!
