Stochastics Indicator – Excel VBA and Formula versions

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 [...]

October 29th, 2009 | Tags: , , , , , , , , , , , , | Category: Excel How to, Indicators | Leave a comment

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 [...]

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

Excel still slow with SP2, despite claims of improved charting.

I have high hopes for performance improvements each time MSFT releases an new version or service pack.  This time the claim with Office 2007 service pack 2 that had me curious was:

“Improves the charting mechanism in Excel 2007. This includes better parity with Office 2003, improved robustness, and targeted performance improvement”

Benchmark.xls is a [...]

May 3rd, 2009 | Tags: , , , , , | Category: Benchmark.xls | One comment