Google Ad

MACD VBA

This post includes links to two example xls files that show both VBA and Formula based calculations for the indicator MACD or Moving Average Convergence

Continue reading MACD VBA

October 6th, 2009 | Tags: , , , , , , , | Category: Automated trading Systems, Equities, Excel as a Trading Platform, Free Excel/VBA based Indicators | 2 comments

Data Converter to Convert OHLC Data to a larger timeframe.

If you have ever wanted to take your existing Open High Low Close historical trading data and convert it into larger time frame, the following Excel VBA based data converter I wrote may do the trick.

DataConverter.xls allows you to configure the Number of OHLC bars that should be condensed down into a single bar. You

Continue reading Data Converter to Convert OHLC Data to a larger timeframe.

August 30th, 2009 | Tags: , , , , , , , , , , , , | Category: Automated trading Systems, Backtesting, Equities, Excel as a Trading Platform, S&P futures | 10 comments

Constant Volume Charts added

I have added the option of constant volume  bar charts (as alternative to time based) for the Excel/VBA based automated trading platform

The constant volume bar option, updates a new bar after a certain amount of volume has completed. This amount should be entered into D3 of the “Live” sheet. Checks are in place to prompt

Continue reading Constant Volume Charts added

June 11th, 2009 | Tags: , , , , , , , , , , , , , | Category: Excel as a Trading Platform, Excel/VBA Automated Trading Platform, S&P futures, Updates/Change log | Leave a comment

End Of Day Backtest (and data downloader)

End Of Day Backtest (and data downloader) moved here

April 24th, 2009 | Tags: , , , , , , , | Category: Equities | Leave a comment