FAQ: Ticker Symbol Excel VBA Mismatch Error
Question: When I attempt to run the model with AAPL and several other stocks, I get a type mismatch error from Excel, and then in attempting to debug the model code, this is what is displayed (see below.) I realize that it is not recognizing the indicator variables,...A Simple Correlation Trading Model in Excel
As an example, we will show how a simple yet effective correlation trading model can be built in Excel with free data and some basic statistical formulas. The idea here is to compare two closely related stocks of similar size and volatility in the same industry,...Automated Order Execution from Excel to a Broker’s System
If you want to fully automate your Excel trading model, you will want to execute buy and sell orders directly through your broker’s system. Several brokers such as Interactive Brokers provide an Application Programming Interface (API) that allows you to send...Steps for Developing Your Trading Model Logic
The following basic steps should be taken in developing your trading rules. The best way to do this is to write it down as you go. You will undoubtedly change your rules, find errors, and develop rules for the many complicated situations you come across in the....
