The Prediction Machine
Subtitle: Part I - Protocols and OpenBB
“Anyone who believes that exponential growth can go on forever in a finite world is either a madman or an economist.”
- Kenneth Boulding, Economist
- Steve Keen, Economist
In Superforecasting - The Art and Science of Prediction Philip Tetlock and Dan Gardner tested the predictions of experts and found “the average expert was roughly as accurate as a dart-throwing chimpanzee.” Experts and pundits have gained reputations mainly by telling convincing stories more often than being right. Is it possible to create an algorithm that does better?
For several years, Tetlock has been running the Good Judgment Open forecasting contest where anyone can try to be a superforecaster by estimating things like,
- What will be the average price of large eggs per dozen in the US as of 3 March 2023, according to the USDA?
- Will monthly global land and sea temperature anomalies reach or exceed 1.4°C before October 2023, according to the National Oceanic and Atmospheric Administration (NOAA)?
- How many tech industry employees will be laid off in February 2023 and March 2023, according to Layoffs.fyi?
On the Good Judgment About page, you can find many research papers on the subject of superforecasting.
To narrow the scope of this project a bit, let’s try to predict whether a stock price will rise or fall during a day. Investing feels a little bit like the three laws of thermodynamics - you can’t win, there are no tie games, and you have to play. You have to play because even if you bury your money in a hole in your backyard, that’s a decision. It’s a decision to forfeit the game, but still, you have to make that choice.
During times when the market as a whole is moving down, there are still some stocks that rise, and there will be days when the market average increases. Can we find a method that will allow us to correctly find those stocks and those days?
# Day trading
Investing over a very short time is often called day trading, and is in contrast to the longer-term investment strategy known as “buy-and-hold”. Most financial experts recommend the buy and hold strategy, but then they’re dart-throwing chimpanzees. Surely with all of the rapidly evolving information available and new artificial intelligence methods, we can outperform the stock market.
From The cross-section of speculator skill: Evidence from day trading:
- Only 19% of traders did better than the market
- Less than 1% consistently beat the market
- The top 500 traders gained 0.379% per day
- The average day trader traded on 43 days of the year
- Aggregate net returns for all day traders (combined, not individually) were negative for every single year studied
If the best day traders earned 0.379% per day and traded only 43 days per year, then their average return would be , or 17.7%. That’s better than the average, but only for the top 500 traders.
Before we begin, there are some required protocols:
- Don’t do anything stupid.
- Don’t bet real money with this method.
- If you do bet real money, it isn’t our fault.
- Don’t second guess the algorithm.
There are two reasons not to second guess the algorithm. If you think the algorithm is making the wrong decision, it may be because you’re biased, or forgetting some important detail. Presumably, the algorithm will be optimized to provide the best choice with all of the information it has, and be completely unemotional. Let it do its thing.
The other possibility is that you have information that the algorithm doesn’t know yet. In that case, shut it down and retrain it with more complete data, but don’t try to correct it on the fly. You don’t want to be like this poor schlub.
It’s best to think of this project as an exercise in learning about some AI methods.
Signals are the input information to the algorithm. The problem may be having too much information so the algorithm will be overwhelmed with data. To start, though, there are several distinct categories or sources of data we can use as inputs. These are,
- Fundamental analysis calculates the expected stock price based on a detailed study of the underlying business drivers (profitability, operational efficiencies, managerial expertise, etc.) related to the company, its products, its industry, and the general economy.
- Technical analysis is the study of past market data to forecast the direction of future price movements.
- A sentiment indicator is a tool that is used to measure the overall feeling or mood among investors and traders.
- Macroeconomics deals with the performance, structure, behavior, and decision-making of an economy as a whole.
- Other indicators are seasonality, volatility (the VIX), moving averages, the advance-decline line, and the McClellan Oscillator.
Finance professor Roy Batchelor says of the technical analysis method called Fibonacci ratios, “the idea that prices retrace to a Fibonacci ratio or round fraction of the previous trend clearly lacks any scientific rationale”. Many technical trading principles may be bullshit, but if enough people use them they could become self-fulfilling and useful indicators.
OpenBB is an open-source tool to help with financial research that can access stock market, crypto, and ETF data and perform analysis using fundamentals, technical signals, and sentiment indicators. The best way to understand all of the capabilities of OpenBB is to download it, run the application, and open the online help pages. It doesn’t come with a fancy GUI, so you need to type in commands such as
Forecast which will take you to sub-menus for more detailed commands.
Stock data is immediately available through Yahoo Finance, so to load recent data for AMC Entertainment Holdings, Inc. (AMC) switch to the
and now type
load amc which will display
Loading Daily data for AMC with starting period 2020-02-11.
You can change the range of dates to acquire with the start and end commands:
load amc -s 2021-01-01 -e 2022-01-01, or whatever range you’d like to see.
candle command shows the opening and closing prices, and
candle --ma 20 overlays a 20-day moving average. The volume, or number of shares bought and sold, is shown in the bottom section of the plot.
Using the Behavioral Analysis submenu (
ba), you can plot mentions of the stock using data from FinnBrain:
Much more financial data is available through third-party sources. You’ll need to install keys for each API (Application Programming Interface), and OpenBB makes it easy to get the ones you want. Under the
Advanced menu, you’ll see
Set API keys. On the help page, scroll down to see how to obtain the keys. I got keys for stock-related sites that didn’t charge for the information:
Reddit was a little tricky, but some help is here, and for GitHub, I had to create a new app name, OpenBBWildPeaches. You might want to explore some of the other APIs to see if there’s something you’d like to have.
# An example
Forecast menu contains machine learning tools to help predict the future direction of stock prices. If you’re in the
Stocks submenu, use the command
home to return to the top level, then
forecast where you can apply commands to explore the data you previously loaded, apply feature engineering to create new data sets, and predict future prices with Time Series Forecasting.
Note the disclaimer at the top, and don’t forget Protocol 2.
Instead of using a built-in method, we’ll use a very simple rule-based model. First, we need to export the data in either xlsx or csv format. From the top level, use
/stocks/load AMC --export xlsx which will save the data in
Using the closing price data we can build a simple prediction machine. Add a new column
Close Diff and take the difference of the first two entries in column ,
=e3-e2. Copy this formula to the bottom of the last row of data. These will be the values we want to predict.
The formula to predict the closing price differences is very simple. If the both of the differences are positive or both are negative, take the average of the two values. If the price went up one day, and down the other, add the two price differences together. An easy way to see the behavior of the price change over two consecutive days is to multiply price changes together, and apply the sign function,
=sign(h2*h3) where column is used to store the differences.
Next create one more column to hold the predicted values, using the formula
=IF(I4<0,H4+H3,AVERAGE(H4,H3)). This says that if the entry in column is negative (the changes were in opposite directions) add the two values together, otherwise take the average. Your spreadsheet should now look like this:
Next, make a scatter plot of the predicted changes against the actual closing differences (col. vs col. ). I added a red line at to show where perfect predictions would lie on the plot.
For a plain-vanilla prediction machine, it works fairly well.
# A simple neural network
In the example, when the Indicator (column ) is less than zero the output is the sum , and if it’s non-negative the output is the average. But, the average is , so what happened was we added the two inputs together and then multiplied by either or depending on whether the price changes, , were in the opposite or the same direction.
The equations contained in the spreadsheet can be outlined as a flow chart,
where the two previous changes in closing prices are the inputs. The first operation sums them together and the lower one multiplies them to create the indicator function () which returns a multiplier . The prediction is . This is a very simple neural network with the exception that the values for were pre-selected. In a true neural network, some of the input data would be used to “train” the network.
In the training phase, the two values that can take on are adjusted until the errors between the true price changes and the predicted changes have been minimized. Many algorithms have been developed to handle the training portion and to test the optimal weights on data that has been held out from the training phase. Doing this helps to see how good the weights are at predicting new inputs. To read more about how neural networks are designed, take a look at Machine Learning for Beginners: An Introduction to Neural Networks by Victor Zhou.
For the AMC stock data, the scatter plot uses only the first 250 data points out of a total of about 760 that were downloaded by OpenBB. Notice the sharp rise in prices during the summer of 2021. At that point, the simple neural network failed miserably.
In OpenBB you can write scripts to automate processes using the built-in functions. To create new functions like this simple neural network, we needed to export the data to a spreadsheet and write the functions there. OpenBB is written in Python, and a much more effective method for interfacing with it is through the Software Development Kit (SDK) which will allow us to write in Python and call OpenBB functions. Getting the SDK and running Python will be the subject of the next post.
OpenBB Terminal is the first and only open source investment research platform. The terminal connects to dozens of different data providers and allows users to access investment research from a single platform. More than that, due to its open source nature, users can add custom data sources or build their own analysis on top.
Posts using OpenBB Terminal
Anaconda is a distribution of the Python and R programming languages for scientific computing (data science, machine learning applications, large-scale data processing, predictive analytics, etc.), that aims to simplify package management and deployment.
Python is an interpreted, high-level and general-purpose programming language.
See all software used on wildpeaches →