Building a comprehensive stock valuation ratio with machine learningScott Rogowski - January 04, 2021
Like many amateur investors, I spent the early COVID period frantically shuffling my money around - trying to limit losses. Later, as the market reversed in early April, I instead sought out undervalued stocks I could use to recover quickly. While I somehow came out ahead, the madness of the period made it clear how crude my investment strategy was.
Amateur investors like myself have rather basic tools. Most of us will just look at the P/E ratio, decide whether that number "feels fair", and go from there. Some more sophisticated investors might also look at the P/S or the EV/EBITDA. Ultimately though, regardless of preferred metric, we tend to make decisions based on a hunch and a prayer. It's no wonder that there are professional traders who make a living off of us.
(Mis)using machine learning
My background is in software development. As part of that, I enjoy dabbling with machine learning. Machine learning is a scary sounding term but it's actually quite simple. If you ever did linear regression in high school, that's machine learning. Given a set of points, a machine learning algorithm can derive a "best-fit" line such that for any x, we can predict the y. A simple example might be predicting the price of a home. We know intuitively that larger homes are usually more expensive. But given a specific size, say 2000 sq ft, could we guess how much that house would cost? If we find a dataset of recent home sales, we could draw a line through the data and make a well-informed estimate.
Basic ML example from this medium article
Machine learning algorithms can have more than one input dimension. To get a better estimate of a house's price, we might want to also look at whether it has a garage. A house with a garage will probably cost more than one without a garage. Other possible input dimensions might include the number of bathrooms or the age of the house. Generally, the more dimensions in our model, the better the price estimate.
Most algorithmic stock trading uses machine learning. That's not what this is about though. Building an algorithmic trading bot is a naive pipe-dream of many novice ML students. While it might have been possible 20 years ago, today, there are thousands of algo-trading houses with incredibly complex models and exotic data inputs. It is simply too difficult to build an effective trading algorithm with off-the-shelf data. There is too much competition and the market is too efficient.
Instead, I decided to approach the problem from a different angle. What if, instead of predicting the future, I predicted the present?
The FFER (Fundamental Fitted Estimate Ratio) is the ratio between a stock's actual price and its predicted price. Almost by definition, this is a useful ratio. If a stock's actual price is 2x more than it's predicted price, that implies a 2x overvaluation. But how do we predict the price of a stock? We can use the same method as we would use to predict the price of a house - machine learning.
To build my model, I used a dataset of the 1500 stocks in the S&P 1500. To simplify, instead of the per-share price, I used the market cap for my output dimension. For inputs, I used 16 different fundamental financial figures. These 16 inputs were (roughly in order of importance):
- Net income
- Total revenue
- Total assets
- Total liabilities
- Operating income
- Dividends paid
- Return on assets
- Debt ratio
- Asset turnover ratio
- Cash flow to debt ratio
- Quarterly change in cash
- Yearly change in revenue
- Yearly change in return on assets
- Yearly change in sales on assets
- Yearly change in working capital
Why 16? Well, I started with 60. The problem with a lot of dimensions is the tendency to "overfit." Overfitting is what happens when your ML model fits to every nook, outlier, and weird exception. By contrast, a good ML model captures only the "essence" of the data. And with 60 inputs and only 500 stocks, the model was DEEPLY overfit. Luckily, it was possible to rank the importance of input dimensions in my model. So, to fix my problem, I repeatedly removed the least important dimension and re-trained. Each iteration generally lowered the "test error" until I found a minimum at 16 dimensions.
For the actual algorithm, I used 100 XGBoost models trained with identical data. I then estimated the model outputs to get a final price prediction. This strategy is known as an "ensemble." In this case, using an ensemble was important to "smooth" the price prediction. In addition to XGBoost, I experimented with other algorithms like SVMs and neural networks. However, XGBoost consistently had equal or better performance relative to other algorithms. Given that XGBoost is also a relatively "lightweight" algorithm, I thought it was the appropriate choice.
Below is a selection of a few stocks and their FFERs from January 4th (the first trading day of 2021).
|Ticker ⇕||Name||Price ⇕||FFE Price ⇕||FFER ⇕|
|UPS||United Parcel Service||$163.8||$187.66||0.872|
|BAC||Bank of America||$30.03||$179.03||0.168|
On the FFER home page, you can see a much larger table, recalculated daily. In general, the numbers "feel" correct. Tesla has the highest FFER of the S&P 500 followed by trendy smaller tech companies. At the opposite end, the stocks with the lowest FFERs are generally experiencing financial difficulty.
Using the FFER for investment decisions
Ultimately, how you use the FFER is up to you. To address what must be your first question, I have tried using backdated FFERs to predict future returns. The results are the opposite of what I would have expected. While the relationship is somewhat weak, stocks with higher historical FFERs tend to generate better returns. I have several hypotheses for why this might be. Expect that in another post.
Personally, to make my future investment decisions, I plan to combine the FFER with qualitative intuition. This strategy is well illustrated with a Warren Buffet quote:
"It's far better to buy a wonderful company at a fair price, than a fair company at a wonderful price."
In other words, I plan to scour the FFER table looking for "wonderful" companies that, nevertheless, seem to be cheap.
One last thing
The input data for the FFER, and the model itself, is trained with Fastmap. Fastmap is another one of my projects. Fastmap is a drop-in replacement for
map that makes your Python code run faster either locally or in the cloud. The fastmap project prioritizes a simple interface and a simple deployment. Fastmap is open source.