Added new file for Live trading with Interactive Brokers

In addition to the free files located under “Instructions and Downloads”, there is now a new file under “Products and Services” for live trading via Interactive Brokers. This Excel VBA based file is an all in one solution for testing, trading and charting.

This is very similar to a version I have been using for my

Continue reading Added new file for Live trading with Interactive Brokers

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

How to add an indicator to Simulator.xls Chart (or any Excel Stock Chart).

If you have ever tried to add a simple moving average (or any data series) to a stock chart you may have noticed that after adding the series, the chart got all messed up!

Here is a short tutorial and an example file showing how to add a simple moving average to a stock chart. I

Continue reading How to add an indicator to Simulator.xls Chart (or any Excel Stock Chart).