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

Excel question

This post answers the following question.

“I have recently been trying to chart historical data in Excel in a bar chart format and found the “canned” graph allows only for high, low, and close, but not the open.  Do you have a simple way to add the open tick to a bar chart in

Continue reading Excel question

Excel Books I recommend

Best Beginner books

1. Excel 2007 Bible – It is important to have one book that just covers excel (not Visual Basic and Macros) so that you don’t unnecessarily use VBA for performing calculations better handled by formulas. The channels and trend lines in my videos of sim trading the ES are formula based not VBA

Continue reading Excel Books I recommend