I get this question all the time. “I use Trading Software X and it has all the bells and whistles. Does your Excel software do what Software X does? I just want to make money.” [signed, Trader Losing Money] You know my answer? “It’s not the...
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...
Once you have your trading rules set up and you have coded them to display in your Excel trading model spreadsheet, you can simply enter the orders manually with your broker. This is the simplest and most reliable method, and works well when you only need to send a...
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...
You can often get the best of both worlds by buying or developing an add-in toolkit and combining it with custom formulas and VBA. This allows you to focus on the parts of your model that are specific to your needs while gaining efficiency and functionality in those...
