Skip to main content

Visualising the Straits Times Index

The STI benchmark for Singapore's stock exchange is easy to visualise as it has just 30 well publicised constituents. Go on, click the sector headings to drill down.

It's easy to see how diverse it is. Is it too concentrated?


I hold both STI tracking funds (ES3, G3B). I was worried of overexposure to banks, and underexposure to the REITs that recently enriched one of my uncles. Anecdotes are a poor way to make financial decisions, I know, but what you gonna do? Us Asian kids are drilled in the aspirational and cautionary tales of our respectively rich and poor uncles, so much so that we scramble for our spreadsheets when we hear of a new fable.

I'm actually quite happy with the weightings once visualised. The narrative that worked for him has been replaced by another story, which just happens to be a picture.

And that picture says, "Calm down." The eggs are in different baskets, though some baskets are bigger than others, and some baskets are REITS.

The other concentration risk lies in that the STI's constituents make up about 60% of Singapore market capitalisation. There's a whole other 40% of listings you could buy. That doesn't mean you should. Although many are diamonds in the rough, the FTSE ST All-Share index underperforming the STI in the 5 years to May 2022 demonstrate that many smaller-caps are, well, just rough.

The index - and funds - are not static either. 2015 saw the notable addition of Yanzijiang Shipbuilding. The STI soon dropped Noble for CapitaLand Commercial. That's more than enough dynamism for your humble buy-and-holder.

Sources:


Comments

Popular posts from this blog

Transcode to PSP using Handbrake

Source: Handbrake 0.9.9.5530 64-bit edition Target: (Phat) Playstation Portable PSP-1000 , System Software: 6.60 Many internet articles on how to transcode video to PSP using Handbrake have not worked for me. Even the most helpful are incomplete. I hope this post will help fill in the blanks. There is no longer any PSP preset for Handbrake, but from what I can gather, the preset had only limited success as the x264 encoder would change syntax and settings between versions. Other presets that may have worked before, like 'iPod' and 'Apple-Universal' now do not. Here is what worked for me, step by step:

Firefox History Statistics - Extracting from Places.sqlite

If you want to take a look at Firefox surfing activity, the about:me add-on is a good start. However, it presents only one view of data and is thus limited in its ability to present more detailed statistics. We will view that data in a different program. So let's first extract it from the browsing history stored in the Places.sqlite file into a CSV file using a Firefox add-on. Step 1 - Locate and copy Places.sqlite to a working location On Windows machines, Places.sqlite is found in a directory similar to: C:\Users\User1\AppData\Roaming\Mozilla\Firefox\Profiles\ .default\places.sqlite Copy the file to another location. The database will be locked while using Firefox, and the SQLite plugin we will use to open it.

Bloomberg JSON data into Libreoffice Calc

LibreOffice Calc has no inbuilt stock market functions, and a popular plugin which offered those has stopped working along with changes to Yahoo Finance. Luckily, we can get the latest quotes from Bloomberg. [2018-12-15] Bloomberg Finance is, understandably, blocking multiple simultaneous requests. A more flexible solution is using a Python Stock Scraper .