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.
Table of Contents
Chapter 1: Introduction--The Value of Information 7
Chapter 2: The Basics 63
Chapter 3: Advanced Topics 153
With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.
Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.
$24.99 | ISBN-13: 978-0-13-282218-3