Diving into retail investing behaviour with Robinhood

1 1


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

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.

2 1

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

3 1

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.

4 1

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.

5 1

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.

In terms of users, I had to aggregate these and find the average users per day. This is because the data is being pulled multiple times in a day and included timestamps. So what I did there was aggregate those figures and find the average users holding the stock on a single day.

More will be added to this to do other sorts of analysis but this is it for now.

6 1


User Growth Higher in CY20 vs Cy19

Looking at data from 1 January 2019 to 12 June 2019, we can see that users holding stocks on the platform grew +35%.

7 1

For the same time period in 2020, that growth is much more significant at +162%.

8 1

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).

9 1

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%.

10 1

For the same period in 2020, this grew 236%.

11 1

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.


The App


Share on facebook
Share on twitter
Share on linkedin
Share on email