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
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
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
Continue reading Excel still slow with SP2, despite claims of improved charting.
Recent Comments