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
If you have ever tried to add a simple moving average (or any data series) to a stock chart you may have noticed that after adding the series, the chart got all messed up!
Here is a short tutorial and an example file showing how to add a simple moving average to a stock chart. I
Continue reading How to add an indicator to Simulator.xls Chart (or any Excel Stock Chart).
In this article I discuss the pros and cons of Excel as a trading platform.
A little History
Over the last 16 years of trading, I have used a lot of trading platforms: broker platforms, third party vendor platforms and small applications written by private programmers. One thing all these platforms have had in common is that
Continue reading Microsoft Excel as a Trading Platform
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
Recent Comments