With many folks out of work or on shortened hours both in Australia and overseas there have been a number of news articles pointing out the rise in retail trading.
In Australia, we saw ASIC release an article on this (LINK) which highlighted trading activity and potential harm to retail traders jumping into the markets here (and an especially concerning piece on those jumping into CFD’s — contracts for difference).
Whilst we do not have readily available data on retail trading here in Australia, we can get some insights into markets overseas, particularly in the USA.
Note: This information is republished with permission. This is not investment advice. It is general analysis and republication of existing data in an alternative user-friendly format. For advice on investments then please contact your financial adviser or get in touch with one of ours here at Prosperity: LINK
The Robinhood Data
In the USA, the mobile app Robinhood (LINK) is quite popular amongst younger traders and when you consider that the majority of jobs lost have been for people in younger age brackets (hospitality, retail, arts jobs) then insights into this app would be quite interesting.
Luckily for us, Robinhoood user tracking data is made available by RobinTrack.net (LINK). This site, run by Casey Primozic, showcases a number of interesting leaderboards which are filterable to showcase various changes in popularity of particular stocks over different periods.
Most importantly, he makes the data available to download, so that’s what I did so that I could analyse it in Power BI.
Analysis using Power BI
After downloading it, I noticed all the individual securities have their own file.
To handle this, there is a Folder analysis option when you “Get Data” in Power BI and after pulling this in we were up and rolling.
One of the things I noticed was that each security has multiple timestamps per date where user holding info is collected. To handle this we aggregate by those dates and average the number of users holding that stock on that date. This is why in the final result you’ll see the numbers of users holding a particular stock have decimal points, because we may have an average of 550.5 users who held the stock that day.
To give the app a nice template background, I create that in PPT first and load it into a blank Power BI canvas. This gives a good base for where to set your charts, KPI’s/metrics and filters.
Then I added these element using the Power BI desktop app and change display options, set colours, edit levels of interactivity and generally try to make the app simple and user-friendly.
This app allows users to search for what the biggest movers were in the 8.4k tradable securities on Robinhood over a filterable period of time. The % change takes what the total holders were at the start of the period filtered and compares that with the end number of users.
I also pulled in names of companies for 95% of the tickers listed here (from Google Finance) and also tagged those which (as at 3 June 2020) were in the S&P 500. This means users can filter for companies in the S&P 500 or not when they do their analysis.
More will be added to this to do other sorts of analysis but this is it for now.
User Growth Higher in CY20 vs Cy19
With this app we can create all sorts of insights from it. The following insights are basic but give you a good idea of what you can do with the data.
Looking at data from 1 January 2019 to 12 June 2019, we can see that users holding stocks on the platform grew +35%.
For the same time period in 2020, that growth is much more significant at +162%.
We can also see how popular the Robinhood.com domain is in terms of page views and how that’s picked up since the pandemic came into full effect. Using insights from SimilarWeb enables this (although this data is not in the app).
Growth in leveraged products grows higher as well
Last week saw news of a customer of Robinhood committing suicide citing $730k USD of losses (LINK). A combination of app limitation and consumer financial illiteracy are some of the factors being spoke about that led to this persons demise. I added an ability to search within the names of securities traded on Robinhood for evidence of growth across leveraged products which are one of the riskier types of investments that retail traders can make. What was interesting was seeing growth in that as well.
From 1 January 2019 to 12 June 2019, the search for “3x” in the name of a security product actually dipped 8%.
For the same period in 2020, this grew 236%.
The same search for 2x leveraged products also saw higher growth with 209% in this same period in 2019 and 306% in 2020.
The dangers of investing in products like this with a lack of knowledge can be detrimental for some and even worse for others. The need for further financial literacy is clear, especially when there is evidence of rising user holdings on retail trading apps like Robinhood.
With the data from Robintrack being updated daily, but the steps to bring it in being a bit manual, I will update this app each weekend. The latest update bring us up to 20 June 2020.
With all of the above you can try it out yourself. If you’re interested in going for a bit of a deep dive to look at what this looks like then feel free to take a look at the app: LINK