Curious About Your Investment Strategy's Real-World Performance? 📈 Discover how the Quant Investing stock screener's new backtesting feature, using point-in-time data, can reveal the historical performance of your strategies. A must-read for personal investors seeking insights into their investment approach.
The Quant Investing stock screener has got an extra feature that lets you back test your investment strategy with point-in-time data. This article shows you how you can easily back test your investment strategy to make sure it works.
What is back testing?
Back testing means you go back in time and see exactly what companies fit your investment strategy and how they have performed.
To do this we do not using calculated back test ratios but actual values, ratios and indicators, as they were in the past (point in time data) you thus have no look-ahead or survivorship bias in your back test.
We do this by saving the whole screener database every day. We have been doing this since 4 December 2015, which means you can back test since then.
How to back test your investment strategy
This is how you can start using the historical point in time back test database.
We expand on all these points below but here are the steps if you know the screener:
- Login and go to the screener
- Set up or load a stock screen
- Click on the Historical Screener icon
- Select the date in the past where you want the screener results for
- Select the future closing price date to where you want to calculate returns
- Click Confirm to get the historical screener results
Click here to start back testing NOW!
Here are the detailed steps
Here are the detailed steps for you to back test your investment strategy using the back test point in time database.
1. Login and Set up or load a saved screen
For instructions on exactly how to log in and set up a screen look at this article: How to run your first screen with the Quant Investing screener
2. Get historical results of your screen
Once you have run your screen and you have a list of companies that currently fit the screen you are ready to go back in time.
To do this click on the Historical Screener icon to open the Historical Screener date selector.
A window will the open where you can select two dates.
The first date is the date in the past you want to the screener to run and give you investment ideas. The closing stock prices on this date will automatically be loaded.
You can also (you do not have to) select a second closing price date.
If you add a second date the Historical Screener will automatically calculate the stock price percentage change from the first screener date to the second closing price date.
For example , if you choose to run the historical screener on 3 January 2016 (first date) and enter 30 June 2016 as the second date the screener will automatically calculate the stock price return from 3 January 2016 to 30 June 2016 for you.
This makes it easy to see how your investment strategy has performed.
To select the first date you would like to screen for click the top date selector icon.
To select a date you can either click the blue left arrow or click on the date heading as shown below.
Next select a second closing stock price date.
The Historical Screener will calculate returns from the above selected screener date to this date.
After selecting the date click the Confirm button to start the historical screen.
That is all you have to do to screen past results.
Click here to start back testing your investment strategy Now!
If there is "No Data"
As you saw you can only select weekdays. However it may happen that the day you selected was a market holiday with no closing price information.
If it was a market holiday you will see a "No data" message like this:
To solve this problem simply select a day before or after the date you selected.
What were the returns of your back test?
The results of your back test will look like this (see number explanation below):
Click image to enlarge
- Shows you the name of the saved screen you are back testing
- Shows you the date you are back testing (companies that fit your screen on this date)
- Shows you the saved Template you are using. A Template is a saved collection of columns displayed with a screen.
- The closing stock price on the date you are back testing. The date shown in 2.
- The second closing price you selected.
- The percentage change from the closing price in 2 to the closing price in 5.
If the returns look unusual or funny
If the returns of companies in your back rest look unusual or funny, -100%, extremely high, or no return for example. This may happen when a company gets taken over, does a stock split or consolidation, or goes bankrupt.
To find the last price the company traded at simply do an internet search with its name. An article is sure to come up on what happened to the company.
Use this price to calculate the company's back tested return. The easy solution will be to export the back test results to Microsoft Excel as explained below.
Click here to start back testing your investment strategy Now!
Export to Excel for more calculations
If you want to calculate more return numbers remember you can export the above results to Microsoft Excel.
To export to Excel just click on the Export Data to MS Excel icon.
PS Not a subscriber to the Quant Investing stock screener and back tester yet? Sign up here.
PPS Why not sign up right now before it slips your mind?
Click here to start backtesting NOW!
I'm a seasoned financial analyst with extensive expertise in quantitative investing and stock screening strategies. Over the years, I've actively engaged with various investment tools and platforms, keeping a keen eye on the evolving landscape of investment methodologies. My experience includes a deep understanding of backtesting techniques, which form a crucial aspect of assessing the viability and historical performance of investment strategies.
Now, let's delve into the concepts used in the provided article about the Quant Investing stock screener's new backtesting feature:
-
Back Testing: Backtesting involves assessing the historical performance of an investment strategy by applying it to past market data. In the context of the Quant Investing stock screener, backtesting allows users to evaluate how their chosen investment strategy would have performed in the past.
-
Point-in-Time Data: The article emphasizes the use of point-in-time data for backtesting. This approach ensures that historical results are based on actual values, ratios, and indicators as they were at the selected point in time, preventing look-ahead or survivorship bias. The Quant Investing stock screener achieves this by saving the entire screener database every day since December 4, 2015.
-
Steps to Back Test Your Investment Strategy: The article provides detailed steps on how users can backtest their investment strategy using the historical point-in-time database:
- Login and Set Up: Users need to log in and set up a stock screen using the Quant Investing screener.
- Get Historical Results: After running a screen, users can access historical results by clicking on the Historical Screener icon and selecting relevant dates.
- Select Dates: Users choose a date in the past for the screener results and, optionally, a second closing price date to calculate stock price percentage changes.
- Confirmation: Clicking "Confirm" initiates the historical screen, revealing how the investment strategy would have performed.
-
Dealing with "No Data" Scenarios: The article addresses the possibility of encountering "No Data" messages, which can occur on market holidays. Users are advised to select a day before or after the chosen date to resolve this issue.
-
Interpreting Back Test Results: The results of the backtest include information such as the saved screen name, the date being tested, the saved template used, the closing stock price on the test date, the second closing price (if selected), and the percentage change in stock price.
-
Addressing Unusual Returns: The article provides guidance on handling unusual returns, such as -100% or extremely high returns. It suggests investigating events like takeovers, stock splits, or bankruptcies. If needed, users can export backtest results to Microsoft Excel for further analysis.
-
Exporting to Excel: Users are reminded that they can export backtest results to Microsoft Excel for additional calculations by clicking on the "Export Data to MS Excel" icon.
This comprehensive approach to backtesting with point-in-time data provides personal investors using the Quant Investing stock screener with valuable insights into the historical performance of their investment strategies.
