I believe day trading to be a zero sum game and picking stocks glorified gambling (which I do occasionally). Whilst I may have slightly better than average knowledge about say semiconductors, there is no way I have enough time to read about every company’s: developments, prospects, competitors, financials etc let alone for an area I have no idea about such as genetics. As such I’d like to target specific industries/areas that I think are almost guaranteed success long term, pies and ETFs are great for that.
At the moment I have following pies:
- Blockchain (mostly fluff from Reality BLCN )
- Chip manufacturers
- Fast growth digital stuff I don’t understand
- Quantum computing (mostly fluff from Defiance QTUM)
- Smart buildings
- Mega software companies
- Water tech
- Index developed/emerging
I like checking these forums especially for a laugh about anything that involves Tesla, but generally I want to be as passive as possible with my investing. The time I spend analysing stock is the time I don’t spend at my core hustle which is what allows me to actually put money into stocks. I plan to put £50 per each of the above pies every month and remove the trading 212 app altogether so I’m not tempted buying random stuff or worse trying to time the market (here is a great example of why timing market is pointless on the long run).
I have slight aversion to to index tracker funds as they include companies that are huge now but offer no long term growth potential or ones that are slightly less ethical like (though I love arms industry, thanks to them we have all sorts of crazy engineering that no one would ever need to develop otherwise).
A lot of interesting ETFs are not available in the EU due to regulatory mismatch.
Because of the above issues I wrote a small program that allows ETFs to be loaded, blended with other ETFs and then filter out anything that is not available on T212 or not available in ISA. Undesired securities can be removed. It saved me from going through excel myself, seeing what’s available and then scaling the ratios.
It’s like a second time in my life I did anything GUI related so that aspect is a POS, otherwise it seems to work for what I designed it for.
I’ve uploaded two binaries that should work on osx and windows 64bit.
How to use:
- Remove from the excel file anything that isn’t the main table
- Make sure all files are .xlsx or .xls
- Load file(s)
- (Optional) Add/remove custom security entries
- (Optional) Set relative weights for given ETFs
- Number of pies
- ISA/fractional filtering
- Removal below 0.5% threshold
- Make pie
- (Optional) Save as new excellent file
I’m open to comments about my investing strategy, and I hope this script happens to work for someone.