So today (like most days) I had Ausbiz playing while I was monitoring and researching some trades and I heard two really interesting things that sparked my inner data geek and saw me invest a few hours to spin up some data analytics using the Commsec Daily Course of Sales data.
In reverse order:
- During The Last Call I heard Andrew say that there's alot of value to be had in Small Caps if you're prepared to go the extra mile, because in the main part the big guys cant touch them until they enter into an Index usually
- Earlier during The Call hosted by Nadine today the discussion around QFE got my interest
So taking on board Andrew's statement, I felt that I wanted to understand money flow into a 'Small Cap' by visualising the data that is free and available in the format of Course of Sales.
disclosure : my employment (when I get back into that mode) is a data geek - officially a Data Analyst which kind of comes in handy with investing / trading
The picture in my mind was that I wanted to know the level below Open, High, Low , Close and Volume with respects to a day's trade (would have been especially interesting for Fat Fish the other day), so using the csv that is freely available to be downloaded (even intra day if you were that keen) and the Microsoft product Power BI, I stood up a little analytics app where I can now break down:
- wavg Share Price throughout the course of the day / hour / minute / second
- money flows similarly
- assess how much a Low or High was in play or if they just got 'touched' by someone closing out their larger order
I understand that you're probably thinking this sounds like Day trading, yeas and no. You see I have some positions in small cap and back to what Andrew was saying you have to be able to stomach the swings and IMO that means understand the trades. (maybe I think that way because to me it's only data)
So I have done that (Thanks Andrew and Nadine), and just as a screen snap example using today (19th Feb 2021) for QFE - Quick Fee Limited, I have posted that screen grab with some dot points over on QFE
I guess I'd probably look to use this info to justify when and what price to take a position and go in knowing, or at least having an expectation, of what other recent positions holders may have as their holding costs.
So if you're interested in data atthat transactional level and spottign trends within the same, check it out over on QFE in a few minutes time.
Thanks Ausbiz crew, keep up the good content.
Disclaimers / DYOR and all that, but I have reconciled total Volume and Total $ Value of my aggregations of the detail which is Course of Sales to the totals being reported on the Trading Platform Website.