MACD

The following excel file is an example of how to calculate the MACD indicator. This example shows the 5, 13, 6, setting. the MACD is in column N.  Over time I may add more excel indicator examples. As I do they will be most easily found in the right sidebar under the “How to” –

Continue reading MACD

How to post your ATS trades in twitter using Excel

As an example, the following Excel script can be used to post your automated trading system trades into twitter via API.  This code can easily be changed to do whatever you want. But in this example it will just be for sending a trade.

Sub TWITTER()
Dim symbol As String
Dim Price As String
Dim xml, Username,

Continue reading How to post your ATS trades in twitter using Excel

Excel Books I recommend

Best Beginner books

1. Excel 2007 Bible – It is important to have one book that just covers excel (not Visual Basic and Macros) so that you don’t unnecessarily use VBA for performing calculations better handled by formulas. The channels and trend lines in my videos of sim trading the ES are formula based not VBA

Continue reading Excel Books I recommend

Excel Based Automated Channels

Excel Based Automated

Continue reading Excel Based Automated Channels