This post includes two example excel files that show both VBA and Formula based calculations for the indicator “Stochastics”.
Both files contain the exact same set of Open High Low Close data. The formula based version should be easier to understand and serves as a way to verify that the VBA code that I wrote is
Continue reading Stochastics Indicator – Excel VBA and Formula versions
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
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.
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
Recent Comments