Back to skip links

Purchase eTextbooks at the new VitalSource web site. Product options and pricing may differ. Shop Now

Additional product details

ISBN-10 0132822180ISBN-13 9780132822183
ISBN-10 0137131828ISBN-13 9780137131822
Author(s): Jeff Augen
Publisher: FT Press
Copyright year: © 2011 Pages: 208

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.