Our Products
Trading Models
Courses
Analysis & Data
Articles
Running Your Excel Trading Model in Live Demo Mode
Assuming you've built a potentially profitable trading model in Excel, have backtested it thoroughly on multiple time frames, multiple historical periods, and multiple securities, and you are satisfied that it will be profitable over time, the next step is to run it...
Building a Backtesting Model in Excel
Building the backtesting model begins with designing the data handling layout. Will you be manually inputting the historical price-volume data? Will the data come from a DDE link directly into Excel, or will it come from imported files such as .csv or .txt.? What does...
How to Backtest a Trading Model in Excel
There are several ways to backtest an Excel trading model. You can do it visually by recording the buy, sell, and out signals given by your model in an Excel spreadsheet, including the date, time, and theoretical trade prices. This is very slow and cumbersome....