|
|
||
|
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 The following are the settings that I recommend for using Excel for live trading and/or running my files such as simulator.xls etc. Disable Auto recover by selecting Tools>Options and selecting the “Save” tab. Uncheck “Save AutoRecover info every:”. Instead make it a practice to always save backups of your trading files anytime you make changes. Continue reading Suggested Excel Setup for Trading The following excel file is an example of how to calculate the MACD indicator. This example shows the 5, 13, 6, setting. the MACD is in column N. Over time I may add more excel indicator examples. As I do they will be most easily found in the right sidebar under the “How to” – Continue reading MACD |
Excel Based Automated Channels. Updated every five minutes (9:05 EST to 4:15 EST). Click image for full size.
|
|
|
Copyright © 2010 ExcelTrader - All Rights Reserved |
||
Recent Comments