Microsoft Excel for Stock and Option Traders

Virtually every active trader or investor uses Microsoft Excel. During the past few years, however, Excel has evolved into a powerful analytical tool that can be used for complex statistical analysis and to create new indicators and custom charts. Few investors understand how to exploit these capabilities. This book is designed to show average investors how they can use the power of Excel to gain an advantage in the marketplace by designing their own analytical tools and indicators. This book is 100% focused on using Excel for trading and investing, and delivers many useful programs and macros that can be directly copied and implemented. Augen discusses specific approaches for creating and testing new custom indicators, provides step-by-step guidance on creating new statistical analysis techniques and new data visualization strategies that any investor can utilize with just a few simple commands. Augen also walks investors through constructing massive price history databases that exploit Excel's 1,000,000-row capability--and using them to pursue data-mining strategies and statistical analyses.